The basic rule syntax for this message would be as below:
)MSG DB02325I
)PROC job=msg.jobname
address SQL "Update STCTBL set current_state='UP'",
"where jobname=:job"
However, for this rule to work properly a Datacom parameter must be changed to remove the jobname prefix of the MUF messages.
In the message DATACOM:DB02325I the first word "DATACOM" is the jobname of the MUF started task. This indicates the following MUF parameter is set:
MUFMSG YES,NO,NO
To remove the jobname prefix the value of this parameter must be changed:
MUFMSG NO,NO,NO
This change may have other implications as there can be other rules already intercepting the MUF messages so be careful before implementing it on a production environment.
The alternative to modifying the MUF parameter would be creating the rule as below:
)MSG DATACOM:*
)PROC
job=msg.jobname
prefix = word(msg.text,1)
parse var prefix jobname ":" msgid
if msgid = 'DB02325I' then do
address SQL "Update STCTBL set current_state='UP'",
"where jobname=:job"
end