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

    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

    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?



    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.


    Copyright © 2014 IDUG. All Rights Reserved

    All material, files, logos and trademarks within this site are properties of their respective organizations.

    Terms of Service - Privacy Policy - Contact