Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2002
    Location
    ATL
    Posts
    170

    Unanswered: Performance Issue

    Hi folks

    I have a ddl file that contains 100K statements(It contains drops , creation of table , creation of indexes,commits).

    This process ran all night and still finished only 20% of the statements.
    All it is doing is dropping the table and recreating table and adding indexes to the new table. I dont understand why DB2 is processing these statement so slow. What parameters can i tunne to improove the performance of DDLs(creation of objects).

    Iam on AIX5.3 UDB8.1 fixpack6.

    In the past 300K statement ran in less than two hours and iam trying to figure out why this perticular DDL is running so long.

    Any ideas !!!

  2. #2
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665
    The first place I would look would be the disk subsystem. Try to track the IO waits and go from there
    ------------
    And back to SQL Server....I always find my way home
    View my Linkedin profile

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Convert your script to a shell script were you can add a "date" command after each one to figure out which statements are taking a long time.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  4. #4
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Do you have dropped-table-recovery turned on for your tablespaces? That may slow down the DROP statements.

    Also, if you add data to the tables, it is usually better to first load the data and then create indexes and foreign keys.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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