OA68939: UPDATE OAM'S OBJECT SUPPORT SAMPLE JOBS TO WORK WITH NEW VERSIONS OF DB2

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• As of APPLCOMPAT V12R1M504, Db2 has deprecated support for the
  creation of Segmented (non-UTS) tablespaces. This has caused
  OAM Db2 sample jobs to implicitly create PBG tablespaces
  instead of segmented which is desired at V12R1M504 and higher.
  
  Within our CBRILOB sample, the LOB tablespace is being created
  as PBG, however the auxiliary table space is still defined as
  segmented which causes Db2 to return with SQLCODE-769.
  
  All OAM samples that define tablespaces will be updated to
  explicitly be defined as PBG. LOB tablespaces will be defined
  as PBR.
  

Local fix

• If APPLCOMPAT is V12R1M504 or higher, then Add PART clause to
  the CREATE AUXILIARY TABLE. This will cause the auxiliary table
  to become compatible with the LOB table space which is being
  created as PBG at APPLCOMPAT V12R1M504 or higher.
  
  Example:
  
   CREATE AUXILIARY TABLE osg_hlq.OSM_LOB_AUX_TBL
          IN         osg_hlq.OSMLATS
          STORES     osg_hlq.OSM_LOB_BASE_TBL
          COLUMN     OTOBJ
          PART       1;
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OAM object users.                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: In Db2 APPLCOMPAT V12R1M504, create     *
  *                      tablespace statements result in the     *
  *                      creation of partition by growth         *
  *                      tablespaces. CBRILOB has an issue with  *
  *                      the auxiliary create tablespace         *
  *                      statement when PBG is used              *
  *                      which results a SQL -769.               *
  ****************************************************************
  

Problem conclusion

• CBRILOB has been redesigned to now be partition by range with
  relative page numbering and recommended default specifications.
  
  CBRISQL0,CBRISQLX, CBRSAMPL, CBRSMCID and CBRSMR1D have also
  been updated to now be created as partition by growth
  with recommended default specifications.
  
  CBRIALC0, CBRIALCX, and CBRIALCY are no longer necessary as
  Db2 will automatically manage the VSAM datasets.
  
  See link for all publication updates related to this support:
  
  https://public.dhe.ibm.com/eserver/zseries/zos/DFSMS/OAM/OA68939
  

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:

  UJ99221 UJ99222 UJ99223

Modules/Macros

• CBRILOB  CBRISQL0 CBRISQLX CBRSAMPL CBRSMCID CBRSMR1D
  

Fix information

• Fixed component name

  OBJECT ACCESS M

• Fixed component ID

  5695DF180

Applicable component levels

• R250 PSY UJ99223

     UP26/03/24 P F603

• R310 PSY UJ99222

     UP26/03/24 P F603

• R320 PSY UJ99221

     UP26/03/24 P F603

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.