PH26731: MIG: GENERATED GEN JCL INCORRECTLY SPECIFIES DDSQL PARAMETER

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Db2 Admin Tool:  MIG - generated GEN JCL incorrectly specifies
  DDSQL parameter
  
  Example:
  
  RUN PROG(ADB2GEN) PLAN(ADB2GEN) -
  PARMS('/,DDSQL(ADBSQL2)')
  
  This will fail with error similar to
  
  ADBSQL2 DD statement missing and generate DDL and/or generate
     stats requested.
  
  ADB1192I ADB2GEN - Now terminating
  

Local fix

• The JCL can be edited to remove the DDSQL parm
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Admin Tool Migrate          *
  *                 function.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: User input from a previous execution of *
  *                      the GEN line command might cause        *
  *                      incorrect JCL to be generated when      *
  *                      migrating objects.                      *
  ****************************************************************
  When issuing the GEN line command and using TSO execution mode,
  values can be incorrectly reused later by the Migrate function.
  The following example shows incorrect GEN JCL that was produced
  by the Migrate function:
  
  RUN PROG(ADB2GEN) PLAN(ADB2GEN)
  -PARMS('/,DDSQL(ADBSQL2)')
  
  Resulting in a error message similar to the following:
  
     ADBSQL2  DD statement missing and generate DDL
        and/or generate stats requested.
  
  DDSQL should not be produced in this context
  

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:

  UI71173

Modules/Macros

• ADB28M
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI71173

     UP20/08/25 P F008

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.