Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 6968
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: 6968
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 How to write Rexx program to size and... sreejeshcs CLIST & REXX 14 Thu Oct 12, 2017 7:26 am
No new posts Accessing CICS tran with map from JCL... navdeepaggarwal CICS 5 Tue Oct 03, 2017 6:15 pm
No new posts More than 1 Include criteria for sing... Roy Ware SYNCSORT 6 Wed Sep 13, 2017 11:45 pm
No new posts Multiple VSAM files single output fil... Mohan Kothakota DFSORT/ICETOOL 11 Wed Aug 09, 2017 7:57 pm
No new posts Profile changed to NUMBER ON STD (fro... Martylin TSO/ISPF 1 Thu Aug 03, 2017 9:14 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us