View previous topic :: View next topic |
Author |
Message |
SMS Beginner
Joined: 16 Oct 2005 Posts: 53 Topics: 24
|
Posted: Fri Jul 20, 2007 3:32 pm Post subject: Table showing the current EXPLAIN status |
|
|
Hi,
I am looking for a DB2 catalog table which shows whether the EXPLAIN is current or not.
SYSIBM.SYPLAN shows only whether a plan has EXPLAIN or not ('Y' or 'N').
I've around 300 tables. At one shot I would like to extract this info.
Can anyone help me ? Your inputs are appreciated.
Thanks
SMS |
|
Back to top |
|
 |
CZerfas Intermediate
Joined: 31 Jan 2003 Posts: 211 Topics: 8
|
Posted: Mon Jul 23, 2007 1:52 am Post subject: |
|
|
The EXPLAIN is current, if the consistency token stated in the explain table row matches the consistency token within the load module you are executing. Since DB2 cannot know, what load library you are using, you cannot find this information in the DB2 catalog.
regards
Christian |
|
Back to top |
|
 |
SMS Beginner
Joined: 16 Oct 2005 Posts: 53 Topics: 24
|
Posted: Mon Jul 23, 2007 12:09 pm Post subject: |
|
|
Christian,
Thanks for the information.
Regards,
SMS |
|
Back to top |
|
 |
|
|