Results 1 to 4 of 4

Thread: Load st

  1. #1
    Join Date
    May 2008
    Posts
    39

    Unanswered: Load st

    Hi

    I have 5 files which inserts data into exception table using Load utility.when i execute all 5 file concurrently table gets into loaad pending state.

    So i used load terminate.

    But is it possible to check if the table is being accesed by some other process then continue the load.

  2. #2
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338
    you can either take Snapshot for the entire application or take a snapshot for Locks during the time you start your LOAD utility.

    Is there any RI between these tables or any relationship among them?

  3. #3
    Join Date
    May 2008
    Posts
    39
    All 5 files use same exception table
    How shld I tk snapshot of locks

  4. #4
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338
    Ok. Look when you start the Load utility on a single table, the utility holds a X (exclusive Lock) on that table. So you should n't try to load all the files to the same table at the same. You can write a shell script which will pick the files one by one and process them with the LOAD command. Or you can try that manually. You can just type "GET SNAPSHOT" in the IBM Manual for V8 or V9. It will give you example with commands on how to take Snapshot on Locks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •