PM66906: SQ COMMAND SQLCODEN452 ERROR: UNABLE TO ACCESS THE FILE REFERENCED BY HOST VARIABLE REASON 13 / SQLSTATE 428A1

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' SQ line command fails
  with a message:
  DSNT408I SQLCODE = -452, ERROR:  UNABLE TO ACCESS THE FILE
  REFERENCED BY HOST VARIABLE
  >sqlid<.ADB.LOB.>date<.>time<(R0000001).
  REASON 13
  as messages ACF99913 ACF2 VIOLATION and ACF90913  -DATASET
  CANNOT BE OPENED are issued by the external security product.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who use the 'SQ - Show the          *
  *                 SQL statements' line command on              *
  *                 DB2 10.                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: A SQLCODE=- 452 / SQLCODEN452           *
  *                      is received when using the 'SQ -        *
  *                      Show the SQL statements' line           *
  *                      command on panel ADB21K                 *
  *                      'Packages':                             *
  *                                                              *
  *                      DSNT408I SQLCODE = -452,                *
  *                      ERROR:  UNABLE TO ACCESS                *
  *                      THE FILE REFERENCED                     *
  *                      BY HOST VARIABLE                        *
  *                      >data set name<                         *
  *                      REASON CODE: 13                         *
  *                      DSNT418I SQLSTATE= 428A1                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When the 'SQ - Show the SQL statements' line command
  is used, the LOB data for SYSPACKSTMT is stored in a
  data set with the name TSOprefix.ADB.LOB.Dyymmdd.Thhmmss.
  However, the user is running on a secondary SQLID
  and the ID does not have access to the data set.
  

Problem conclusion

• The problem has been fixed by providing a new
  'HLQ for LOB files' parameter on panel ADB2P2
  'Change DB2 Admin Defaults'.  If this parameter is
  specified, the HLQ will be added to the temporary data
  set that DB2 uses to store LOB files.
  Example:
  HLQ.ADB.LOB.Dyymmdd.Thhmmss
  

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:

  UK80061

Modules/Macros

•    ADBHP2   ADBMAIN  ADB2P2
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK80061

     UP12/07/12 P F207

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.