Software Configuration, Active Database | Intel AS/400 RISC Server

16.3 9406-MMA System Hardware Information

16.3.1Small system Hardware Configuration 9406-MMA 7051 4 way - 32 GB Mainstore DASD / 30 70GB 15K rpm arms,

6 DASD in CEC Mirrored

24 DASD in a #5786 EXP24 Disk Drawer attached with a 571F IOA RAID5 Protected

Software Configuration

100,000 spool files (100,000 completed jobs with 1 spool file per job) 500 jobs in job queues (inactive)

600 active jobs in system during Mainstore dump

1000 user profiles, 1000 libraries

Active Database: 2 libraries with 500 physical files and 20 logical files

16.3.2Large system Hardware Configurations 9406-MMA 7056 8 way - 96 GB Mainstore DASD / 432 70GB 15K rpm arms,

3 ASP's defined, 108 RAID5 DASD in ASP1, 288 RAID5 DASD in ASP2, 36 DASD no protection in ASP3 - Mainstore dump set to ASP 2

y This system was tested with database files unrelated to this test covering 30% of the DASD space available, this database load causes a long directory recovery.

9406-MMA 7061 16 way - 512 GB Mainstore DASD / 1000 70GB 15K rpm arms,

3 ASP's defined, 196 Nonconfigured DASD, 120 RAID5 DASD in ASP1, 612 RAID5 DASD in ASP2, 72 DASD no protection in ASP3 - Mainstore dump set to ASP 2

yThis system was tested with database files unrelated to this test covering 30% of the DASD space available, this database load causes a long directory recovery.

Software Configuration

400,000 spool files (400,000 completed jobs with 1 spool files each) 1000 jobs waiting on job queues (inactive)

11000 active jobs in system during mainstore dump

200 remote printers, 6000 user profiles, 6000 libraries

Active Database:

y25 libraries with 2600 physical files and 452 logical files

y2 libraries with 10,000 physical files and 200 logical files

NOTE:

yPhysical files are explicitly journaled

yLogical files are journaled using SMAPP set to *MIN

yCommitment Control used on 20% of the files

IBM i 6.1 Performance Capabilities Reference - January/April/October 2008
© Copyright IBM Corp. 2008	Chapter 16 IPL Performance	274

Image 274

Intel AS/400 RISC Server, 170 Servers 16.3 9406-MMA System Hardware Information, Software Configuration, Active Database

Contents

January/April/October Toolcat Mkttools GET AS4ADV36 Package Table of Contents 117 Performance Observations and Tips107 System Application Server Instance 119 158 10.2 DB2 for i5/OS access with Odbc 155157 11.1 199 Supported Backup Device Rates 243196 200 IPL Performance 284 17.7 File Level Backup Performance 29219.6 User Pool Faulting Guidelines 310 19.7 285 335 Switchable IASP’s 327 Geographic Mirroring 329334 What the Estimator is Not 335 Special Notices Disclaimer Notice Ipds Purpose of this Document Introduction Page ISeries and AS/400 Risc Server Model Performance Behavior Interactive Indicators and MetricsOverview Disclaimer and Remaining Sections 3 V5R3 Server Model Behavior V4R5 V5R2 4 V5R2 and V5R1Page 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 V5R1 Non-Domino Processing Domino-Complementary ProcessingInteractive Processing Logical Partitioning on a Dedicated Server Running Linux on a Dedicated ServerPage Effect of Dasd Type on Batch Batch PerformanceEffect of CPU Speed on Batch Batch Workload Description Job Priority Tuning Parameters for BatchExpert Cache Dynamic Priority SchedulingPage New for i5/OS V6R1 DB2 for i5/OS PerformanceI5/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 SQE Query Coverage I5/OS V5R3 HighlightsCommon table expressions Deletes Derived tables Like/Substring predicates DB2 Multisystem LOB columns I5/OS V5R3 SQE Performance Enhancements Partitioned Table Support Materialized Query Table Support Fast Delete Support V5R2 Highlights Introduction of the SQL Query EngineSQE Optimizer SQE Query Engine SQE Database Statistics Statistic Usage Example SQE for V5R2 Summary IndexingEncoded Vector Indices EVIs Decision Support Queries DB2 Symmetric Multiprocessing feature IntroductionDB2 for i5/OS Memory Sharing Considerations SMP Performance Summary Journaling Journaling and Commitment ControlRemote 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 Description of Function Reuse Deleted Record SpaceComparison to Normal Inserts Performance References for DB2 Copyright IBM Corp Communications Performance System i Ethernet Solutions CCIN3 Hardware Communication Performance Test EnvironmentSoftware Dasd Performance Communication and Storage observationsLarge 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 Performance1167 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 PerformancePerformance Observations and Tips 10.9 15.4 18.7 88.8Page APPC, ICF, CPI-C, and Anynet Page Test Type Hprip Link Hprip Link Speed AnyNet HPR and Enterprise extender considerationsSpeed = 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 ConfigurationPHP 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 ServerWhat’s new in V6R1? Sho Using ‘threadUsed=false custom property toolbox Jdbc Tuning changes in V6R1Using direct map native Jdbc Use of unix sockets toolbox JdbcPage 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 WebFaced applications, one simple, one IBM WebFacingModerate, and one complex. See .4, for Many 5250 applications have been implemented Version 5.0 of WebfacingMore 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 ViewerCache 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 What’s new with V5R4 and Hats WebSphere Host Access Transformation Services HatsHats Customization Hats Customization CPW/User System Application Server Instance IBM Systems Workload Estimator for HatsPage WebSphere Portal WebSphere Commerce Connect for iSeries WebSphere Commerce Payments Performance Tips and Techniques Connect for iSeries Connector Types Performance Observations/TipsPage Introduction Java PerformanceWhat’s new in V6R1 IBM Technology for Java 32-bit and 64-bit Native Code Garbage Collection Classic VM 64-bit JIT CompilerPage 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 SolutionsIBM 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 PerformanceEncryption 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/ExplanationsPage Jdbc Performance Tuning Tips 10.1 DB2 for i5/OS access with JdbcDB2 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 Collaboration Edition and Domino Edition offeringsDomino 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 iSeriesPerformance 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 RunsLinux 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 Computational Performance -- Java Number Processors PartitionWeb Serving Performance Gcc and High Optimization gcc compiler option -O3 TCP/IP Function Megabit Ethernet LAN Virtual LANNetwork 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 PerformancePage 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.1 571B RAID5 vs RAID6 10 15K 35GB Dasd 14.1.3 571B14.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.1Page 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 PerformanceUse Optimum Block Size Useoptblk Data Compaction Compact User Mix WorkloadsDatabase File related Workloads User Mix 3GB contains 12,300 objects Comparing Performance Data Medium & High Performing Backup Devices Lower Performing Backup DevicesUltra 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 MarchIV5R4M5 July August IPL Performance Considerations IPL PerformanceIPL Test Description 16.3 9406-MMA System Hardware Information Software ConfigurationActive Database 16.5 9406-MMA IPL Performance Measurements Abnormal 1 iV5R4M5 Normal IPL Power-On Cold Start16.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 Configuration16.7.2 5XX Large system Hardware Configuration Database 16.9 5XX IPL Performance Measurements Abnormal 1 Normal IPL Power-On Cold Start16.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 V5R4 iSCSI Host Bus Adapter iSCSI HBA Integrated BladeCenter and System x PerformanceIntegrated xSeries Adapter IXA Integrated xSeries Servers IXS Effects of Windows and Linux loads on the host system17.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 LparV5R3 Information General Tips Considerations V5R1 Additions Lpar Performance Considerations Performance on a 12-way systemPage Lpar Throughput Increase Lpar Measurements 5920 26 % Over a Standalone 12-way5700 21 % TPC-C Commercial Performance Miscellaneous Performance InformationSAP 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 Setobjacc Set Object Access User Pool Faulting GuidelinesLarge 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 ThreadsGeneral Performance Tips and Techniques Coming Change Problem Solution In-lining General Performance Guidelines -- Effects of CompilationOptimization 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 FeatureHMT 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 ConsiderationsSwitchable IASP’s Workload Description Hardware Configuration Workload ConfigurationSystem 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 MirroringGeographic Mirroring Measurements Active State Geographic Mirroring Tips IBM Systems Workload Estimator Merging PM for System i data into the Estimator Estimator AccessWhat the Estimator is Not Page Appendix A. CPW and CIW Descriptions Commercial Processing Workload CPW CPW Application Description Compute Intensive Workload CIW Page Page How Collection Services works Performance Data Collection ServicesStarting Collection Services Batch Modeling Tool Bchmdl Page Page CPW values for the IBM Power Systems IBM i operating system V6R1 Additions October V6R1 Additions August CPW values for the IBM Power 595 IBM i operating systemV6R1 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 technologyIBM 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, JulyIBM ~ i5 Servers Express CPU 750 V5R2 Additions February, May, JulyISeries Model 8xx Servers 540 Models share L2 cache between 2 processors Model 810 and 825 iSeries for Domino FebruaryV5R2 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 Servers10.3 V5R1 Dedicated Server for Domino Table C.10.3 .1 Dedicated Servers for Domino CPW Values and Interactive Features for CUoD Models Capacity Upgrade on-demand ModelsActive Stand-by 840-2352 840-2353 840-2354 Table C.10.4.1.1 V5R1 Capacity Upgrade on-demand Models 16500 11.1 AS/400e Model 8xx Servers 11 V4R5 AdditionsTable C.11.1 Model 8xx Servers All new Condor models Table C.11.2.1 Model 2xx Servers Dedicated Server for DominoTable C.11.3.1 Dedicated Server for Domino 12.1 AS/400e Model 7xx Servers SB Models12 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 DominoPrevious Model 170 Servers Table C.12.2.2 Dedicated Server for Domino 15 AS/400 Advanced Servers 13 AS/400e Model Sxx Servers14 AS/400e Custom 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 SB1Table C.15.2 AS/400 Advanced Servers V3R7 Table C.17.1 AS/400 Risc Systems 17 AS/400 Models 4xx, 5xx and 6xx SystemsTable 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.7 AS/400 Advanced Systems Cisc Table C.18.6 AS/400 Cisc Model 9406 SystemsTable C.18.8 AS/400 Advanced Servers Cisc