IBM Support

Tivoli Storage Manager server fails to format database with rc=499

Technote (troubleshooting)


A Tivoli Storage Manager server in installed on Windows. The Tivoli Storage Manager server instance upgrade wizard is used to upgrade the server. The upgrade wizard fails to format the new server instance database with rc=499.


Sophos antivirus interfering with the Tivoli Storage Manager server instance

Diagnosing the problem

Examine the "c:\program files\tivoli\tsm\dsmupgdx.trc" file to get more information on the format failure. For example :

<timestamp> com.tivoli.dsm.ServerConfig.ServerDB$ Issuing cmd: "C:\Program Files\Tivoli\TSM\Server\dsmserv" -k Server1 LOADFORMAT dbfile=\"C:\Program Files\Tivoli\TSM\server1\dbfile.1\" activelogdir=\"D:\ActiveLog\" archlogdir=\"E:\ArchiveLog\" activelogsize=16384 >Format.Out 2>&1 on id tsminst1
<timestamp> enter, Monitoring file C:\Program Files\Tivoli\TSM\server1\Format.Out
<timestamp> 2012 File C:\Program Files\Tivoli\TSM\server1\Format.Out not created yet.
<timestamp> File C:\Program Files\Tivoli\TSM\server1\Format.Out now being read.
<timestamp> File C:\Program Files\Tivoli\TSM\server1\Format.Out now being read.
<timestamp> com.tivoli.dsm.ServerConfig.ServerDB$ Format rc: 9994
<timestamp> com.tivoli.dsm.ServerConfig.ServerDB$ format stderr:
<timestamp> com.tivoli.dsm.ServerConfig.ProcessMonitor.cancel(): enter
<timestamp> File C:\Program Files\Tivoli\TSM\server1\Format.Out now being read.
<timestamp> exit
<timestamp> com.tivoli.dsm.ServerConfig.ProcessMonitor.cancel(): exit
<timestamp> com.tivoli.dsm.ConfigWizard.DoFormatPanel.signalEvent(): enter, event=formatDone, rc=499

The db2diag log file will also show the following error :

<timestamp> LEVEL: Severe
PID : 2304 TID : 2008 PROC : db2syscs.exe
APPHDL : 0-8 APPID: *LOCAL.SERVER1.121107195909
EDUID : 2008 EDUNAME: db2agent (TSMDB1) 0
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: -901 sqlerrml: 20
sqlerrmc: Invalid collation ID
sqlerrp : SQLNQB6E
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0xFFFFFF9C (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)

Resolving the problem

In this case, the Sophos antivirus was installed on the Windows machine. The Sophos antivirus was interfering with the format process as it was accessing the database files being created.

Configure the Sophos antivirus to not scan the Tivoli Storage Manager instance database and files
or disable the Sophos antivirus where appropriate and rerun the upgrade wizard.

Document information

More support for: Tivoli Storage Manager

Software version: All Supported Versions

Operating system(s): Windows

Reference #: 1618840

Modified date: 2014-10-27