IBM Support

Extend dbspace using Administration Center can cause duplicate path entries.

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.

    3. Then log back into the Administration Center and attempt to use the GUI interface to EXTEND DBSPACE a second time. After the second time the "Q DBSpace" command shows the same volume two times.

    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

    TSM APAR IC80172

    DB2 APAR IC78956

    [{"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Server","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Supported Versions","Edition":"Edition Independent","Line of Business":{"code":"LOB26","label":"Storage"}}]

    Document Information

    Modified date:
    17 June 2018

    UID

    swg21697560

    Page Feedback