A fix is available
APAR status
Closed as program error.
Error description
When specifying the IN operator multiple times in a WHERE predicate, HPU does not return the correct amount of rows. The same UNLOAD with DB2 FORCE produces the correct amount of rows. Changing the IN operator to an equal operator works OK also. ADDITIONAL SYMPTOMS: 1) Using UNLOAD PLUS syntax HPU generates a null indicator when when null is specified. PB 8643 2) ABEND0C4 during HPU UNLOAD: LSCX041 **** ERROR **** ABEND occurred in line 12012 of @@518258(IPABF) ,offset 000E4C Extended name: inzpabfFillDsu Program terminated by operating system. ABEND code = S0C4 PB 8735
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 High Performance Unload. * **************************************************************** * PROBLEM DESCRIPTION: When specifying the IN operator * * multiple times in a WHERE predicate, * * HPU does not return the correct amount * * of rows. The same UNLOAD with DB2 FORCE * * produces the correct amount of rows. * * Changing the IN operator to an equal * * operator works OK also. PB 8643 * * ADDITIONAL SYMPTOMS: * * 1. Using UNLOAD PLUS syntax HPU * * generates a null indicator when null * * is specified. PB 8643 * * 2. ABEND0C4 during HPU UNLOAD: LSCX041 * * **** ERROR **** ABEND occurred in line * * 12012 of @@518258(IPABF) ,offset * * 000E4C Extended name: inzpabfFillDsu * * Program terminated by operating * * system. ABEND code = S0C4 PB 8735 * * 3. HPU 310 ONLY : When unloading an * * ASCII or UNICODE tablespace in DB2 * * FORCE using ASIS, data is unloaded in * * EBCDIC instead of using the correct * * encoding scheme. PB 8618 * * 4. HPU 310 ONLY : An ORDER BY clause * * coded in a non supported select can * * give an error message INZU039E FATAL * * SYNTAX ERROR PB 8742 * * 4a.HPU 310 only: When a keyword is * * used as a column name in the new INTO * * clause of the HPU syntax, error * * messages INZU016E and INZU039E are * * issued. These keywords should be * * accepted as column names in the INTO * * clause. PB 8608 * * 5. HPU 310 only: Error message * * INZI010E INTERNAL CONVERSION ERROR * * BETWEEN CCSID nnn AND CCSID 1208 * * is issued when a SELECT uses a * * delimited table or view name (between * * quotes). PB 8615 * * 6. HPU 310 only: When unloading a * * UNICODE or ASCII tablespace using a * * SELECT processed by DB2 with the ASIS * * option, the content of the output data * * is incorrectly converted to EBCDIC. * * 7. HPU 310 only: When OPTIONS NULLID * * YES is specified for a SELECT, HPU * * wrongly generates a a null identifier * * in the output data and a NULLIF in the * * corresponding LOADDDN file for columns * * defined as NOT NULL. PB 8632 * * 8. HPU 310 only: When a SELECT with * * FORMAT VARIABLE ALL is requested, the * * output variable columns are wrongly * * padded and written on their maximum * * length. PB 8621 * * 9. HPU 310 only: When a REFORMAT or * * INTO clause is used to change a * * numeric column into a VARCHAR, the * * corresponding load sysin (LOADDDN) is * * incorrect because the data type is not * * specified for the column. PB 8519 * * 10. HPU 310 only: When a REFORMAT or * * an INTO clause is used to change a * * numeric column into an EXTERNAL data * * type, the corresponding load sysin * * (LOADDDN) is incorrect because a CHAR * * data type is used instead of the * * corresponding EXTERNAL data * * type. PB 8518 * * 11. When converting a graphic column * * into a CHAR MIXED using a FORMAT USER, * * the LOAD sysin may beincorrect. PB 7827 * * 12. HPU 310 only: In FastUnload syntax, * * when LOAD-CONTROL ONLY is used, an * * abend U1003 occurs and a message * * IEC130I DD STATEMENT MISSING with an * * empty ddname is issued. PB 8460 * * 13. HPU 310 only: In HPU or Unload * * Plus syntax, when an ORDER BY is * * specified on a column that is * * reformated by an INTO clause, a SORT * * error may occur and a U1009 abend is * * issued. PB 8635 * * 14. In FastUnload syntax, in * * OUTPUT-FORMAT COMMA-DELIMITED, for * * FLOAT data, the plus sign is replaced * * by a binary zero (x'00'). PB 8619 * * 15. HPU 310 only: An abend S0C4 may * * occur when a TEMPLATE is used in a * * SELECT processed by DB2 (DB2 FORCE or * * DB2 YES with non supported SELECT) * * without specifying the space primary * * and secondary allocation parameters. * * The correct processing is to issue * * error message INZU276E. PB 8599 * * 16. New parmlib variable WRKTVCNT has * * been added. This variable allows to * * set the VOLCOUNT parameter when * * temporary files are dynamically * * allocated on tape using the unit name * * specified in WRKTUNIT. By default the * * VOLCOUNT is set to 5. This variable * * allows using higher values, and avoid * * abend S837-08, and messages IEC028I * * 837-08. PB 6451 * * 17. HPU 310 only: An error message * * "INZU499E ERROR: NO INFORMATION FOUND * * IN SYSIBM.SYSAUXRELS FOR LOB COLUMN : * * colname" is issued when trying to * * unload a LOB column using a lob file * * reference either from a view, or when * * the lob column is renamed in the * * SELECT. PB 8687 * * 18. Incorrect evaluation of the WHERE * * clause when several CCSID conversion * * are involved. This problem occurs when * * a WHERE clause is coded for a table * * contained in an ASCII or UNICODE * * tablespace, and when the WHERE clause * * contains at the same time some * * predicate on character strings, and * * some other predicates on numeric data. * * The result is generally that rows are * * missing in the output file, possibly * * an empty output file. PB 8657 * * 19. HPU 310 only: In FastUnload syntax, * * columns unloaded with an INTO clause * * specifying a numeric EXTERNAL datatype * * are incorrectly unloaded. The padding * * can be done with blanks instead of * * zeroes ('0'). PB 8620 * * 20. HPU 310 only: When a conversion is * * defined into a GRAPHIC EXTERNAL with a * * REFORMAT option, the LOADDDN is * * incorrect. PB 8557 * * 21. HPU 310 only: the unload from a * * full image copy (FIC) returns no rows * * in DB2 V9. PB 8424 * * 22. HPU 310 only: An abend S0C4 occurs * * when unloading from an incremental * * image copy (IIC). PB 8543 * * 23. HPU 310 only: In Unload Plus and * * Fastunload format, when an INTO clause * * is used to rename the target table * * (INTO NAME for Unload Plus or INTO * * TABLE for FastUnload), the output data * * is incorrect (contains binary zeroes). * * Other symptom, an abend S0C4 can also * * occur. PB 8663 * * 24. HPU 310 only: An abend U1010 may * * occur when 2 partitioned tablespaces * * are unloaded in the same UNLOAD * * COMMAND with PARALLELISM activated * * (PARALLELISM > 1) PB 8284 * * 25. In FastUnload syntax, in * * OUTPUT-FORMAT DSNTIAUL, the null values * * for character columns are incorrectly * * padded with blanks instead of binary * * zeroes. PB 8677 * * 26. HPU 310 only: In HPU syntax, when * * the INTO clause is used with a list of * * columns, and when a column name is not * * specified but replaced by a comma, a * * return code 8 and a message INZU016E * * INTO STATEMENT SYNTAX IS INVALID are * * issued. PB 8456 * * 27. HPU 310 only: When message * * INZI188E is issued, the LDS name is * * truncated. PB 8482 * * 28. HPU 310 only: When a TEMPLATE is * * used to create a PDS file, and when 2 * * SELECT processed in parallel write in * * the same file but in different members, * * the output data is incorrect. PB 8497 * * 29. An abend S0C9 can occur when the * * parmib parameter MAXTUNIT is set to * * 0. PB 8694 * * 30. This APAR adds the support of LOB * * FILE REFERENCE for SELECT processed by * * DB2 (DB2 FORCE or DB2 YES with non * * supported SELECT) PB 7312 * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Modules inzpyacc and inzctrlp were changed to remove the null byte indicator when IF NULL is used in Unload Plus syntax. Additional Fixes: 1. Modules inzpyacc and inzctrlp were changed to remove the null byte indicator when IF NULL is used in Unload Plus syntax. 2. Module inzpab was changed to update the PAB control blocks for multiple unload of the same TS. 3. Modules inzquery, inzqryv8, inzctrl and inztask were changed to retrieve the CCSID of the tablespace and can issue error message INZU304E in case of SQL error when retrieving this value. 4. Module inzhyacc was change to change the parsing of the SELECT statements in this case. 4a. Module inzhyacc was changed to analyze correctly delimited identifiers. 5. Module inzhyacc was changed to analyze correctly delimited identifiers 6. Modules inzctrlh, inzquery and inzqryv8 were changed to process the SELECT using the encoding scheme and CCSID of the tablespace. 7. Modules inzmsgs and inzctrlh were changed to specify the NULLIF keyword only when necessary. 8. Module inzctrlh was changed to process correctly FORMAT VARIABLE ALL. 9. Module inzrload is changed to generate the correct data type when a numeric is converted into a VARCHAR. 10. Module inzrload is changed to generate the correct external data type when a numeric is converted into a numeric EXTERNAL. 11. Modules inzatom and inzrload were changed to generate correctly the LOAD sysin. 12. Module inzrunh was changed. The unload process should not be started when LOAD-CONTROL ONLY is specified. 13. Module inzpab was changed to generate the SORT sysin on the content of the original data, before formatting. 14. Modules inzctrlp and inzctrlf were changed. Functions inzcontrolUnpDelimitedEcs(), inzcontrolUnpExternalEcs() and inzcontrolFunDelimitedEcs() where changed to process correctly the sign character for FLOAT data. 15. Modules inzrunh and otmplate were changed to fix this problem. 16. Not a bug 17. Modules inzctrlh and inzpabf were changed to process correctly renamed LOB columns. 18. Module inznode was changed. The CCSID is set correctly for each predicate. 19. Module inzctrlf was changed to process correctly the padding character. 20. Modules udbcrfel, inzhyacc, inzctrlh, inzpabf, inzrload were changed to generate correcyl the LOAD sysin when REFORMAT is used. 21. Module udbcrrts was changed to process correctly the input FIC in V9. 22. Module udbcrrts was changed to process correctly the input IIC. 23. Modules inzpyacc and inzfyacc were changed to process correctly the INTO NAME and INTO TABLE. 24. Module udbcrrts was changed to process correctly the parallelism of several partitioned tablespaces. 25. Module inzctrlf was changed to process correctly the padding character. 26. Module inzhyacc was changed to accept an ending semicolon in the INTO clause. 27. Module oestime was changed to display the complete LDS name in error messages. 28. Modules inzctrl and inzctrlh were changed to de-activate the parallelism when the output file is a PDS or PDSE. 29. Module inzplib was changed to control the value of this parameter. 30. Not a bug
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PK38092
Reported component name
DB2 HI PERF UNL
Reported component ID
5697F4400
Reported release
310
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2007-01-25
Closed date
2007-03-16
Last modified date
2007-04-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK23114
Modules/Macros
INZACDB2 INZCRXSM INZCRXSQ INZQRYV8 INZQUERY INZRSAVE INZSBIND INZSDBA INZSDBE INZSDBU INZSETA INZSETE INZSETU INZSPLOC INZTPMEM INZTTBL INZUTILB INZUTISK
Fix information
Fixed component name
DB2 HI PERF UNL
Fixed component ID
5697F4400
Applicable component levels
R310 PSY UK23114
UP07/03/21 P F703
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSAUUV","label":"IBM Db2 High Performance Unload for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"310","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 February 2021