Is there a way to count the number of times a program has been called (portal and LID combined, plus subsequent programs that might be called from an initial execution). We are looking to identify what programs are users are executing. We are 8.1 apps and 8.0.3 env.
Thanks
I can think of a couple.. If you want to know what BATCH program are executed you can look in the joblogs directory. If all your users are on Portal, you can parse the webserver logs to see what they ran.
If you want a listing of EVERY program, every time it runs I'd institute TIMESTATS in the CAP_DB file (ORACLE, IBM, whatever your DB is). Timestats makes a logfile for every execution of every program, showing when it started, who ran it, how long it took, how much data moved, what functions were used, what indexes it used, etc.. VERY handy for Application performance analysis and tuning, but it'll also give you an absolutely 100% accurate record of what ran by whom and when.
You can read about timestats in your Lawson Enterprise Database Management manual.