Ask the Experts

Ask the Experts

Change Management

• 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 ...  Continue Reading

• Changing system CCSID

  If done without attention to detail, changing the CCSID on the AS/400 can lead to very messy database files.  Continue Reading

• Changing BRMS configurations for new naming conventions for i5

  Use BRMMED to adapt the i5 to new location names for relocated machines.  Continue Reading

• Why can't we change the system value?

  One Search400.com member wrote, "We recently upgraded to V5R3, and we're no longer able to change system value QUTCOFFSET. Do you know what the problem is?" Systems management expert Dan Reusche explains what is going on.  Continue Reading