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

Technote (troubleshooting)


Problem(Abstract)

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

Cause

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$FormatThread.run(): 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> com.tivoli.dsm.ServerConfig.ProcessMonitor.run(): enter, Monitoring file C:\Program Files\Tivoli\TSM\server1\Format.Out
<timestamp> 2012 com.tivoli.dsm.ServerConfig.ProcessMonitor.read(): File C:\Program Files\Tivoli\TSM\server1\Format.Out not created yet.
<timestamp> com.tivoli.dsm.ServerConfig.ProcessMonitor.read(): File C:\Program Files\Tivoli\TSM\server1\Format.Out now being read.
...
<timestamp> com.tivoli.dsm.ServerConfig.ProcessMonitor.read(): File C:\Program Files\Tivoli\TSM\server1\Format.Out now being read.
<timestamp> com.tivoli.dsm.ServerConfig.ServerDB$FormatThread.run(): Format rc: 9994
<timestamp> com.tivoli.dsm.ServerConfig.ServerDB$FormatThread.run(): format stderr:
<timestamp> com.tivoli.dsm.ServerConfig.ProcessMonitor.cancel(): enter
<timestamp> com.tivoli.dsm.ServerConfig.ProcessMonitor.read(): File C:\Program Files\Tivoli\TSM\server1\Format.Out now being read.
<timestamp> com.tivoli.dsm.ServerConfig.ProcessMonitor.run(): 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
INSTANCE: SERVER1 NODE : 000 DB : TSMDB1
APPHDL : 0-8 APPID: *LOCAL.SERVER1.121107195909
AUTHID : TSMINST1
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)
sqlstate:


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 anitvirus where appropriate and rerun the upgrade wizard.


Rate this page:

(0 users)Average rating

Document information


More support for:

Tivoli Storage Manager
Server

Software version:

6.1, 6.2, 6.3

Operating system(s):

Windows

Reference #:

1618840

Modified date:

2012-12-03

Translate my page

Machine Translation

Content navigation