|
View previous topic :: View next topic
|
| Author |
Message |
shyamkumarnagabandi
New User
Joined: 12 May 2009
Posts: 7
Location: hyderabad
|
|
|
|
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 |
|
 |
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
| 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 |
|
|
shyamkumarnagabandi
New User
Joined: 12 May 2009
Posts: 7
Location: hyderabad
|
|
|
|
| thanx... |
|
| Back to top |
|
|
shyamkumarnagabandi
New User
Joined: 12 May 2009
Posts: 7
Location: hyderabad
|
|
|
|
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 |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
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 |
|
|
|
|
