Max rows can be loaded onto DB2 table using load utility

Elixir · Posted: Thu Oct 27, 2011 2:26 am

Hello,

What is the Max rows can be loaded onto DB2 table using load utility?

Pedro · Posted: Thu Oct 27, 2011 3:03 am

I could not find a max value listed in the DB2 Utilities manual. Since DB2 is a high capacity product, I suspect any limit on load utility is quite high.

Likely, the constraint will be from some of the resources required to the load, such as the size of the vsam files, number of partitions, job region size, size of sort files, etc...