## 5.5 RTW workload 

The Relational Transaction Workload (RTW) is a standard workload that is used by the CICS performance team in Hursley to assess changes in performance characteristics for new CICS releases for applications accessing Db2. The Db2 team employed the RTW workload as one of its performance test benchmark workloads to achieve better performance analysis coverage for CICS-Db2 type of workloads. The workload was modified slightly compared to the version the CICS team uses to better reflect the Db2 behavior of the workload. 

The RTW workload includes the following characteristics: 

GLYPH<SM590000> All programs that make up the workload are written in COBOL. 

GLYPH<SM590000> The workload uses 20 (data) tables in segmented table spaces, 11 non-unique indexes, and 16 unique indexes. 

GLYPH<SM590000> It issues on average 200 Db2 calls per transaction. 

GLYPH<SM590000> The transaction mix includes 26% select, 3% insert, 7% update, 3% delete, 6% open cursor, 36% fetch cursor, 6% close cursor operations. 

The following environment configuration is used for the non-data sharing RTW workload: 

GLYPH<SM590000> One z13 LPAR with eight general CPs 

GLYPH<SM590000> Four CICS regions that are running CICS TS V5.1 

GLYPH<SM590000> A non-data sharing Db2 subsystem 

GLYPH<SM590000> z/OS 2.1 

GLYPH<SM590000> DS8870 DASD controller 

GLYPH<SM590000> TPNS on another z13 LPAR with four general CPs to drive the workload 

The following environment was used by the two-way data sharing RTW workload: 

GLYPH<SM590000> Two z13 LPARs with eight general CPs each 

GLYPH<SM590000> Eight CICS regions running CICS TS 5.1 with four regions that are running on each of the LPARs 

GLYPH<SM590000> Two z13 ICF LPARs running CFLEVEL 21 CFCC 

GLYPH<SM590000> Two Db2 subsystems, each running on one of the two LPARs 

GLYPH<SM590000> DS8870 DASD controller 

GLYPH<SM590000> TPNS on another z13 LPAR with four general CPs to drive the workload 

## 5.5.1 Performance measurements for non-data sharing RTW workload 

Five performance measurements that use the RTW workload were conducted during different migration stages, from Db2 11 NFM to Db2 12 at function level V12R1M500. A typical customer might run their Db2 system in any of the following migration phases: 

GLYPH<SM590000> Baseline measurement with Db2 11 NFM 

GLYPH<SM590000> Db2 12 at function level V12R1M100 measurement without rebinding application packages 

GLYPH<SM590000> Db2 12 at function level V12R1M100 measurement after rebinding application packages with APREUSE(ERROR) 

GLYPH<SM590000> Db2 12 at function level V12R1M500 measurement with application packages previously rebound at V12R1M100 with APREUSE(ERROR) 

GLYPH<SM590000> Db2 12 at function level V12R1M500 measurement after rebinding application packages with APREUSE(NONE) 

