PM16848: INCORRECT OUTPUT USING FASTUNLOAD SYNTAX.

Obtain the fix for this APAR.

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 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.