Wanted Performance Tips for Updating DB2 Databse on AS/400


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Wanted Performance Tips for Updating DB2 Databse on AS/400

  1. #1
    Satish Pamidimarthi Guest

    Wanted Performance Tips for Updating DB2 Databse on AS/400


    hi Netizens...!
    Does anyone have Performace Tips for Bulk (2 to 3 Hundred Thousand records)
    updates of a DB2 Database on AS/400 machine...!
    I'm having JDK1.1.7, JDBC 1.0 on the AS/400 machine...! :-(
    bye, n Thx in Advance...!
    Satish Pamidimarthi
    >============================================================<


  2. #2
    Paul Clapham Guest

    Re: Wanted Performance Tips for Updating DB2 Databse on AS/400

    Your Java program is running on the AS/400 where the database is located, I
    assume? So there would be no issues of sending megabytes over a network.
    Here's one tip: if you have a logical file (index) that would be greatly
    altered by the bulk update, try deleting it before you do the update and
    recreate it again after the update finishes. You only have to delete the
    logical file's member (RMVM) and add it back (ADDLFM) afterwards. Or,
    changing its access path maintenance method (CHGLF MAINT(...)) to *REBLD and
    then back to *IMMED or *DLY might work the same way.

    PC2

    Satish Pamidimarthi <java@hamarashehar.com> wrote in message
    news:3a14b26e$1@news.devx.com...
    >
    > hi Netizens...!
    > Does anyone have Performace Tips for Bulk (2 to 3 Hundred Thousand

    records)
    > updates of a DB2 Database on AS/400 machine...!
    > I'm having JDK1.1.7, JDBC 1.0 on the AS/400 machine...! :-(
    > bye, n Thx in Advance...!
    > Satish Pamidimarthi
    > >============================================================<




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center