PM46379: MSGADBC130E ALTER REQUEST AND LOAD STMT DO NOT MATCH CC1012 RC1012 ON CONVERT JOBSTEP ROUTINE ADB27AC

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS  fails cc1012 in convert
  jobstep CNV10001 when processing second, or subsequent, ALT
  operation, when using panel ADBPALT option:
  .
     1 - Continue by having the data sets deleted and recreated.
  .
  Panel ADBPALT warns of existing WSL or DSN names with the
  following text:
  .
    Data sets for the chosen prefix and worklist already exist.
    Continuing will cause the loss of all existing content in
    those data sets
  .
  Choosing option 1 builds a job, which fails during execution.
  Error messages in joblog convert step appear similar to:
  .
  ADB27AC - Conversions for Alter Column(s)
  --------------------------------------------------------------
  .
            ADBC001I Alter for table <schema>.<table2>
  
            ADBC130E Alter request and LOAD stmt do not match
                     Req  = ><schema><.><table2><
                     Load = ><schema><.><table1><
  ADB27AC - Now terminating
  

Local fix

• Choose option 2 and specify a new DSN or WSL name in panel
  ADBPALT
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the Alter Table (ALT)           *
  *                 function.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      Apply job ends with Return Code 1012    *
  *                      and error in convert step CNV10001 when *
  *                      specifying 'Perform analysis in batch'  *
  *                      to 'NO' on panel ADBP7P 'ALTER          *
  *                      Analysis Options', and then uses an     *
  *                      existing worklist name/prefix on panel  *
  *                      ADBPALT,                                *
  *                      'ALTER - Build Analyze and Apply Job'   *
  *                      to process the second or subsequent ALT *
  *                      operation.  The error messages in the   *
  *                      convert step are similar to:            *
  *                      .                                       *
  *                      ADB27AC - Conversions for Alter         *
  *                      Column(s)                               *
  *                      -------------------------------         *
  *                      .                                       *
  *                      ADBC001I Alter for table                *
  *                               schema.table2                  *
  *                      ADBC130E Alter request and LOAD         *
  *                               stmt do not match              *
  *                               Req  = >schema<.>table2<       *
  *                               Load = >schema<.>table1<       *
  *                      ADB27AC - Now terminating               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The DB2 Administration Tool for z/OS reuses the last
  contents of the IFF data set in the Apply job when setting
  'Perform analysis in batch' to 'NO' on panel ADBP7P and
  then using an existing worklist name/prefix on panel
  ADBPALT.
  

Problem conclusion

• REXX EXEC ADBEALT has been modified to use the correct content
  of the IFF dataset for the ALT function.
  
  After this APAR is applied, submitting the Apply JCL job
  may fail with a JCL error and stop execution in the
  load step if using an existing worklist name/prefix
  on panel ADBPALT. The JCL error is issued due to
  SYSDISC data set for DSNUPROC in the load step is
  not defined because a duplicate name exists in the catalog.
  The JCL error is expected because there is an existing SYSDISC
  data set from the previous ALT action. To work around,
  the user can delete or rename the existing SYSDISC data
  set and then rerun the Apply JCL job from the load step.
  Additionally, a follow-on APAR will address this issue
  to provide the users with a choice to delete the existing
  SYSDISC data set.
  

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:

Modules/Macros

•    ADBEALT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK75308

     UP12/01/12 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.