DB2 upgrade database Fails due to descriptor corruption

Posted by Jdcc on Server Fault See other posts from Server Fault or by Jdcc
Published on 2010-12-21T17:56:05Z Indexed on 2010/12/21 18:56 UTC
Read the original article Hit count: 1126

Hi Everyone,

I've recently upgraded my DB2 9.5 to DB2 9.7, and I am unable to update my database to v9.7. The error I have been receiving is this: "SQL0901N The SQL statement failed because of a non-severe system error. Subsequent SQL statements can be processed. (Reason "Packed descriptor corruption found. Please run RUNSTATS on this table".) SQLSTATE=58004"

I have tried to connect with 9.5 clients that worked before the "upgrade" on other machines, but they complain about the DB not being migrated to the current version. So my DB is now somewhere in limbo between 9.5 and 9.7.

Would anyone have any clever ideas on how to execute runstats on this DB without being able to connect to it? I'm not concerned so much about the data inside, as I am about the settings (name,optimization stuff, etc)

Please let me know if I there is any information I left out. Thanks, Jdcc

© Server Fault or respective owner

Related posts about database

Related posts about upgrade