Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2006

    Unanswered: query good for some rows not for large

    Hi :
    We need some guidance on some query which does Insert by select from some tables.
    It works fine lets say for 50,000 but once we start 60,000 it is taking for ever.

    but if we do in smal subsets it works fine.

    Can someone put light on this ,that why it is happening?

    any idea?


    UDB 8.2.2

    AIX 5.2

    We have upto date statistics on all the tables.

    Thanks and appreciate in advance for any guidance.


  2. #2
    Join Date
    May 2003
    You may be running out of log space, but in that case the statement should rollback with an error.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jan 2003
    oraora, can you please provide error message, SQL sintax, table definitions of source and target table.

Posting Permissions

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