Tuning Db2 Websherr

Servidor de DB2 Produccion 2
Servidor de WebSphere Process Server Produccion 19
Servidor de WebSphere Process Server Testing 24

Tuning y Optimizacion de WepSphere Process Server

I. Servidor de DB2 Produccion

Servidor
Hostname | was34lp2 |
Direccion IP | 10.4.35.209 |
Sistema Operativo | AIX 6 |
Procesadores | proc0, proc4 |
Memoria | 16GB |

Servidor de Base de datosNombre de instancia | db2inst1 |
Version | DB21085I Instance "db2inst1" uses "64" bits and DB2 code release "SQL09055" with level identifier "06060107". Informational tokens are "DB2 v9.5.0.5", "s091123", "U829462", and Fix Pack "5". |

| Database alias = BPEDB2 Database name = BPEDB2 Local database directory = /home/db2inst1Database release level = c.00 Comment = Directory entry type = Indirect Catalog database partition number = 0 Alternate server hostname = Alternate server port number = |
$ db2 get db cfg for BPEDB2 Database Configuration for Database BPEDB2 Database configuration release level = 0x0c00 Databaserelease level = 0x0c00 Database territory = en-us Database code page = 1208 Database code set = UTF-8 Database country/region code = 1 Database collating sequence = IDENTITY Alternate collatingsequence (ALT_COLLATE) = Number compatibility = OFF Varchar2 compatibility = OFF Database page size = 4096 Dynamic SQL Query management (DYN_QUERY_MGMT) = DISABLE Discovery support for this database (DISCOVER_DB) = ENABLE Restrict access= NO Default query optimization class (DFT_QUERYOPT) = 5 Degree of parallelism (DFT_DEGREE) = 1 Continue upon arithmetic exceptions (DFT_SQLMATHWARN) = NO Default refresh age (DFT_REFRESH_AGE) = 0 Default maintained table types for opt (DFT_MTTB_TYPES) = SYSTEM Number of frequent values retained (NUM_FREQVALUES) = 10 Number of quantilesretained (NUM_QUANTILES) = 20 Decimal floating point rounding mode (DECFLT_ROUNDING) = ROUND_HALF_EVEN Backup pending = NO Database is consistent = NO Rollforward pending = NO Restore pending = NO Multi-page file allocation enabled= YES Log retain for recovery status = NO User exit for logging status = NO Self tuning memory (SELF_TUNING_MEM) = ON Size of database shared memory (4KB) (DATABASE_MEMORY) = AUTOMATIC(454460) Database memory threshold (DB_MEM_THRESH) = 10 Max storage for lock list (4KB) (LOCKLIST) =AUTOMATIC(2432) Percent. of lock lists per application (MAXLOCKS) = AUTOMATIC(98) Package cache size (4KB) (PCKCACHESZ) = AUTOMATIC(13215) Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = AUTOMATIC(17259) Sort list heap (4KB) (SORTHEAP) = AUTOMATIC(4309) Database heap (4KB) (DBHEAP) = AUTOMATIC(2578) Catalog cachesize (4KB) (CATALOGCACHE_SZ) = 300 Log buffer size (4KB) (LOGBUFSZ) = 98 Utilities heap size (4KB) (UTIL_HEAP_SZ) = 57626 Buffer pool size (pages) (BUFFPAGE) = 1000 SQL statement heap (4KB) (STMTHEAP) = AUTOMATIC(4096) Default application heap (4KB) (APPLHEAPSZ) = AUTOMATIC(256) Application Memory...