We are going through an audit of changed objects on our systems. We have run into a case where SQLRPG programs are showing on the changed object report even though we have not changed them. I read something awhile back that stated something to the affect that when you use an RPG program with embedded SQL that it can show up as changed. I can't find the link, but I was wondering if this something that you know about.
DB2 stores access plans inside the SQLRPG program object for each SQL statement embedded within the program. An access plan is an internal DB2 structure that lays out how the SQL statement will be implemented internally.
When DB2 updates these access plans in the program because of environment changes on your system (new PTFs, more memory, etc), the change date of the program object will be updated at the same time.
This was first published in October 2008