Troubleshooting
Problem
How to get information about orphan rows in a database while upgrade
Environment
db2 luw all versions
Diagnosing The Problem
During upgrade orphan rows found
Resolving The Problem
While upgrading/migrating the database to new version of db, you may find orphan rows with the following type of error
Database: "TEST"
SQL1344N Orphan rows found in the system catalogs. Contact your technical service representative prior to attempting a database upgrade.
If you observe the following message you can request db2cleancat tool from IBM support
as per below link
http://www-01.ibm.com/support/docview.wss?uid=swg21984793.
However this may happen ,since there maybe new routines coming in new version and fixpack ,
db2cleancat tool of the specific version may not able to clean orphan rows .
Here are relevant messages
While running db2cleancat with option 0 -
it gave 0 rows
But while upgrading it shows following error
SQL1344N Orphan rows found in the system catalogs. Contact your technical service representative prior to attempting a database upgrade.
DBT5529N The db2ckupgrade utility did not complete successfully. The database cannot be upgraded. The output log file is named "/tmp/log.txt".
This is due to the reason that db2cleancat tool could not detect new definitions of syscats.
In this case you need to use the following script to detect orphan rows .
Use the attached script rtc70086.clp and generate the following output.
Before using the scirpt -change the permission with 777 or full access to db2instance user.
db2 -vtf rtc70086.clp | tee rtc70086.out
Send the output file rtc70086.out to IBM support team.
The above script will detect all orphan rows which is not detected by the specific version of the tool.
After this support will provide db2cleancat tool specific to the environment -which will help cleaning orphan rows.
Related Information
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Install\/Migrate\/Upgrade - Database","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.8;9.7;9.5;10.1;10.5;11.1","Edition":"Advanced Enterprise Server;Advanced Workgroup Server;Enterprise Server;Workgroup Server","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg22006136