BI Data Analytics

Problem: Users creates schedules and leave it and as users move out, they start failing. It leaves up to admin to see if they are genuine failure vs just clean up. Solution: One use case used heavily to find out reoccurring failure schedules for specific user and clean up them in one go using MotioPI. Benefits: Give more visibility in hidden issues in system other than having clean administration Help in clean up in schedules done from My Folders.

Problem: When a large queries fired from Cognos to Application database,  there is always question or confusion who is client running the query ( Adhoc run) or identify which one of scheduled jobs  running on same database. Solution: DB2 is backend database for reporting queries, WLM_SET_CLIENT_INFO procedure can be added to Cognos Data source Command line parameter. In Cognos, this procedure command with user account parameter can be added in data source so that with each query, Client account name is sent as well. Now DBA can create script to capture information at DB end: Server ID Client ID DB ID Volume Read Rows Returned Cost of Query Cognos Team will get email for any volume breach happens and it is easy to detect and engage user to take further for fine tuning queries/model to prevent issues and improve performance.