PH12600: DB2 ADMINISTRATION TOOL FOR Z/OS - ADB5146E UNEXPECTED SQLCODE -551 WITH ADBTEP2 ON RESTART

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ADBTEP2 batch program issues SQLCODE -551 / SQLCODEN551 error
  during a RESTART process:
     ADB5146E Unexpected SQLCODE -551 in :
              SET SYSIBM.TEMPORAL_LOGICAL_TRANSACTION_
     DSNT408I SQLCODE = -551, ERROR: >userid< DOES NOT HAVE THE
              PRIVILEGE TO PERFORM OPERATION WRITE ON OBJECT
              SYSIBM.TEMPORAL_LOGICAL_TRANSACTION_TIME
     DSNT418I SQLSTATE = 42501 SQLSTATE RETURN CODE
     DSNT415I SQLERRP = DSNXORSO SQL PROCEDURE DETECTING ERROR
     DSNT416I SQLERRD = -10 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool         *
  *                 for z/OS or Db2 Object Comparison            *
  *                 Tool for z/OS.                               *
  ****************************************************************
  * PROBLEM DESCRIPTION: Running a WSL by a job submitter        *
  *                      who does not have read or write         *
  *                      privileges on built-in global variable  *
  *                      SYSIBM.TEMPORAL_LOGICAL_TRANSACTION_    *
  *                      TIME or                                 *
  *                      SYSIBM.TEMPORAL_LOGICAL_TRANSACTIONS    *
  *                      may result in an authorization          *
  *                      error.                                  *
  ****************************************************************
  Using dynamic SQL, batch restart program, ADBTEP2
  internally executes SELECT and SET statements on
  built-in global variables
  SYSIBM.TEMPORAL_LOGICAL_TRANSACTION_TIME
  and/or SYSIBM.TEMPORAL_LOGICAL_TRANSACTIONS, in order to
  retain the environmental condition for restarting a WSL.
  If the job submitter lacks the privileges to execute these
  statements, an authorization error may result, as in the
  following example:
  
  ADB5146E Unexpected SQLCODE -551 in :SET SYSIBM.
  TEMPORAL_LOGICAL_TRANSACTION_
  
  With this fix, the execution of the statements is changed
  to use static SQL statements. As a result, the package
  owner's privileges will be used to execute the statements
  instead of using the privileges of the individual job submitter.
  

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:

  UI65154

Modules/Macros

• ADBTEP2  ADBTEPR
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI65154

     UP19/09/07 P F909

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.