PM43689: UNLOAD LOB FAILED WHEN THE FILE NAME CONTAIN $ DOLLAR SIGN

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This unload utility would failed with -452 when the file name
  contain $
  
  DSNU283I  _DB2D 189 14:52:32.41 DSNUULVA - LOB
  ERROR
  
        SQLCODE = -452
  
        SQLERRM = /u/DB2D/LOBWORK/TWFRLM$1/DEJJNZZG 1
  
        SQLSTATE= 428A1
  
        SQLERRP = DSNOLFRV
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 9 and DB2 10 for z/OS users of File  *
  *                 Reference Variables (FRV).                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: An SQLCODE -452 is issued from DSNOLFRV *
  *                      location 330 when the HFS file name in  *
  *                      a File Reference Variable contains      *
  *                      special characters '$' or ' '(white     *
  *                      space).  These characters are allowed   *
  *                      for valid HFS file names in a File      *
  *                      Reference Variable.                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  An SQLCODE -452 is issued from DSNOLFRV, location 330, when the
  HFS file name in a File Reference Variable contains special
  characters '$' or ' '(white space).  These characters are
  allowed in forming a valid HFS file name in the File Reference
  Variable.
  
  
  The following example illustrates the problem.
  
  1. Create a Table with a LOB column and populate the table.
  
     CREATE TABLE T1 (C1 INT, C2 CLOB(1K));
  
     INSERT ITNO T1 VALUES(1, CAST('AAA' AS CLOB)) FOR 100 ROWS;
  
  
  2. UNLOAD the Table to a File Reference Variable that contains a
     special character '$' in the HFS file name
  
     TEMPLATE  LOBT       DSN /U/DB2D/LOBWORK/LOB$TS DSNTYPE(HFS)
     UNLOAD DATA FROM TABLE T1
     (C1                    INT,
      C2 VARCHAR(255)    CLOBF LOBT)
  
  
  3. An SQLCODE -452 will result as mentioned above.
  
  Please note. When the HFS file name contains a ' '(white space),
  an SQLCODE452 will also be issued from DSNOLFRV location 330.
  

Problem conclusion

• The code in DB2 has been modified to allow the special
  characters '$' and ' ' (white space) for a File Reference
  Variable.  As a result, an SQLCODE -452 will not be issued when
  unloading a LOB with a file name that contains either of these
  characters.
  
  Additional Keywords: SQLCODE452 SQLLOB
  

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:

  UK71487 UK71488

Modules/Macros

• DSNOLFRV
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK71487

     UP11/09/15 P F109

• R910 PSY UK71488

     UP11/09/15 P F109

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.