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: 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 Read two inputs and write into output... murali.andaluri DFSORT/ICETOOL 5 Wed Jul 26, 2017 7:35 pm
No new posts Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm
No new posts pre-compiler for program in an HFS Pedro DB2 0 Fri Jun 23, 2017 11:13 pm
No new posts Compiling program in endeavor for tra... RALAKKAL Compuware & Other Tools 4 Mon Jun 05, 2017 8:27 pm
No new posts COBOL DB2 program - zIIP eligible vasanthz COBOL Programming 7 Wed May 31, 2017 5:12 am


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