Troubleshooting
Problem
An AIX system is upgraded. After the AIX system is rebooted, the Tivoli Storage Manager server fails to start with the following error :
[]ANR0264E A database file IO error is prohibiting activation of TSMDB1 with sqlcode -1036.[]
Symptom
When the server is started in the foreground, the following errors are issued :
ANR7801I Subsystem process ID is 10879000.
ANR0900I Processing options file /home/tsminst1/dsmserv.opt.
ANR7811I Using instance directory /home/tsminst1.
ANR4726I The ICC support module has been loaded.
ANR0990I Server restart-recovery in progress.
ANR0152I Database manager successfully started.
ANR0264E A database file IO error is prohibiting activation of TSMDB1 with sqlcode -1036.
Diagnosing The Problem
Review the db2diag log of the Tivoli Storage Manager server instance. In this case, the following error was logged :
2015-01-30-04.41.16.657835+480 I15438488A390 LEVEL: Error
PID : 19267724 TID : 3857 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
EDUID : 3857 EDUNAME: db2loggr (TSMDB1) 0
FUNCTION: DB2 UDB, data protection services, sqlpgInitRecoverable, probe:1370
DATA #1 : <preformatted>
Log file S0001482.LOG not found.
The log shows that Tivoli Storage Manager server failed to start because a log file was missing.
In this scenario, the Tivoli Storage Manager server instance directory was stored in rootvg. The rootvg was mirrored to a target second disk. The mirroring was stopped to apply maintenance to the target mirrored disk. However, the Tivoli Storage Manager server was still running during this procedure. This caused data from the Tivoli Storage Manager server instance directory to become out of sync between the mirrored volumes.
Resolving The Problem
This type of scenario is used to facilitate applying maintenance to the AIX system rootvg and be able to rollback changes if needed. When the Tivoli Storage Manager server instance directory is also stored on rootvg, complete the following steps to apply maintenance without breaking the server:
- Stop the Tivoli Storage Manager server instance. Verify that the dsmserv and db2sysc processes are stopped.
- After the Tivoli Storage Manager server instance is stopped, verify that the mirror disk synchronized. Then stop the mirroring.
- Apply AIX maintenance on the other mirror disk while leaving the Tivoli Storage Manager server stopped.
- Reboot the AIX system using the mirror disk.
Use this procedure for any Tivoli Storage Manager server instance file that is stored on rootvg. For example, the volume history file, device configuration file, log files, database files, and so on.
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21695852