MVSFORUMS.com

dubasir · Beginner Joined: 13 Dec 2004 Posts: 20 Topics: 9

Hi,

Do i need to bind the program everytime when reorg is executed on a table that is used in the program.

In development region i have to bind the program whenever reorg is executed. Is this the same in production region as well. Please suggest.

Thanks in advance,
Ramki

CZerfas · Intermediate Joined: 31 Jan 2003 Posts: 211 Topics: 8

If the characteristics of your data has changed "significantly", you are advised to recreate the access path to the data.

For this you don't have to do a BIND (i.e. with the DBRM as input create a new DB2 package), but you can do a REBIND. This skips the validation phase of the BIND and simply creates a new package out of the contents of the DB2 catalog, means the saved SQL statements of your module in the table SYSSTMT.

regards
Christian

jsharon1248 · Posted: Mon Jul 19, 2010 8:11 am Post subject:

Runstats. Don't forget the Runstats after the Reorg.

A Bind is recommended after Reorgs and Runstats, but not required. Your Package would continue to use the existing access path if you didn't Bind or Rebind.