PM85366: DSNA620I DSNADMAL ERROR ALLOCATING DATA SET CALLING STORED PROCEDURE ADMIN_DS_LIST FROM QMF

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Calling stored procdure ADMIN_DS_LIST from QMF can generate the
  following sample messages.
  
  DSNA620I  DSNADMAL ERROR ALLOCATING DATA SET
  DSNAME=hlq.dsn                                     ,
  RETURN CODE=12, ERROR REASON CODE='035C'X,
  INFO REASON CODE='0002'X
  IKJ56231I UTILITY DATA SET NOT ALLOCATED, SYSTEM OR
  INSTALLATION ERROR+  IKJ56231I TEXT UNIT X'0002' CONTAINS
  INVALID PARAMETER
  
  The problem does not occur from the DB2 Command window.
  
  DSNA620
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS V10 users who           *
  *                 call DB2 stored procedures.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: Calls to the DB2 stored procedure       *
  *                      SYSPROC.ADMIN_DS_LIST did not           *
  *                      successfully allocate the data set      *
  *                      specified in the parmlist unless the    *
  *                      data set name was 44 characters long    *
  *                      or padded with spaces for 44            *
  *                      characters.                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  A call to the DB2-supplied stored procedure
  SYSPROC.ADMIN_DS_LIST requires the first parm
  to be a data set name; this parm is defined to
  the procedure as Input and CHAR(44).  Unless the
  DSN parm was a full 44 bytes long, padded with spaces
  if necessary, the result set from calling the stored proc
  included &MSG:
  'DSNA620I  DSNADMAL ERROR ALLOCATING DATA SET DSNAME
  USER01.REXX.EXEC, RETURN CODE=12, ERROR REASON CODE=
  '035C'X, INFO REASON CODE='0002'X IKJ56231I UTILITY
  DATA SET NOT ALLOCATED, SYSTEM OR INSTALLATION
  ERROR+  IKJ56231I TEXT UNIT X'0002' CONTAINS IN
  VALID PARAMETER'
  

Problem conclusion

• Logic was altered to pass the actual length of the data set
  name to DB2 with the call to the stored procedure, rather than
  the 44-byte length defined to the parm that contains the data
  set name.
  

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:

  UK92985

Modules/Macros

• DSQGPSQM DSQGPSQS DSQGPSQX DSQIPSQM DSQIPSQS
  DSQIPSQX
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• RA10 PSY UK92985

     UP13/03/30 P F303

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.