Troubleshooting
Problem
When you create a fenced DRDA server in a DB2 federation server for an AS400 database source, you may receive an unexpected error "56072".
Symptom
For example, when you run below "CREATE SERVER" command:
CREATE SERVER MYAS400 TYPE DB2/ISERIES VERSION 5.4 WRAPPER "drda" AUTHORIZATION "user" PASSWORD "pwd" OPTIONS ( ADD DBNAME 'DB400' )
The command may fail with below error:
Unexpected error code "56072" received from data source "MYAS400". Associated text and tokens are "func="commit" msg=" SQL30005N Execution failed because fu".. SQLCODE=-1822, SQLSTATE=560BD, DRIVER=4.14.113
And at the same time, the db2diag.log shows messages similar to below:
2015-02-23-23.23.11.377000-480 E1140F544 LEVEL: Error
PID : 2960 TID : 3632 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : FEDDB
APPHDL : 0-442 APPID: 127.0.0.1.64642.150224072311
AUTHID : ADMINISTRATOR HOSTNAME: HOST1
EDUID : 3632 EDUNAME: db2agent (FEDDB) 0
FUNCTION: DB2 UDB, DRDA Application Requester, sqljrReportServerErrReply, probe:10
MESSAGE : ADM2502C The remote database server has encountered an error.
2015-02-23-23.23.11.392000-480 I1686F980 LEVEL: Error
PID : 2960 TID : 3632 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : FEDDB
APPHDL : 0-442 APPID: 127.0.0.1.64642.150224072311
AUTHID : ADMINISTRATOR HOSTNAME: HOST1
EDUID : 3632 EDUNAME: db2agent (FEDDB) 0
FUNCTION: DB2 UDB, DRDA Application Requester, sqljrReportServerErrReply, probe:20
MESSAGE : ZRC=0x80370097=-2143879017=SQLJR_BADRPY "INVALID RPYDSS"
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -30000 sqlerrml: 12
sqlerrmc: 0x1254 0200
sqlerrp : sqljrerm
sqlerrd : (1) 0x80370097 (2) 0x00000097 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2015-02-23-23.23.11.392000-480 I4094F633 LEVEL: Error
PID : 2960 TID : 3632 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : FEDDB
APPHDL : 0-442 APPID: 127.0.0.1.64642.150224072311
AUTHID : ADMINISTRATOR HOSTNAME: HOST1
EDUID : 3632 EDUNAME: db2agent (FEDDB) 0
FUNCTION: DB2 UDB, drda wrapper, report_error_message, probe:10
DATA #1 : String, 16 bytes
DRDA Server:
DATA #2 : String with size, 5 bytes
MYAS400
DATA #3 : String, 16 bytes
Function name:
DATA #4 : String with size, 7 bytes
do_prep
2015-02-23-23.23.11.392000-480 I4729F944 LEVEL: Error
PID : 2960 TID : 3632 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : FEDDB
APPHDL : 0-442 APPID: 127.0.0.1.64642.150224072311
AUTHID : ADMINISTRATOR HOSTNAME: HOST1
EDUID : 3632 EDUNAME: db2agent (FEDDB) 0
FUNCTION: DB2 UDB, drda wrapper, report_error_message, probe:20
DATA #1 : String, 16 bytes
ODBC native err:
DATA #2 : String with size, 6 bytes
-30000
DATA #3 : String, 16 bytes
ODBC sqlstate:
DATA #4 : String with size, 6 bytes
58008.
DATA #5 : String, 16 bytes
ODBC error txt:
DATA #6 : String with size, 226 bytes
[IBM][CLI Driver][AS] SQL30000N Execution failed because of a Distributed Protocol Error that will not affect the successful execution of subsequent commands or SQL statements: Reason Code "0x1254"("0200"). SQLSTATE=58008
2015-02-23-23.23.11.408000-480 E5675F544 LEVEL: Error
PID : 2960 TID : 3632 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : FEDDB
APPHDL : 0-442 APPID: 127.0.0.1.64642.150224072311
AUTHID : ADMINISTRATOR HOSTNAME: HOST1
EDUID : 3632 EDUNAME: db2agent (FEDDB) 0
FUNCTION: DB2 UDB, DRDA Application Requester, sqljrReportServerErrReply, probe:10
MESSAGE : ADM2502C The remote database server has encountered an error.
2015-02-23-23.23.11.408000-480 I6221F1013 LEVEL: Error
PID : 2960 TID : 3632 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : FEDDB
APPHDL : 0-442 APPID: 127.0.0.1.64642.150224072311
AUTHID : ADMINISTRATOR HOSTNAME: HOST1
EDUID : 3632 EDUNAME: db2agent (FEDDB) 0
FUNCTION: DB2 UDB, DRDA Application Requester, sqljrReportServerErrReply, probe:20
MESSAGE : ZRC=0x80370084=-2143879036=SQLJR_BADCOM "Op not supported"
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -30005 sqlerrml: 43
sqlerrmc: DB400 QSQ06010 0x2204"("02")"
sqlerrp : sqljrerm
sqlerrd : (1) 0x80370084 (2) 0x00000084 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2015-02-23-23.23.11.408000-480 I8662F632 LEVEL: Error
PID : 2960 TID : 3632 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : FEDDB
APPHDL : 0-442 APPID: 127.0.0.1.64642.150224072311
AUTHID : ADMINISTRATOR HOSTNAME: HOST1
EDUID : 3632 EDUNAME: db2agent (FEDDB) 0
FUNCTION: DB2 UDB, drda wrapper, report_error_message, probe:10
DATA #1 : String, 16 bytes
DRDA Server:
DATA #2 : String with size, 5 bytes
MYAS400
DATA #3 : String, 16 bytes
Function name:
DATA #4 : String with size, 6 bytes
commit
2015-02-23-23.23.11.408000-480 I9296F913 LEVEL: Error
PID : 2960 TID : 3632 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : FEDDB
APPHDL : 0-442 APPID: 127.0.0.1.64642.150224072311
AUTHID : ADMINISTRATOR HOSTNAME: HOST1
EDUID : 3632 EDUNAME: db2agent (FEDDB) 0
FUNCTION: DB2 UDB, drda wrapper, report_error_message, probe:20
DATA #1 : String, 16 bytes
ODBC native err:
DATA #2 : String with size, 6 bytes
-30005
DATA #3 : String, 16 bytes
ODBC sqlstate:
DATA #4 : String with size, 6 bytes
56072.
DATA #5 : String, 16 bytes
ODBC error txt:
DATA #6 : String with size, 195 bytes
[IBM][CLI Driver][AS] SQL30005N Execution failed because function not supported by the server: location "DB400 " product ID "QSQ06010" reason code "0x2204"("02")"". SQLSTATE=56072
Log InLog in to view more of this document
Was this topic helpful?
Document Information
More support for:
Db2 for Linux, UNIX and Windows
Software version:
9.8, 9.7, 9.5, 10.1, 10.5
Operating system(s):
AIX, HP-UX, Linux, Solaris, Windows
Document number:
257965
Modified date:
30 April 2025
UID
swg21699358