Another DB2 question...SYSIBM.SYSPLANDEP...how is this updated

I can't find in any manual where it states how SYSIBM.SYSPLANDEP is updated. I made the assumption it would be done at BIND time. I have a DBRM that contains both dynamic and static SQL. This DBRM is bound into a plan. I can run the program and the SQL will execute successfully. However

Re: Another DB2 question...SYSIBM.SYSPLANDEP...how is this updated

Basic DB2 structure - 1. very old DB2 - plans contained DBRM's - BIND PLAN MEMBER(list of DBRM's) - DBRM dependencies for these DBRM's are stored in SYSPLANDEP 2. new DB2 (last 15 years) - plans contain package list entries - BIND PLAN PKLIST(list of package names) No dependendies stored in SYSPL

Re: Another DB2 question...SYSIBM.SYSPLANDEP...how is this updated

:44 AM Subject: Another DB2 question...SYSIBM.SYSPLANDEP...how is this updated Sent by: IBM Mainframe Discussion List I can't find in any manual where it states how SYSIBM.SYSPLANDEP is updated. I made the assumption it would be done at BIND time. I have a DBRM that contains both dy