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
 

 

maximum number of packages for a single program in db2

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

New User


Joined: 12 May 2009
Posts: 7
Location: hyderabad

PostPosted: Tue Jun 09, 2009 4:08 pm    Post subject: maximum number of packages for a single program in db2
Reply with quote

what is the maximum no of packages(storing as DBRMS) can be given for a single program??
I did bind package for 15 times...but i need to know how many versions does it stores???
could any one help me out...
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6967
Location: porcelain throne

PostPosted: Tue Jun 09, 2009 6:21 pm    Post subject:
Reply with quote

Quote:
what is the maximum no of packages(storing as DBRMS) can be given for a single program??

you only get one dbrm per program.
Whether your site has some type of autobackup during re-precompile
to save old dbrms generated,
you will have to ask someone in your shop.


Quote:
I did bind package for 15 times...but i need to know how many versions does it stores???

versions refers to the number of db2 catelogue entries are maintained for any one plan/package.

As with the previously poorly written question, this is site specific.
we have no idea want goes on in your shop
(other than employing people who have no idea about what is going on in the shop),
Ask someone with whom you work.
Back to top
View user's profile Send private message
shyamkumarnagabandi

New User


Joined: 12 May 2009
Posts: 7
Location: hyderabad

PostPosted: Tue Jun 09, 2009 7:08 pm    Post subject:
Reply with quote

thanx...
Back to top
View user's profile Send private message
shyamkumarnagabandi

New User


Joined: 12 May 2009
Posts: 7
Location: hyderabad

PostPosted: Tue Jun 09, 2009 7:29 pm    Post subject:
Reply with quote

actually when i executed a query ' SELECT * FROM SYSIBM.SYSPACKAGE;'
it has given the some entries which i had made bind PACKAGE which is having some versions.
I knew that the program will contain only one DBRM for one plan/package.
but i need to know how entries does it stores???
if the question was not clear...plz let me know....
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6967
Location: porcelain throne

PostPosted: Tue Jun 09, 2009 7:55 pm    Post subject:
Reply with quote

I realize that my sarcasm may have hidden the message, but
all these things are site specific,
they are db2 parms, installation set-up
that only your site support knows


These entries are carried in db2 systems tables.
As an appendix to every SQL Reference, usually
Appendix D. DB2 catalog tables
you could look thru those,
or maybe a db2 tool (bmc, platnum, etc..) will also display them.
I usually ask a DBA.
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 IMS T-Pipe queue counts in a COBOL Pr... Siva NKK Kothamasu IMS DB/DC 0 Tue May 09, 2017 6:31 pm
No new posts SMTP the current generation number of... Jyothi Kulunde JCL & VSAM 4 Thu May 04, 2017 4:08 pm
This topic is locked: you cannot edit posts or make replies. SDSF multiple spool datasets extracte... PJAlarcon CLIST & REXX 1 Fri Apr 21, 2017 10:50 pm
No new posts Need help in REXX CALL program Raje1002 CLIST & REXX 5 Wed Apr 19, 2017 11:18 pm
No new posts Edit large number of datasets (QSAM) zh_lad TSO/ISPF 3 Tue Apr 04, 2017 6:08 pm


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