Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2013
    Posts
    34

    Unanswered: Need query to check the estimate time for load process

    Env: db2 9.1 on linux v5.

    Hi All,

    On some production environment one load process is loading data into table .
    It is taking very long time. When i see the status of load with query "load query table tabname"
    Indexing is in progress.

    My question is Is there any query or command to check the estimate time(i.e how much time the load will take) for load to complete?

    Thanks in advance.

  2. #2
    Join Date
    Oct 2007
    Posts
    246
    Quote Originally Posted by Pra View Post
    Env: db2 9.1 on linux v5.

    Hi All,

    On some production environment one load process is loading data into table .
    It is taking very long time. When i see the status of load with query "load query table tabname"
    Indexing is in progress.

    My question is Is there any query or command to check the estimate time(i.e how much time the load will take) for load to complete?

    Thanks in advance.
    ---------

    Use

    db2 List utilities show detail


    Check the indexes for the table, more indexes more time to load.

  3. #3
    Join Date
    May 2012
    Location
    Canberra, Australia
    Posts
    176
    Provided Answers: 6
    If you were on a higher version you could use snaputil_progress view.

Posting Permissions

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