Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Regarding packages, Collection & Plan

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

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Wed Nov 12, 2008 4:40 pm    Post subject: Regarding packages, Collection & Plan
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    Post subject:
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: 1013
Location: India

PostPosted: Wed Nov 12, 2008 5:23 pm    Post subject:
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    Post subject:
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: 1013
Location: India

PostPosted: Wed Nov 12, 2008 7:41 pm    Post subject:
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    Post subject:
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: 1013
Location: India

PostPosted: Wed Nov 12, 2008 8:22 pm    Post subject:
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    Post subject:
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: 1013
Location: India

PostPosted: Thu Nov 13, 2008 9:40 am    Post subject:
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    Post subject:
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: 1013
Location: India

PostPosted: Thu Nov 13, 2008 12:10 pm    Post subject:
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    Post subject:
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.    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Program and its corresponding plan vickey_dw DB2 4 Thu Apr 07, 2016 9:27 pm
No new posts Should we Rebind Plan if no SQL changes sappy_mf DB2 2 Thu Mar 03, 2016 2:13 pm
No new posts What's plan, package, bind ? jackzhang75 DB2 2 Sun Feb 28, 2016 7:29 pm
No new posts DB2 plan for DSNTEP2 / DSNTEP4 Mainak_Dalal DB2 3 Thu Jan 21, 2016 1:08 am
No new posts Multiple COBOL-DB2 pragrams calling b... deepak_shrivastava DB2 1 Wed Jan 06, 2016 3:45 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us