If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
Since you used the word "subsystem" does that mean you are using DB2 for OS/390 and z/OS? Please specify your platform and other info as requested in Must Read Before Posting thread.
You can build a list of all plans to rebind using the following as a guide (this is not the exact syntax):
Select 'REBIND PLAN ('||name||' );' from sysibm.sysplan where ...
You can do something similar for packages if needed.
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
I am assuming that your platform is os/390 or Z/os. If it is, then goto DB2I PRIMARY OPTION MENU (where we run our spufi etc) use option 5. which can be used for bind/rebind one or all plans and packages in a subsystem.