PK94676: SM MOVE OF DB2 CATALOG FAILS ADR129E KEYWORD 'OUTDY ' IS IMPROPER OR DELIMITER ')' IS NOT PROPERLY PRECEDED BY A CONSTANT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS Space Management MOVE
  function built invalid ADRDSSU COPY syntax which results in
  various ADR124E error messages.
  Example:
  PAGE 0001     5695-DF175  DFSMSDSS V1R11.0 DATA SET SERVICES
  .
   COPY -
     DATASET(INCLUDE()) -
     ODY( -
         (DM0001) -
        ,(DN22222) -
        ) -
     CATALOG DELETE
  .
  ADR124E (001)-RI01 (02), DELIMITER ')' IS NOT PROPERLY PRECEDED
  BY A CONSTANT OR KEYWORD
  ADR131E (001)-RI03 (01), ABOVE TEXT BYPASSED UNTIL NEXT COMMAND
  

Local fix

• Amend the COPY syntax to include the VSAM dataset names:
  e.g.:
  COPY -
     DATASET(INCLUDE(DSN9.DSNDBC.DSNDB06.SYSOBJ.I0001.A001)) -
     RENUNC(DSN9.DSNDBC.DSNDB06.SYSOBJ.I0001.A001 -
            DSN77.DSNDBC.DSNDB06.SYSOBJ.I0001.A001) -
     ODY( -
         (DBCAT8) -
        ) -
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the Space Manager function to   *
  *                 move a page set.                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: In the DB2 Administration Tool for      *
  *                      z/OS, the MOVE function of Space        *
  *                      Manager builds an invalid ADRDSSU       *
  *                      syntax.                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  An empty page set is generated on panel ADB2M1S 'Page Set
  Statistics' when the user press PF3 on panel ADB2MSPC
  'Space Manager'.
  

Problem conclusion

• Programs have been modified to solve this problem and a
  new message:
  
  ADB739E ('Invalid qualifier' vcatname is not valid for DB2
  catalog high level qualifier. Check the installation value for
  DB2 catalog and try again.')
  
  was added and will be displayed on panel ADB2M1S after the
  customer inputs an invalid vcat name on panel ADB2MSPC.
  

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:

  UK65799 UK65800

Modules/Macros

•    ADB2MSP  ADB2MSPC ADB2M1S  ADB73
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK65799

     UP11/03/19 P F103

• R720 PSY UK65800

     UP11/03/19 P F103

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.