Resources

Plan purge REXX

Topic: Code Place

Subtopic: DB2 for z/OS



image copy (BMC Copy Plus) of the tablespaces containing your plan tables. Next plan purge (each owner) where you specify the DB2 ssid & plan table owner, lastly it reorgs. For each plan table you must have a corresponding history table



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.