|
Problem IC62489
|
Status: Closed |
SQL0804N WHEN USING LOAD WITH STATISTICS |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
When running LOAD with STATISTICS on DB2 v9.7 GA for AIX, Linux
you may receive the following error:
SQL0804N The application program parameters for the current
request are not
valid. Reason code "". 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 corresponding db2trc will have a .flw output something like:
1329665 | | | | | | sqlusCLoadSubAgent::iRun entry [eduid
156 eduname db2agent]
1330992 | | | | | | | sqluLoadPartition entry [eduid 156
eduname db2agent]
1339244 | | | | | | | | call_sqluvload entry [eduid 156
eduname db2agent]
1339249 | | | | | | | | | sqluvload data [probe 1294]
1475466 | | | | | | | | | | DIAG_NOTE data [probe 0]
1475455 | | | | | | | | | | | sqlulPollMsg data [probe 3945]
1475460 | | | | | | | | | | | | sqlulFRMResponse data [probe
4991]
1475481 | | | | | | | | | | | | | sqlulEnd entry [eduid 156
eduname db2agent]
1475848 | | | | | | | | | | | | | | sqlu_update_sys_stats
entry [eduid 156 eduname db2agent]
1475851 | | | | | | | | | | | | | | |
sqluCCatalogInfo::iUpdateCatalogWithStats entry [eduid 156
eduname db2agent]
1475858 | | | | | | | | | | | | | | | | sqlr_update_catalogs
entry [eduid 156 eduname db2agent]
1479040 | | | | | | | | | | | | | | | | |
sqlr_prep_catalog_string entry [eduid 156 eduname
db2agent]
1479041 | | | | | | | | | | | | | | | | | | sqlv_z2ascii
entry [eduid 156 eduname db2agent]
1479049 | | | | | | | | | | | | | | | | | | | sqlrxd2a exit
[rc = 0x8016000E = -2146041842 =
SQLRXITD] |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* n/a *
****************************************************************
* PROBLEM DESCRIPTION: *
* When running LOAD with STATISTICS on DB2 v9.7 GA for AIX, *
* Linux *
* you may receive the following error: *
* *
* *
* *
* *
* *
* SQL0804N The application program parameters for the current *
* *
* request are not *
* *
* valid. Reason code "". 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 corresponding db2trc will have a .flw output something *
* like: *
* *
* *
* *
* *
* 1329665 | | | | | | sqlusCLoadSubAgent::iRun entry *
* [eduid *
* 156 eduname db2agent] *
* *
* 1330992 | | | | | | | sqluLoadPartition entry [eduid 156 *
* *
* eduname db2agent] *
* *
* 1339244 | | | | | | | | call_sqluvload entry [eduid 156 *
* *
* eduname db2agent] *
* *
* 1339249 | | | | | | | | | sqluvload data [probe 1294] *
* *
* 1475466 | | | | | | | | | | DIAG_NOTE data [probe 0] *
* *
* 1475455 | | | | | | | | | | | sqlulPollMsg data [probe *
* 3945] *
* 1475460 | | | | | | | | | | | | sqlulFRMResponse data *
* [probe *
* 4991] *
* *
* 1475481 | | | | | | | | | | | | | sqlulEnd entry [eduid *
* 156 *
* eduname db2agent] *
* *
* 1475848 | | | | | | | | | | | | | | *
* sqlu_update_sys_stats *
* entry [eduid 156 eduname db2agent] *
* *
* 1475851 | | | | | | | | | | | | | | | *
* *
* sqluCCatalogInfo::iUpdateCatalogWithStats entry [eduid 156 *
* *
* eduname db2agent] *
* *
* 1475858 | | | | | | | | | | | | | | | | *
* sqlr_update_catalogs *
* entry [eduid 156 eduname db2agent] *
* *
* 1479040 | | | | | | | | | | | | | | | | | *
* *
* sqlr_prep_catalog_string entry [eduid 156 eduname *
* *
* db2agent] *
* *
* 1479041 | | | | | | | | | | | | | | | | | | sqlv_z2ascii *
* *
* entry [eduid 156 eduname db2agent] *
* *
* 1479049 | | | | | | | | | | | | | | | | | | | sqlrxd2a *
* exit *
* [rc = 0x8016000E = -2146041842 = *
* *
* SQLRXITD] *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 FixPak 1 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First fixed in DB2 Version 9.7 FixPak 1 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 13.08.2009
24.02.2010
24.02.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
