Troubleshooting
Problem
When using the Tivoli Storage Manager Administration Center there is a rare possibility when extending the database space a duplicate path entry will be created.
Symptom
1. Using the Administration Center GUI EXTEND DBSPACE, the GUI window closes without showing the results of the extend command.
2. The Administration Center is closed and the Admin client command line interface (dsmadmc), is used to run "Q DBSpace", and verify the new database path does not exist.
For example if the path being extended was /tsm/db/db03, the Q DBSPACE would look like the following:
- PATH_NUMBER LOCATION
-------------------- -----------
1 /tsm/db/db01
2 /tsm/db/db02
3 /tsm/db/db03
4 /tsm/db/db03
4. The db2diag.log file will show two attempts to create the new path micro seconds apart:
- 2014-12-23-11.29.09.695274+060 E91349442A560 LEVEL: Warning
PID : 3276890 TID : 54052 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
APPHDL : 0-63299 APPID: *LOCAL.tsminst1.141223101819
AUTHID : TSMINST1
EDUID : 54052 EDUNAME: db2agent (TSMDB1) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbAlterDatabaseStorageAct,
probe:50
MESSAGE : ADM6112I Storage path "/tsm/db/db03" was added to the database. The new storage path will not be used automatically.
- 2014-12-23-11.29.09.706519+060 E91350003A560 LEVEL: Warning
PID : 3276890 TID : 17198 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
APPHDL : 0-63601 APPID: *LOCAL.tsminst1.141223101828
AUTHID : TSMINST1
EDUID : 17198 EDUNAME: db2agent (TSMDB1) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbAlterDatabaseStorageAct, probe:50
MESSAGE : ADM6112I Storage path "/tsm/db/db03" was added to the database. The new storage path will not be used automatically.
Cause
The problem is an issue with DB2 that has not been identified.
Environment
The problem has been seen on AIX at Tivoli Storage Manager Server version 6.3.5.100, but can affect all versions.
Diagnosing The Problem
Run QUERY DBSPACE command to verify duplicate entries have been created. Check the db2diag.log file for two separate warnings micro seconds apart with the following message:
MESSAGE : ADM6112I Storage path "/tsm/db/db03" was added to the database.
The new storage path will not be used automatically.
Resolving The Problem
The following steps can be take to remove the duplicate entries:
1. Create a text file called dbdirs.txt in the instance home directory where the
- dsmserv.opt file resides. The file will contain the names of all the volumes to be
used as database space containers, including the extended container. For example:
/tsm/db/db01
/tsm/db/db02
/tsm/db/db03
2. Stop all sessions and processes so there is no activity on the Server.
3. Perform a full Database backup and then halt the Tivoli Storage Manager Server.
4. From the instance directory run the database RESTORE command using the "on" option:
- /opt/tivoli/tsm/server/bin/dsmserv restore db on=<fullpath>/dbdirs
5. After the restore the duplicate volume will be gone.
Related Information
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21697560