| Author |
Message
|
| SteelHawk |
 Posted: Wed Jul 23, 2003 1:28 pm Post subject: Audit_Trail Table... |
 |
|
Novice
Joined: 23 Jul 2003
Posts: 10
Location: Mexico City
|
Someone know How can I extract the data from the BLOB field CONTAINER_CONTENT in the AUDIT_TRAIL database table ???...
Thank you for your help.. |
|
| Back to top |
|
 |
| jmac |
| Posted: Wed Jul 23, 2003 2:02 pm Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Steel:
I've not tried this but I suspect that you would use the ExecutionService::reanOnlyContainerFromStream() method to rebuild a container object from the byte array.
IF you try this PLEASE post your results.
GOOD LUCK
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| Andy |
| Posted: Wed Jul 23, 2003 9:00 pm Post subject: |
|
|
Centurion
Joined: 14 May 2003
Posts: 122
|
| jmac wrote: |
| I've not tried this but I suspect that you would use the ExecutionService::reanOnlyContainerFromStream() method to rebuild a container object from the byte array. |
I didnt know if there are APIs available to extract data from AUDIT_TRAIL table or I didnt understand the problem. Could somebody explain it to me please?
_________________
 Andy |
|
| Back to top |
|
|
| jmac |
| Posted: Thu Jul 24, 2003 4:33 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Andy:
There is no API to extract data from the AuditTable... But the contents of the Global Container is written to an audit record as a blob, which as I stated I believe can be made readable via ExecutionService::reanOnlyContainerFromStream()
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| SteelHawk |
| Posted: Tue Jul 29, 2003 9:16 am Post subject: |
|
|
Novice
Joined: 23 Jul 2003
Posts: 10
Location: Mexico City
|
Thanks for your ideas, i´ll try it .....i found another way let me explain it, in the Buildtime you can choose the processes you want to extract, and send the data structure to the Global Data Container(GDC), this one create a GC_table with all the information in character field type and you can do a SQL query for all the data structure.
i hope this will usefull to someone... |
|
| Back to top |
|
|
| Andy |
| Posted: Wed Jul 30, 2003 12:38 am Post subject: |
|
|
Centurion
Joined: 14 May 2003
Posts: 122
|
Its useful information... but we should also keep in mind that GDC data structure should be kept small because it is written in AUDIT_TRAIL table. So large data would be an overhead on workflow server if database audit is on.
Also, its not good idea to query runtime database. I am not sure if its also true for GDC table.
Thanks
_________________
Andy |
|
| Back to top |
|
|
| MaheshPN |
| Posted: Fri Aug 01, 2003 10:44 am Post subject: Audit_Trail Table... |
|
|
Master
Joined: 21 May 2003
Posts: 245
Location: Charlotte, NC
|
Hi SteelHawk,
I was trying to use GC_table to get the global container data.
As you see there will be one entry for each process instance and there is on field PIID(character type) is null/bank. Since I need to use the data present in that(GC Fields) in run time for the same process instace I need to find which entry is belongs to perticular process instace, so that i can query the table. Hope you have understood my problem. If you done some thing like this let us know.
Thanks,
Mahesh
IBM Certified Solution Expert - MQWorkflow |
|
| Back to top |
|
|
| dkrawczynski |
| Posted: Sun Aug 03, 2003 5:35 pm Post subject: |
|
|
Apprentice
Joined: 19 Dec 2002
Posts: 26
Location: Dallas, TX
|
You can join the GC_... table to the process instance table using the PIID column to get a view of the global container data for each process instance. The PIID column looks empty using a normal query because it contains binary data stored in a character field. If you want to view the values of any of the "ID" fields in the Workflow database wrap the column name with the hex() function.
Ex. select hex(PIID),hex(BIID) from fmc.process_inst pi, fmc.gc_mars_data gc where gc.piid = pi.biid
_________________
Doug Krawczynski
IBM Certified Solutions Expert -
MQSeries Workflow |
|
| Back to top |
|
|
|
|
