January/April/October
 Toolcat Mkttools GET AS4ADV36 Package
 Table of Contents
 107
Performance Observations and Tips
117
System Application Server Instance 119
 157
10.2 DB2 for i5/OS access with Odbc 155
158
11.1
 196
Supported Backup Device Rates 243
199
200
 IPL Performance
 19.6 User Pool Faulting Guidelines 310 19.7
17.7 File Level Backup Performance 292
284
285
 334
Switchable IASP’s 327 Geographic Mirroring 329
335
What the Estimator is Not 335
 Disclaimer Notice
Special Notices
 Ipds
 Purpose of this Document
 Introduction
Page
 ISeries and AS/400 Risc Server Model Performance Behavior
Interactive Indicators and Metrics
Overview
 3 V5R3
Disclaimer and Remaining Sections
 4 V5R2 and V5R1
Server Model Behavior V4R5 V5R2
Page
 100
 Server Model Differences
 Custom Server Model
 Performance Highlights of Model 7xx Servers
Model 7xx and 9/98 Model
 Performance Highlights of Model 170 Servers
 Additional Server Considerations
Performance Highlights of Custom Server Models
 Example
Interactive Utilization
 Server Dynamic Tuning SDT
Page
 Affects of Server Dynamic Tuning
 Managing Interactive Capacity
Interactive/Server characteristics in the real world
 Is Interactive really Interactive?
Page
 Migration from Traditional Models
 Number of interactive transactions per hour
Interval end time hour and minute
 Upgrade Considerations for Interactive Capacity
 13.2 V5R1 DSD Performance Behavior
 V5R1 Non-Domino Processing
Domino-Complementary Processing
Interactive Processing
 Running Linux on a Dedicated Server
Logical Partitioning on a Dedicated Server
Page
 Effect of CPU Speed on Batch
Batch Performance
Effect of Dasd Type on Batch
Batch Workload Description
 Expert Cache
Tuning Parameters for Batch
Job Priority
Dynamic Priority Scheduling
Page
 New for i5/OS V6R1
DB2 for i5/OS Performance
I5/OS V6R1 SQE Query Coverage
 Query Attribute POWER5 Processor POWER6 Processor
 Records Inserted/Selected
DB2 i5/OS V5R4 Highlights
 I5/OS V5R4 SQE Query Coverage
 I5/OS V5R3 SQE Query Coverage
I5/OS V5R3 Highlights
Common table expressions Deletes Derived tables
 I5/OS V5R3 SQE Performance Enhancements
Like/Substring predicates DB2 Multisystem LOB columns
 Partitioned Table Support
 Materialized Query Table Support Fast Delete Support
V5R2 Highlights Introduction of the SQL Query Engine
SQE Optimizer
 SQE Database Statistics
SQE Query Engine
 Statistic Usage Example
 SQE for V5R2 Summary
Indexing
Encoded Vector Indices EVIs
 DB2 for i5/OS Memory Sharing Considerations
DB2 Symmetric Multiprocessing feature Introduction
Decision Support Queries
SMP Performance Summary
 Journaling
Journaling and Commitment Control
Remote Journal Function
 Smapp
System-Managed Access Path Protection Smapp
 Commitment Control
DB2 Multisystem for i5/OS
 Copyright IBM Corp
 Triggers
Referential Integrity
 Description
Variable Length Fields
 Performance Expectations
 Description of Function
Reuse Deleted Record Space
Comparison to Normal Inserts
 Performance References for DB2
 Copyright IBM Corp
 Communications Performance
 CCIN3
System i Ethernet Solutions
 Hardware
Communication Performance Test Environment
Software
 Dasd Performance
Communication and Storage observations
Large data transfer FTP
 Streaming Performance
TCP/IP non-secure performance
 TCP/IP Secure Performance
RR & Acrr Performance
 1167 565.4 530.0 479.6 462.1 202.2
SSL Performance
249.7 53.4 48.0 31.3 27.4
478.4 55.7 53.3 36.9 31.9
 VPN Performance
SSL Relative Performance
 Performance Observations and Tips
VPN Relative Performance
27.5
10.9 15.4 18.7 88.8
Page
 APPC, ICF, CPI-C, and Anynet
Page
 Test Type Hprip Link Hprip Link Speed AnyNet
HPR and Enterprise extender considerations
Speed = 10Mbps = 100Mbps
 For network information select Networking
Additional Information
 Web Server and WebSphere Performance
 Http Server powered by Apache
 Relative Performance Metrics
 Http Server powered by Apache for i5/OS
 V5R4 Relative Capacity for CGI
 Http Server powered by Apache for i5/OS
Page
Page
Page
Page
 PHP Zend Core for
System Configuration
Zend Core for
Database and Workload Description
 OS / DB
Database Access
 Database Persistent versus Non-Persistent Connections
 Zend Platform
Database Isolation Levels
 PHP System Sizing
 What’s new in V6R1?
WebSphere Application Server
Thi
Sho
 Using direct map native Jdbc
Tuning changes in V6R1
Using ‘threadUsed=false custom property toolbox Jdbc
Use of unix sockets toolbox Jdbc
Page
 Topology of the Trade Application
Page
 WebSphere Application Server
 Trade Capacity Results
Trade3 Measurement Results
 Trade 6 Primitives
Trade Scalability Results
 Description of Trade primitives in Figure
 WebSphere Trade 3 Primitives
 Accelerator for System
 Trade Jdbc Response Time 1 User Time seconds
Page
 WebSphere Application Server V51 Express
 WebFaced applications, one simple, one
IBM WebFacing
Moderate, and one complex. See .4, for
 More in line with the other two machines
Version 5.0 of Webfacing
Many 5250 applications have been implemented
With best performance techniques, such as
 Display File Record I/O Processing
Tuning the Record Definition Cache
 Cache Size Effect
Cache Management Definition Cache Content Viewer
Definitions would be retained in the cache with few cache
Misses for not commonly used records
 Cache Viewer Button operations
 Cache Management Record Definition Loader
Button Operation
 Compression
Record Definition Loader Button operations Operation
 Webfacing Compression
Enabling Compression in IBM Http Server powered by Apache
 Additional Resources
 PartnerWorld for Developers Webfacing website
 What’s new with V5R4 and Hats
WebSphere Host Access Transformation Services Hats
Hats Customization
 Hats Customization CPW/User
 IBM Systems Workload Estimator for Hats
System Application Server Instance
Page
 WebSphere Commerce
WebSphere Portal
 WebSphere Commerce Payments Performance Tips and Techniques
Connect for iSeries
 Performance Observations/Tips
Connect for iSeries Connector Types
Page
 Introduction
Java Performance
What’s new in V6R1
 IBM Technology for Java 32-bit and 64-bit
 Garbage Collection
Native Code
 JIT Compiler
Classic VM 64-bit
Page
 Garbage Collection
 Bytecode Verification
 Functional Considerations
Determining Which JVM to Use
 Performance Considerations
 General Guidelines
Capacity Planning
 Java Performance Tips and Techniques
 Classic VM-specific Tips
I5/OS Specific Java Tips and Techniques
 Java Language Performance Tips
Consider the special property os400.jit.mmi.threshold
 Minimize synchronized methods
 Java i5/OS Database Access Tips
Instead, the above procedure should be written as
 Pool Database Connections
 Resources
 IBM Software Solutions
System i Cryptographic Solutions
IBM Hardware Solutions
Cryptography Performance
 CSP API Sets
Cryptography Performance Test Environment
 Measurement Results
Software Cryptographic API Performance
 Bytes/Second
Hardware Cryptographic API Performance
 Encryption Threads
Cipher Encrypt Performance
4764
Transactions/second Bytes/second
 CCA CSP
Cryptography Observations, Tips and Recommendations
 Supported number of 4764 Cryptographic Coprocessors
 ISeries NetServer File Serving Performance
ISeries NetServer File Serving Performance
 Conclusion/Explanations
Response Time
Page
 Jdbc Performance Tuning Tips
10.1 DB2 for i5/OS access with Jdbc
DB2 for i5/OS Jdbc and Odbc Performance
 References for Jdbc 10.2 DB2 for i5/OS access with Odbc
 Odbc Performance Settings
Page
 Microsoft Odbc webpage
References for Odbc
 Domino on
 Mail and Calendaring Users MCU
Domino Workload Descriptions
 Domino
Domino Web Access formerly known as iNotes Web Access
 Domino Domain Monitor
 Additional memory was added for this test
Domino Web Access client improvements with Domino
 Response Time and Megahertz relationship
 Collaboration Edition
Collaboration Edition and Domino Edition offerings
Domino Edition
 Performance Tips / Techniques
Page
Page
 Domino Subsystem Tuning
Domino Web Access
 Main Storage Options
Performance Monitoring Statistics
 Minimize
 Thousands
 V5R3 Main Storage Options Response Times
Sizing Domino on System
 Performance Data Collection Tools
Lpar and Partial Processor Considerations
 System i NotesBench Audits and Benchmarks
 Performance Improvements for WebSphere MQ V5.3 CSD6
WebSphere MQ for iSeries
Queue Manager Start Following an Abnormal End
Checkpoint Following a Journal Receiver Roll-over
 Conclusions, Recommendations and Tips
Test Description and Results
 Other Sources of Information
 Linux on iSeries Performance
Basic Requirements -- Where Linux Runs
Summary
Key Ideas
 Linux on iSeries Architecture
Linux on iSeries Technical Overview
 Linux on iSeries Run-time Support
 Basic Configuration and Performance Questions
 Computational Performance -- C-based code
General Performance Information and Results
 Computational Performance -- Java
Number Processors Partition
Web Serving Performance
 Network Operations
TCP/IP Function Megabit Ethernet LAN Virtual LAN
Gcc and High Optimization gcc compiler option -O3
Gcc Compiler, Version
 Virtual Disk
Value of Virtual LAN and Virtual Disk
 13.7 DB2 UDB for Linux on iSeries
 Top Tips for Linux on iSeries Performance
Linux on iSeries and IBM eServer Workload Estimator
Page
Page
Page
 Internal Native Attachment
Dasd Performance
 Devices & Controllers
Direct Attach Native Hardware Characteristics
 Intensive Workload Performance Comparison
14.1.2 iV5R2 Direct Attach Dasd
 Intensive Workload
 14.1.3.1 571B RAID5 vs RAID6 10 15K 35GB Dasd
14.1.3 571B
14.1.3.2 571B IOP vs Iopless 10 15K 35GB Dasd
 Dasd
14.1.4 571B, 5709, 573D, 5703, 2780 IOA Comparison Chart
 14.1.4.4
 14.1.5.1
 14.1.6.2
Comparing 571E/574F and 571F/575B IOP and IOPLess
 1000 2000 3000 4000 Ops/Sec
 14.1.7.4
 14.1.8.1
Performance Limits on the 571F/575B
Page
 14.1.9.2 14.1.9.1
 Direct Attach 571E/574F and 571F/575B Observations
 100 200 300 400 500 600 Ops/Sec
New in iV5R4M5 14.2.1 9406-MMA CEC vs 9406-570 CEC Dasd
 RAID Hot Spare
 14.2.3 12X Loop Testing
 Non Encrypted ASP vs Encrypted ASP
New in iV6R1M0 Encrypted ASP
 Non Encrypted ASP vs Encrypted ASP
 100 350 600 850 1100 1350 1600 1850
14.3.2 57B8/57B7 IOA
 POWER6 520 57B8/57B7 6 RAID5 Dasd in CEC
 14.3.3 572A IOA
Page
 SAN Storage Area Network External
 14.5 iV6R1M0 -- Vios and IVM Considerations
 Generic Concepts
General Vios Considerations
 Generic Configuration Concepts
Page
Page
 Chdev -dev hdisk03 -attr pv=yes will assign a Pvid to hdisk3
Page
 Vios and JS12 Express and JS22 Express Considerations
 001 10000 20000 30000 40000 50000 60000
 Vios
 CPU Vios
 Average Dasd Response Time Seconds
 BladeCenter S and JS12 Express
Page
Page
 System Workload Response Time Seconds
 IBM i operating system 5.4 Virtual Scsi Performance
Page
 Introduction
 Virtual Scsi Performance Examples
 Virtual Scsi Bandwidth-Multiple Network Storage Spaces
Native vs. Virtual Performance
 Nwsd Read Scaling
 Virtual Scsi Bandwidth-Disk Scaling
 Sizing
Sizing when using Dedicated Processors
 CPU milliseconds to process virtual Scsi I/O transaction
 Sizing when using Micro-Partitioning
 Disk 1GB Sequential Read
Sizing memory
 AIX Virtual IO Client Performance Guide
 Supported Backup Device Rates
Save/Restore Performance
 Use Optimum Block Size Useoptblk
Save Command Parameters that Affect Performance
Data Compression Dtacpr
Data Compaction Compact
 Database File related Workloads
Workloads
User Mix
User Mix 3GB contains 12,300 objects
 Comparing Performance Data
 Medium & High Performing Backup Devices
Lower Performing Backup Devices
Ultra High Performing Backup Devices
 Use of Multiple Backup Devices
 Parallel and Concurrent Library Measurements
 Large File Concurrent
Save and Restore Rates
 Large File Parallel
Save and Restore Rates
 User Mix Concurrent
User Mix Concurrent Runs
 Number of Processors Affect Performance
450 440 430 420
 100
Dasd and Backup Devices Sharing a Tower
 Virtual Tape
200
 Data To Save Hours
 Parallel Virtual Tapes
500
 Concurrent Virtual Tapes
1500 1000
 Large File Virtual Tape Scaling Save Write to Virtual tape
Save and Restore Scaling using a Virtual Tape Drive
 Large File Save
 User Mix Saves
 PCI-X  In a 5094/5294 tower use slot C08 or C09
High-End Tape Placement on System
 700
 250
 SLR60
15.19 5XX Tape Device Rates
 Measurements in GB/HR all 8 Dasd in the system ASP
 Source File 1GB
 15.21 5XX DVD RAM and Optical Library
 High
Software Compression
 ASP
15.23 9406-MMA DVD RAM
 1GB
15.24 9406-MMA 576B IOPLess IOA
 IV5R4M5 July
What’s New and Tips on Performance What’s New IV6R1M0 March
IV5R4 January
August
 IPL Performance Considerations
IPL Performance
IPL Test Description
 16.3 9406-MMA System Hardware Information
Software Configuration
Active Database
 16.4 9406-MMA IPL Performance Measurements Normal
1 iV5R4M5 Normal IPL Power-On Cold Start
16.5 9406-MMA IPL Performance Measurements Abnormal
1 iV5R4M5 Abnormal IPL Partition MSD
 MSD Affects on IPL Performance Measurements
 16.7.2 5XX Large system Hardware Configuration
16.7.1 5XX Small system Hardware Configuration
16.7 5XX System Hardware Information
Database
 16.8 5XX IPL Performance Measurements Normal
1 Normal IPL Power-On Cold Start
16.9 5XX IPL Performance Measurements Abnormal
Measurement units are in hours, minutes and seconds
 IPL Tips
16.10 5XX IOP vs IOPLess effects on IPL Performance Normal
 V5R4 iSCSI Host Bus Adapter iSCSI HBA
Integrated BladeCenter and System x Performance
Integrated xSeries Adapter IXA
 Integrated xSeries Servers IXS
Effects of Windows and Linux loads on the host system
17.2.1 IXS/IXA Disk I/O Operations
 ISCSI Disk I/O Operations
Extended Write Operations
 Crtsbsd SBSDQGPL/QFPHIS POOLS1 10000
ISCSI virtual I/O private memory pool
 17.2.5 IXS/IXA IOP Resource
Virtual Ethernet Connections
 ISCSI attached servers
IXS and IXA attached servers
 Machine Pool MBytes Base Pool Qfphis Private Pool Total
Disk I/O CPU Cost
 CPW per 1k Disk Operations
Further notes about IXS/IXA Disk Operations
 ISCSI Target, IXA Capacity Comparison MB per Second
Disk I/O Throughput
 VE Capacity Comparisons
Virtual Ethernet CPU Cost and Capacities
 PP TCP Stream i5/OS to Windows
VE CPW Cost
 Windows CPU Cost
File Level Backup Performance
 Flbu SAV / RST Rates
Additional Sources of Information
 Microsoft Hardware Compatibility Test URL See
 V5R3 Information
Logical Partitioning Lpar
V5R2 Additions
General Tips
 V5R1 Additions
Considerations
 Performance on a 12-way system
Lpar Performance Considerations
Page
 Lpar Throughput Increase
 Lpar Measurements
 5920 26 %
Over a Standalone 12-way
5700 21 %
 TPC-C Commercial Performance
Miscellaneous Performance Information
SAP Performance Information
 VolanoMark
SPECjbb2000
 Dynamic Priority Scheduling
Delay Cost Terminology
 Priority Mapping to Delay Cost Curves
 Qdynptyscd = ‘1’ on Qdynptyscd = ‘0’
Performance Testing Results
 Main Storage Sizing Guidelines
Memory Tuning Using the Qpfradj System Value
 Additional Memory Tuning Techniques
 Setobjacc Set Object Access
User Pool Faulting Guidelines
Large Memory Systems
 Batch
Interactive
 19.7 AS/400 NetFinity Capacity Planning
 AS/400 NetFinity Software Inventory Performance
 Conclusions/Recommendations for NetFinity
 General Performance Tips and Techniques
Adjusting Your Performance Tuning for Threads
History
Coming Change
 Solution
Problem
 In-lining
General Performance Guidelines -- Effects of Compilation
Optimization Levels
 Theory -- and Practice
 Typical Storage Costs
System Level Considerations
 Brief Example
Order1 Orderj Ordert OrderN
 Short but Important Tip about Data Base
Which is more important?
 Final Thought About Memory and Competitiveness
 HMT Described
Hardware Multi-threading HMT
 HMT and SMT Compared and Contrasted
HMT Feature SMT Feature
Some key similarities and differences are
Models With/Without HMT
 POWER6 520 Memory Considerations
 Aligning Floating Point Data on Power6
Page
 Switchable IASP’s
High Availability Switchable Resources Considerations
High Availability Performance
Workload Description
 System Configuration
Workload Configuration
Hardware Configuration
Cabling Map
 Geographic Mirroring
Switchover Tips
 Workload Description
 Hardware Configuration Cabling Map
Large System Configuration
 Geographic Mirroring Measurements
Switchable Towers using Geographic Mirroring
Synchronization on an idle system
Active State
 Geographic Mirroring Tips
 IBM Systems Workload Estimator
 Merging PM for System i data into the Estimator
Estimator Access
What the Estimator is Not
Page
 Commercial Processing Workload CPW
Appendix A. CPW and CIW Descriptions
 CPW Application Description
 Compute Intensive Workload CIW
Page
Page
 How Collection Services works
Performance Data Collection Services
Starting Collection Services
 Batch Modeling Tool Bchmdl
Page
Page
 V6R1 Additions October
CPW values for the IBM Power Systems IBM i operating system
 V6R1 Additions August
CPW values for the IBM Power 595 IBM i operating system
V6R1 Additions April
 V6R1 Additions January
Table C.3.1. CPW values for Power System Models
 IBM System i using the POWER5 processor technology
IBM System i using the POWER6 processor technology
V5R4 Additions July
V5R4 Additions January/May/August 2006 and January/April
 Model Edition Accelerator
 IBM ~ i5 Servers
V5R3 Additions May, July, August, October 2004, July
Value
Express
 CPU
 ISeries Model 8xx Servers
V5R2 Additions February, May, July
750
540
 V5R2 Additions
Model 810 and 825 iSeries for Domino February
Models share L2 cache between 2 processors
Standard Models 8xx Servers
 Table C.9.2.1 Standard Models 8xx Servers
10 V5R1 Additions
 Table C.9.1.1 Model 8xx Servers
Model 8xx Servers
 10.3 V5R1 Dedicated Server for Domino
Model 2xx Servers
Table C.10.2.1 Model 2xx Servers
Table C.10.3 .1 Dedicated Servers for Domino
 CPW Values and Interactive Features for CUoD Models
Capacity Upgrade on-demand Models
Active Stand-by 840-2352 840-2353 840-2354
 16500
Table C.10.4.1.1 V5R1 Capacity Upgrade on-demand Models
 11.1 AS/400e Model 8xx Servers
11 V4R5 Additions
Table C.11.1 Model 8xx Servers All new Condor models
 Table C.11.2.1 Model 2xx Servers
Dedicated Server for Domino
Table C.11.3.1 Dedicated Server for Domino
 12 V4R4 Additions
SB Models
12.1 AS/400e Model 7xx Servers
Table C.11.4.1 SB Models
 Table C.12.2.1 Current Model 170 Servers
Model 170 Servers Current 170 Servers
 Previous Model 170 Servers
AS/400e Dedicated Server for Domino
2407 2408 2409 120
Table C.12.2.2 Dedicated Server for Domino
 14 AS/400e Custom Servers
13 AS/400e Model Sxx Servers
15 AS/400 Advanced Servers
Table C.13.1 AS/400e Servers
 Table C.15.1 AS/400 Advanced Servers V4R1 and V4R2
16 AS/400e Custom Application Server Model SB1
Table C.15.2 AS/400 Advanced Servers V3R7
 Table C.16.1 AS/400e Custom Application Server Model SB1
17 AS/400 Models 4xx, 5xx and 6xx Systems
Table C.17.1 AS/400 Risc Systems
Table C.17.2 AS/400e Systems
 18 AS/400 Cisc Model Capacities
 Table C.18.7 AS/400 Advanced Systems Cisc
Table C.18.6 AS/400 Cisc Model 9406 Systems
Table C.18.8 AS/400 Advanced Servers Cisc