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

Georg Peter

[DB2-L] AW: [DB2-L] PKLIST's asssociated to PLAN's
Hallo Ruediger,

good comment - the following is the result:

---------+---------+---------+---------+---------+---------+---------+------
---+
select a.collid

, a.planname

from sysibm.syspacklist a

where planname in (select name from sysibm.sysplan b)

and collid like 'DT%'

order by 2 asc

---------+---------+---------+---------+---------+---------+---------+------
---+
COLLID PLANNAME

---------+---------+---------+---------+---------+---------+---------+------
---+
DTOSSYENTW PLDTCIC1

DTOSSYPROD PLDTCIC2

DTOSSYENTW PLDTCIC3

DTOSSYENTW PLDTCIC4

DTOSSYENTW PLDTCIC6

DTOSSYENTW PLDTCIC8

DSNE610I NUMBER OF ROWS DISPLAYED IS 6

DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100


With kind regards - mit freundlichen Gruessen,
Georg

---------------------------------------------------------------------------------
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

Mark Vickers

Re: PKLIST's asssociated to PLAN's
(in response to Georg Peter)
George, I use this to get the package details as well:

SELECT PKG.LOCATION, PKG.COLLID, PKG.NAME
, HEX(PKG.CONTOKEN) AS CONTOKEN
, PKG.OWNER, PKG.CREATOR, PKG.TIMESTAMP, PKG.BINDTIME
, PKG.QUALIFIER , PKG.EXPLAIN, PKG.HOSTLANG
FROM SYSIBM.SYSPACKAGE PKG
JOIN SYSIBM.SYSPACKLIST PKL
ON PKG.COLLID = PKL.COLLID
WHERE PLANNAME = 'MQWFPL01'
ORDER BY 1,2,3

and add any other columns you need.

Mark.

-----Original Message-----
From: Peter, Georg [mailto:[login to unmask email]
Sent: Wednesday, January 05, 2005 5:12 AM
To: [login to unmask email]
Subject: [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

Mark Vickers

Re: PKLIST's asssociated to PLAN's
(in response to Mark Vickers)
oops,

Try this

SELECT PKG.LOCATION, PKG.COLLID, PKG.NAME
, HEX(PKG.CONTOKEN) AS CONTOKEN
, PKG.OWNER, PKG.CREATOR, PKG.TIMESTAMP, PKG.BINDTIME
, PKG.QUALIFIER , PKG.EXPLAIN, PKG.HOSTLANG
FROM SYSIBM.SYSPACKAGE PKG
JOIN SYSIBM.SYSPACKLIST PKL
ON PKG.COLLID = PKL.COLLID
AND PKG.NAME = PKL.NAME
WHERE PKL.PLANNAME = 'DBPK024'
ORDER BY 1,2,3


-----Original Message-----
From: Peter, Georg [mailto:[login to unmask email]
Sent: Wednesday, January 05, 2005 5:12 AM
To: [login to unmask email]
Subject: [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