Hi
I am running a DB2 v9.7 Enterprise edition database on Windows 2003 server
Our application heavily uses DB2 SQL PL Stored Procedures for all processing.
The following is a strage behaviour happening on the DB
- We execute a stored procedure which processes almost 3 million records (expected to complete in 10 mins)
- Sometimes , in our test env. when it runs for more than 15 mins , we cancel the execution by pressing Control+C
- DB2 does the ROLLBACK and data and tables are back to the state before execution and we terminate the DB2 connection
- But , from next time we cannot connect to DB , it gives the following error in Windows EventViewer "ADM7518C : <dbName> marked bad."
What might be the issue?
But after doing an instance level stop and start , we can connect to DB.
(This DB is migrated from v8.2 and We used to do the cancel of stored procedure execution in v8.2 , everything used to be normal and no errors in v8.2)
Thanks in advance
Sree
