content_image/1000830.jpg content_image/1000829.jpg
Figure 6-1 shows the LOAD rate in MBps versus the number of concurrent zload tasks. The results indicate that LOAD performance increases with the number of parallel zload runs. If enough hardware resources are available, running parallel zload tasks increases LOAD throughput. 

<img src='content_image/1000830.jpg'>

## Load methods comparison scenario 

This set of measurements are taken to demonstrate the performance comparison of the following techniques when loading data in internal format into a single table partition in Db2 for z/OS: 

GLYPH<SM590000> DRDA Fast Load 

GLYPH<SM590000> File transfer to z/OS (by using FTP) followed by local LOAD 

GLYPH<SM590000> Db2 for Linux, UNIX, and Windows Client import utility 

The Db2 for Linux, UNIX, and Windows command import utility inserts data from an external file with a supported file format into a table, hierarchy, view, or nickname. The import command also is available as part of the Db2 for Linux, UNIX, and Windows clients. 

Example 6-4 shows the import syntax that is used during the test scenario. 

<img src='content_image/1000829.jpg'>

The following options in the “modified by” section are necessary for performance: 

GLYPH<SM590000> compound=x : x is a number 1 - 100, inclusive. It uses non-atomic compound SQL to insert the data, and x statements are attempted each time. 

GLYPH<SM590000> commitcount n: Performs a COMMIT after every n  records that are imported. 

