Version 5.2
|
|
Version 5.2
|
In a partitioned database, large amounts of data are divided across many partitions. Partitioning keys are used to determine the particular database partition where each portion of the data resides. Data must pass through a splitting phase before it can be loaded at the correct database partition. This split and load process is accomplished by the Autoloader utility.
The Autoloader utility has been improved for users of DB2 Extended Enterprise Edition on AIX, and is now available for users of DB2 Extended Enterprise Edition on Windows NT and Solaris. operating systems
The Autoloader utility uses a hashing algorithm to partition the data into as many output sockets as there are database partitions in the nodegroup in which the table was defined. It then loads these output sockets concurrently across the set of database partitions in the nodegroup. A key feature of the Autoloader utility is that it uses sockets for all data transfer required in the split and load process. It also allows the use of multiple database partitions for the splitting phase, thereby improving performance significantly. See the Administration Guide for details.