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
 

 

How many DBRMs , Packages and Plans created after Bind

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

New User


Joined: 06 May 2005
Posts: 20
Location: Bangalore

PostPosted: Sat May 07, 2005 10:43 am    Post subject: How many DBRMs , Packages and Plans created after Bind
Reply with quote

Hi all,

I have 5 SQL statements in my Cobol-DB2 program.

when I bind it, how many DBRMs , Packages and Plans will be generated?

Please help me out.
:shock:
Back to top
View user's profile Send private message

gnagakishore

New User


Joined: 26 Mar 2005
Posts: 25
Location: Hyderabad

PostPosted: Sat May 07, 2005 10:35 pm    Post subject:
Reply with quote

one plan will come its sure. but regarding to packages and dbrms its system dependent i think.
Back to top
View user's profile Send private message
muraliksnv

New User


Joined: 07 May 2005
Posts: 3

PostPosted: Sun May 08, 2005 3:24 pm    Post subject: exceptional conditions
Reply with quote

hi all,

how many exceptional conditions can we give in a handle command?
Back to top
View user's profile Send private message
sivatechdrive

Active User


Joined: 17 Oct 2004
Posts: 190
Location: hyderabad

PostPosted: Mon May 09, 2005 12:34 pm    Post subject: Re: DBRM
Reply with quote

Hi praneethgokul

there will be only 1 DBRM..and 1 plan

the DBRM is based on the program not the number of SQL sttements inside a Program...
if this program calls 3 db2-cobol subprograms then the total number of DBRM's are 4 ( 1 mainprogram + 3 subprograms )


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

New User


Joined: 26 Apr 2005
Posts: 11
Location: pune

PostPosted: Tue May 10, 2005 9:51 pm    Post subject:
Reply with quote

hi, one dbrm will be generated for one program. if your is calling n- sub-programs then for every sub-progaram there will be n dbrm. i.e., for a program that is calling n programs there will be n+1 dbrms. for one dbrm there may one package or more, but only one plan will be generated.
Back to top
View user's profile Send private message
narasimharao_koganti

New User


Joined: 26 Apr 2005
Posts: 11
Location: pune

PostPosted: Tue May 10, 2005 10:02 pm    Post subject:
Reply with quote

hi murali,
I think we can specify upto 12 handle conditions, in a handle condition command.
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 What's plan, package, bind ? jackzhang75 DB2 2 Sun Feb 28, 2016 7:29 pm
No new posts What is Bind Error? Chetan Kumar Mainframe Interview Questions 1 Fri Oct 16, 2015 7:00 pm
No new posts Include a member getting created with... anjali.bisht JCL & VSAM 5 Tue Oct 13, 2015 11:19 am


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