commit issue with import in db2

Posted on 2006-03-24
Last Modified: 2012-06-27

Please help me with this scenario:

Problem :
I have around 10 tables(having relationship with each other) and a data
asc file for each. i use import utility to load all the data one by one
for each table...these files are almost 1gb each. I need to commit data
only when all the 10 table imports are done as the data is relational
dependant , not after each table import is finished as the import
commits as it is done with the inserts/updates for one table...

The tables are in use by the users  so can drop relationships, Can i
use import in stored procedure.? or if these all imports can be clubbed
in a transaction. The data is either inserted or
updated(using  insert_update option of import)

please advice.
Question by:chee_torr
    LVL 7

    Accepted Solution

    create a updatable view and import into view (instead of table)
    LVL 45

    Assisted Solution

    Hi chee_torr,

    I would think that the easiest solution is to just order the imports so that you don't violate the RI.

    But the fastest method is to disable the RI, import the data, and then enable the RI.

    Good Luck!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
    Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
    This video discusses moving either the default database or any database to a new volume.
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now