Analytics Is the Answer: Three More Business Analytics Areas Needed for Management

Thanks for all the comments this last week and throughout the year. I really appreciate it. The comments this week were related to additional business analytics areas that need to be communicated to management. Management needs to be aware of business analytics on maintenance activities, security/compliance efforts and the number of end-users helping make profits for the company.

First, the developers and the DBAs I have talked to have been extremely busy doing all sorts of maintenance and creation of new DB2 objects. Management needs business analytics on the number of new or changed database objects such as table spaces, tables and indexes. How many more database objects is your staff managing at the end of 2011 compared to last year? Or how many more entire systems or data sharing members exist compared to last year? Also, how many more reorganizations, resizings, or maintenance jobs were supported, how many off-hours or on-call situations did your staff support? Do some research and supply the business analytics of how often your staff gets harassed and ask your boss if you can call him that often.

Next, the year has also been stressful improving the security and compliance area. When I have been doing DB2 system security reviews this year, I found more overall objects that support more data assets and need more attention. The security configuration reviews of system settings shows many more public, SSL or Trusted settings. The number of security ROLE definitions by application, department, or division and the number of encrypted, masked or special authorities within the system, database and applications continue to grow. The number of combinations of ROLEs and their column or row level access combinations will definitely stagger management minds. Get the business analytics of the numbers of new security configurations defined or improved in 2011. Your management compliance and security departments will definitely appreciate reporting this up their chain of command to the board of directors.

Last, but not least, the business analytics of the simple number of system and application end users processing work needs to be communicated to management. Even in these tough economic times businesses are adding user workload and business executives need to understand how business critical the systems you and your group support are. Management knows your systems are important, but documenting the business analytics of the number of users and other previously mentioned areas in a report to management reinforces how important data asset management is within your company.

Business analytics reports are the best way to show these areas and it’s a great way to prove why your application development, DBA and security areas are so overworked, tired and need more education, consultant help and tools. Do some research and supply the business analytics of all these situations mentioned. Assign one hour or more time to each of these incidents or situation and put these business analytics into management’s year-end salary review process. It will definitely help your budget discussions and overall negotiating position.


Happy Holidays and have a Happy New Year.

Also, I am beginning to plan my Regional DB2 User Group support for 2012 year. Please send an email to me at moc.ekluebevadnull@evad if you would like me to come and speak or offer a DB2 class at your local user group.

Early bird reduced pricing for these seminars ends January 9th. Sign up now!

Public DB2 Performance Tuning & SQL Training Education classes in February in Chicago.

Dave Beulke & Sheryl Larsen Chicago February 22-24

February 22: DB2 SQL and Optimization Enhancements by Sheryl Larsen

February 23: DB2 10 for z/OS Performance Training by Dave Beulke

February 24: Two great seminars to choose from

Tuning SQL for Performance by Sheryl Larsen


DB2 Performance for Java Developers by Dave Beulke

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>