Tech Library 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. |
|
24/7 Environment, Need to Update Production Data? Audit, Data Security & SOX Compliance FEARS!!! (I07) 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 OBJECTIVES: 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? Click Here to Download NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information. |
