Creating a collection ?

Dee Reins

Creating a collection ?

I should be able to
What is the syntax for creating a collection id. I see alot of syntax of how to create the packages within a collection id.

Thanks
Dee


______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html
Attachments

  • import1 (3.7k)

Steen Rasmussen

Re: Creating a collection ?
(in response to Dee Reins)
You simply specify a new collection-id when you bind the package. If the
collection-id doesn't exist already AND you have the authorization to
create a collection-id, DB2 will create it for you during the BIND
PACKAGE process.

Steen Rasmussen
CA
Sr Engineering Services Architect
IBM Certified Database Associate - DB2 9 Fundamentals
IBM Certified Database Administrator - DB2 9 DBA for z/OS



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Dee Reins
Sent: Monday, January 19, 2009 1:25 PM
To: [login to unmask email]
Subject: [DB2-L] Creating a collection ?


I should be able to
What is the syntax for creating a collection id. I see alot of
syntax of how to create the packages within a collection id.

Thanks
Dee


______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password.
You should have gotten an e-mail with the temporary password assigned to
your account. Please log in and update your member profile. If you are
not already an IDUG.org member, please register at
http://www.idug.org/component/juser/register.html

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Byron Pierce

Re: Creating a collection ?
(in response to Steen Rasmussen)
You can also execute a PLAN bind with a PKLIST - something like will create
collection APPLPLAN:

//SYSTSIN DD *
DSN SYSTEM(DB21)
BIND PLAN (APPLPLAN) -
PKLIST(*.APPLPLAN.*) -
QUALIFIER(APPL) -
ENABLE(*) -
RETAIN -
ACTION(REPLACE) -
OWNER(APPLOWNR) -
EXPLAIN(YES) -
ACQUIRE(USE) -
FLAG(I) -
ISOLATION(CS) -
RELEASE(COMMIT) -
VALIDATE(BIND) -
DYNAMICRULES(BIND)
END

Byron C. Pierce
Prudential Retirement Technology
Database Services - DBA
280 Trumbull Street - H18C
Hartford, CT 06103-3509
Work: 860.534.4222
Fax: 860.534.3135



"Rasmussen,
Steen"
<Steen.Rasmussen@ To
CA.COM> [login to unmask email]
cc
Sent by: DB2 Data
Base Discussion Subject
List Re: [DB2-L] Creating a collection ?
<[login to unmask email]
ORG>



Mon 01/19/2009
02:36 PM


Please respond to
DB2 Database
Discussion list
at IDUG
<[login to unmask email]
2-l.org>





You simply specify a new collection-id when you bind the package. If the
collection-id doesn't exist already AND you have the authorization to
create a collection-id, DB2 will create it for you during the BIND
PACKAGE process.

Steen Rasmussen
CA
Sr Engineering Services Architect
IBM Certified Database Associate - DB2 9 Fundamentals
IBM Certified Database Administrator - DB2 9 DBA for z/OS



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Dee Reins
Sent: Monday, January 19, 2009 1:25 PM
To: [login to unmask email]
Subject: [DB2-L] Creating a collection ?


I should be able to
What is the syntax for creating a collection id. I see alot of
syntax of how to create the packages within a collection id.

Thanks
Dee


______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password.
You should have gotten an e-mail with the temporary password assigned to
your account. Please log in and update your member profile. If you are
not already an IDUG.org member, please register at
http://www.idug.org/component/juser/register.html

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You
should have gotten an e-mail with the temporary password assigned to your
account. Please log in and update your member profile. If you are not
already an IDUG.org member, please register at
http://www.idug.org/component/juser/register.html










______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Philip Sevetson

Re: Creating a collection ?
(in response to Byron Pierce)
Dee,

To expand a bit on what Steen said, a "collection" object does not
actually exist and cannot be created. So "creating" a collection is
implicit in the first BIND or GRANT statement to reference the
collection.

You might, forex, GRANT PACKADM ON collection_id TO SOMEUSER.
Thereafter, SOMEUSER would be able to BIND PACKAGE ... ACTION(ADD)
within that collection.

Hope this helps!

--Phil Sevetson

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Dee Reins
Sent: Monday, January 19, 2009 2:25 PM
To: [login to unmask email]
Subject: [DB2-L] Creating a collection ?


I should be able to
What is the syntax for creating a collection id. I see alot of
syntax of how to create the packages within a collection id.

Thanks
Dee


______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password.
You should have gotten an e-mail with the temporary password assigned to
your account. Please log in and update your member profile. If you are
not already an IDUG.org member, please register at
http://www.idug.org/component/juser/register.html

______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Dee Reins

Re: Creating a collection ?
(in response to Philip Sevetson)
Thank you all for your help.
These answers cleared up my problem.

My next problem, is that the oracle application folks, want to connect to DB2 on a mainframe, using the oracle gateway, and they are giving me the instructions to connect to DB2/UDB on unix.
What are the odds that they are not listening to me. :-)



-------------- Original message ----------------------
From: "Sevetson, Phil" <[login to unmask email]>
> Dee,
>
> To expand a bit on what Steen said, a "collection" object does not
> actually exist and cannot be created. So "creating" a collection is
> implicit in the first BIND or GRANT statement to reference the
> collection.
>
> You might, forex, GRANT PACKADM ON collection_id TO SOMEUSER.
> Thereafter, SOMEUSER would be able to BIND PACKAGE ... ACTION(ADD)
> within that collection.
>
> Hope this helps!
>
> --Phil Sevetson
>
> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
> Behalf Of Dee Reins
> Sent: Monday, January 19, 2009 2:25 PM
> To: [login to unmask email]
> Subject: [DB2-L] Creating a collection ?
>
>
> I should be able to
> What is the syntax for creating a collection id. I see alot of
> syntax of how to create the packages within a collection id.
>
> Thanks
> Dee
>
>
> ______________________________________________________________________
>
> * IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/Events *
> ______________________________________________________________________
>
>
>
>
> IDUG.org was recently updated requiring members to use a new password.
> You should have gotten an e-mail with the temporary password assigned to
> your account. Please log in and update your member profile. If you are
> not already an IDUG.org member, please register at
> http://www.idug.org/component/juser/register.html
>
> ______________________________________________________________________
>
> * IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
> ______________________________________________________________________
>
>
>
>
> IDUG.org was recently updated requiring members to use a new password. You
> should have gotten an e-mail with the temporary password assigned to your
> account. Please log in and update your member profile. If you are not already an
> IDUG.org member, please register at
> http://www.idug.org/component/juser/register.html

______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html