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: 6966
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: 6966
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 Data replication from multiple Db2 ta... kishpra DB2 1 Mon Mar 27, 2017 9:58 pm
No new posts Splitting of single report to seperat... abdulrafi TSO/ISPF 3 Mon Mar 27, 2017 3:59 pm
No new posts Append data from two files into a sin... Praveen04 DFSORT/ICETOOL 5 Thu Mar 16, 2017 7:29 pm
No new posts IMS DB-How to update a record (a sing... Nic Clouston IMS DB/DC 9 Thu Mar 09, 2017 4:38 pm
No new posts what is meaning of the number in dcl Martylin PL/I & Assembler 2 Thu Mar 09, 2017 7:18 am


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