Ask the Expert

Auditing: RPG with embedded SQL showing up as a changed object

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: