PH21122: DB2 ADMIN TOOL AL LINE CMD ADB26COV NATIVE STORED PROCEDURE CANNOT CHANGE COMMIT ON RETURN TO OR FROM 'A' ('AUTONOMOUS')

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This APAR addresses two issues that arise on panel ADB26COV when
  using the AL line command to change the COMMIT ON RETURN
  parameter of a native stored procedure:
  
  1. If COMMIT ON RETURN is already set to 'Y' or 'N': Only Y or N
  can be selected; option 'A' ('AUTONOMOUS') is rejected as
  'Invalid Value'.
  
  2. If 'COMMIT ON RETURN' is already set to 'A', then it cannot
  be changed to 'Y' or 'N'.
  

Local fix

• Use the ALT line command instead of line command AL.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS who use the stored procedures panel to  *
  *                 alter a stored procedure.                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Users cannot change whether a native    *
  *                      stored procedure is autonomous by using *
  *                      the AL line command.                    *
  ****************************************************************
  Panel ADB26COV does not allow users to modify a native stored
  procedure to be defined with AUTONOMOUS, or to modify it from
  AUTONOMOUS to COMMIT ON RETURN YES or NO. The panel
  needs the ability to issue an ALTER PROCEDURE ALL VERSIONS
  statement to allow these changes.
  
  Panel ADB26COV will include a new primary command,
  ALLVERSIONS, that, when issued, will display the
  ALL VERSIONS clause instead of the ACTIVE VERSION or
  VERSION number clause. After issuing the new command,
  a new primary command, ACTIVEVERSION , will take its
  place, and a user can toggle between the two
  primary commands.
  
  The stored procedure panel, ADB21O, should also have
  a way for users to display the ALTER panel with
  ALL VERSIONS specified. A new line command, ALAV,
  will be added to allow users to do that.
  

Problem conclusion

• Problems have 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:

  UI68843

Modules/Macros

• ADB21O   ADB26CO  ADB26COU ADB26COV ADBC15   ADBH6COV
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI68843

     UP20/04/08 P F004

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.