User Tools

Site Tools


tsm:tsm_db_problem

DB2 errors

DB2 suspended write

ANR0162W SQL1552N dsmserv fails to start due to suspended write operations In most cases, this problem can be resolved by running the db2 set write resume command. However, if it is not possible to connect to the TSMDB1 database due to the SQL1552N message, then you cannot run the command 'db2 set write resume', and must restart the database using the following DB2 command: db2 restart db tsmdb1 write resume

DB2 uncatalog

The Tivoli Storage Manager Server instance fails to start with the DBI1306N error after an upgrade.
The following commands will fail to run:

db2 connect to tsmdb1
db2 list db directory

Catalog the TSMDB1 database:

db2 catalog db tsmdb1

Try to start the Tivoli Storage Manager Server. If the following error is logged :

  1. 5035:SQLSTATE 55001: The database must be upgraded.

Please run the following command :

db2 upgrade db tsmdb1

Note: It may be necessary to start the DB2 instance with the 'db2start' command first.

Incorrect database opened

IC60982: “ANR0227S INCORRECT DATABASE OPENED. SERVER CANNOT START.” FOLLOWING A DSMSERV FORMAT AND DSMSERV RESTORE DB

If the original copy of dsmserv.dbid, is available, copy it in the instance directory prior to starting the TSM Server.

Alternatively, delete the “dsmserv.dbid” file located in the server instance directory, then start the server in the foreground and include the -S option.

Example on Windows:

     dsmserv -S -k server1

Example on AIX/Linus/Solaris/HP-UX:

 dsmserv -S

After the server is started successfully, it can be halted and started normally.

tsm/tsm_db_problem.txt · Last modified: 2021/01/01 21:25 (external edit)