| Author |
Message
|
| mehedi |
 Posted: Wed Nov 05, 2003 12:26 pm Post subject: AUDIT Queue XML Audit message Timestamp element format |
 |
|
Centurion
Joined: 11 Nov 2001
Posts: 102
Location: PSTech
|
Below is the message put on the AUDIT Queue by Workflow.
The date is in the format YYYY-MM-dd-hh.mm.ss.
How can this format be changed(by some setting in workflow process model level or above) YYYY-MM-dd-hh.mm.ss.000000 ?
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>.<!-- This document is generated by a MQSeries Workflow Version 3.3.0 server -->..
<WfMessage>. <WfMessageHeader>.
<ResponseRequired>No</ResponseRequired>.
</WfMessageHeader>.
<AuditTrailRecord>. <Timestamp>2003-10-29 19:06:43</Timestamp>
<AuditEvent>21039</AuditEvent>
<ProcInstName>253050-DCN-039327400000</ProcInstName>
<ProcInstID>UAAAAAEBjsAKAAAAAAAAAAAAAAABAY9AAAAAAAAAAAAAUA==</ProcInstID>
<ProcInstTopLevelName>253050-DCN-039327400000</ProcInstTopLevelName>
<ProcInstTopLevelID>UAAAAAEBjsAKAAAAAAAAAAAAAAABAY9AAAAAAAAAAAAAUA==</ProcInstTopLevelID>
<ProcTemplName>EOEProcess</ProcTemplName>.
<ProcTemplValidFromDate>2003-10-29 19:04:59</ProcTemplValidFromDate>.
<UserID>MQM</UserID>
<AssociatedObject>UAAAAAEBjsAKAAAAAAAAAAAAAAABAY9AAAAAAAAAAAAAUA==</AssociatedObject>
<ObjectDescription>EOE Process Block</ObjectDescription>
</AuditTrailRecord>.</WfMessage> |
|
| Back to top |
|
 |
| jmac |
| Posted: Wed Nov 05, 2003 4:24 pm Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
To my knowledge this can not be changed
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| mehedi |
| Posted: Thu Nov 06, 2003 6:31 am Post subject: |
|
|
Centurion
Joined: 11 Nov 2001
Posts: 102
Location: PSTech
|
John,
How is the format of this timestamp determined ?
The vendor(s____m) of the loader tells us ours is the only installation where the timestamp format is YYYY-MM-dd-hh.mm.ss & not YYYY-MM-dd-hh.mm.ss.000000.
_________________
Thanks
Mehedi Hashir
mhashir@hotmail.com |
|
| Back to top |
|
|
| jmac |
| Posted: Thu Nov 06, 2003 7:20 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Mehedi:
I misunderstood your question.... I thought you wanted to put the timestamp into a different format like mm-dd-yyy or some such....
Now that I understand.... What version of MQWF are you using? I believe that there was a time when the timestamp in Audit to MQ records was only to the second, but that was changed sometime in V332 (I THINK).
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| ucbus1 |
| Posted: Thu Nov 06, 2003 7:40 am Post subject: |
|
|
Knight
Joined: 30 Jan 2002
Posts: 560
|
Mahedi,
May be it helps. The time stamp you are passing is DB2 standrd ISO time stamp. I think your DBA shouls be able to set up the format you need (provided DB2 supports).
Again.. may be I am jumping here with half knowledge.
Thanks |
|
| Back to top |
|
|
| mehedi |
| Posted: Thu Nov 06, 2003 11:44 am Post subject: |
|
|
Centurion
Joined: 11 Nov 2001
Posts: 102
Location: PSTech
|
|
| Back to top |
|
|
| jmac |
| Posted: Thu Nov 06, 2003 12:26 pm Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Mehedi:
Thats the problem... the timestamp was expanded during 332 at some point
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
|
|
