CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

Using table trigger to store application usage (AS/400)

edited Sep 27, 2013 1:24AM in CNC, DB and Operating System - JDE1 (MOSC) 3 commentsAnswered
Hi all!

We're trying to find a way to track usage of interactive and batch applications in preparation for upgrade from XE to 9.1 For batch versions this would be easy (copy submitted jobs every night) but there is, to my knowledge, no way to track usage of interactive applications?  (how often an application was run / last execution date)

This is why we're looking at solving this by using table triggers. Has anyone done anything like this before and would like to share thoughts/comments on this? I was thinking to drive the trigger from the the versions table and update a custom table with usage stats (Application/Version/Number of times run).  Or is there, maybe, a way to do this without modification?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center