Recover from ANR0162W with SQLCODE SQL0440N and SQLSTATE 42884

Technote (troubleshooting)


Problem(Abstract)

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.

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Tivoli Storage Manager
Server

Software version:

6.1, 6.2, 6.3, 6.4

Operating system(s):

All Platforms

Reference #:

1631469

Modified date:

2013-03-25

Translate my page

Machine Translation

Content navigation