IDUG is proud to offer the latest in DB2 information straight from those who know it best: database administrators (DBAs), database managers, application programmers and developers, vendors and other IT professionals who use DB2 daily.
Topic: 2008 NA
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.