DB2 SQL0902C solution instance

DB2 SQL0902C solution instance

On Sunday, when the development environment archives and deletes the database, after the database is restarted, the database cannot be opened, and the database will be restored in the future because it is the development environment, they are also unconsciously messing up and eventually lead to complete chaos at the scene, finally requesting technical support, after I back up the database online on another host, I plan to restore DB2 on this host. SQL0902C A system error (reason code = "8") occurred is encountered. subsequent SQL reports an error. The DB2 database version is the same, and the backup file is normal through db2ckbtp detection. Only the source end is AIX 7, 1, and the target end is 5.3. it was suspected that it was an operating system problem. The final solution was to drop the database on the target end, and the information in the uncatalog directory, and specify the directory parameters after the on in the restore to a specific directory, the database is restored completely.

Db2 "restore db cmsdb from [path name] on/db2data/db2inst1/abcdb logtarget/tmp/logs replace existing redirect"

When dropping the database, SQL30061N indicates that the specified ABCDB does not exist.

Db2 drop database abcdb

The abcdb entry is still visible when the db2 list db directory is found,

After the db2 uncatalog database abcdb is used, the abcdb entry disappears, and the above DB2 recovery work can proceed.

DB2 database performance adjustment and optimization (1st and 2) PDF

DB2 database performance optimization

DB2 9.7 for Linux 5.4 Installation Steps

This article permanently updates the link address: