Problem with ARSLOAD

Previous topic - Next topic

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.
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Webinars:  https://CMOD.Training/
IBM CMOD Professional Services: https://CMOD.cloud

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

pankaj.puranik