Manuel D’UtilisationTable des matièresContents5Performance Management7Overview7Intended Audience8System Components8Performance Tuning Methodology10Performance Recommendations Checklists11Sterling B2B Integrator: General Recommendations Checklist11IBM Sterling File Gateway: Specific Recommendations Checklist15EBICS Banking Server: Specific Recommendations18Database Management19Planning19Server Sizing20Storage and File Systems20Database management for Sterling B2B Integrator22Dynamically Manage JDBC Pools26Oracle Database Configuration and Monitoring28Oracle init parameter configuration checklist28Rolling Back or Undoing Changes in Oracle Database31Database Storage32Monitoring with the AWR Report34Index and Table Statistics37Enable BLOB Caching38Using Oracle Real Application Clusters (RAC) for High Availability38IBM DB2 for LUW Configuration and Monitoring41Mandatory settings for IBM DB2 registry variables41Recommended settings for IBM DB2 registry variables42Recommended Settings for DBM CFG Parameters44Mandatory settings for DB CFG parameters46Recommended settings for DB CFG parameters46Recommended Settings for DB2 9.748Recommended Settings for DB2 for Linux on System z (5.2.4.0 or later)50Storage Subsystem50Log Configuration53DB2 Monitoring54DB2 Index and Table Statistics57Microsoft SQL Server Configuration and Monitoring57Mandatory settings for Microsoft SQL Server57Recommended instance-specific settings for Microsoft SQL Server58Recommended database-specific settings for Microsoft SQL Server58Microsoft SQL Server Memory with Address Windowing Extensions (AWE)59Row Versioning-Based Isolation Level (READ_COMMITTED_SNAPSHOT) for Microsoft SQL Server59Recommended Settings for Microsoft SQL Server 2008 and 201259Storage Subsystem62Monitoring Microsoft SQL Server Using Microsoft SQL Server Management Studio63Monitoring Microsoft SQL Server Using SQL Server Profiler63Microsoft SQL Dynamic Management Views64Microsoft SQL System Monitor64Microsoft SQL Server Maintenance Plan64Microsoft SQL Server Index, Table Statistics, and Index Rebuilds66Windows Defragmentation66Microsoft SQL Server Tips67Java Virtual Machine67Garbage Collection Statistics68JVM Verbose Garbage Collection68IBM JVM Garbage Collection Example68Introduction to HotSpot JVM Performance and Tuning69HotSpot JVM Heap Memory and Garbage Collection70HotSpot JVM Garbage Collection Tools71HotSpot JVM Startup and Runtime Performance Optimization72HotSpot JVM Default Parameters72Display HotSpot Statistics for HP JVM75Display HotSpot Statistics for Sun JVM75HotSpot JVM Heap Monitoring76HotSpot JVM Thread Monitoring76Performing a Thread Dump77HotSpot Thread Dump Analysis Tools78HotSpot JVM DeadLock Detection78HotSpot JVM Blocked Thread Detection79HotSpot JVM Troubleshooting Tips79Introduction to the IBM® JVM Performance and Tuning Guidelines84Before You Begin Tuning Your IBM® JVM84IBM® JVM Default Parameters for Sterling B2B Integrator84IBM® JVM Troubleshooting Tips85Monitoring Operations88Managing System Logs88Auditing99Monitoring a Business Process Thread100Monitoring Messages102Reviewing System Information103Monitoring Node Status112Monitoring Deprecated Resources115Soft Stop of Sterling B2B Integrator116Completing a Soft Stop of Sterling B2B Integrator from the System Troubleshooter117Completing a Soft Stop of Sterling B2B Integrator from the Command Line121Soft Stop opscmd Commands123Graceful Adapter Shutdown124Hard Stop of Sterling B2B Integrator126Performance Tuning126Performance Tuning Utility126View and Restore Performance Configuration Settings127Edit Performance Configuration Settings129Manual Performance Tuning172Tuning Your ASI Environment172Scheduling Policy178Queues in an Application Server Independent Environment178Monitoring Queues using Queue Watcher183Compress Cache Contents186Set the Document Body Serialization Threshold Property187Allocate JNDI Contexts188Changing Persistence Levels188Changing System Logging191Enable Trusted Domains for Schemas191Enable the Console Listener192Enabling the JMX Event Listener192Enhance EDI Performance193Customizing Property Files194Managing System Recovery195Changing the Soft Stop Time Limit196Changing Advanced File Transfer Settings197Optimize System Performance for Sterling e-Invoicing199The Order of Segments in Maps and Data200Purge Performance Recommendations201Optimizing and Controlling the System Threads202WebSphere MQ Parameters208Placement of WebSphere MQ Log and Data Files209Performance Statistics209Turning On and Turning Off Performance Statistics219Turning On Performance Statistics219Turning Off Performance Statistics219Reporting Performance Statistics219Creating Performance Statistics220Deleting a Performance Statistics Report220Troubleshooting220Database Maintenance Check220Full Database Issues and Resolution224Database Connection Issues228Database Down Check230Tracking JDBC Connections232Types of Cache Memory233Symptoms and Causes of Inefficient Cache Usage234Resolving Inefficient Cache Usage234Correcting Dropped Data Problems235Correcting Out-Of-Memory Errors236Understanding Business Process236Symptoms and Causes of Poor Business Process Execution Time236Resolving Halted, Halting, Waiting, or Interrupted Business Processes238Slow System: Symptoms, Causes, and Resolution240Performing a Thread Dump242Scenario-Based Troubleshooting Tips and Techniques245Performance and Tuning Worksheet247workflowLauncher: Running a Business Process from a Command Line250Notices253Index257A257B257C257D257E257F257G257H258I258J258L258M258N258O258P258Q259R259S259T259U259V259W259Taille: 2,1 MoPages: 262Language: EnglishOuvrir le manuel