collection, how to remove an empty collection

JH

collection, how to remove an empty collection
To list:
We freed all packages from a collection, the
next step is to remove this collection.
We could not find the right command to do it.
Thanks for your help.
Joe



__________________________________
Do you Yahoo!?
All your favorites on one personal page – Try My Yahoo!
http://my.yahoo.com

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

Michael Ebert

Re: collection, how to remove an empty collection
(in response to JH)
A collection is just a conceptual grouping, a naming convention (like
beginning all production packages with a 'P'). It has no independent
physical existence. So you cannot create or destroy it independently. If
all packages specifying a certain collection are gone, the collection is
gone as well.

Dr. Michael Ebert
DB2 Database Administrator
aMaDEUS Data Processing
Erding / Munich, Germany




From: Joe Huang <[login to unmask email]>@IDUGDB2-L.ORG on 06-01-2005 12:25 PST

Please respond to DB2 Database Discussion list at IDUG
<[login to unmask email]>

Sent by: DB2 Data Base Discussion List <[login to unmask email]>



To: [login to unmask email]


cc:






Subjec [DB2-L] collection, how to remove
t: an empty collection








To list:
We freed all packages from a collection, the
next step is to remove this collection.
We could not find the right command to do it.
Thanks for your help.
Joe

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

Cindy Andersen

Re: collection, how to remove an empty collection
(in response to Michael Ebert)
If you indeed freed all the packages from a collection, then the
collection should not exist. There is no command to create or remove a
collection. The collection is implicitly created when used in the BIND
PACKAGE (location.collection-id) MEMBER (dbrm-member-name)... command if
it doesn't already exist. It should be implicitly removed if there are
no packages referencing it.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Joe Huang
Sent: Thursday, January 06, 2005 2:26 PM
To: [login to unmask email]
Subject: [DB2-L] collection, how to remove an empty collection

To list:
We freed all packages from a collection, the next step is to remove this
collection.
We could not find the right command to do it.
Thanks for your help.
Joe

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

Dave Nance

Re: collection, how to remove an empty collection
(in response to Cindy Andersen)
There could still be references to it if you have create in/on or
packadm on the collection, the same applies for granting bind and
execute auth on collid.* . You can issue revokes of those authorities.
This way, you have not only removed the conceptual grouping, but you
have, also, removed the ability of anyone to recreate those groupings.

Dave Nance
First Health Services, Corp.
(804)527-6841


>>> [login to unmask email] 1/6/05 3:40:44 PM >>>
A collection is just a conceptual grouping, a naming convention (like
beginning all production packages with a 'P'). It has no independent
physical existence. So you cannot create or destroy it independently.
If
all packages specifying a certain collection are gone, the collection
is
gone as well.

Dr. Michael Ebert
DB2 Database Administrator
aMaDEUS Data Processing
Erding / Munich, Germany




From: Joe Huang <[login to unmask email]>@IDUGDB2-L.ORG on 06-01-2005 12:25
PST

Please respond to DB2 Database Discussion list at IDUG
<[login to unmask email]>

Sent by: DB2 Data Base Discussion List <[login to unmask email]>



To: [login to unmask email]


cc:






Subjec [DB2-L] collection, how to remove
t: an empty collection








To list:
We freed all packages from a collection, the
next step is to remove this collection.
We could not find the right command to do it.
Thanks for your help.
Joe

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



"MMS <fhmail.firsthealth.com>" made the following annotations.
------------------------------------------------------------------------------
This message, including any attachments, is intended solely for the use
of the named recipient(s) and may contain confidential and/or
privileged information. Any unauthorized review, use, disclosure or
distribution of this communication(s) is expressly prohibited.
If you are not the intended recipient, please contact the sender by
reply e-mail and destroy any and all copies of the original message.
Thank you.
=====

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

Victor Bond

Re: collection, how to remove an empty collection
(in response to Dave Nance)
Dr Ebert is correct, but if you want to remove all reference to the
collection you might want to rebind all plans that include the collection in
their package list (check sysibm.syspacklist catalog table). Specify the
packagelist without the old collection.

There also might be some reference to it in the sysibm.syspackageauth table,
so you may need to revoke permissions on it.


-----Original Message-----
From: Michael Ebert [mailto:[login to unmask email]
Sent: Thursday, January 06, 2005 12:41 PM
To: [login to unmask email]
Subject: Re: [DB2-L] collection, how to remove an empty collection


A collection is just a conceptual grouping, a naming convention (like
beginning all production packages with a 'P'). It has no independent
physical existence. So you cannot create or destroy it independently. If all
packages specifying a certain collection are gone, the collection is gone as
well.

Dr. Michael Ebert
DB2 Database Administrator
aMaDEUS Data Processing
Erding / Munich, Germany




From: Joe Huang <[login to unmask email]>@IDUGDB2-L.ORG on 06-01-2005 12:25 PST

Please respond to DB2 Database Discussion list at IDUG
<[login to unmask email]>

Sent by: DB2 Data Base Discussion List <[login to unmask email]>



To: [login to unmask email]


cc:






Subjec [DB2-L] collection, how to remove
t: an empty collection








To list:
We freed all packages from a collection, the
next step is to remove this collection.
We could not find the right command to do it.
Thanks for your help.
Joe

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

Tina Hilton

Re: collection, how to remove an empty collection
(in response to Victor Bond)
I thought that as long as a plan referenced a collection, the collection
still existed, even if it had no packages. I remember running into this when
doing cleanup a while back. Once I freed the plans then the collection
disappeared.

Tina Hilton

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of
Michael Ebert
Sent: Thursday, January 06, 2005 3:41 PM
To: [login to unmask email]
Subject: Re: [DB2-L] collection, how to remove an empty collection

A collection is just a conceptual grouping, a naming convention (like
beginning all production packages with a 'P'). It has no independent
physical existence. So you cannot create or destroy it independently. If
all packages specifying a certain collection are gone, the collection is
gone as well.

Dr. Michael Ebert
DB2 Database Administrator
aMaDEUS Data Processing
Erding / Munich, Germany




From: Joe Huang <[login to unmask email]>@IDUGDB2-L.ORG on 06-01-2005 12:25 PST

Please respond to DB2 Database Discussion list at IDUG
<[login to unmask email]>

Sent by: DB2 Data Base Discussion List <[login to unmask email]>



To: [login to unmask email]


cc:






Subjec [DB2-L] collection, how to remove
t: an empty collection








To list:
We freed all packages from a collection, the
next step is to remove this collection.
We could not find the right command to do it.
Thanks for your help.
Joe

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

Philip Sevetson

Re: collection, how to remove an empty collection
(in response to Tina Hilton)
Since everyone else is jumping in here, My $.02...

If you're trying to eliminate the record of a collection, don't forget to
REVOKE any privileges granted in SYSRESAUTH.

--Phil Sevetson
Database Administration
Wakefern Food Corporation CISD
mailto:[login to unmask email]




If you indeed freed all the packages from a collection, then the
collection should not exist. There is no command to create or remove a
collection. The collection is implicitly created when used in the BIND
PACKAGE (location.collection-id) MEMBER (dbrm-member-name)... command if
it doesn't already exist. It should be implicitly removed if there are
no packages referencing it.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Joe Huang
Sent: Thursday, January 06, 2005 2:26 PM
To: [login to unmask email]
Subject: [DB2-L] collection, how to remove an empty collection

To list:
We freed all packages from a collection, the next step is to remove this
collection.
We could not find the right command to do it.
Thanks for your help.
Joe

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

JH

Re: collection, how to remove an empty collection
(in response to Philip Sevetson)
Tina:
Thanks, you are correct, I do have a number of
PLANs pointing to empty collection ids.
Joe



--- "Hilton, Tina" <[login to unmask email]> wrote:

> I thought that as long as a plan referenced a
> collection, the collection
> still existed, even if it had no packages. I
> remember running into this when
> doing cleanup a while back. Once I freed the plans
> then the collection
> disappeared.
>
> Tina Hilton
>
> -----Original Message-----
> From: DB2 Data Base Discussion List
> [mailto:[login to unmask email] On Behalf Of
> Michael Ebert
> Sent: Thursday, January 06, 2005 3:41 PM
> To: [login to unmask email]
> Subject: Re: [DB2-L] collection, how to remove an
> empty collection
>
> A collection is just a conceptual grouping, a naming
> convention (like
> beginning all production packages with a 'P'). It
> has no independent
> physical existence. So you cannot create or destroy
> it independently. If
> all packages specifying a certain collection are
> gone, the collection is
> gone as well.
>
> Dr. Michael Ebert
> DB2 Database Administrator
> aMaDEUS Data Processing
> Erding / Munich, Germany
>
>
>
>
> From: Joe Huang <[login to unmask email]>@IDUGDB2-L.ORG
> on 06-01-2005 12:25 PST
>
> Please respond to DB2 Database Discussion list at
> IDUG
> <[login to unmask email]>
>
> Sent by: DB2 Data Base Discussion List
> <[login to unmask email]>
>
>
>
> To: [login to unmask email]
>
>
> cc:
>
>
>
>
>
>
> Subjec [DB2-L] collection, how to remove
> t: an empty collection
>
>
>
>
>
>
>
>
> To list:
> We freed all packages from a collection, the
> next step is to remove this collection.
> We could not find the right command to do it.
> Thanks for your help.
> Joe
>
>
-----------------------------------------------------------------------------
> ----
> 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
>




__________________________________
Do you Yahoo!?
Take Yahoo! Mail with you! Get it on your mobile phone.
http://mobile.yahoo.com/maildemo

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