IBM Support

Recover from ANR0162W with SQLCODE SQL0440N and SQLSTATE 42884

Troubleshooting


Problem

The Tivoli Storage Manager server might report messages like the following: ANR0162W Supplemental database diagnostic information: -1:42884:-440

Symptom

Additional messages might look similar to:

ANR0162W ([IBM][CLI Driver][DB2/AIX64] SQL0440N No authorized routine named
ANR0162W "ASCII" of type "FUNCTION" having compatible arguments was found.
ANR0162W SQLSTATE=42884
).
ANR9999D_3326425794 CheckTableIntegrity(tbinsert.c:8277) Thread<62>: Error 2343
ANR9999D_3326425794 fetching status for table Staged.Expiring.Objects.
ANR9999D Thread<62> issued message 9999 from:
ANR9999D Thread<62> 0x000000010000d0b8 StdPutText
ANR9999D Thread<62> 0x000000010000db34 OutDiagToCons
ANR9999D Thread<62> 0x0000000100008d9c outDiagfExt
ANR9999D Thread<62> 0x0000000100bb8898 CheckTableIntegrity
ANR9999D Thread<62> 0x0000000100bb603c EndInsertRecords
ANR9999D Thread<62> 0x0000000100bb2604 TbXiInsertThread
ANR9999D Thread<62> 0x0000000100020ae0 StartThread
ANR0162W Supplemental database diagnostic information: -1:42884:-440
ANR0162W ([IBM][CLI Driver][DB2/AIX64] SQL0440N No authorized routine named
ANR0162W "ASCII" of type "FUNCTION" having compatible arguments was found.
ANR0162W SQLSTATE=42884
).

Note: the symptom is not limited to "ASCII" type "FUNCTION"

Cause

The symptom has been seen with changing the system date to a time in the past.

Diagnosing The Problem

Review the db2diag.log for occurrences of messages like the following:
.
2013-03-13-08.16.00.443153-300 I846403A407 LEVEL: Warning
PID : 9371758 TID : 258 PROC : db2sysc 0
INSTANCE: tsm1 NODE : 000
EDUID : 258 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, fast comm manager, sqkfEventTimer::getTimeElapsed,
probe:5
DATA #1 : <preformatted>
Correcting system clock problem - curr time: 1363180560, start time:
1363192687

Alternatively check for the function create time, in the above example you would submit the following commands as instance user:
db2 connect to tsmdb1
db2 "select schema, name, function_id, create_time from sysibm.sysfunctions where name='ASCII'"

Resolving The Problem

Make sure system time is always correct and avoid a time change to an earlier time.

[{"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Server","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Supported Versions","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
17 June 2018

UID

swg21631469