TI Process Log Cube

[Beast]

Looking to record when a TI process starts and ends in a Process Log Cube. Ive created a variable for each

vStarted = TIMST(NOW,'\D_\M_\Y_\h_\i_\s'); I have put into the Prolog tab and then done a CellPutS to a Log cube

vEnded= TIMST(NOW,'\D_\M_\Y_\h_\i_\s'); I have put in the Epilog tab and again done a CellPutS to a log cube

All seems to work fine apart from fact that both Start and End times are exactly the same, and although I am not loading a lot of data in the TI i would expect it to take more than a second to execute successfully ? Have I got the variables in the right place ?

Also Id like to have some sort of status flag for the process along the lines of 'Completed', 'Error' or something similar, has anybody done something similar ?

Thanks as always for any help.

[declanr]

Have you looked in the actual server log file to see the timestamps for process executed and process completed to see how long they take to complete?

[winsonlee]

http://www.bihints.com/monitoring_chore ... ail_part_2

prob you can do something like the above tutorial.

[nick_leeson]

A document that will give you a few ideas.
http://www.ibm.com/developerworks/data/ ... ge328.html


Cheers

[lotsaram]

The 2 links you've been given above are pretty good and I think about all you need to build your own process logging solution. Depending on the number of records you are processing I wouldn't be too surprised if start time and finish time were the exact same second considering that TI should processes multiple thousand records per second.

[Beast]

Some great responses as always.

The two links provided were excellent and provided some useful techniques.

And you were all write as well, the process I was testing did indeed take only a second to run.

Thanks.