PM90093: WSL VALIDATION MESSAGE ADB3012E ERROR PROCESSING INDEX IN CREATE STATEMENT: THE PRIMARY INDEX OR INDEX ENFORCING UNIQUE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' Work Statement List (WSL)
  validation program ADB2WVL issues a message:
  FUNCTION = ADB2WVL, LINE 428: Signal error
  RC       = 8
  ZERRMSG  =
  ZERRSM   = User error
  ZERRLM   = One or more statements not successfully validated
     . Please see Report for more details.
  and shows the following in the CONSISTENCY CHECKS REPORT:
  ADB3012E Error processing Index >schema<.>index< in CREATE
  statement: The primary index or index enforcing unique
  constraint does not have a matching primary or unique key.
  

Local fix

• Do not use the WSL validation option.
  

Problem summary

•   USERS AFFECTED: Users of the DB2 Administration Tool
                    for z/OS who validate Work Statement
                    List (WSL .
  
    PROBLEM DESCRIPTION: In the DB2 catalog, there is a table
                         which has a PRIMARY KEY and a UNIQUE
                         INDEX defined on this table.  In the
                         WSL, this table is dropped and
                         recreated without the PRIMARY KEY and
                         a UNIQUE INDEX.
  
                         The WSL validation program ADB2WVL
                         issues a RC 8 / Return Code 8 and
                         error message ADB3012E /
                         msgadb3012e:
  
                         FUNCTION = ADB2WVL,
                         LINE 428:
                         Signal error
                         RC       = 8
                         ZERRMSG  =
                         ZERRSM   = User error
                         ZERRLM   = One or more statements
                         not successfully validated. Please
                         see Report for more details.
  
                         In addition, the following is
                         displayed in the CONSISTENCY
                         CHECKS REPORT:
  
                         ADB3012E Error processing Index
                         >schema<.>index< in CREATE statement:
                         The primary index or index enforcing
                         unique constraint does not have a
                         matching primary or unique key.
  
    RECOMMENDATION:
  
  Validate WSL failed with message ADB3012E / msgadb3012e.
  

Problem conclusion

• Problem has been resolved.
  

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:

  UK95187 UK95188

Modules/Macros

• ADB2WVL
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK95187

     UP13/06/19 P F306

• RA20 PSY UK95188

     UP13/06/19 P F306

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.