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

A fix is available

Subscribe

You can track all active APARs for this component.

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 number

    PM85366

  • Reported component name

    QMF-QUERY MGMT

  • Reported component ID

    566872101

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-03-21

  • Closed date

    2013-03-28

  • Last modified date

    2013-04-02

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



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 Query Management Facility
QMF for TSO/CICS

Software version:

10.1.0

Reference #:

PM85366

Modified date:

2013-04-02

Translate my page

Machine Translation

Content navigation