A fix is available
APAR status
Closed as program error.
Error description
FastUnload syntax: When parmlib variable VUU031/DTDELIM is set to NO and format COMMA-DELIMITED is requested, delimiters that should enclose datetime values are missing. DTDELIM is not intended to have an influence on COMMA-DELIMITED format output since it applies only to HPU native DELIMITED format. To bypass the problem set DTDELIM to YES. PB10721 HOLD DATA is incomplete in this PTF. The complete HOLDDATA follows. ****************************** Before applying this fix, make sure you had not been relying on the wrong behavior that is to be fixed. If you wish to produce an output format similar to that produced by the former incorrect behavior (i.e. getting date/time/timestamp data not surrounded by delimiters), consider using the HPU native DELIMITED format. To get delimited char fields and non delimited date/time/timestamp fields, set DTDELIM to NO. For example, the output of the following unloas statement before the fix : FASTUNLOAD OUTPUT-FORMAT COMMA-DELIMITED COMMA ';' QUOTE '/' SELECT CURRENT_DATE, CURRENT SQLID FROM SYSIBM.SYSDUMMY1 ; looks like the following: 03.12.2010;/MZLFLB/ To get the same output, after the PTF, set DTDELIM to NO and use the following statement: UNLOAD TABLESPACE SELECT CURRENT_DATE, CURRENT SQLID FROM SYSIBM.SYSDUMMY1 ; OUTDDN SYSREC01 FORMAT DELIMITED DELIM '/' SEP ';' Note that after the fix, the output of the first statement is: /03.12.2010/;/MZLFLB/ ******************************
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 High Performance Unload. * **************************************************************** * PROBLEM DESCRIPTION: FastUnload syntax: When parmlib * * variable VUU031/DTDLIM is set to NO and * * format COMMA-DELIMITED is requested, * * delimiters that should enclose datetime * * values are missing. DTDLIM is not * * intended to have an influence on * * COMMA-DELIMITED format output since it * * applies only to HPU native DELIMITED * * format. * * PB 10721 * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** inzctrlf module was fixed to correctly generate delimiters for date/time/timestamp data.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PM16848
Reported component name
DB2 HI PERF UNL
Reported component ID
5697F4400
Reported release
310
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2010-06-18
Closed date
2010-12-28
Last modified date
2011-08-16
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK63535 UK63536 UK63537
Modules/Macros
INZRSAVE INZUTILK INZUTISK
Fix information
Fixed component name
DB2 HI PERF UNL
Fixed component ID
5697F4400
Applicable component levels
R310 PSY UK63535
UP11/01/05 P F101
R320 PSY UK63536
UP11/01/05 P F101
R410 PSY UK63537
UP11/01/05 P F101
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"310"}]
Document Information
Modified date:
30 March 2021