PL37204: COLUMNS IN PLAN_TABLE UPDATED BY EXPLAIN ARE NOT CLEARLY DOCUMENTED.

APAR status

• Closed as documentation error.

Error description

• THE SQL REFERENCE SC2643800 PAGE 172 STATES THAT THE VALUES
  INSERTED INTO THE COLUMNS OF PLAN_TABLE BY EXPLAIN ARE
  DESCRIBED IN SECTION 6 OF THE SYSTEM AND DATABASE
  ADMINSTRATION GUIDE. THE SYSTEM AND DATABASE ADMINSTRATION
  GUIDE SC2643740 STATES THAT THE COLUMNS IN PLAN_TABLE ARE
  DISCRIBED IN CHAPTER 5 OF THE SQL REFERENCE. IN THE REL1.3
  MANUAL SC2643460 THIS WAS ON PAGE141. THIS EXPLAINATION SHOULD
  BE IN AT LEAST ONE OF THESE MANUALS.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL.                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DB2 VERSION 2.1 ONLY:
                                                                 .
  IN THE DB2 SQL REFERENCE PAGE 172 UNDER EXPLAIN IT REFERS THE
  USER TO SECTION 6 OF THE SYSTEM AND DATABASE ADMINISTRATION
  GUIDE FOR A DESCRIPTION OF THE VALUES INSERTED INTO THE
  PLAN_TABLE. BUT, IN THE DB2 SYSTEM AND DATABASE ADMINISTRATION
  GUIDE SECTION 6 'PERFORMANCE MONITORING AND TUNING' PAGE 808
  UNDER 'QUERYING PLAN_TABLE' IT REFERS THE USER BACK TO CHAPTER
  5 OF THE SQL REFERENCE. NEITHER OF THE PUBLICATIONS INCLUDE
  A DESCRIPTION OF THE COLUMNS IN THE PLAN_TABLE.
  

Problem conclusion

• USER'S MAY REFER TO THE DB2 APPLICATION PROGRAMMING GUIDE
  STARTING ON PAGE 105 FOR A DESCRIPTION OF THE COLUMNS IN THE
  PLAN_TABLE.
                                                                 .
  A REQUEST FOR PUBLICATION CHANGE HAS BEEN SUBMITTED TO INCLUDE
  A CORRECTION IN THE NEXT RELEASE.
                                                                 .
  SLRS AFFECTED:
                                                                 .
   DB2 SYSTEM AND DATABASE ADMINISTRATION GUIDE SC264374 PAGE 808.
   DB2 SQL REFERENCE                            SC264380 PAGE 172.
   DB2 APPLICATION PROGRAMMING GUIDE            SC264377 PAGE 105.
  

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:

Fix information

Applicable component levels