PH27317: SQLCODE -551 ON SYSIBM.SYSLEVELUPDATES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Users may experience a -551 SQLCODE with the message:
  USER DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION SELECT ON
  OBJECT SYSIBM.SYSLEVELUPDATES when invoking Optim after
  application of PTF UI67718.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users invoking Optim following application   *
  *                 of PTF UI67718 on a DB2 V12 subsystem.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: Following application of PTF UI67718    *
  *                      Optim users may experience a -551       *
  *                      SQLCODE on DB2 V12 catalog table        *
  *                      SYSIBM.SYSLEVELUPDATES                  *
  *                      when invoking Optim.                    *
  ****************************************************************
  * RECOMMENDATION: Apply the fix provided.                      *
  ****************************************************************
  PTF UI67718 introduced a SELECT statement to retrieve
  information from the SYSIBM.SYSLEVELUPDATES table outside of a
  DBRM to retrieve the activated DB2 V12 Function Level values.
  When the statement is issued it is done so using the SQLID
  of the user, if the user does not have SELECT authority to
  the table DB2 will fail it with a -551 SQLCODE and Optim
  will exit.
  

Problem conclusion

• The SELECT statement against the SYSIBM.SYSLEVELUPDATES
  table has been moved into an Optim DBRM that is bound with
  the packages and plan using an alias for the table.  Access
  is achieved using the alias as is the practice for all
  other DB2 catalog tables Optim utilizes.
  
  The new Optim alias for SYSIBM.SYSLEVELUPDATES will need to be
  created after application of this PTF.
  Please invoke the FOPINSTL CLIST and use option 5.1 to generate
  and execute the statement to do so.
  The Optim packages will need to be rebound after application of
  this PTF.
  Please invoke the FOPINSTL CLIST and use option 5.2.1 and 5.2.2
  to do so.
  
  Additionally, this PTF introduces a new Optim DBRM - FOPD2VC5 -
  which is now required for DB2 V12 systems.  Consequently the
  Optim packages will require rebinding.  Please refer to the
  Optim Customization guide for the steps required.
  

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

• FOP1OSFN FOP9APIM FOPCFPMN FOPCXLIB FOPD2V85 FOPD2V91 FOPD2VA5
  FOPD2VC5 FOPD2VNN FOPHSTM  FOPI4706 FOPIBDPK FOPINS0  FOPMAIN
  FOPMAMAI FOPMCMAI FOPMCOLA FOPMCOLP FOPMDPRC FOPMECMN FOPMMCMR
  FOPMMJBS FOPMMUNU FOPMMUTL FOPMUXIM FOPOMN   FOPPEX2C FOPPEXC
  FOPTC710 FOPTC71M FOPTC71P FOPTC71R FOPTC71S FOPZFMMN FOPZMAIN
  

Fix information

• Fixed component name

  OPTIM MOVE FOR

• Fixed component ID

  5655V0700

Applicable component levels

• RB70 PSY UI70815

     UP20/07/31 P F007

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.