IBM Support

ANR9999D... sqlState=560C2, sqlCode=-20241 from table. Returning rc = 2158

Technote (troubleshooting)


Problem(Abstract)

A Tivoli Storage Manager Server crashes. An attempt to restart the server in the foreground logs the ANR999D error.

Cause

Out of space condition in the file system in which the Tivoli Storage Manager server instance directory is located

Diagnosing the problem

Logon with the Tivoli Storage Manager server instance userid and start the Tivoli Storage Manager server in the foreground. For example :


MYAIX:/home/myinstance $ /opt/tivoli/tsm/server/bin/rc.dsmserv -u instanceid -i /myfs/instancedir
ANR7800I DSMSERV generated at 14:47:44 on Jan 19 2011.
Tivoli Storage Manager for AIX
Version 6, Release 2, Level 2.2
Licensed Materials - Property of IBM
(C) Copyright IBM Corporation 1990, 2010.
All rights reserved.
U.S. Government Users Restricted Rights - Use, duplication or disclosure
restricted by GSA ADP Schedule Contract with IBM Corporation.
ANR7801I Subsystem process ID is 6357168.
ANR0900I Processing options file /myfs/instancedir/dsmserv.opt.
ANR7811I Using instance directory /myfs/instancedir.
ANR4726I The ICC support module has been loaded.
ANR0990I Server restart-recovery in progress.
ANR0152I Database manager successfully started.
ANR1380I The buffer pool monitor switch is enabled.
ANR1635I The server machine GUID, 72.db.13.4a.67.0d.11.de.9b.cf.08.63.ac
.11.31.6b, has initialized.
ANR9999D_3831306406 ReportSQLDiagInfo(dbieval.c:1342) Thread<1>: Missing
sqlState=560C2, sqlCode=-20241 from table. Returning rc = 2158.
ANR9999D Thread<1> issued message 9999 from:
ANR9999D Thread<1> 0x000000010000d694 StdPutText
ANR9999D Thread<1> 0x000000010000e13c OutDiagToCons
ANR9999D Thread<1> 0x000000010000947c outDiagfExt
ANR9999D Thread<1> 0x00000001001bbbac ReportSQLDiagInfo
ANR9999D Thread<1> 0x00000001001bb010 DbiEvalSQLOutcomeX
ANR9999D Thread<1> 0x00000001000751ec tbDestroy
ANR9999D Thread<1> 0x00000001008d7b64 admInitPart2
ANR9999D Thread<1> 0x00000001008d6704 admInit
ANR9999D Thread<1> 0x00000001004db244 StartServer
ANR9999D Thread<1> 0x00000001004dad30 admStartServer
ANR9999D Thread<1> 0x0000000100000eec main
ANR0162W Supplemental database diagnostic information: -1:560C2:-20241
([IBM][CLI Driver][DB2/AIX64] SQL20241N Writing a history file entry
for dropped table "TSMDB1.ADMIN_SQL_TABLES" failed. SQLSTATE=560C2).
ANR9999D_1912944817 admInitPart2(adminit.c:1945) Thread<1>: Error 2158
destroying table Admin.SQL.Tables.
ANR9999D Thread<1> issued message 9999 from:
ANR9999D Thread<1> 0x000000010000d694 StdPutText
ANR9999D Thread<1> 0x000000010000e13c OutDiagToCons
ANR9999D Thread<1> 0x000000010000947c outDiagfExt
ANR9999D Thread<1> 0x00000001008da5e0 admInitPart2
ANR9999D Thread<1> 0x00000001008d6704 admInit
ANR9999D Thread<1> 0x00000001004db244 StartServer
ANR9999D Thread<1> 0x00000001004dad30 admStartServer
ANR9999D Thread<1> 0x0000000100000eec main
ANR0369I Stopping the database manager because of a server shutdown.
ANR0991I Server shutdown complete.


Resolving the problem

In this example, the instance directory is /myfs/instancedir. The file system /myfs was full, preventing the Tivoli Storage Manager server from starting. Add space to the file system that is full and restart the server.

Document information

More support for: Tivoli Storage Manager
Server

Software version: All Supported Versions

Operating system(s): AIX

Reference #: 1566847

Modified date: 23 June 2017


Translate this page: