| Author |
Message
|
| fagundes |
 Posted: Mon Feb 02, 2004 2:14 pm Post subject: Monitoring the final times of workflow instances/activities |
 |
|
Apprentice
Joined: 15 Aug 2003
Posts: 45
|
Good days for all.
I need to monitor and make a log of my Server MQSWflow.
I need to count the quantities of finished workflow instances (start time and final time) and finished activities (start time and final time) and write these data into a file.
Can I to use some tool of RunTime to make it?
Can I write a program for providing this log ?
Can anybody help me...
Thanks in advance.
Fagundes
_________________
Fagundes Pereira da Silva
M.Sc. Candidate / UFRJ Brazil
Interest Area: WfMS Performance Analysis |
|
| Back to top |
|
 |
| vennela |
| Posted: Mon Feb 02, 2004 3:00 pm Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
| That is what audit trails would do for you |
|
| Back to top |
|
|
| jmac |
| Posted: Mon Feb 02, 2004 5:29 pm Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
You might want to have a look at the "database Views" provided by MQWF. These may give you what you are looking for.
Side note to Vennala: New Icon, you finally gave in to popular demand? I say bring back the old Vennala
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| fagundes |
| Posted: Tue Feb 03, 2004 9:23 am Post subject: audit trials |
|
|
Apprentice
Joined: 15 Aug 2003
Posts: 45
|
Please, have anybody got examples of programms consulting the audit trials? or queries direct on db2?
I looked for information on the adm.guide, but after to try what was written there, occurred errors ...
Thanks in advance.
Fagundes
_________________
Fagundes Pereira da Silva
M.Sc. Candidate / UFRJ Brazil
Interest Area: WfMS Performance Analysis |
|
| Back to top |
|
|
| jmac |
| Posted: Tue Feb 03, 2004 10:28 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
I successfully ran the following script adapted from the script shown on p102 of the V3.4 Programming Guide
SELECT DATE(t_level_proc.completed), COUNT(t_level_proc.piid), activity.name
FROM fmc.proc_inst_view proc, fmc.proc_inst_view t_level_proc,
fmc.prog_act_inst_view activity
GROUP BY activity.name, DATE(t_level_proc.completed)
Note that I did find I had to remove the WHERE clause to get this to run, I really don't know a lot about SQL, so I am sure there is a less drastic solution to making this sample script work.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| fagundes |
| Posted: Tue Feb 03, 2004 1:49 pm Post subject: auditing ... |
|
|
Apprentice
Joined: 15 Aug 2003
Posts: 45
|
Thanks, but my MQSeries is 3.3 and in the Programming Guide there is nothing about connecting to DB2 and query the audit with application programs.
Thanks Sir.
Fagundes
_________________
Fagundes Pereira da Silva
M.Sc. Candidate / UFRJ Brazil
Interest Area: WfMS Performance Analysis |
|
| Back to top |
|
|
|
|
