IT06159: DSMSERV RESTORE DB FAILS WITH ANR2990E MESSAGES AND MAY EXPERIANCE HANG.

6.3.6.000-TIV-TSMRPT-AGENT-Linux
6.3.6.000-TIV-TSMRPT-AGENT-AIX
6.3.6.000-TIV-TSMRPT-AIX
6.3.6.000-TIV-TSMRPT-AGENT-Windows
6.3.6.000-TIV-TSMRPT-Linuxx86
6.3.6.000-TIV-TSMRPT-Linuxx86_64
6.3.6.000-TIV-TSMRPT-WindowsI32
6.3.6.000-TIV-TSMRPT-WindowsX64
6.3.6.000-TIV-TSMAC-WindowsX64
6.3.6.000-TIV-TSMAC-WindowsI32
6.3.6.000-TIV-TSMAC-SolarisSPARC
6.3.6.000-TIV-TSMAC-Linuxx86
6.3.6.000-TIV-TSMAC-Linuxs390x
6.3.6.000-TIV-TSMAC-AIX
6.3.6.000-TIV-TSMALL-SolarisSPARC
6.3.6.000-TIV-TSMALL-WindowsX64
6.3.6.000-TIV-TSMSTA-WindowsI32
6.3.6.000-TIV-TSMALL-HP-UX
6.3.6.000-TIV-TSMALL-Linuxppc64
6.3.6.000-TIV-TSMALL-AIX
6.3.6.000-TIV-TSMALL-Linuxs390x
6.3.6.000-TIV-TSMALL-Linuxx86_64
IBM Tivoli Storage Manager V6.3 Fix Pack 6 (6.3.6.000) Server Downloads

APAR status

• Closed as program error.

Error description

• Problem Description:
  
  dsmserv restore db fails with the ANR2990E and ANR9999D
  messages and hangs.
  This was because the DB backup path did not exist at restore.
  
  ANR2032E RESTORE DB: Command failed - internal server error
  detected.
  ANR9999D Thread<1> issued message 2032 from:
  ANR9999D Thread<1>  0x00000000d273e6 outMsgf
  ANR9999D Thread<1>  0x000000004da27c AdmRestoreDb
  ANR9999D Thread<1>  0x000000004886fb admRestoreDatabase
  ANR9999D Thread<1>  0x00000000476fab main
  ANR9999D Thread<1>  0x00003d9341ecdd *UNKNOWN*
  ANR9999D Thread<1>  0x000000004753c9 *UNKNOWN*
  ANR4574E Database backup/restore terminated - data transfer
  interrupted.
  ANR2990E Database restore is terminated due to an invalid
  database path
  /tsm/tsm1/db and DB2 sqlcode -1051
  
  However the "dsmserv restore" process was hungup after the
  ANR9999Ds.
  ctrl+C and kill did not work and you need  run  "kill -11"
  command
  to terminate the process.
  
  Customer/L2 diagnostics:
  
  ICBACK ICREST  VERBDETAIL TCPINFO ADDMSG
  
  Tivoli Storage Manager Server "ICBACK ICREST VERBDETAIL
  TCPINFO ADDMSG " trace shows below messages.
  ===============================================
  16:22:13.821 [10][output.c][7531][PutConsoleMsg]:ANR8340I FILE
  volume /home/pool1/14478972.DBV mounted.~ mountWait           :
  0x02 (2)
  16:22:18.832 [12][output.c][7531][PutConsoleMsg]:ANR8340I FILE
  volume /home/pool1/14478972.DBV mounted.~
  16:22:19.399 [11][icutil.c][869][icSaveRestoreMount]:Trying to
  save handles 0x7fa9e8017468 and 0x7fa9e8016d08.
  16:22:19.399 [11][icutil.c][893][icSaveRestoreMount]:Returning 0
  (failure@0).
  
  16:22:20.441
  [1][rdbicrst.c][1330][EvaluateRestoreStatus]:Restore  database
  failed with sqlcode -1051 sqlerrmc
  token is /tsm/tsm1/db  sqlerrml is 12.
  16:22:20.441 [1][output.c][7531][PutConsoleMsg]:ANR2990E
  Database   restore is terminated due
  to an invalid database path /tsm/tsm1/db and DB2 sqlcode -1051 ~
  16:22:20.441 [1][rdbicrst.c][1160][DoRestoreDB]:db2restore
  completes  with evaluated rc 3328 (failingLine 1363).
  16:22:20.442 [1][rdbicrst.c][1166][DoRestoreDB]:RC after restore
  is 3328 and needRollforward=True.
  16:22:20.442 [1][rdbicrst.c][1280][DoRestoreDB]:Exiting with rc
  3328 and failing line 1363.
  16:22:20.442 [1][rdbicrst.c][735][RdbAdmRestoreDB]:RC 3328 from
  restore processing.
  16:22:20.442 [1][rdbicrst.c][787][RdbAdmRestoreDB]:Exiting with
  rc 3328  set at line 0
  ---------------------------
  
  Tivoli Storage Manager Versions Affected:
  
  Tivoli Storage Manager Server 6.1, 6.2, 6.3 and 7.1.0 on all
  supported operating systems.
  
  Initial Impact:
  
  Medium
  
  Additional Keywords:
  restore db hung database
  

Local fix

• 1) create the directory that corresponds to the database backup
  image
  
  2) use the ON parameter in restore db command.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Tivoli Storage Manager server users.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed in level 6.3.6. Note that this is      *
  * subject to change at the discretion of IBM.                  *
  ****************************************************************
  

Problem conclusion

• This problem was fixed.
  Affected platforms:  AIX, HP-UX, Solaris, Linux, and Windows.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  TSM SERVER

• Fixed component ID

  5698ISMSV

Applicable component levels

• R62A PSY

     UP

• R62H PSY

     UP

• R62W PSY

     UP

• R62L PSY

     UP

• R62S PSY

     UP

• R63A PSY

     UP

• R63H PSY

     UP

• R63W PSY

     UP

• R63L PSY

     UP

• R63S PSY

     UP