PL40841: MSGDSNU060I SQLCODE-551 WITH CHECK UTILITY AND STATS AUTHORITY

APAR status

• Closed as returned (APAR cannot be resolved without additional info from IBM or customer.)

Error description

• USER ATTEMPTED TO RUN THE CHECK UTILITY AGAINST A USER DATABASE
  WITH REFERENTIAL INTEGRITY CONSTRAINTS AND IS GETTING A SQLCODE
  -551 (USER NOT PERMITTED TO PERFORM THIS OPERATION) EVEN THOUGH
  THE USER HAS STATS AUTHORITY OVER THE DATABASE, WHICH OUGHT TO
  BE SUFFICIENT.  RAISING THE USER'S AUTHORITY TO DBMAINT DOES
  NOT HELP BUT RAISING IT TO DBADM DOES PERMIT THE CHECK UTILITY
  TO RUN TO COMPLETION.
  

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

•     USER WAS TOLD TO START DB2 TRACE WITH TDATA(COR) AND IT
  WAS FOUND THAT THE TRACE RECORDED WITHOUT RECORD HEADERS.
     WITHOUT THE RECORD HEADER WE ONLY GET TRACE DATA FIELDS
  AND CANNOT IDENTIFY THE TRACE ENTRY.
      USER IS REQUESTED TO RECREATE THE PROBLEM AFTER STARTING
  DB2 GLOBAL TRACE TO EXTERNAL DATASET (SMF OR GTF) WITH OPTIONS
  TDATA(TRA,COR).   USER IS ALSO REQUESTED TO SUBMIT UTILITY JOB
  LISTING AND IDENTIFY THE USER-ID THAT IS EXECUTING THE JOB.
  ALSO DSN1COPY OF THE FOLLOWING CATALOG TABLESPACES ARE
  REQUESTED:       SYSDBASE,  SYSDBAUT,  SYSGPAUT AND SYSUSER.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels