The collection of each package is stored in the DB2 Catalog in the
SYSIBM.SYSPACKAGE table in the COLLID column. Same column name is also in
the SYSIBM.SYSPACKLIST for the packages included in a plan and
SYSIBM.SYSPACKSTMT for the SQL statements in each package.
If you are asking instead, which collection of several known to use in which
circumstance, then the best approach is to consult your application or
database documentation, or as a last result talk to the DBA, application
developer or designer who built the application with multiple collections
(it had better be documented somewhere or else you'll have to walk through
the programs to figure things out).
Good luck.
Cheers,
Craig S. Mullins
Director, Technology Planning
BMC Software
http://www.BMC.com
http://www.DBAzine.com
http://www.CraigSMullins.com
-----Original Message-----
From: Mery Moreno
[mailto:db2udbdba-ezmlmshield-x47629706.[Email address protected]
Sent: Friday, May 28, 2004 1:21 PM
To: LazyDBA Discussion
Subject: CLI COLLECTION ID
All,
How I can find what DB2 collection Id my environmment is using?
Plataform OS/390 version 6.1
Thanks,
Mery B. Moreno
Database Administrator - DBA
Lakeland Regional Medical Center
Phone: 863-687-1100 Ext 2830
Confidentiality Notice:
This is a transmission from Lakeland Regional Medical Center. This message
and any attached documents may be confidential and contain information
protected by state and federal medical privacy statutes. They are intended
only for the use of the addressee. If you are not the intended recipient,
any disclosure, copying, or distribution of this information is strictly
prohibited. If you received this transmission in error, please accept our
apologies and notify the sender.
<<<<GWAVAsig>>>>
BEGIN:VCARD
VERSION:2.1
X-GWTYPE:USER
FN:Moreno, Mery
ORG:;I.S.
EMAIL;WORK;PREF:Mery.[Email address protected]
N:Moreno;Mery
TITLE:DBA
END:VCARD
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: db2udbdba-[Email address protected]
DB2 & UDB email list listserv db2-l LazyDBA home page