IBM Tivoli Composite Application Manager for Application Diagnostics, Version 7.1.0.1
ITCAM Agent for WebSphere Applications/J2EE Database optimization
The problem: There are some general performance issues in ITCAM Agent for WebSphere Applications/J2EE reports, especially with Lock Contention reports or your SQL reports for "Response Time (ms)" not working.
The solution: The following are some solutions to boost performance and solve your problems with reports not being rendered.
"itcamBP" is the name of the buffer pool and "32K" is the page space size.
To see available bufferpools, run db2 select * from syscat.bufferpools.
db2 "CREATE TEMPORARY TABLESPACE itcamTEMP PAGESIZE 32K MANAGED BY SYSTEM USING ('/opt/IBM/temp/db2inst1/itcamts.10') BUFFERPOOL itcamBP"/opt/IBM/temp/db2inst1/itcamts.10 is the file to be used. DB2 MUST be able to read/write to the directory/file and it must have adequate space on the file-system. "itcamTEMP" is the TEMPORARY tablespace name while "itcamBP" is defined above. "...TEMPORARY TABLESPACE..." is important.
To see available tablespace: db2 list tablespaces
- Stop and start DB2:
- Log in as the DB2 admin
- Run db2stop
- Run db2start
Note: This will require a Managing Server/WAS restart too after creating the bufferpool and temporary tablespace.
- Follow the Managing Server installation guide for DB2 maintenance:
$AM_home/bin/run-stat-cmds.sh or... db2 "RUNSTATS ON TABLE db2inst1.request WITH DISTRIBUTION AND DETAILED INDEXES ALL" db2 "RUNSTATS ON TABLE db2inst1.method WITH DISTRIBUTION AND DETAILED INDEXES ALL"db2inst1 is the schema user ID.
Run these commands may take a few minutes, and should be done daily.
In addition, you may use the AM_home/bin/datatrim.sh script. See the ITCAM for Application Diagnostics Managing Server Installation Guide for further details and DB2 maintenance.
Parent topic:
Run the Managing Server