While trying to propagate data from AS400 to db2 database on RS6k Box I am getting error:
Message . . . . : Function restricted - SQLSTATE 56098, SQLCODE -727.
Cause . . . . . : An SQL or a product restriction was returned by the
application server. Either the SQLSTATE and SQLCODE are not recognized by
SQL or the GET DIAGNOSTICS DB2_TOKEN_STRING is not valid for the
corresponding SQL message.
The GET DIAGNOSTICS MESSAGE_TEXT is .
The GET DIAGNOSTICS DB2_TOKEN_COUNT is 4.
The GET DIAGNOSTICS DB2_TOKEN_STRING is 5-20442704ASN.SGSIGDP.
The relational database is DATADB and the product identification is
SQL08016.
Recovery . . . : Refer to the product specific documentation for the
application server.
In Diag Log I find this information:
DIA5000C A DRDA AS token "RECOVERABLE" was detected. The diagnostic data
returned is (SRVDGN): "FUNCTION ID = 0012 , PROBE POINT = 0649 , TRACE POINT =
0150 , SUBCODE1 = 8005006D, SUBCODE2 = FFFFFEB4, SUBCODE3 = 00000000, ERROR MSG
= SQLAM: CONNECT failed. CCSID specified on ACCRDB not supported".
Conversion table not available. Source code page = 0, Target code page = 1208
DIA8102C Conversion table not loaded. Source code page "", Target code page "",
method "", handle "".
ZRC=0x800F005Bÿ
My Db cfg is :
Database configuration release level = 0x0a00
Database release level = 0x0a00
Database territory = US
Database code page = 1208
Database code set = UTF-8
Database country/region code = 1
We are not populating any non english character
Urgent Help would highly be appreciated...
Regards,
Sepia