PH58324: MISSING CHECK CONDITION DATAREPEATFACTORF=0 FOR DSN_VIRTUAL_INDEXES.DATAREPEATFACTORF

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DSN_VIRTUAL_INDEXES is defined with the following
  check constraint on the column DATAREPEATFACTORF
  .
    CHECK("DATAREPEATFACTORF" = -1
       OR "DATAREPEATFACTORF" >= 1)
  .
  instead of
  .
    CHECK("DATAREPEATFACTORF" = -1
       OR "DATAREPEATFACTORF" = 0
       OR "DATAREPEATFACTORF" >= 1)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 for z/OS and Db2 13 for z/OS                      *
  * users of the following:                                      *
  * o Db2 EXPLAIN table DSN_VIRTUAL_INDEXES                      *
  * o Db2-supplied stored procedure                              *
  *   - SYSPROC.ADMIN_EXPLAIN_MAINT                              *
  * o Db2-supplied REXX execs:                                   *
  *   - DSNTXTA (Job DSNTIJXA)                                   *
  *   - DSNTXTB (Job DSNTIJXB)                                   *
  * o Db2 sample job DSNTESC                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The EXPLAIN table DSN_VIRTUAL_INDEXES                        *
  * is currently defined with the                                *
  * following check constraint on the                            *
  * column DATAREPEATFACTORF                                     *
  *   CHECK("DATAREPEATFACTORF" = -1                             *
  *      OR "DATAREPEATFACTORF" >= 1)                            *
  * instead of                                                   *
  *   CHECK("DATAREPEATFACTORF" = -1                             *
  *      OR "DATAREPEATFACTORF" = 0                              *
  *      OR "DATAREPEATFACTORF" >= 1)                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  The Db2-supplied stored procedure SYSPROC.ADMIN_EXPLAIN_MAINT,
  the Db2 REXX execs DSNTXTA and DSNTXTB, and the Db2 sample
  job DSNTESC all specified the incorrect check constraint on
  the DATAREPEATFACTORF column of the EXPLAIN table
  DSN_VIRTUAL_INDEXES.
  

Problem conclusion

• This APAR provides the following fixes to ensure that the
  correct check constraint is specified on
  DSN_VIRTUAL_INDEXES.DATAREPEATFACTORF:
  o Db2-supplied stored procedure SYSPROC.ADMIN_EXPLAIN_MAINT:
    - Specify the correct check constraint on column
      DATAREPEATFACTORF when performing the following actions:
      o Create table DSN_VIRTUAL_INDEXES.
      o Add missing column DATAREPEATFACTORF to an existing
        DSN_VIRTUAL_INDEXES table.
      o Add missing check constraint on
        DSN_VIRTUAL_INDEXES.DATAREPEATFACTORF.
  o Db2-supplied REXX exec DSNTXTA (job DSNTIJXA):
    - Specify the correct check constraint on column
      DATAREPEATFACTORF when performing the following actions:
      o Add missing column DATAREPEATFACTORF to an existing
        DSN_VIRTUAL_INDEXES table.
      o Add missing check constraint on
        DSN_VIRTUAL_INDEXES.DATAREPEATFACTORF.
  o Db2-supplied REXX exec DSNTXTB (job DSNTIJXB):
    - Specify the correct check constraint on column
      DATAREPEATFACTORF when performing the following actions:
      o Create table DSN_VIRTUAL_INDEXES in UNICODE.
  o Db2 sample job DSNTESC:
    - Specify the correct check constraint on column
      DATAREPEATFACTORF in the
      CREATE TABLE DSN8!!0.DSN_VIRTUAL_INDEXES statement.
  

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:

  UI95033 UI95034

Modules/Macros

• DSNADMEM DSN@DMEM DSNTESC  DSNTXTA  DSNTXTB
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI95033

     UP23/12/29 P F312

• RD10 PSY UI95034

     UP23/12/29 P F312

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.