| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| db2 tuning for workflow systems |
« View previous topic :: View next topic » |
| Author |
Message
|
| mkhadse |
 Posted: Fri Jan 10, 2003 10:50 am Post subject: db2 tuning for workflow systems |
 |
|
Acolyte
Joined: 31 Dec 1969
Posts: 73
|
Does anybody perform any db2 maintenance on workflow system? I know that IBM remmends to run statistics and Reorganize/rebind every day or every few days.
Apart from this has anyone changed certain database parameters for better performance?
In my case we get a timeout message when we are logging into the webclient? Can any database tuning be done to make loading the workitems faster/avoinfinf the workflow timeout messages?
Thanks |
|
| Back to top |
|
 |
| Ratan |
| Posted: Fri Jan 10, 2003 11:05 am Post subject: |
|
|
Grand Master
Joined: 18 Jul 2002
Posts: 1245
|
Are you sure it is the database that is causing the timeout and not the communication failure?
With Db2 tuning, our DBA increased the values of certain parameters, APPLSTACKSZ, AgentStackSZ, HEAPSZ, ...etc, but I am not sure what their impact on the system is.
-Laze |
|
| Back to top |
|
|
| kriersd |
| Posted: Fri Jan 10, 2003 11:19 am Post subject: |
|
|
Master
Joined: 22 Jul 2002
Posts: 209
Location: IA, USA
|
LazeKnight
Please refer to the thread topic "FMC31100W". I think you find your answer. :)
Dave
_________________
Dave Krier
IBM WebSphere MQ Workflow V3.4 Solution Designer |
|
| Back to top |
|
|
| Ratan |
| Posted: Fri Jan 10, 2003 11:26 am Post subject: |
|
|
Grand Master
Joined: 18 Jul 2002
Posts: 1245
|
Dave,
Thanks for the document. I do reorgs and rebinds as weekly scheduled tasks.
I am actually talking about other parameters that can be customizable depending on your harware resources, and I think those are for DB2 admins to answer.
-Laze |
|
| Back to top |
|
|
| jmac |
| Posted: Fri Jan 10, 2003 11:55 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
I have culled the following notes for myself from some of the past IBM T3 Presentations. I cannot vouch for any of these, so please do your own research. Some of these are obviously helpful, like using different devices for the high activity tables.
If possible use different dedicated physical devices for
High performance requirement tables (see next)
DB2_RR_TO_RS variable specifies whether or not next-key locking occurs on access to user tables. When set to YES, next-key locking will not be activated and this reduces locking and increases concurrency. During installation MQWorkflow sets this variable to YES.
The value can be displayed using the db2set command
DB2 parameters that should be examined note that they dont tell you what to examine for, just to examine.
LOGFILSZ size of each primary and secondary log file
APPLHEAPSZ number of private memory pages available to be used by the database manager on behalf of a specific agent
NUM_IOCLEANERS number of asynchronous page cleaners for a database. These page cleaners write changed pages from the buffer pool to disk
LOGBUFSZ amount of the database heap to use as a buffer for log records
AGENT_STACK_SZ virtual memory that is allocated by DB2 for each agent
The following shows the IBM supplied performance requirements of the tables. Note that the table names here do not match what I see when I look at the MQWF tables, but you can definitly see there are parallels:
High: INSTINDX, ADTTRAIL, WORKITEM
Medium: ACTWI, BLOCK, BLOCKACT, PROCACT, PROGACT, NTFYITEM, PROCESS,CONTAINER, ADMIN
Low: MODEL, TEMPLATE, LIST, STAFF, TOPOLOGY
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| mkhadse |
| Posted: Fri Jan 10, 2003 1:02 pm Post subject: |
|
|
Acolyte
Joined: 31 Dec 1969
Posts: 73
|
Thanks jmac.
I am seeing a about 200-400 deadlocks a day in the database. Is it recommended to change the locktimeout database parameter. When I check this for the workflow RT database it is set to -1?
I have read about SYSCOM VitalSigns Analyzer tool, will it help me tune the database for better performance looking at the process instances/workitem stats? Where can I get this tool? |
|
| Back to top |
|
|
| jmac |
| Posted: Fri Jan 10, 2003 1:35 pm Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
| Quote: |
| I am seeing a about 200-400 deadlocks a day in the database. Is it recommended to change the locktimeout database parameter. When I check this for the workflow RT database it is set to -1? |
Have you looked at the FMC31100W thread. You may need to run this procedure daily. The recommendation is to run it every time you import a new Process Instance.
| Quote: |
| I have read about SYSCOM VitalSigns Analyzer tool, will it help me tune the database for better performance looking at the process instances/workitem stats? Where can I get this tool? |
This tool processes Audit trail records. You can get information on the tool from MQSeries Transaction pack WA08
http://www-3.ibm.com/software/ts/mqseries/txppacs/wa08.html
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
