Troubleshooting
Problem
Tivoli Storage Manager数据库安装成功，但是数据文件升级失败。
Symptom
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:
Cause
防病毒软件在DB2编目过程中损坏数据库数据文件。
Resolving The Problem
执行以下步骤；
- 重新安装升级之前版本的Tivoli Storage Manager
- 还原有损坏的数据文件
- 关闭防病毒软件，重新执行升级操作
[{"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Server","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21689090