IBM Tivoli Monitoring: System p Agent Reports 6.2.2.2-TIV-ITM_SYSP_RPT-IF0003

Download Description

(C) Copyright International Business Machines Corporation 2012.
All rights reserved.

Component: IBM(R) Tivoli(R) Monitoring: System p(R) Agent,
Version 6.2.2.2

Component ID: 5724C04AG

Interim Fix: 0003, 6.2.2.2-TIV-ITM_SYSP_RPT-IF0003

Date: August 20, 2012

Contents:

1.0 General description
2.0 Problems fixed
3.0 Architecture and prerequisites
4.0 Image directory contents
5.0 Installation instructions
6.0 Additional installation information
7.0 Known problems and workarounds
8.0 Additional product information
9.0 Notices


1.0 General description
-----------------------

This interim fix resolves the APARs and defects listed in the
"Problems Fixed" section below.


2.0 Problems fixed
------------------

The following problems are addressed by this fix.

2.1 APARs
---------------
APAR: IV25680
Abstract: DUPLICATE CEC NAMES APPEAR IN THE PROMPT PAGE OF REPORTS
Additional information: Duplicate CEC names might display in the
reporting promp after installing the interim fix for
APAR IV20176 and the warehouse has not been pruned of
data collected prior to the fix.

APAR: IV26055
Abstract: WHEN THE FIX FOR APAR: IV26053 WAS RELEASED, IT DID NOT
INCLUDE SOME OF THE OLD REPORTS.
Additional information: The original reports for the agent were not
included in interim fix 6.2.2.2-TIV-ITM_SYSP_RPT-IF0002.
Now, a new folder named 'Deprecated' contains certain
CEC base agent reports which used the identifier
'Machine ID' to uniquely identify CECs. These deprecated
reports have been provided only for continuity until
the upgraded agent gathers adequate data. The new reports
use 'Type_Model_SerialNumber' to uniquely identify CECs.
When there is enough data in the warehouse after upgrading
the agent, use the regular reports not in the
'Deprecated' folder. The deprecated reports will be
removed in future releases. Ensure that any
customizations to the CEC Base agent reports are done only
to the new reports and not to the deprecated ones.

2.2 Defects
-----------
Defect: 169071
Abstract: Performance enhancement - relationship to TIME_DIMENSION
Additional information: This is a performance enchancement by
using TIME_DIMENSION instead of "Time Dimension."

2.3 Enhancements
------------------
None.

2.4 Superseded fixes
---------------------
6.2.2.2-TIV-ITM_SYSP_RPT-IF0001
6.2.2.2-TIV-ITM_SYSP_RPT-IF0002

2.5 APARs and defects included from superseded fixes
---------------------------------------------------------------

6.2.2.2-TIV-ITM_SYSP_RPT-IF0002
-------------------------------
APAR: IV16594
Abstract: CPU POOLS UTILIZATION REPORT FAILS FOR HOURLY
SUMMARIZATION
Additional information: The CPU Pools Utilization Details
Report fails to run for the "Hourly" summarization type,
because the System p agent data model is missing some
join statements. Also, "CPU Pools Hourly" is misspelled
in the Consolidation View of the data model, causing the
report to fail.

APAR: IV20176
Abstract: NO UNIQUE MACHINE IDENTIFIER FOR REMOTE CECS CAUSES
REPORTS TO FAIL
Additional information: When running Tivoli Common Reporting for the
following three reports:
---
LPAR Physical CPU Utilization Details
LPAR Physical Memory Utilization Details
LPAR Workload Trend and Forecast
---
the prompt page asks the user to choose a CEC and will
display a list of LPARs for the users to select. If the
agent is monitoring the CEC from a remote LPAR, the list
will show LPARs from multiple CECs instead of just the
LPARs on the chosen CEC. This occurs because the
machine ID attribute contains the ID of the CEC on which
the agent LPAR is running. However, the CEC ID of the
remote CEC cannot be determined due to a limitation in
the AIX Performance Tools. A different unique
identifier is needed.
Note: This APAR also requires interim fix
6.2.2.2-TIV-ITM_CEC_BASE-IF0003 or above for the agent.

APAR: IV21250
Abstract: REPORTS FAIL FOR NON-ITMUSER SCHEMA NAME
Additional information: The schema name of ITMUSER is hardcoded for
the IBM Tivoli Monitoring tables in the data model for
the System p agents. This causes reports to fail when
using a different schema name while configuring the
Warehouse Proxy Agent and the Summarization and Pruning
Agent.

APAR: IV22072
Abstract: VALUES FOR VACATION PERIODS ARE INCORRECT.
Additional information: The prompt page of the following reports in
the System P reports package have an incorrect
interpretation of values for vacation periods. The values
listed should be All days (-1), Work days (0) and Vacation
days (1).
List of affected reports:
---
Performance Trends and Resource Forecasts > CPU Pools Utilization Details
Performance Trends and Resource Forecasts > Frame workload trend and forecast
Performance Trends and Resource Forecasts > LPAR Physical CPU Utilization Details
Performance Trends and Resource Forecasts > LPAR Physical Memory Utilization Details
Performance Trends and Resource Forecasts > LPAR Workload Trend and Forecast
Performance Trends and Resource Forecasts > VIOS Disk Capacity Details
Performance Trends and Resource Forecasts > VIOS Shared Ethernet Adapter Utilization
What-If Analysis for Workload Placement > Number of LPARs for CEC
What-If Analysis for Workload Placement > Resources Needed For Additional LPARs on CEC
Workload Right-Sizing and Balancing > Top or Bottom CECs by Physical CPU Utilization
Workload Right-Sizing and Balancing > Top or Bottom CECs by Physical Memory Utilization
Workload Right-Sizing and Balancing > Top or Bottom LPARs by Physical CPU Utilization
Workload Right-Sizing and Balancing > Top or Bottom LPARs by Physical Memory Utilization
Workload Right-Sizing and Balancing > Top or Bottom VIOSs by Disk Capacity

APAR: IV22818
Abstract: UDA ERROR IN WHAT-IF ANALYSIS REPORTS
Additional information: Running What-If Analysis for Workload
Placement reports might cause the following error:
---
UDA-SQL-0114 The cursor supplied to the operation
"sqlOpenResult" is inactive. UDA-SOR-0005 Unable to
write the file.

APAR: IV26053
Abstract: SYSTEM P AGENT REPORTS LIST LPARS FOR THE WRONG CEC IF
AGENT IS ON A REMOTE LPAR.
Additional information: This fix is required to take advantage of
the agent fix in APAR IV20176. See APAR IV20176 above.

6.2.2.2-TIV-ITM_SYSP_RPT-IF0001
-------------------------------

APAR: IV08029
Abstract: SPLIT QUERIES IN THE DATA MODELS CAUSES PERFORMANCE
PROBLEMS
Additional information: The Tivoli Common Reporting data model
for the System p agents reports contains split queries
that might cause performance problems with very large
amounts of data. In the data models, reports utilize
simple queries like 'select x, y from A', instead of
'select * from A'. As a result, Cognos processes queries
through use of joins at the Cognos level, instead of
being performed at the database level. This results in
poor performance. The performance impact is greater when
dealing with large datasets.

APAR: IV09285
Abstract: PROCESSES SUMMARY HOURLY REPORTS INCORRECTLY USES DAILY
DATA
Additional information: The Tivoli Common Reporting data model
for the System p agents reports incorrectly uses daily
data to generate "Processes Summary Hourly" reports.



3.0 Architecture and prerequisites
----------------------------------

This fix is supported on all operating systems listed in the
IBM Tivoli Monitoring: VIOS Premium Agent User's Guide, version 6.2.2.2.
See chapter 8 for information on the Tivoli Common Reporting reports for
all the IBM Tivoli Monitoring System p agents.

The User's Guide is here:

http://publib.boulder.ibm.com/infocenter/tivihelp/v15r1/topic/com.ibm.itm.doc_6.2.3/pviosagent6222_user.pdf

Please refer to the IBM Software Product Compatability Reports (SPCR)
for the latest operating system certification information:
http://publib.boulder.ibm.com/infocenter/prodguid/v1r0/clarity/index.html


3.1 Prerequisites for this fix
------------------------------

The prerequisite level for this fix is defined in Chapter 8 of the
IBM Tivoli Monitoring: VIOS Premium Agent User's Guide, version 6.2.2.2.

In addition, interim fix 6.2.2.2-TIV-ITM_CEC_BASE-IF0003 is required
for the CEC Base agent.


4.0 Image directory content
---------------------------

This fix image contains the following files:
- 6.2.2.2-TIV-ITM_SYSP_RPT-IF0003.README - This README file
- 6.2.2.2-TIV-ITM_SYSP_RPT-IF0003.zip - Fix archive .zip format.

The fix archive file contains the following directories and files,
which is the same as the format found in the REPORTS directory
of the IBM Tivoli Monitoring Agents for System p V6.2.2 Interim
Feature 2, Agent Support Files Multiplatform English (CI1MQEN)
media as found on Passport Advantage:
- gui
- lib
- model
- reports
- setup_aix.bin
- setup_linux.bin
- setup_solaris.bin
- setup_windows.exe
- silent_installer.properties
- tcr_install.properties

Note this interim fix is a complete replacement of the report package.

5.0 Installation instructions
-----------------------------
This fix can be installed over an existing installation or as
a new install.

5.1 Before installing the fix
------------------------------
- The prerequisites listed under section 3.1 entitled 'Prerequisites
for this fix' must be installed before this fix can be installed.

- Because there is no uninstall utility for this fix, make sure to
perform a backup of your environment before installing this fix.

5.2 Tivoli Common Reporting server update
-----------------------------------------------
1. Transfer the archive file to a temporary directory on the
same computer where the Tivoli Common Reporting server is
installed.

2. Expand the archive file, 6.2.2.2-TIV-ITM_SYSP_RPT-IF0003.zip.
The fix archive contains the following files:
- gui
- lib
- model
- reports
- setup_aix.bin
- setup_linux.bin
- setup_solaris.bin
- setup_windows.exe
- silent_installer.properties
- tcr_install.properties

3. See Chapter 8 of the IBM Tivoli Monitoring: VIOS Premium Agent
User's Guide, version 6.2.2.2 for further install instructions.


6.0 Additional installation information
---------------------------------------
None.


7.0 Known problems and workarounds
----------------------------------
None.


8.0 Additional product information
----------------------------------
None.


9.0 Notices
-----------

This information was developed for products and services offered in the
United States. IBM may not offer the products, services, or features
discussed in this document in other countries. Consult your local IBM
representative for information on the products and services currently
available in your area. Any reference to an IBM product, program, or
service is not intended to state or imply that only that IBM product,
program, or service may be used. Any functionally equivalent product,
program, or service that does not infringe any IBM intellectual
property right may be used instead. However, it is the user's
responsibility to evaluate and verify the operation of any non-IBM
product, program, or service.

IBM may have patents or pending patent applications covering subject
matter described in this document. The furnishing of this document does
not grant you any license to these patents. You can send license
inquiries, in writing, to:

IBM Director of Licensing
IBM Corporation
North Castle Drive
Armonk, NY 10504-1785
U.S.A.

The following paragraph does not apply to the United Kingdom or any
other country where such provisions are inconsistent with local law:

INTERNATIONAL BUSINESS MACHINES CORPORATION PROVIDES THIS PUBLICATION
"AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED,
INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
NON-INFRINGEMENT, MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE.

Some states do not allow disclaimer of express or implied warranties in
certain transactions, therefore, this statement may not apply to you.

Trademarks and service marks
----------------------------

IBM, the IBM logo, and ibm.com® are trademarks or registered trademarks
of International Business Machines Corp., registered in many
jurisdictions worldwide. Other product and service names might be
trademarks of IBM or other companies. A current list of IBM trademarks
is available on the Web at "Copyright and trademark information" at
http://www.ibm.com/legal/copytrade.shtml.

Other company, product, and service names may be trademarks or service
marks of others.