A fix is available
APAR status
Closed as program error.
Error description
Receive MSGINZU059W with RC=04 when using FASTUNLOAD syntax and CTLDDN=SYSCTL and when the SYSCTLnn DD is allocated as DUMMY. PB 8698 ADDITIONAL SYMPTOMS 1) The DATE, TIME, and TIMESTAMP are incorrect when the SELECT is being done by DB2 and it encounters a nullable column after a DATE, TIME or TIMESTAMP NOT NULL. PB 8686 2) When unloading a tablespace with an sql containing a common table expression, it fails with: INZU097E SYNTAX ERROR - UNRECOGNIZED ELEMENT WITH FOR UNLOAD BLOCK PB 8768 3) ABEND0C4 when HPU UNLOAD of INLINE ImageCopy is run without INLINE parm in SYSIN. Warning or error message should be issued instead of ABEND0C4. PB 8775 4) Invoking HPU via DB2 ADMIN TOOL. From ADMIN TOOL panel ADB21T, using the command HPU for a table gets the following error: &ZPREFIX NOT USABLE and HPU doesn't start. Under HPU R210 the same error is indicated but HPU does start. PB 8286
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 High Perofrmance Unload. * **************************************************************** * PROBLEM DESCRIPTION: For 220..... * * An abend S0C4 can occur when unloading * * from an INLINE Image Copy without * * specifying the INLINE keyword or CHECK * * keyword in the SYSIN DD card. HPU will * * now end with RC 8 and issue a message * * to explain that the pages are not in * * the expected sequence. PB 8775 * * For 310..... * * 1. Message INZU063I incorrectly issued * * when DB2 FORCE is specified PB 5772 * * 2. Message &ZPREFIX not USABLE issued * * in the ISPF application. PB 8286 * * 3. Cosmetic changes in the ISPF * * application: * * - The spelling of Table Space (in 2 * * words) in messages and in panels. * * - The copyright screen appeared on * * panel INZA10 which is not the first * * panel of the application. * * - Changes in the description of * * possible values in panel INZA10. * * PB 8287 * * 4. ISPF application: ISPF error * * message is issued when UNLMAXROWS or * * UNLFREQROWS values a re too large. * * PB 8294 * * 5. ISPF application: On panel INZB12, * * if PART ALL is selected using 'U', an * * ISPF error message occurs. PB 8296 * * 6. ISPF application: With partition * * selection, the generated JCL is * * inconsistent and message INZU012E * * CONFLICT BETWEEN SELECT PART() AND * * UNLOAD PART() SPECIFICATIONS is issued * * if the job is submitted. PB 8297 * * 7. ISPF application: The generated JCL * * is incorrect when a LIKE TABLE and a * * CCSID conversion are both required. * * PB 8300 * * 8. ISPF application: The generated JCL * * is incorrect when a table with a long * * name is used. The generated JCL * * contains a blank in column 72 and the * * submitted job fails. PB8305 * * 9. ISPF application: ISPF error when * * the partition number is entered on 5 * * digits onpanel INZA10. PB 8307 * * 10. REFORMAT option : the NULL x y * * option is ignored. Same problem for * * the INTO clause. PB 8328 * * 11. When unloading a tablespace with * * QUIESCE YES on which the status of one * * index prohibits the QUIESCE processing * * (for example REBUILD PENDING), an * * abend U1210 can occur. PB 8338 * * 12. An SELECT made on a view created * * with delimited identifiers fails with * * error message INZI010E INTERNAL * * CONVERSION ERROR BETWEEN CCSID 290 AND * * CCSID 1208. PB 8356 * * 13. When unloading an EBCDIC table * * space in UNICODE, some conversion * * error message can be issued. The * * messages are: * * * 226 * CONVERSION ROUTINE ERROR * * * ddname* colname * * * data PB 8371 * * 14. Error message INZI322E LISTEF * * ERROR: LOB OPTION IS NOT SUPPORTED BY * * UTILITY is issued when a LISTDEF with * * CLONE is coded. In addition a U1210 * * can occur when unloading from a table * * that has a CLONE table with a listdef. * * PB 8383 * * 15. In DB2 V9 only, after an ALTER ADD * * COLUMN, the unloaded data can be * * incorrect for the added column. * * PB 8428 * * 16. Various errors with DDLDDN: * * - DDNDDL is incorrectly processed when * * coded after COPYDDN ddname,INLINE. * * Some error messages INZI188E can be * * issued. * * - An S0C4 abend can occur when using * * bufferpool > 8Kb * * - A RC=8 + INZI503E DDL ANALYSING: * * SYNTAX ERROR AT POS(nn, nn) is issued * * when accessing to a tablespace * * defined with table partitioning * * (PARTITION BY RANGE), or with * * MAXPARTITIONS (partition by growth). * * - A RC=8 + message INZI503E is issued * * when the DDL contains an ALTER * * statement or a CREATE VIEW * * - Message NZI010E INTERNAL CONVERSION * * ERROR BETWEEN CCSID 290 AND CCSID 930 * * is issued when the DDL contains some * * DBCS identifiers * * - A S0C4 abend can occur when the * * DDLDDN contains several tables, each * * one with a CREATE INDEX. * * - Error message INZU273E ORIGINOBID IS * * MANDATORY TO UNLOAD DROPPED * * MULTI-TABLES TABLESPACE FROM FIC is * * issued for a multi-table table space * * with the OBID specified for each * * table in the DDLDDN file. In this * * case the DDLDDN file contains enough * * information and this message should * * not be issued. * * - Message INZI510E DDL ANALYSING: * * DUPLICATE DESCRIPTION OF COLUMNS * * is issued when the DDLDDN file * * contains a BIGINT columns. * * - Message INZI503E is issued for a * * PARTITION BY RANGE is coded in a * * CREATE INDEX and the USING stogroup * * clause is used after the range * * definition. PB 8432 * * 17. Missing information message with * * UNLOAD PLUS syntax in FORMAT CSVwhen a * * SYSCNTL file is requested. The message * * INZU216I LOAD STATEMENT CAN NOT BE * * GENERATED IN FORMAT CSV should be * * issued. PB 8459 * * 18. Message INZU065E INCONSISTANT * * PARAMETER LIST is issued when a IN * * predicate with very larger numeric * * values is used in a SELECT in DB2 NO. * * PB 8498 * * 19. Incorrect data unloaded on a table * * on which an ALTER ADD col CHAR NOT * * NULL WITH DEFAULT USER has been issued * * before the unload. PB 8530 * * 20. When doing an unload from an image * * copy using image copy per partition, * * and when a ddname is missing the * * message "INZU293E UNLOAD FROM IMAGE * * COPY STARTING AT POS(nn,nn). NO OUTPUT * * DDNAME FOUND FOR PARTITION nn" is * * issued instead of INZU234E COPYDDN NOT * * FOUND FOR PARTITION nn. PB 8614 * * 21. UNLOAD PLUS SYNTAX: A U1009 abend * * can be issued when unloading a * * DATA/TIMA columns into a smaller CHAR * * column using the TRIM or MIXED option. * * PB 8646 * * 22. An abend U1133 or U1135 is issued * * when unloading a partitioned * * tablespace with LOB data into LOB * * file Reference with an ORDER BY. * * PB 8689 * * 23. Data unloaded after a LOB file * * reference can be incorrect when the * * length of the LOB data is shorter than * * the name of the file reference. * * PB 8692 * * 24. When QUIESCECAT YES is used, the * * list of quiesced table spaces contains * * too many objects. Some of the table * * spaces that are quiesced are not * * accessed by HPU at the VSAM level. * * PB 8693 * * 25. FastUnload syntax using * * LOAD-CONTROL NONE. Message * * INZU059W LOADDDN: SYSCTL01 NOT FOUND. * * SKIP LOAD STATEMENT GENERATION FOR * * SELECT STARTING AT POS(1, 0) is * * incorrectly issued, and the return * * code is 4 instead of 0. This message * * should not be issued with LOAD-CONTROL * * NONE. PB 8698 * * 26. Abend U1210 when using a * * Fastunload parameter with an HPU sysin. * * Can also occur with an HPU parameter * * incorrectly codded (2 consecutive * * commas in the parm field). PB 8704 * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** For 220..... Module udbcrrts was changed to issue message INZRE40 when finding some pages not in sequence. For 310..... 1. Module inzctrl.c was changed to remove message INZU063I when DB2 FORCE is specified. 2. This message &ZPREFIX NOT USABLE has been removed. 3. Messages files inzm01 inzm02 inzm03 were changed. Module INZUNLPR was changed to display the copyright only on the first panel. Panel INZA10 was changed. 4. Panels INZA10 and INZB100 where changed to control the value of UNLMAXROWS and UNLFREQROWS. 5. Panel INZPART1 was changed to fix this problem. 6. Skeleton INZSGEN was fixed to correct this problem. 7. Skeletons inzssel2 and inzssel1 were changed. 8. Module unlispf is changed to generate a correct JCL. 9. Panel INZA10 was changed to fix this problem. 10. Modules udbldef udbcrfel inzpabf were changed to process correctly this option. 11. Module oddlcmd was changed to avoid this error. 12. Module inzcat whas changed to process correctly delimited identifiers. 13. Modules inzmsgs and inzctrlh were changed to issue a new warning message INZU502W when conversion error can occur. 14. Modules inzctrlh olistdef inzquery inzqryv8 inztask were changed to process correctly the CLONE objects. 15. Module udbspmfl was changed to process correcty the altered rows. 16. Modules oddlx2y and oddlx2 were changed to process correctly the DDLDDN file. 17. Module inzctrlp was changed to issue message INZU216I when needed. 18. Modules inznode and udbspxwr were changed to process correclt large numeric values. 19. Module inzpabf was fixed to correct this problem. 20. Module inzctrlh was changed to issue the correct message. 21. Modules inzctrlh inzctrlp inzpyacc inzatom were changed to process correctly the TRIM option. 22. Module udbcrfel was fixed to process correctly this case. 23. Module inzgcxtr was changed to process correctly this case. 24. Modules inzctrl inzctrlh inzctrlz and odb2util were changed to reduce ths list of quiesced DB2 catalog table spaces. 25. Modules inzctrlf and inzfyacc were changed to fix this problem. 26. Modules inzctrl inzctrlh inzmain were changed to avoid issuing a U1210 abend in such a case.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PK38957
Reported component name
DB2 HI PERF UNL
Reported component ID
5697F4400
Reported release
220
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2007-02-07
Closed date
2007-05-29
Last modified date
2007-07-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK25580 UK25581
Modules/Macros
INZACDB2 INZA10 INZA201 INZB102E INZB102I INZB12 INZCRXSM INZCRXSQ INZHPUSK INZH0005 INZM01 INZM02 INZM03 INZQRYV8 INZQUERY INZRSAVE INZSDBA INZSDBE INZSDBU INZSETA INZSETE INZSETU INZSGEN INZSPLOC INZSSEL1 INZSSEL2 INZTPMEM INZT02 INZUNLPR INZUTILB INZUTISK
Fix information
Fixed component name
DB2 HI PERF UNL
Fixed component ID
5697F4400
Applicable component levels
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":"220","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 February 2021