IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Regarding packages, Collection & Plan


IBM Mainframe Forums -> DB2
Post new topic   This topic is locked: you cannot edit posts or make replies.
View previous topic :: View next topic  
Author Message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1020
Location: India

PostPosted: Wed Nov 12, 2008 4:40 pm
Reply with quote

Hi all,

I have a cobol-db2 program, i pre-compile it. It gives me a DBRM.

My question is ,
when i bind package it, it creates a new PACKAGE, RIGHT
My question is,
How to create a new collection & add my PACKAGE to that collection.
So that i can use the this collection in the plan.

Please enlight me in this process.....
How to create new package, collection and plan.
Add packages to collections and use this collection in the plan.

Very Confused Right now,
Sushanth
Back to top
View user's profile Send private message
Bharath Bhat

Active User


Joined: 20 Mar 2008
Posts: 283
Location: chennai

PostPosted: Wed Nov 12, 2008 4:43 pm
Reply with quote

Read this Article. Probably this could help you.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1020
Location: India

PostPosted: Wed Nov 12, 2008 5:23 pm
Reply with quote

Hi,

I get the flow how it goes.

By bind package/plan ? i can create a package/plan.

How to create a collection ? and add the package to the collection.

Sushanth
Back to top
View user's profile Send private message
Bharath Bhat

Active User


Joined: 20 Mar 2008
Posts: 283
Location: chennai

PostPosted: Wed Nov 12, 2008 6:03 pm
Reply with quote

When you are binding a package, mention your collection name in
Code:
PACKAGE(?)
MEMBER(URMEMBER)
...........................
...........

I think that should create a collection if you have authority to create a collection.

PS--> I've not tested it. But when I tried, it gave me an error
Code:
DSNT235I  -DTTA DSNTBCM2 BIND AUTHORIZATION ERROR
           USING DB2TUNT AUTHORITY               

not an SQLCODE. So I thought the approach is correct but problem with authority.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1020
Location: India

PostPosted: Wed Nov 12, 2008 7:41 pm
Reply with quote

I just found out, in BIND PLAN i can create a new collection(PKLIST).

Thank You,
Sushanth
Back to top
View user's profile Send private message
Bharath Bhat

Active User


Joined: 20 Mar 2008
Posts: 283
Location: chennai

PostPosted: Wed Nov 12, 2008 8:20 pm
Reply with quote

Thanks for letting me know.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1020
Location: India

PostPosted: Wed Nov 12, 2008 8:22 pm
Reply with quote

Its all about SHARING bharath.
Back to top
View user's profile Send private message
Bharath Bhat

Active User


Joined: 20 Mar 2008
Posts: 283
Location: chennai

PostPosted: Wed Nov 12, 2008 8:39 pm
Reply with quote

I tried it out, but I am still getting a similiar error. icon_confused.gif I guess I do not have proper authority.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1020
Location: India

PostPosted: Thu Nov 13, 2008 9:40 am
Reply with quote

Bharath,

I tried to create package for a table which i created. I guess i will be having proper authority.

Sushanth
Back to top
View user's profile Send private message
Bharath Bhat

Active User


Joined: 20 Mar 2008
Posts: 283
Location: chennai

PostPosted: Thu Nov 13, 2008 10:11 am
Reply with quote

sushanth bobby wrote:
Bharath,

I tried to create package for a table which i created. I guess i will be having proper authority.

Sushanth

I thought packages are for programs. What do you mean by 'package for a table'?
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1020
Location: India

PostPosted: Thu Nov 13, 2008 12:10 pm
Reply with quote

Yes Yes Bharath,

Packages are for program only. The cobol program access the table which i created, so i am the table owner. So, as i was saying, i will be having proper authority.

Sushanth
Back to top
View user's profile Send private message
Bharath Bhat

Active User


Joined: 20 Mar 2008
Posts: 283
Location: chennai

PostPosted: Thu Nov 13, 2008 12:42 pm
Reply with quote

Oh!! Okies, I got that. I will try to emulate you some time later icon_wink.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies. View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts current batch plan DB2 3
No new posts Packages - Versioning DB2 1
No new posts Log an Plan name/id or Job Id using D... DB2 1
No new posts Number of Packages required for stati... DB2 4
No new posts Usage/Utiliy of Plan in DB2 DB2 4
Search our Forums:

Back to Top