A fix is available
APAR status
Closed as new function.
Error description
This APAR is created to provide New Function to DB2 HPU R310. including unload of XML columns.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 High Performance Unload. * **************************************************************** * PROBLEM DESCRIPTION: Support of XML columns using File * * Reference or in stream. This support * * is added in DB2 FORCE and in DB2 YES, * * the SELECT is processed by DB2. PB 8726 * * * * Additional 310 Symptoms from PK38957... * * * * 27. Unloading a partitioned table * * space into a PDS file generating one * * seperate member per partition should * * not be accepted. This case was not * * controled and the unloaded data was * * not usable. A control is now done to * * avoid this case and a new error * * message INZU501E is issued. PB 8705 * * 28. When a template that generates a * * PDS file is used in DB2 FORCE, and * * when the PDS already exists, HPU * * complains that the DIR keyword is not * * coded. For an existing PDS, the DIR * * keyword sould be ignored and not * * mandatory. The DISP should be set to * * SHR when the PDS already exist. PB 8708 * * 29. When a SUBSTR is used on a LOB * * column and when the LOB is unloaded * * using a FILE RERERENCE, an abend U1210 * * can occur. PB 8709 * * 30. An abend U1135 is issued when an * * ORDER BY is requested on a LOB column * * in a select processed natively. Such * * operation is not supported. A new * * error message INZU503E is now issued. * * PB 8710 * * 31. Error message INZU147E ERROR : * * DUPLICATE COLUMN colname IN ORDER BY * * CLAUSE is issued for a SELECT * * processed natively that unloads LOB * * data and when some of the columns of * * the ORDER BY clause are not part of * * the selected items. PB 8711 * * 32. In UNLOAD PLUS syntax or * * FASTUNLOAD syntax, the output data is * * incorrect for columns for which a * * NULLIF (U+) or DEFAULTIF (FU) clause * * is used, when the constant value is * * shorter than the output field. PB 8721 * * 33. En abend U1129 is issued when a * * DATE column is unloaded into a CHAR * * field smaller than the minimum length * * (10 characters). The correct behaviour * * is to truncate the date field on the * * specified number of characters. PB 8723 * * 34. FastUnload Syntax: A FLOAT column * * unloaded in OUTPUT-FORMAT EXTERNAL * * does not adhere to the SQL rules. The * * mantissa contains 18 digits when the * * SQL limit is 17 digits. PB 8725 * * 36. Error message INZU025E INVALID * * OPERAND FOR OPERATOR STRIP() is issued * * when RTRIM or LTRIM scalar function is * * used. PB 8727 * * 37. In FORMAT DELIMITED, the GRAPHIC * * columns are unloaded in GRAPHIC format * * instead of GRAPHIC EXTERNAL (the SO/SI * * are missing). This is a regression * * compared to pre-V8 support. PB 8733 * * 38. In V8 NFM, in DB2 FORCE a SQLCODE * * +354 on a multi-row fetch is ignored * * and may lead to an abend S0C7 or * * incorrect data in the output file. * * PB 8738 * * 39. Error message IKJ56246I DATA SET * * dsname NOT ALLOCATED, FILE IN USE when * * unloading in parallel 2 table spaces * * that have the same PSID but a * * different DBID. For one of the 2 * * tablespaces, the unloaded data is * * incorrect because HPU reads from the * * wrong LDS file. The result is * * unpredictable. In addition, if the * * tablespaces are partitioned, the * * unload fails with an abend U1005. * * PB 8739 * * 40. When keyword OUTDDN is missing, * * HPU should issue error message * * INZU096E REQUIRED KEYWORD, OUTDDN, NOT * * SPECIFIED, PROCESSING TERMINATED * * Instead of that when the OUTDDN and * * FORMAT keywords are both missing, * * either message INZU097E SYNTAX ERROR - * * UNRECOGNIZED ELEMENT FOR SELECT * * BLOCK or INZU039E FATAL SYNTAX ERROR * * BEFORE LINE nn COLUMN nn are issued. * * PB 8746 * * 41. HPU 310 Only: When a semicolon was * * missing between 2 UNLOAD commands, HPU * * was not issuing any error message. This * * control has been reintroduced in the * * HPU parser. The error message issued * * is INZU015E UNLOAD TABLESPACE STATEMENT * * MUST BE TERMINATED BY A SEMI-COLON. * * PB 8753 * * 42. Requirement MR0212077834. External * * sort for select processed by DB2. * * PB 8574 * * 43. An abend S0C4 occurs when DB2 * * FORCE is coded on a physical unload * * (UNLDDN) for which no logical unload * * (SELECT) is coded. PB 8758 * * 44. Processing of HIDDEN columns: * * A new option HIDDEN YES/NO has been * * added to the OPTIONS block. A new * * parameter can also be coded on the * * EXEC card HIDDEN(YES/NO). PB 8764 * * 45. Requirement MR0702012835. New * * message is issued to signal that the * * access mode of the unloaded object has * * been changed. INZU508I TABLE * * creator.name HAS BEEN LOCKED IN SHARE * * MODE DURING UNLOAD PROCESS. PB 8767 * * 46. Support of COMMON TABLE EXPRESSION * * has been added. PB 8768 * * 47. The value of the ULDEGREE parmlib * * variable is ignored. PB 8770 * * 48. 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 * * 49. When a LISTDEF includes a table * * that has a CLONE, and when the LISTDEF * * is used in 2 select from list to * * unload the base table and the clone * * using the CLONE keyword, the first * * table requested is unloaded twice. * * PB 8756 * * 50. When a LISTDEF with CLONED YES is * * coded, HPU terminates with error * * message INZU039E FATAL SYNTAX ERROR * * BEFORE LINE nn COLUMN nn. PB 8787 * * 51. Procedure INZT02 doesn't free the * * files allocated to write the generated * * members. PB 8788 * * 52. Inconsistency between the * * processing of the char and of the * * data/time columns in FORMAT DELIMITED. * * When no delimited is coded (DELIM * * parameter is not specified in sysin), * * the CHAR columns are not delimited. If * * parmlib variable DTDELIM is set to YES, * * the date/time columns are delimited * * using a blank character, which is not * * consistent with the processing of the * * CHAR columns. In addition if DELIM '' * * is coded, a binary value is used as a * * delimiter (x'04') In such a case * * nodelimiter should be added to the * * data. PB 8792 * * 53. ISPF INTERFACE: when the HPU * * application is invoked using DB2 ADMIN, * * an ISPF error message can be issued: * * ISPD014 Data set not cataloged 'IVAR' * * was not found in catalog. PB 8795 * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Not a bug. Additional 310 fixes from PK38957... 27. Modules inzpab and inzmsgswere changed to do this control and issue the new message. 28. Modules otmplate and inzctrlh were changed to improve the processing for existing PDS files. 29. Module inzgcxtr was changed to avoid this problem. 30. Modules inzctrl and inzmsgs were changed to process correctly this case. 31. Module inzpab was changed to fix this problem. 32. Module inzctrlh was fixed to process correctly this. 33. Module inzctrlh was changed to process correctly this truncation case. 34. Modules udbcrfel and inzpab were changed to generate a value that follows the SQL rules. 36. Module inznode was whanged to fix this problem. 37. Modules inzctrlh inztoken inzmain inzrload were changed to use a new parmlib parameter ULOPTNS/DELIMITEDGRAPHEXT in order to determine of the GRAPHIC should be unloaded as GRAPHIC or GRAPHIC EXTERNAL in FORMAT DELIMITED. 38. Module inzcrxsm was changed to use a GET DIAGNOSTIC in case of SQLCODE +354, to display the first negative sqlcode and stop processing. 39. Modules udbdsfic inzpabf udballoc were changed to generate a ddname different for each object unloaded in parallel. 40. Module inzhyacc was changed to issue the correct error message. 41. Module inzmyacc inzfyacc inzhyacc were changed to control the semicolon between 2 UNLOAD commands. 42. Not a bug. 43. Module inzctrl was changed to ignore the DB2 FORCE keyword when only a physical unload is coded. 44. Not a bug. 45. Not a bug. 46. Not a bug. 47. Modules inzcrxsq inzcrxsm inzpab were changed to issue a SET CURRENT DEGREE depending on the content of the ULDEGREE parmlib variable. 48. Module udbcrrts was changed to issue message INZRE40 when finding some pages not in sequence. 49. Modules inzctrlh olistdef and olistdef were changed to process correctly this case. 50. Modules inztyacc olistdef and olistdef were changed to process correctly the CLONED YES in the LISTDEF statement. 51. Procedure INZT02 was changed to free the files at the end of processing. 52. Module inzhyacc inzpyacc inzctrlh inzctrlp and inzctrf were changed to fix these problems. 53. Skeleton inzhpusk was changed to set the IVAR variable.
Problem conclusion
Temporary fix
Comments
APPLY the PTF.
APAR Information
APAR number
PK40400
Reported component name
DB2 HI PERF UNL
Reported component ID
5697F4400
Reported release
310
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2007-03-01
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:
Modules/Macros
INZM01
Fix information
Fixed component name
DB2 HI PERF UNL
Fixed component ID
5697F4400
Applicable component levels
R310 PSY UK25581
UP07/06/09 P F706
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