PH65490: ENHANCEMENT IN HANDLING OF UNSUPPORTED FILE TYPES WHEN UNLOAD LOB DATA TO AN EXTERNAL DATA SET.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DSNU283I  -xxxx DSNUULVA - LOB ERROR
  SQLCODE = -452
  SQLERRM = xxxxxxx.13
  SQLSTATE= 428A1
  SQLERRP = DSNOLFRV
  SQLERRD = 00000064 00000000 00000000 FFFFFFFF 00000000 00000000
  is returned at DSNUULVA for LOB-UNLOAD job when unload dataset
  is not supported by the LOB file reference, and it may lead to
  GETMAIN/ICF/RACF issues.
  Additional keyword:MSGDSNU283I SQLCODE452
  

Local fix

• Specify only supported file type as external output data set,
  that is PDS, PDSE, NFS or ZFS.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Db2 13 users of the UNLOAD utility with      *
  *                 LOBs using a File Reference Variable (FRV).  *
  ****************************************************************
  * PROBLEM DESCRIPTION: DSNU283I  -xxxx DSNUULVA - LOB ERROR    *
  *                      SQLCODE = -452                          *
  *                      SQLERRM = xxxxxxx.13                    *
  *                      SQLSTATE= 428A1                         *
  *                      SQLERRP = DSNOLFRV                      *
  *                      SQLERRD = 00000064 00000000 00000000    *
  *                      FFFFFFFF 00000000 00000000              *
  *                      is returned at DSNUULVA for LOB-UNLOAD  *
  *                      job when the unload dataset is a tape   *
  *                      data set which is not supported by the  *
  *                      LOB file reference, and it may lead to  *
  *                      GETMAIN/ICF/RACFissues.                 *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  DSNU283I  -xxxx DSNUULVA - LOB ERROR
  SQLCODE = -452
  SQLERRM = xxxxxxx.13
  SQLSTATE= 428A1
  SQLERRP = DSNOLFRV
  SQLERRD = 00000064 00000000 00000000 FFFFFFFF 00000000 00000000
  is returned at DSNUULVA for LOB-UNLOAD job when the unload
  dataset is a tape data set which is not supported by the LOB
  file reference, and it may lead to GETMAIN/ICF/RACFissues.
  

Problem conclusion

• DB2 has been modified to fix the LOB file reference abend
  when external file type is not supported during UNLOAD JOB.
  Additional Keywords: SQLOB SQLUNLOAD SQLFILEREFERENCE SQLTAPE
  IEC340I IGD300I IGD312I ICH408I ICH409I ABEND878 ABENDS878
  DSNB250E DSNI042I RC00C200E1 RC8 ABEND04E RC00E50013
  MSGDSNU283I SQLCODE452
  

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:

  UO03045

Modules/Macros

• DSNOLFRV
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RD10 PSY UO03045

     UP25/05/13 I 1000

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.