IBM Support

Tivoli Storage Manager 升级失败

Technote (troubleshooting)


此文件只適用於下列語言版本:

簡體中文

問題〈摘要〉

Tivoli Storage Manager数据库安装成功,但是数据文件升级失败。

徵狀

Tivoli Storage Manager升级日志log.txt文件中有类似如下的信息:

Tue May 27 02:44:14.864 EDT 2014 : FINEST : Cmd worked (from com.tivoli.dsm.install.RedefineInstances.startDB)
Tue May 27 02:44:14.864 EDT 2014 : INFO : Issuing cmd: "C:\Program Files\Tivoli\TSM\db2\bin\db2" upgrade database TSMDB1 (from com.tivoli.dsm.install.RedefineInstances.performDBUpgrade)
Tue May 27 02:44:14.864 EDT 2014 : INFO : signalEvent (from com.tivoli.dsm.install.RedefineInstancesPanel.signalEvent)
Tue May 27 02:45:28.918 EDT 2014 : INFO : stdout:SQL0902C A system error (reason code = "SYSCOLUMNS Migration DMS rc=0: SYSIBM.SYSJAROBJECTS") occurred. Subsequent SQL statements cannot be processed. SQLSTATE=58005 (from com.tivoli.dsm.install.RedefineInstances.performDBUpgrade)


在DB2的db2diag.log 日志文件中,有类似如下的错误信息:

2014-05-27-02.45.08.575000-240 I79382F803 LEVEL: Severe
PID : 4064 TID : 3740 PROC : db2syscs.exe
INSTANCE: DB2TSM NODE : 000 DB : TSMDB1
APPHDL : 0-7 APPID: *LOCAL.DB2TSM.140527064416
AUTHID : SYSTEM
EDUID : 3740 EDUNAME: db2agent (TSMDB1 )
FUNCTION: DB2 UDB, catalog migration, sqlrlm_95toCobra_syscolumns,
probe:1245
MESSAGE : Column pd not found for this row
DATA #1 : String with size, 8 bytes
JAR_DATA
DATA #2 : String with size, 8 bytes
BLOB
DATA #3 : Boolean, 1 bytes
false
DATA #4 : Boolean, 1 bytes
true
DATA #5 : signed integer, 4 bytes
2992
DATA #6 : Dumped object of size 2992 bytes at offset 0, 60 bytes
C:\ProgramData\IBM\DB2\DB2TSM1\DB2TSM\4064.3740.000.dump.bin

...

2014-05-27-02.45.08.575000-240 I82882F894 LEVEL: Severe
PID : 4064 TID : 3740 PROC : db2syscs.exe
INSTANCE: DB2TSM NODE : 000 DB : TSMDB1
APPHDL : 0-7 APPID: *LOCAL.DB2TSM.140527064416
AUTHID : SYSTEM
EDUID : 3740 EDUNAME: db2agent (TSMDB1 )
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:300
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -902 sqlerrml: 51
sqlerrmc: SYSCOLUMNS Migration DMS rc=0: SYSIBM.SYSJAROBJECTS
sqlerrp : SQLRM139
sqlerrd : (1) 0x00000001 (2) 0x00000001 (3) 0x00000000
(4) 0x00000003 (5) 0xFFFFFB17 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:


原因

防病毒软件在DB2编目过程中损坏数据库数据文件。


解決問題

执行以下步骤;

  1. 重新安装升级之前版本的Tivoli Storage Manager
  2. 还原有损坏的数据文件
  3. 关闭防病毒软件,重新执行升级操作

Document information

More support for: Tivoli Storage Manager
Server

Software version: All Versions

Operating system(s): Windows

Reference #: 1689090

Modified date: 13 November 2017


Translate this page: