So there is no automated way to recreate indexes in DB2 like you can in MSSQL?
We are having random issues when a certain database is accessed it kills the DBM for the instance. Not much info is in db2diag or in any trap files but it seems to happen when selecting certain information.
Also helpful that you cant open some of the debugging files without opening a ticket with IBM for them to decrypt it....
I am still clueless as to what the problem is in the first place. What DB2 version are you on? Tell us about the server that DB2 is running on. 32/64 bit? Amount of RAM? Windows version? DBM Config? DB Config? The more information you supply, the better answer you will receive.