A fix is available
APAR status
Closed as program error.
Error description
1) Abend S0C4 rc11 when attempting to unload a non partitioned LOB TS with an ORDER BY clause. ( abend0c4 abends0c4 rc 11 ) PB 10024 2) Msg INZU238E UNEXPECTED UNSUPPORTED SELECT is issued when the logical unload statement includes an SQL expression where CHAR(constant) is used in another expression on a subsystem with MIXED=YES. PB 10045 3) Abend S0C4 in INZUTILK when processing logical unload statement including a CASE expression with no ELSE clause and msg LSCX041 inznodeConvert PB 10048 4) Syntax error when processing a SQL statement including a numerical constant with a decimal separator. The following expressions patterns cause the unload process to stop: dd. : ex 51. dd.dd : ex 100.32 dd.E+dd : 10.e+3 dd.ddE+dd : 10.2e+3 dd,E+dd : 10,e+3 function(nn,) : CHAR(10,). Almost any syntax error message may be issued depending on the exact syntax of the unload statement. msgINZU096E REQUIRED KEYWORD, FROM, NOT SPECIFIED, PROCESSING TERMINATED is one of the possible messages. PB 10066 5) A point is used as decimal point for external representation of decimal data regardless of the DB2 subsystem settings. When the DB2 settings specify COMMA as decimal separator, the numerical data unloaded into an external format is written with a period instead of a comma. PB 10067 6) On a DB2 subsystem with MIXED=YES, an incorrect LOAD statement is generated during the conversion from GRAPHIC or VARGRAPHIC data to a VARCHAR output field. The keywords VARCHAR MIXED are missing from the output field specification of the LOAD statement. Error message issued by LOAD may depend on the exact LOAD statement to be generated. A typical message is "DSNU082I DSNUGPRS - INVALID KEYWORD - nn" PB 10119 7) HPU terminates with RC08 and msg INZU215E LOAD STATEMENT ERROR : INVALID CONVERSION FOR COLUMN colname when the unload statement requests conversion from GRAPHIC or VARGRAPHIC data to VARCHAR output field when FORMAT USER and load statement generation (LOADDDN) are requested. PB 10122 -------------------------------------------------------- ADDITIONAL SYMPTOMS: Message LSCX110 when using LOADOPT
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 High Performance Unload. * **************************************************************** * PROBLEM DESCRIPTION: 1. S0C4 ABEND occurs when attempting * * to unload a non partitionned LOB * * tablespace with an ORDER BY clause. The * * detailled sympom is as follows: * * 16.04.15 JOB05753 IEA995I SYMPTOM * * DUMP OUTPUT 415 * * SYSTEM COMPLETION CODE=0C4 REASON * * CODE=00000011 * * TIME=16.04.15 SEQ=02059 CPU=0000 * * ASID=001A * * PSW AT TIME OF ERROR 077D2000 * * 926A77A4 ILC 4 INTC 11 * * NO ACTIVE MODULE FOUND * * NAME=UNKNOWN * * DATA AT PSW 126A779E - C0984B90 * * C0D44899 000058B0 * * GR 0: 00000000 1: 12744E40 * * 2: 00099885 3: 12726188 * * 4: 12B26FFF 5: 000990C0 * * 6: 00099885 7: 12732938 * * 8: 00000000 9: 12B26FFC * * A: 92709108 B: 00018774 * * C: 126A7710 D: 12726188 * * E: 00000023 F: 126A7710 * * PB 10024 * * 2. On a DB2 subsystem with MIXED=YES, * * msgINZU238E UNEXPECTED UNSUPPORTED * * SELECT is issued when the logical * * unload statement includes an SQL * * expression where CHAR(constant) is * * used in another expression. * * PB 10045 * * 3. ABEND S0C4 occurs when processing a * * logical unlooad statement including a * * case expression with no ELSE clause. * * The detailed symptom is as follows : * * IEA995I SYMPTOM DUMP OUTPUT 908 * * SYSTEM COMPLETION CODE=0C4 * * REASON CODE=00000004 * * TIME=22.58.34 SEQ=11620 CPU=0000 * * ASID=0051 * * PSW AT TIME OF ERROR 078D1000 * * 800B23BE ILC 2 INTC 04 * * ACTIVE LOAD MODULE * * ADDRESS=00007000 OFFSET=000A * * NAME=INZUTILK * * DATA AT PSW 000B23B8 - 472055CE * * 0E0247E0 55D65810 * * GR 0: 00000002 1: 0000000A * * 2: 12349748 3: 0000000A * * 4: 000C12B0 5: 000B1DF4 * * 6: 0000000A 7: 00000002 * * 8: 00000000 9: 123560F8 * * A: 000C2A60 B: 00000000 * * C: 8041C008 D: 0041F768 * * E: 800B227E F: 12313B78 * * END OF SYMPTOM DUMP * * and in the SYSnnnn data set: * * LSCX041 **** ERROR **** * * ABEND occurred in line 8504 of * * @@133768(INODE) ,offset 0005D2 * * Extended name: _inznodeConvert * * Program terminated by operating system. * * ABEND code = S0C4 * * PB 10048 * * 4. On a DB2 subsystem with decimal * * separator set to COMMA, a syntax error * * occurs when processing a SQL statement * * including a numerical constant with a * * decimal separator. The following * * expressions patterns cause the unload * * process to stop: * * dd. : ex 51. * * dd.dd : ex 100.32 * * dd.E+dd : 10.e+3 * * dd.ddE+dd : 10.2e+3 * * dd,E+dd : 10,e+3 * * function(nn,) : CHAR(10,). * * Various syntax error message may be * * issued depending on the exact syntax * * of the unload statement. msgINZU096E * * REQUIRED KEYWORD, FROM, NOT SPECIFIED, * * PROCESSING TERMINATED is one of the * * possible message. * * PB 10066 * * 5. A point is used as decimal point * * for external representation of decimal * * data regardless of the DB2 subsystem * * settings. When the DB2 settings * * specify COMMA as decimal separator, * * the numerical data unloaded into an * * external format is written with a * * period instead of a comma. * * PB 10067 * * 6. When the SORTKEYS operand * * (specified either in the SYSIN or in * * the parmlib dataset) length exceeds 8 * * digits, the following messages are * * issued within dynamically allocated * * dataset named SYSnnnn: * * LSCX110 **** NOTE **** * * Generated in MEMCPY called from * * line 2748 of 312348(IRLOAD) , * * offset 0004E4 * * Extended name: _inzrloadPrintOptionTs * * Arguments to memcpy overlap (length * * = 4294967286). Results are * * unpredictable. * * LSCX500 **** WARNING **** ERRNO = * * Generated in MEMCPY called from * * line 2748 of 312348(IRLOAD) , * * offset 0004E4 * * Extended name: _inzrloadPrintOptionTs * * File not opened, ddname SYSTERM not * * defined. * * Interrupted while: Opening file * * "//ddn:*" (stderr) * * Printing runtime message 110 * * LSCX110 **** NOTE **** * * Generated in MEMCPY called from * * line 1029 of 227316(OCHAR) , * * offset 00028C * * Extended name: ocharAppend * * Arguments to memcpy overlap (length * * = 4294967295). Results are * * unpredictable. * * Moreover, the SORTKEYS specification * * is missing in the LOADDDN dataset. * * PB 10081 * * 7. On a DB2 subsystem with MIXED=YES, * * a wrong LOAD statement is generated * * when the unload statement implies * * conversion from GRAPHIC or VARGRAPHIC * * data to a VARCHAR output field. In * * such a case, the keywords VARCHAR * * MIXED are missing from the output * * field specification of the LOAD * * statement. The error message issued * * by the LOAD may depend on the exact * * LOAD statement involved. A typical * * message is "DSNU082I DSNUGPRS - * * INVALID KEYWORD - nn" where nn is the * * expected length of the (VAR)CHAR * * MIXED output filed. * * PB 10119 * * 8. HPU stops with return code 8 and * * issues msg INZU215E LOAD STATEMENT * * ERROR : INVALID CONVERSION FOR COLUMN * * colname when the unload statement * * requests conversion from GRAPHIC or * * VARGRAPHIC data to VARCHAR output * * field. This occurs only if FORMAT * * USER and load statement generation * * (LOADDDN) are requested. * * PB 10122 * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** 1. inzt2dsn, blkt2dsn, inzgct2d were changed to take into account the partitionning of the LOB tablepsace. 2. inznode was changed to correctly handle CHAR(constant) expressions. 3. inznode was changed to correctly analyze the CASE expression. 4. inznode and olex modules were changed to take the decimal point into account. 5. inznode and olex modules were changed to take the decimal point into account. 6. inzrload and inzhyaccwere changed to support bigint values as an operand for SORTKEYS. 7. inzrload was changed to correctly determine the output field type when (VAR)GRAPHIC -> VARCHAR conversion is involved. 8. inzrload was changed to accept (VAR)GRAPHIC -> VARCHAR conversion when generating LOAD statement.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PK92693
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
2009-07-30
Closed date
2009-09-02
Last modified date
2009-12-17
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
INZUTILB
Fix information
Fixed component name
DB2 HI PERF UNL
Fixed component ID
5697F4400
Applicable component levels
R310 PSY UK49782
UP09/09/10 P F909
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