We have a db2 file that contains a number of stored procedures.
About every other day or 2, the process will bomb out on a user.
We have no idea at what point it is bombing out. Also it cannot be duplicated at will.
Mind you the stored procedure is about 10000 lines and calls other stored procedures to perform specific updates, inserts, and formatting etc...
So we have created a new table ( a log table ). Right before we do something in the stored procedure such as updating or inserting into any number of tables, we will be calling a stored procedure to insert information about what is about to be performed into this new table.
So the question begs asking, when the program bombs out and calls for a rollback of the transaction, how do we preserve the data written to this new table while still rolling back everything else?
Thanks In Advance...