Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2005

    Unanswered: How to know the Load status of a table !!


    I am using db2 Load utility to load data to a table. But whenever i get db2 exception i need to check the status of a table whether the table is in Load pending state or is in Load In progress state. accordingly i should terminate or unset the Load attribute of a table. For this I am using db2LoadQuery() method to fetch the table status info. This works when there is one or two threads accessing same table, but fails if multiple threads accessing same table. I could not reset the table state to normal when there is db2 exception..... Can anyone tell me how use this db2LoadQuery method? Is this method a thread safe?

    Thanks in advance,

    Last edited by suri_me; 12-08-05 at 04:17. Reason: I need to know from CLI programming prospective

  2. #2
    Join Date
    Nov 2004

    load query

    there are 2 commands
    db2 load query table xxx.yy
    db2 list utilities show detail
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified

Posting Permissions

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