How to find which all programs need to rebind in case of

Satish5 · Posted: Tue Nov 24, 2009 5:23 pm

Hi,

What will be the impact on programs in case of table change such as adding a column using alter? How to find which all programs need to rebind in case of table change?

Thanks,
Satish

Bharath Bhat · Posted: Tue Nov 24, 2009 5:33 pm

All the programs inserting into the table may need to be regenerated (after adding the column to the query if needed). And all those programs which have select * on the table.

You can get those programs from SYSIBM.SYSTABAUTH table.

balubhat · New User Joined: 04 Oct 2005 Posts: 19 Location: Singapore

You can use SYSIBM.SYSPACKDEP to check which are the programs using the table.

SELECT DNAME FROM SYSIBM.SYSPACKDEP
WHERE BNAME = <TABLE_NAME>
;

Satish5 · Posted: Thu Nov 26, 2009 9:15 am

Thanks Bharath Bhat and balubhat.

SELECT DNAME FROM SYSIBM.SYSPACKDEP
WHERE BNAME = <TABLE_NAME>

gave me desired reesults.

I could not understand how to get the program list from SYSIBM.SYSTABAUTH, I would apprciate if you can provide the query.

Thanks,
Satish