## 6.1.1 Db2 Fast Load measurements 

This section describes the results of the performance observations when comparing DRDA Fast Load with the local Db2 LOAD utility. 

The test environment for the workload used the following configuration: 

GLYPH<SM590000> z13 z/OS LPAR with 17 dedicated general CPs, 32 GB of memory, and z/OS 2.02. 

GLYPH<SM590000> Linux for System z on z13 LPAR with 10 general CPs with Db2 Connect and Db2 for Linux, UNIX, and Windows 11.1 FP1. 

GLYPH<SM590000> IBM HiperSockets communication between the z/OS and Linux for System z LPARs. 

The scenarios compare the performance of the traditional FTP plus local LOAD process versus loading the data directly from the client by using DRDA Fast Load. 

The test cases consist of loading data from 160 data files into a Db2 table that was created in a table space that is defined with 160 partitions. On the client side, 160 parallel scripts load the data into each partition. 

Example 6-2 show the bash scripts that were used for driving the parallel zload  commands. In this script, the zload12a  file is started to run the zload  command. 

#!/bin/bash let j=1 while [ [ $j -lt 160 ] ] do ( zload12a $j $j.time) >& $j.log & let j=j+1 done 

The contents of the zload12a  file is shown in Example 6-3. 

db2 zload from DB2DRDA.ZLOADB.ITRADE.P000$1 with "zload$1" messages zloadINT.p$1.txt using "TEMPLATE SORTIN DSN DISTRGR.ZLOADI$1.T&TIME. UNIT 3390 SPACE(100,40) CYL VOLUMES(H210BE) DISP(NEW,DELETE,DELETE) BUFNO(20) TEMPLATE SORTOUT DSN DISTRGR.DC1X.ZLOADO$1.T&TIME. UNIT 3390 SPACE(100,40) CYL VOLUMES(H210BD) DISP(NEW,DELETE,DELETE) LOAD DATA INDDN SYSCLIEN WORKDDN(SORTIN,SORTOUT) LOG(NO) NOCOPYPEND FORMAT INTERNAL INDEXDEFER NPI INTO TABLE USRT001.TRADE PART $1 REPLACE PREFORMAT REUSE NUMRECS 11138614 " 

Each file consists of data in internal format to be loaded into each partition. 

## Scalability scenario 

In the scalability scenario, 15, 30, and 60 concurrent LOADs were run to measure the scalability of the DRDA Fast Load. The loads were run from a client machine against different partitions of the same table in Db2 for z/OS. The scenario consisted of loading 15 internal format files into 15 partitions, 30 files into 30 partitions, and 60 files into 60 partitions. The table was empty before the load. 

