Wanted Performance Tips for Updating DB2 Databse on AS/400
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...!
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.
Satish Pamidimarthi <email@example.com> wrote in message
> hi Netizens...!
> Does anyone have Performace Tips for Bulk (2 to 3 Hundred Thousand
> 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
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center