IBM Support

DB2 LOAD is failing with SQL error -804

Troubleshooting


Problem

I am receiving an SQL0804 error when running a load and specifying an exception table. If I do not specify an exception table, then it runs succesfully.

Symptom

When running a load and specifying an exception table, the following error is received:

SQL3015N An SQL error "-804" occurred during processing
SQL0804N The application program parameters for the current request
are not valid. Reason code "100". If a host variable or SQLVAR in the
SQLDA is invalid then: host variable/SQLVAR number = "", SQLTYPE = "",
SQLLEN = "", host variable/SQLVAR type = "". SQLSTATE=07002

The following can be seen in the db2diag.log:


2015-11-19-04.39.36.157377-300 I688137131E644 LEVEL: Warning
PID : 20280 TID : 140130912298752 PROC : db2sysc 0
INSTANCE: db2i1 NODE : 000 DB : <dbname>
APPHDL : 0-825 APPID: *LOCAL.db2i1.151119093719
AUTHID : DB2I1 HOSTNAME: <hostname>
EDUID : 187 EDUNAME: db2agent (LINUXDB) 0
FUNCTION: DB2 UDB, access plan manager, sqlra_get_section, probe:1350
MESSAGE : cannot prepare a non-dynamic section for section 27.
DATA #1 : Hexdump, 8 bytes
0x00007F72923F0F28 : 4E55 4C4C 4944 2020 NULLID

2015-11-19-04.39.36.158409-300 I688137776E644 LEVEL: Warning
PID : 20280 TID : 140130912298752 PROC : db2sysc 0
INSTANCE: db2i1 NODE : 000 DB : <dbname>
APPHDL : 0-825 APPID: *LOCAL.db2i1.151119093719
AUTHID : DB2I1 HOSTNAME: <hostname>
EDUID : 187 EDUNAME: db2agent (LINUXDB) 0
FUNCTION: DB2 UDB, access plan manager, sqlra_get_section, probe:1400
MESSAGE : cannot prepare a non-dynamic section for section 27.
DATA #1 : Hexdump, 8 bytes
0x00007F72B1913D3C : 5351 4C55 4A4B 3047 SQLUJK0G

2015-11-19-04.39.36.159577-300 I688138421E765 LEVEL: Error
PID : 26516 TID : 140442222487328 PROC : db2bp
INSTANCE: db2i1 NODE : 000 DB : <dbname>
APPID : *LOCAL.db2i1.151119093719
HOSTNAME: <hostname>
FUNCTION: DB2 UDB, database utilities, sqluCheckSqlca, probe:2251
MESSAGE : SQL0804N The application program parameters for the current request
are not valid. Reason code "100". If a host variable or SQLVAR in
the SQLDA is invalid then: host variable/SQLVAR number = "", SQLTYPE
= "", SQLLEN = "", host variable/SQLVAR type = "".
DATA #1 : String, 12 bytes
sqlucktb.SQC
DATA #2 : String, 44 bytes
Error from Import/Export or Load Processing.

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Data Movement - Load","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.1;10.5;9.7;9.8","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
30 April 2025

UID

swg21971501

Page Feedback