[DB2-L] PKLIST's asssociated to PLAN's

Ruediger Kurtz

[DB2-L] PKLIST's asssociated to PLAN's
Hi Georg,

not sure if this is what suits you, but ..

Select collid , ...
from sysibm.syspacklist
where planname = 'YourPlan'

Hth

Ruediger Kurtz

-----Ursprüngliche Nachricht-----
Von: DB2 Data Base Discussion List [mailto:[login to unmask email]Im
Auftrag von Peter, Georg
Gesendet: Mittwoch, 5. Januar 2005 12:12
An: [login to unmask email]
Betreff: [DB2-L] PKLIST's asssociated to PLAN's


Collegues,

I am looking for a SQL statement that shows me which pklist's (=
collections) are used from which plans.

Any good ideas ? An example ?

(Environment is DB2 for OS/390 V6)

Thanks in advance.

With kind regards - mit freundlichen Gruessen,
Georg H. Peter c/o
-------------------------------------------------------------------
Datenzentrale Baden-Wuerttemberg
Software Development & Technology Center
Knowledge Center Database Systems
Krailenshaldenstrasse 44, 70469 Stuttgart, Germany, Europe
e:mail [login to unmask email]
Phone 0049-711-8108-271
PC-Fax 004971189696071
Internet (only in german language):http://www.dzbw.de
----------------------------------------------------------------------

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm