Reporting against production databases

[Eric Vaughan]

Hi

     We currently have a business unit that is requesting a final job in each out their applications that would gather all start time and end time of all jobs in it and generate it into one file of that specific generation.
      The WLA Admin team is concerned that this would be a lot of overhead against the production database and would impact performance.  
The question(s) I have is:
1) Does any WLA customers do such a report(s)
2) Do other WLA customers allow business units to run reports against the live production database
3) Do any other WLA customers have a database strictly to run reports against?  If so how do you keep in it in sync with the production database.

Any help or suggestions would be greatly appreciated.

[SHARON SHIMANEK]

Hi, 
1) Does any WLA customers do such a report(s)  - Yes, we do but not for all flow
2) Do other WLA customers allow business units to run reports against the live production database  - NO
3) Do any other WLA customers have a database strictly to run reports against?  If so how do you keep in it in sync with the production database.  - We do not have a seperate database but we utilize the movehistorydata job to move data from ESP_tables to history tables H_ to keep ESP tables smaller we only keep 33 days of info in ESP_application ESP_generic_job.

Our IT Analytics team wanted do to monitor their batch jobs/flows performance so we gave them read access to esp_application and esp_generic job. they created a job flow they call APM = application performance monitoring.  They run this flow every 30 minutes and use a date control process and pull in the data they want for their flows based on our naming standards it is easy for them to do. They wanted to metric on flow performance and job performance.  the date control allows them to only pull in data since the prev run of the APM flow.    so the first step in this flow pulls dseries data from the database, then from there they have other jobs that do their metrics and they created a BI Dashboard use.  

We do not notice any performance issues, we have been doing this for 10+ years

[Ravi Kiran Kunduri]

Hi Eric,

Can you please check if the built-in variables can be helpful here.

APPL._STIME

APPL._ATIME

APPL._RTIME

WOB._RTIME

WOB._LTIME

More details - https://techdocs.broadcom.com/us/en/ca-enterprise-software/intelligent-automation/ca-workload-automation-de/12-3/scheduling/using-javascript/symbolic-variables/built-in-symbolic-variables.html