Query to check whether some XXXX is a vlid plan or not.

karthik_sripal · Posted: Wed Jul 29, 2009 7:13 pm

Hi all,

Good Day!!

I wanna check, whether a plan say PPPP and collection CCCC is existing or not in my db2 subsystem.
I cannot use DB2 file aid, so i must find out this by writing a query.

Can some one please help me in doing this !!

Hope am clear, please write back if any more informations is needed or the problem statement is not clear.

Thanks !!

dbzTHEdinosauer · Posted: Wed Jul 29, 2009 7:30 pm

look in the appendix for any sql reference. A List of ibm supplied tables is there, info about (what is contained), as well as sql for some exercises.

satyender · Posted: Thu Jul 30, 2009 11:57 pm

karthik_sripal,

Query on SYIBM.SYSPLAN or SYSIBM.SYSPACKAGE tables.

UNTESTED EXAMPLE:

SELECT *
FROM
SYSIBM.SYSPLAN
WHERE NAME = ' XYX'
WITH UR;