Create nicknames that point to some Host tables on SYLDSN. Most
of them works just fine, but receives -901 error on the others:
DB21034E The command was processed as an SQL statement because
it was not a valid Command Line Processor command. During SQL
processing it returned: SQL0901N The SQL statement failed
because of a non-severe system error. Subsequent SQL statements
can be processed. (Reason "Error Server Version".)
SQLSTATE=58004
Here is the error message from db2diag.log:
2012-09-24-18.56.24.142000-300 E162857F1365 LEVEL: Info
PID : 6472 TID : 3728 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SAMPL
APPHDL : 0-746 APPID: *LOCAL.DB2.120924235525
AUTHID : DB2INST1
EDUID : 3728 EDUNAME: db2agent (SAMPL)
FUNCTION: DB2 UDB, SW- common services, sqlnn_cmpl, probe:650
MESSAGE : ZRC=0x803100AF=-2144272209=SQLNN_E_BADNEWS
"unexpected error but state is OK"
DATA #1 : String, 62 bytes
An unexpected error was detected during statement compilation.
DATA #2 : Boolean, 1 bytes
true
DATA #3 : Boolean, 1 bytes
true
DATA #4 : Boolean, 1 bytes
true
DATA #5 : Boolean, 1 bytes
false
DATA #6 : Hex integer, 4 bytes
0x00000000
DATA #7 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 20
sqlerrmc: Error Server Version
sqlerrp : SQLQG_DR
sqlerrd : (1) 0x8026006D (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 58004
DATA #8 : Hex integer, 4 bytes
0x00000040
DATA #9 : String, 59 bytes
Compiler error stack for rc = -2144272209:
sqlnn_cmpl[565] |
