This set of queries is designed to analyze the following issues in Cognos Business Intelligence Platform
Application server memory usage planning and rationalization
System stability related such as slow performance, performance degradation and hung issues
Resource utilization sampling, system tuning and optimization
Configuration validation and adjustment
Non reproducible exceptions
System crashes
General Cognos BI platform system health check
Content Oriented System Dump Analysis®
Actively promoted and advocated by the IBM Cognos L3 group, the content oriented system dump analysis focuses on system content rather than software source code and data structures. The approach systematically reveals the complex data structures and system process in a way similar to the operational view of a production system. Without the need to know a product's source code, administrators and support analysts are able to investigate issues by focusing on system and user behaviors. This allows support staff to work around issues with little support from software developers. Utltimately, this will let clients pass the identified use case to the development team for an offical fix. The approach greatly reduces dependencies on the development team and speeds up the problem resolution cycle.
The content oriented approach focuses on the operational view, revealing the following information:
System topology, including what services are available on what server instances in a distributed environment
System settings, including system configuration, system parameters and advanced settings
Client requests consisting of user actions. For example, a http request, a jmx request, a soap request, etc.
Various elapsed times of a process, i.e., the start of a request or intermediate elapsed times during a request process life cycle
User activities, a summary of all on-going requests in the system, with high level abstraction of a user action, such as who a user is, from what browser with what ip address, elapsed time, and what request is doing, etc.
Key connection and queue size information in between components
Utility tools to search and display well known objects, for example, a request and its elapsed time
Cognos Business Intelligence Extensions for IBM Memory Analyzer®
Using the content oriented approach, IBM Cognos L3 developed a set of queries to support Cognos BI platform 8.4 and newer releases. The following figures shows the location and structure of Cognos extensions.
