| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| [solved]Accessing Global Data Container [urgent] |
« View previous topic :: View next topic » |
| Author |
Message
|
| mca |
 Posted: Wed Apr 27, 2005 5:23 pm Post subject: [solved]Accessing Global Data Container [urgent] |
 |
|
Disciple
Joined: 09 Mar 2005
Posts: 196
|
hi all,
In my work flow i have 2 activities. Every order/instance needs to perform these activities. My first activity is an UPES where it determines the wait time for every order. The second activity is an dummy activity which performs the wait time.
So, the o/p container of first activity has 1. order no. 2. Wait time 3. Time of arrival fields which sends these details to the i/p container of dummy activity. I kept an GDC in between these 2 activities to record these fields.
The audit trail is FILTERED(not full) and we donot have WBI Monitor on our systems.
Now by the end of each bussiness day i need to run an report of the bssiness data stating order no, time of arrival and its wait time for each order and also total no. of orders for that day. I have never queried GDC before. I heard the properties of GDC are
1. it stores data in BLOB format, which we cant access by simple SQL statements but needs API calls.
2. It keeps track of only live orders which are in wait time. Once the order finishes the wait time, GDC doesnot have the record of that particular order.
How far the above statements TRUE ?
If i wanna run reports at the end of the day, what is feasible way? If i can run repors using GDC, how is it possible ? Moe details about GDC greatly appreciated.
Last edited by mca on Fri Apr 29, 2005 6:54 am; edited 1 time in total |
|
| Back to top |
|
 |
| jmac |
| Posted: Thu Apr 28, 2005 5:27 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
It is my opinion that you do not need to query the GDC in the workflow, you simply use the data from the associated 21082 in the audit trail. I think you can run your report against the audit trail table and get everything you need.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| mca |
| Posted: Thu Apr 28, 2005 5:34 am Post subject: |
|
|
Disciple
Joined: 09 Mar 2005
Posts: 196
|
hi jmac,
Thanks for the reply
Is the data from the associated 21082 in the audit trail in BLOB format? if so, where can i get the API's to encode them ? Also as our AUDIT TRAIL is filtered, will the 21082 record the values of instances that have finished processing and also which are being processed ? |
|
| Back to top |
|
|
| jmac |
| Posted: Thu Apr 28, 2005 5:45 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
As long as you are putting the 21082 out to the audit trail you will be ok in my opinion.
I access the auditTable w/SQL and use code like this to get at the GDC
| Code: |
else if (columnNames[colIndx].equalsIgnoreCase("CONTAINER_CONTENT"))
{
StringBuffer sb = new StringBuffer();
Blob blobObj = resultSet.getBlob("CONTAINER_CONTENT");
if (blobObj != null)
{
BufferedReader br = new BufferedReader(new InputStreamReader(blobObj.getBinaryStream()));
String line = "";
try
{
while( (line = br.readLine()) != null )
{
sb.append(line.trim());
}
}
catch (IOException e)
{
sb.append("IOException accessing Container Data blob");
}
}
newPrintRow.addElement(sb.toString());
newRow.addElement(sb.toString()); |
There will be a 21082 for every activity that has completed and mapped data to the GDC
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| mca |
| Posted: Thu Apr 28, 2005 6:13 am Post subject: |
|
|
Disciple
Joined: 09 Mar 2005
Posts: 196
|
I am filtering the following event nos onto the audit-trail.
21006,21007,21010,21032,21081,21082
which means using the above code i can get the values desired. Will let you know if any further question.
Thanks Jmac |
|
| 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
|
|
|
|
