Another output of the GENERATE command are updates to three DB2 tables. The rows in these tables record all programs participating in the plan and any changes made by the ASSIGN AUTHID command. You can query these tables using SQL (in the same way that you query other tables) to answer questions such as, "Which plan does program x participate in?"
The "SYSADR Table Declarations for DB2" appendix illustrates the layout of these tables, named SYSADR.APTAB, SYSADR.APRES, and SYSADR.APAUT, respectively.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|