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