Wanted Performance Tips for Updating DB2 Databse on AS/400

[Satish Pamidimarthi]

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
>============================================================<

[Paul Clapham]

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
> >============================================================<