Problem with ARSLOAD

[plb3945]

Pankaj,

We have a really big problem with our CMOD because for our system it takes 5 hours to load 5 megabytes. For your system only few seconds to load 2 gigabytes.
Thanks for your reply
Philippe

[pankaj.puranik]

5 hrs for a 5 MB file????
That's too much!!!

Not sure if it is because of the underlaying technology (hardware, etc) that's making it slower.

[Justin Derrick]

Performance problems can have MANY sources.

First, check to see if there are performance-related fixes in newer versions of CMOD.  (This depends on which version you're at today.)
Second, check to see that there aren't any CPU limitations (other processes using all your cycles).
Third, check for memory utilization for the database.  Earlier versions of DB2 had very low default values for DBHEAP, etc.

Also, in French, a 'byte' is an 'octet'.  So a Megabyte becomes a Megaoctet, or "Mo".  Ko = Kilo-octet, Go = Gigaoctet, etc.  Hope that helps!

-JD.

[pankaj.puranik]

Oh I see :)
Thanks.