Is there an IBM Tool to Rebind Plans/Collections

pts.
Tags:
390
Database
DB2
Mainframe
Oracle
I am an applicaiton developer, (analyst) resonsible for ensuring four test regions (and sometimes the produciton region) performs as effieciently as possible. We have approximately 1000 programs that have not accurate statistics (run stats are not updated, another question). Our DBA's tell us it is our responsibility to rebind the applicaitons (one at a time) multiplied by four regions. We have quit using the Platinum product and have IBM Tools only. Is their a IBM utility/job that says rebind all items in this collection? And if so, can you provide me a sample of the step to execute it! Thanks in advance. (Even if I need to extract all applicaitons from the DB2 catalog and paste them into a job, that is satisfactorily).

Answer Wiki

Thanks. We'll let you know when a new response is added.

Unless I misunderstood, it is easy. Just run this job step to rebind all packages in a collection:

//BATCHDSN EXEC PGM=IKJEFT1B,PARM=’DSN S(DB2P)’
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSTSIN DD *
REBIND PACKAGE(collection.*.(*))

The first * means “all packages”, the second “all versions” within this collection. In fact, you can replace collection by * as well to rebind everything in the subsystem.

Of course, with every rebind you have to be aware of the possibility of access path changes.

You can probably do this from DB2I 5:BIND/REBIND/FREE as well, however I never use this; a batch job provides better documentation.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Home4ever
    It's been a while and I am assuming this is mainframe based. When you say rebind there are 2 commands BIND and REBIND. REBIND will only re-establish the access paths using the previously bound DBRM it will NOT read new DBRM's. So first you need to decide which to do. To access a full collection use 'collection name'.* in the bind/rebind for all packages. You should be able to get a list of packages etc via SQL against the system tables SYSPLAN, SYSPACKAGE, SYSDBRM etc. What IBM tools do you have? You could run a REBIND 'collection name'.* using IKJEFT1B in a batch job. If you need to BIND the packages you will need to check all of the DBRM libraries are correct or list them in priority order concatenated on a DBRMLIB DD statement in your IKJEFT1B step.
    0 pointsBadges:
    report
  • TwoMetreBill
    Many shops, even those with tens of thousands of plans and/or packages, rebind all their plans/packages as part of their REORG cycle. They follow the following steps: 1. REORG with COPY while collecting full statistics on all columns. 2. REBIND PLAN (*) EXPLAIN YES (if they have any plans that don't use packages). 3. REBIND PACKAGE (*.*.*) EXPLAIN YES (to rebind all the packages in all collections. Bill
    0 pointsBadges:
    report
  • Craigmullins
    I'm not sure if these two IBM tools fit your need exactly, but you might want to check them out: DB2 Bind Manager - information available at http://www-306.ibm.com/software/data/db2imstools/db2tools/db2bindmngr.html DB2 Path Checker - information available at http://www-306.ibm.com/software/data/db2imstools/db2tools/db2pathchkr.html Good luck, Craig S. Mullins Mullins Consulting, Inc. http://www.CraigSMullins.com
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following