ANR0162W message from DB2

Trident

TSM/Storge dude
ADSM.ORG Moderator
Joined
Apr 2, 2007
Messages
617
Reaction score
72
Points
0
Location
Oslo, Norway
Website
www.basefarm.no
Hi folks,

Running on AIX72, with SP 8.1.5.003

Yes, I have a pmr for this one.

Found a db2 related issue (db2 10.x SP 8.1.5 is using 11.x)
https://www-01.ibm.com/support/docview.wss?uid=swg1IC99367



But, has anyone seen this before? In this case, a sql restore job terminates with an error.



And q actlog shows this. Pluss some ANR9999 messages

9/15/2018 05:18:13 ANR0162W Supplemental database diagnostic information: -1
:21000:-811 ([IBM][CLI Driver][DB2/AIX64] SQL0811N The r
esult of a scalar fullselect, SELECT INTO statement, or V
ALUES INTO statement is more than one row. SQLSTATE=2100
0). (SESSION: 1001081)
09/15/2018 05:18:13 ANR9999D_1288456981 SmRetrieveBitfile(smnqr.c:2551) Thread
<1639139>: Unknown result code (2343) from bfRtrv. (SESSI
ON: 1001081)
09/15/2018 05:18:13 ANR0546W Retrieve or restore failed for session 1001081 fo
r node XXXXXXT_MSSQL (TDP MSS
QL Win64) - internal server error detected. (SESSION: 100
 
Back
Top