Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2005
    Posts
    3

    Unanswered: DB2 7.2.8 need statistics/benchmark

    Hi,

    I have a UDB DB2 7.2.8 on a Xeon 2.4 GHz/3G ram MS Win 2003 and i try to do mass insert from a java client using jdbc. Each INSERT is about 60kb.

    What is the number of INSERT can i expect to have with that kind of configuration? I run the wizard to configure the db to turn it to mass insert.

    Now, i have about 100 insert/sec when i commit each 1000 INSERT.

    In fact, i have to INSERT about 100.000 rows in less than 10 min.

    What can i do to increase the number of insert ?

    Thanks

    JMi

  2. #2
    Join Date
    Mar 2004
    Posts
    448
    This is what I recommend

    1. Turn append on for table.

    alter table <table_name> append on.

    2. If your table is created with not logged

    then turn it on

    alter table <table_name> activate not logged initially.

    Please make a backup of the table after mass insert.

    3. If possible take lock at the table level

    alter table <table_name> locktype table.

    drop any indexes and rebuilt after the mass insert.

    If possible use load utillity.

    Parameter tuning also needs to be tuned.

    regards

    Mujeeb

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    This developerworks article should help

    http://www-128.ibm.com/developerwork...m-0403wilkins/
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    Feb 2005
    Posts
    3
    Finally found a solution.

    I put the stored procedure to the garbage and i used PreparedStatement, it works quicker now.

    Now, i have 375 row/sec. (Windows 2003, Xeon bi-pro 3 GHz and 3G of ram), row of 70 bytes.

    JMi

Posting Permissions

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