PM33186: SQLCODEN763 FOR CREATE TABLE AFTER (D)FIELD TABLESPACE TYPE CHANGED FROM PBG TO PBR INCORRECTLY REPORTED.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Object Comparison Tool for z/OS issues a message:
  Compare tablespace source(aaaaaaaa.bbbbbbb) and
  target(cccccccc.bbbbbbb)
      (D)Field SEGSIZE changed from 4 to 64
      (D)Field Tablespace TYPE changed from PBG to PBR
    Part 1
      (A)Field PRIQTY changed from 12 to 1000
      (A)Field SECQTY changed from 12 to 500
    Tablespace cccccccc.bbbbbbb will be dropped
  however the APPLY job fails with a SQLCODE -763 on the
  CREATE TABLE statement.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
  *                 z/OS who compare source                      *
  *                 Partition-by-Growth (PBG) table spaces       *
  *                 with target PBG table spaces.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: While comparing source PBG table        *
  *                      spaces with target PBG table spaces,    *
  *                      Object Compare incorrectly reports:     *
  *                                                              *
  *                      'Field Table space type changed from    *
  *                      PBG to PBR'                             *
  *                                                              *
  *                      and the APPLY job fails with a          *
  *                      SQLCODE=-763/SQLCODEN763                *
  *                      on the CREATE TABLE statement:          *
  *                                                              *
  *                      SQLCODE=-763, ERROR:  INVALID           *
  *                      TABLE SPACE NAME ts_name                *
  *                      SQLSTATE   = 560A1 SQLSTATE             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  While comparing source PBG table spaces with target PBG table
  spaces, Object Compare incorrectly reports:
  
  'Field Tablespace type changed from PBG to PBR'
  
  and the APPLY job fails with a SQLCODE = -763/
  SQLCODEN763 on the CREATE TABLE statement:
  
  SQLCODE = -763, ERROR:  INVALID TABLE SPACE NAME ts_name
  SQLSTATE   = 560A1 SQLSTATE
  

Problem conclusion

• Program has been modified to resolve the problem.
  

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:

  UK66739

Modules/Macros

•    GOC2CMF
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R720 PSY UK66739

     UP11/04/15 P F104

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.