Articles & Content


24/7 Environment, Need to Update Production Data? Audit, Data Security & SOX Compliance FEARS!!! (I07)

Topic: 2008 NA

Subtopic: DB2 for z/OS

DATE: 2008-05-20 (01:30 PM - 02:30 PM)
SPEAKERS: Ashish Malhotra (Progressive Insurance)

24/7 Environment, need to update Production data? Audit, Data Security, & SOX Compliance FEARS!!! DON'T WORRY, BE HAPPY!!!We came up with a solution to update and change data in our production environmentThis solution is:Quick - The process only needs SQL statementsDynamic - It can handle multiple update/delete/insert statements because the process was developed using dynamic sqlPreventative - prepares the sql for mistakes and also prevents damaging statements from running (ie ones no ‘where’ clauses)Backups - This process unloads the data before an update or deleteAccountable / Auditable - The developers id, date and sequence number are used to create all the files

EXP. LEVEL: Intermediate


How to securely change production data?

How to make the database changes dynamically?

How to create audit trails for production data updates?

How to prevent production data change mistakes?

How to make database update process Quick & Reliable?

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.