PH42836: DB2 ADMIN TOOL: 'DDL' LINE COMMAND FAILS SYNTAX ERRORS ADB2GEN.REXX WHEN SADBEXEC.VB USED 22/01/10 PTF PEREMOVE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When using SADBEXEC.VB, ADB2GEN.REXX fails with syntax errors as
  follows due to rexx records/instructions beyond column 80:
  
  IRX0006I Error running ADB2GEN, line 331: Unmatched "/*" or
  quote
  
  ISPF Dialog error:
  
  Function :+SELECT CMD(%ADB2GEN SPACEUNI(CYLINDERS) SPACEPRI(1)
  SPACESEC(1;*) LCMD(DDL) DEBUG())
  
  Retcode  :+20006
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DDL line command on                 *
  *                      panel ADB21T 'Tables, Views, and        *
  *                      Aliases' fails with syntax errors when  *
  *                      Variable Block (VB) format              *
  *                      data set 'hlq.SADBEXEC.VB' is used.     *
  ****************************************************************
  When Variable Block (VB) format data set 'hlq.SADBEXEC.VB'
  is used, the DDL line command on panel ADB21T
  'Tables, Views, and Aliases' fails with the following errors:
  
   331 +++   /         skelname = execname||'2' /* for new GEN
   skeleton    *        else/         skelname = skeleton    /
  * for new GEN skeleton    *        adbonejb = 'N'
   DDLONLY  = 'N'  /* If
  .
  .
  .
    Exit 20000 + Rc
      164 +++ Call gen_getparms
   IRX0006I Error running ADB2GEN, line 331: Unmatched "/*" or
   quote
   ***
  Followed by the following dialog error:
   Function : SELECT CMD(%ADB2GEN SPACEUNI(CYLINDERS)
              SPACEPRI(1) SPACESEC(1
              ) LCMD(DDL) DEBUG())
   Retcode  : 20006
  
   Zerrmsg  : ADB209
   Zerrsm   :
   Zerrlm   :
  

Problem conclusion

• The problem has been resolved.
  

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:

  UI79011

Modules/Macros

• ADB2GEN
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI79011

     UP22/01/25 P F201

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.