IBM Support

PM93773: NEW STORED PROCEDURE SYSPROC.ADMIN_COMMAND_MVS

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • New Stored Procedure SYSPROC.ADMIN_COMMAND_MVS
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 11 for z/OS users of the stored      *
    *                 procedure SYSPROC.ADMIN_COMMAND_MVS          *
    *                 and all DB2 10 for z/OS users                *
    ****************************************************************
    * PROBLEM DESCRIPTION: (1) DB2 10 for z/OS only:               *
    *                          This PTF ships a new DB2-supplied   *
    *                          stored procedure,                   *
    *                          SYSPROC.ADMIN_COMMAND_MVS.          *
    *                      (2) DB2 11 for z/OS only:               *
    *                          (a) An incorrect command completion *
    *                              code could be returned by       *
    *                              SYSPROC.ADMIN_COMMAND_MVS if    *
    *                              the command messages queued     *
    *                              to the extended MCS console     *
    *                              contains a null character.      *
    *                          (b) DSNTRIN and DSNTRVFY does not   *
    *                              support ADMIN_COMMAND_MVS in    *
    *                              conversion mode.                *
    ****************************************************************
    * RECOMMENDATION: Apply PTF                                    *
    ****************************************************************
    (1) DB2 10 for z/OS only:
        The ADMIN_COMMAND_MVS stored procedure issues the QUERY
        COPYPOOL, LIST COPYPOOL, DB2 START, DB2 STOP, DUMP or
        DISPLAY WLM command.
    
        This stored procedure is available in new-function mode
        only.
    
    (2) DB2 11 for z/OS only:
        (a) If the command messages queued to the extended MCS
            console contain a null character, ADMIN_COMMAND_MVS
            treats the null character as the end of the messages.
            If a message ADMIN_COMMAND_MVS is looking for comes
            after the null character, it will not find it, and
            because it cannot find it, it returns a wrong command
            completion code.
    
        (b) DSNTRIN and DSNTRVFY do not support ADMIN_COMMAND_MVS
            in conversion mode. With the introduction of
            ADMIN_COMMAND_MVS in V10, both DSNTRIN and DSNTRVFY
            should support ADMIN_COMMAND_MVS in conversion mode.
    

Problem conclusion

  • (1) DB2 10 for z/OS only:
        Information about the ADMIN_COMMAND_MVS stored procedure
        is available in the IBM Information Management Software
        for z/OS Solutions Information Center:
    
        http://pic.dhe.ibm.com/infocenter/dzichelp/v2r2/index.jsp
    
        This stored procedure is available in new-function mode
        only.
    
    (2) DB2 11 for z/OS only:
        (a) ADMIN_COMMAND_MVS is modified to handle a null
            character found in a command message when it's
            parsing the message.
    
        (b) DSNTRIN and DSNTRVFY are modified to support
            ADMIN_COMMAND_MVS in conversion mode.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM93773

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-07-24

  • Closed date

    2013-10-18

  • Last modified date

    2013-12-02

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UK98622 UK98623

Modules/Macros

  • DSN@DMCM DSN@DMGV DSN@RIN  DSN@RVFY DSN@XAZP DSNADMCM DSNADMGV
    DSNADMGX DSNADMGY DSNADMMG DSNADMMW DSNTESR  DSNTIDXA DSNTIDXB
    DSNTIJRT DSNTINST DSNTINSV DSNTINS1 DSNTIPRA DSNTIPRL DSNTRIN
    DSNTRVFY DSNTXAZP HDBAA10J
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK98622

       UP13/11/05 P F311

  • RB10 PSY UK98623

       UP13/11/05 P F311

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.

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
02 December 2013