Impact of RO20082/SQL RELEASE ALL PRIVATE

Document ID : KB000048360
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

After I have received and applied APAR RO20082, what additional changes must be made in order to correctly implement the RO20082 changes in my DB2 version 10 subsystems?

Solution:

After receiving and applying RO20082, edit member OMSMCMD2 in the CA Pan/SQL CAIMAC.

DB2REL should be 101 for DB2 version 10.

Because DB2 v10 no longer supports the use of plans without packages, refer to TEC570346 for examples. Then make the necessary changes.

In the new DB2 v10 subsystem(s), run jobs IJ3STGE1 and CB2ACMDL. If you have multiple DB2 v10 subsystems and have previously used SQLINST4, edit and run SQLINST4.

This fix is only required for DB2 version 10 and DB2REL must be set to 101 to prevent the RELEASE ALL PRIVATE statement from being generated. Otherwise, an error will occur in the DB2 pre-compiler step of the IJ3STGE1 job.