PI37754: DB2 ADMIN TOOL THE APPLY PROCESS NEEDS A SET STATEMENT IN THE FLOW AS POSTUTIL WILL BE A SEPARATE STEP

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• From panel ADB21T, ALT line command on table and delete a
  column.
  
  From panel ADB27CA do OPTIONS ->
    1  Analysis options and set Perform analysis in batch . . no
  then ALTER
  
  Without changing 'Run SQLID' (leaving it blank) the POSTUTIL
  dataset has:
  --#ADMIN PROCESS POSTUTIL
    SET CURRENT SQLID='DB2ADM';
    GRANT ALTER ON TABLE DB08DB.TS03T0 TO C777086;
  
  Changing 'Run SQLID' to DUMMY1, the POSTUTIL dataset has:
  --#ADMIN PROCESS POSTUTIL
    GRANT ALTER ON TABLE DB08DB.TS03T0 TO C777086;
  
  that is no SET CURRENT SQLID statement.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the 'ALT Alter table' (ALT)     *
  *                 function.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using the ALT function to alter    *
  *                      a table, if option 'Run SQLID' is set   *
  *                      to a SQLID selected by the user on      *
  *                      panel ADBP7P 'ALTER Analysis Options'   *
  *                      and option 'Generate one job' is set    *
  *                      to 'NO' on panel ADBPALT 'ALTER -       *
  *                      Build Analyze and Apply Job', there     *
  *                      are no SET CURRENT SQLID statements     *
  *                      generated in the POSTUTIL section of    *
  *                      the drop and recreate:                  *
  *                                                              *
  *                      For example,                            *
  *                      --#ADMIN PROCESS POSTUTIL               *
  *                        GRANT ALTER ON TABLE                  *
  *                      >schema<.>tablename<  TO                *
  *                      >user_SQLID<;                           *
  *                                                              *
  *                      Notice the SET CURRENT                  *
  *                      SQLID=>user_SQLID<                      *
  *                      statement is missing and                *
  *                      a SQLCODE=-551 /                        *
  *                      SQLCODEN551 is observed:                *
  *                                                              *
  *                      DSNT408I SQLCODE = -551,                *
  *                      ERROR: >user_SQLID< DOES NOT            *
  *                      HAVE THE PRIVILEGE TO                   *
  *                      PERFORM OPERATION GRANT                 *
  *                      DELETE ON OBJECT >table_name<           *
  *                      DSNT418I SQLSTATE = 42501               *
  *                      SQLSTATE RETURN CODE                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using the ALT function to alter a table, if option 'Run
  SQLID' is set to a SQLID selected by the user on panel ADBP7P
  and option 'Generate one job' is set to 'NO' on panel ADBPALT,
  there are no SET CURRENT SQLID statements generated in the
  POSTUTIL section of the drop and recreate.
  

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:

  UI27952

Modules/Macros

•    ADBGAJOB
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI27952

     UP15/06/02 P F506

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.