Q

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

DB2 stores access plans inside the SQLRPG program object for each SQL statement embedded within the program. When DB2 updates these access plans because of a system environment change, the change date of the program object will be updated at the same time.

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

Dig deeper on DB2 UDB (universal databases)

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchEnterpriseLinux

SearchDataCenter

Close