Results 1 to 4 of 4
  1. #1
    Join Date
    May 2001
    Posts
    1

    Smile Unanswered: SELECT operation not running when data IMPORT

    I am facing a problem on SELECT operation not running when data IMPORT.

    I am using DB2 UDB V7.1 in Winnt platform. My problem is when I perform large number of data IMPORT in DB2 Command Window, during IMPORT I issued a
    SELECT operation in DB2 Command Center, but the SELECT operation not processed during data IMPORT. The SELECT operation only worked after all
    the IMPORT operation finished.

    From what I know, the SELECT operation should be able to perform during data IMPORT.

  2. #2
    Join Date
    Sep 2002
    Posts
    30
    You can't specify SELECT operation in a IMPORT statement. You can sepcify SELECT operation in a EXPORT statement or in a INSERT statement.

    Please check with the SQL Reference and DB2 Command Reference.

    Regards,

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: SELECT operation not running when data IMPORT

    IMPORT takes an exclusive lock on the table and hence a 'clean' read is not possible to a table being imported ...

    HTH

    Cheers

    Sathyaram

    Originally posted by janekow
    I am facing a problem on SELECT operation not running when data IMPORT.

    I am using DB2 UDB V7.1 in Winnt platform. My problem is when I perform large number of data IMPORT in DB2 Command Window, during IMPORT I issued a
    SELECT operation in DB2 Command Center, but the SELECT operation not processed during data IMPORT. The SELECT operation only worked after all
    the IMPORT operation finished.

    From what I know, the SELECT operation should be able to perform during data IMPORT.

  4. #4
    Join Date
    Nov 2002
    Posts
    10

    Re: SELECT operation not running when data IMPORT

    I am not sure if an uncommited read 'select' will work,
    'SELECT ... WITH UR". If you have result, please post it here. Thanks.


    Originally posted by janekow
    I am facing a problem on SELECT operation not running when data IMPORT.

    I am using DB2 UDB V7.1 in Winnt platform. My problem is when I perform large number of data IMPORT in DB2 Command Window, during IMPORT I issued a
    SELECT operation in DB2 Command Center, but the SELECT operation not processed during data IMPORT. The SELECT operation only worked after all
    the IMPORT operation finished.

    From what I know, the SELECT operation should be able to perform during data IMPORT.
    regards,
    BBG

Posting Permissions

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