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
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL