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
 

 

bind package with different collection ID

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
trevor_rebelo

New User


Joined: 18 Aug 2005
Posts: 17

PostPosted: Tue Jul 11, 2006 6:53 pm    Post subject: bind package with different collection ID
Reply with quote

Hi,

I have a Stored Proc bound with 2 collection ID's and i want the same to be bound with another collection ID.
I have not idea where the DBRM is .... and i don't have the source code also..

can we bind a package using the already bound packages....


Regards
Trevor
Back to top
View user's profile Send private message

senthilssg

New User


Joined: 09 Dec 2005
Posts: 64
Location: USA

PostPosted: Sun Jul 16, 2006 4:53 pm    Post subject:
Reply with quote

Hi,

You can get the collection id from the stored procedure from the following query. In that you can also have external name. This external name is name of the load module and also name of the DBRM also


Code:
SELECT NAME, COLLID, EXTERNAL_NAME FROM SYSIBM.SYSROUTINES WHERE NAME='stoprocname' AND SCHEMA='schema name';


Now you know the DBRM name and collid. So that you can easily able to find the dataset in which DBRM is available by issuing following sql query.


Code:
SELECT NAME, PDSNAME FROM SYSIBM.SYSDBRM WHERE NAME='dbrmname';


Please correct me if I?m wrong

Regards
Senthil
Back to top
View user's profile Send private message
Hanfur

Active User


Joined: 21 Jun 2006
Posts: 104

PostPosted: Tue Jul 18, 2006 12:00 pm    Post subject: Hi
Reply with quote

Trev,

BIND PACKAGE(COLLID) MEMBER(MMNAME) and use REPLACE during BIND since you already know the COLLID of the stored proc it belongs..

-Han.
Back to top
View user's profile Send private message
trevor_rebelo

New User


Joined: 18 Aug 2005
Posts: 17

PostPosted: Fri Jul 21, 2006 5:52 pm    Post subject: Re: Hi
Reply with quote

Hanfur wrote:
Trev,

BIND PACKAGE(COLLID) MEMBER(MMNAME) and use REPLACE during BIND since you already know the COLLID of the stored proc it belongs..

-Han.


I want the already existing package to New CollID .... but NO DBRM , NO CODE
Back to top
View user's profile Send private message
trevor_rebelo

New User


Joined: 18 Aug 2005
Posts: 17

PostPosted: Fri Jul 21, 2006 6:05 pm    Post subject:
Reply with quote

Hi Senthil,

the PDSNAME in the SYSPACKAGE is the PDS where the DBRM existed while binding BUT is no longer existing.

in SYSDBRM there is NO entry...
Back to top
View user's profile Send private message
trevor_rebelo

New User


Joined: 18 Aug 2005
Posts: 17

PostPosted: Fri Jul 21, 2006 6:14 pm    Post subject:
Reply with quote

Hi,

Anyway Thanks for ur suggestions....

I found out 2 solutions ...
1. use the BND024 pgm which comes with BIND MANAGER to create the DBRM from the Package.... (I did not test it as i could not locate the libary)

2. In the DB2I ---- BInd ----BIND package..option we can bind the package either using DBRM (DBRM Option) else using the existing Package (COPY Option)..... (This is workin)

Regards
Trevor
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    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 Why myself doing Package Bind always ... Susanta DB2 5 Thu Mar 02, 2017 10:47 pm
No new posts Bind plan as a member to another bind... rexx77 DB2 0 Thu Feb 16, 2017 2:02 am
No new posts JCL to delete component in a package sundaram.naveen Compuware & Other Tools 14 Tue Nov 29, 2016 6:21 pm
No new posts What's plan, package, bind ? jackzhang75 DB2 2 Sun Feb 28, 2016 7:29 pm
No new posts Cobol DB2 package accessing differen... Mainak_Dalal DB2 1 Tue Jan 26, 2016 12:57 am


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