Intel 170 Servers, 7xx Servers, AS/400 RISC Server

Table of Contents

4.14 Performance References for DB2 ................................................. 61

4.13 Reuse Deleted Record Space ..................................................... 59

4.12 Variable Length Fields .......................................................... 58

4.11 Triggers ..................................................................... 57

4.10 Referential Integrity ............................................................ 56

4.9 DB2 Multisystem for i5/OS ....................................................... 53

4.8 Journaling and Commitment Control ................................................ 53

4.7 DB2 for i5/OS Memory Sharing Considerations ....................................... 52

4.6 DB2 Symmetric Multiprocessing feature ............................................. 51

4.5 Indexing ...................................................................... 49

4.4 V5R2 Highlights - Introduction of the SQL Query Engine ............................... 47

Partitioned Table Support ........................................................ 45

i5/OS V5R3 SQE Query Coverage .................................................. 45

4.3 i5/OS V5R3 Highlights ........................................................... 44

i5/OS V5R4 SQE Query Coverage .................................................. 44

4.2 DB2 i5/OS V5R4 Highlights ...................................................... 41

i5/OS V6R1 SQE Query Coverage .................................................. 41

4.1 New for i5/OS V6R1 ............................................................. 41Chapter 4. DB2 for i5/OS Performance ............................................... 39

3.3 Tuning Parameters for Batch ...................................................... 38

3.2 Effect of DASD Type on Batch .................................................... 38

3.1 Effect of CPU Speed on Batch ..................................................... 38Chapter 3. Batch Performance ...................................................... 34

2.13.2 V5R1 DSD Performance Behavior ............................................ 34

2.13.1 V5R2 iSeries for Domino & DSD Performance Behavior updates .................... 34

2.13 iSeries for Domino and Dedicated Server for Domino Performance Behavior ............. 33

2.12 Upgrade Considerations for Interactive Capacity ..................................... 31

2.11 Migration from Traditional Models ................................................ 28

2.10 Managing Interactive Capacity ................................................... 25

2.9 Server Dynamic Tuning (SDT) .................................................... 24

2.8 Interactive Utilization ........................................................... 23

2.7 Additional Server Considerations .................................................. 23

2.6 Performance Highlights of Custom Server Models ..................................... 22

2.5 Performance Highlights of Model 170 Servers ........................................ 21

2.4 Performance Highlights of Model 7xx Servers ........................................ 19

2.3 Server Model Differences ........................................................ 17

2.2.3 Existing Older Models ....................................................... 17

2.2.2 Choosing Between Similarly Rated Systems ...................................... 16

2.2.1 In V4R5 - V5R2 ............................................................ 16

2.2 Server Model Behavior .......................................................... 16

2.1.4 V5R2 and V5R1 ........................................................... 15

2.1.3 V5R3 .................................................................... 15

2.1.2 Disclaimer and Remaining Sections ............................................ 14

2.1.1 Interactive Indicators and Metrics ............................................. 14

2.1 Overview ..................................................................... 14Chapter 2. iSeries and AS/400 RISC Server Model Performance Behavior ................. 13Chapter 1. Introduction ............................................................ 12Purpose of this Document ........................................................... 10Special Notices ....................................................................

IBM i 6.1 Performance Capabilities Reference - January/April/October 2008