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: 1214
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