Contents
Performance Management ....... 1
Overview ............... 1
Intended Audience ........... 2
System Components ........... 2
Performance Tuning Methodology ...... 4
Performance Recommendations Checklists .... 5
Sterling B2B Integrator: General Recommendations
Checklist .............. 5
IBM Sterling File Gateway: Specific
Recommendations Checklist ........ 9
EBICS Banking Server: Specific
Recommendations ........... 12
Database Management........... 13
Planning .............. 13
Server Sizing ............. 14
Storage and File Systems ......... 14
Database management for Sterling B2B Integrator 16
Oracle Database Configuration and Monitoring 22
IBM DB2 for LUW Configuration and Monitoring 35
Microsoft SQL Server Configuration and
Monitoring ............. 51
Java Virtual Machine ........... 61
Garbage Collection Statistics........ 62
JVM Verbose Garbage Collection ...... 62
IBM JVM Garbage Collection Example .... 62
Introduction to HotSpot JVM Performance and
Tuning ............... 63
Introduction to the IBM JVM Performance and
Tuning Guidelines ........... 78
Monitoring Operations .......... 82
Managing System Logs ......... 82
Auditing .............. 93
Monitoring a Business Process Thread .... 94
Monitoring Messages .......... 96
Reviewing System Information ....... 97
Monitoring Node Status ......... 106
Monitoring Deprecated Resources ..... 109
Soft Stop of Sterling B2B Integrator ..... 110
Hard Stop of Sterling B2B Integrator .... 120
Performance Tuning ........... 120
Performance Tuning Utility........ 120
Manual Performance Tuning ....... 166
Performance Statistics .......... 203
Turning On and Turning Off Performance
Statistics .............. 213
Reporting Performance Statistics ...... 213
Troubleshooting ............ 214
Database Maintenance Check ....... 214
Full Database Issues and Resolution..... 218
Database Connection Issues ....... 222
Database Down Check ......... 224
Tracking JDBC Connections ....... 226
Types of Cache Memory......... 227
Symptoms and Causes of Inefficient Cache
Usage ............... 228
Resolving Inefficient Cache Usage ..... 228
Correcting Dropped Data Problems ..... 229
Correcting Out-Of-Memory Errors ..... 230
Understanding Business Process ...... 230
Symptoms and Causes of Poor Business Process
Execution Time............ 230
Resolving Halted, Halting, Waiting, or
Interrupted Business Processes ...... 232
Slow System: Symptoms, Causes, and
Resolution ............. 234
Performing a Thread Dump ....... 236
Scenario-Based Troubleshooting Tips and
Techniques ............. 239
Performance and Tuning Worksheet ...... 241
workflowLauncher: Running a Business Process
from a Command Line .......... 244
Notices .............. 247
Index ............... 251
© Copyright IBM Corp. 2000, 2015 iii