IBM Support

IBM Tivoli Monitoring OS Agent Reports - APAR IV99022

Download


Abstract

This fix resolves the APARs and defects listed in the “Download Description” section below

Download Description

While running the Tivoli Common Report Disk Utilization reports for UNIX OS Agent, the report fails with the error message:
           

                  'SQL0206N "Disk_DV.LAT_Mount_Point_U" is not valid 

At first,  please have a look into your IBM Tivoli Monitoring Warehouse if the table view 'Disk_DV' exits.
If that is the case, then it is a known issue and solved in APAR IV99022

The fix for this problem is identified under APAR IV99022 and implemented  through a change in the data model. 

Which report package to use depends on customer's TCR and Cognos versions.
- Cognos version can be found in cmplst.txt file, in our testing environment, it is under /opt/IBM/JazzSM/reporting/cognos.
- TCR version can be found, for example, under  /opt/IBM/JazzSM/reporting/version. Both information can also be obtained from the report GUI page.

1. If the customer has TCR 3.x and Cognos 10.x, then install OS agent report package, OSAgentsReports.zip directly using trcmd.sh import command, for  example, say OSAgentsReports.zip is saved under /tmp directory,

    /opt/IBM/JazzSM/reporting/bin/trcmd.sh -import -bulk /tmp/OSAgentsReports.zip  -user <report login username> -password <password>

2. If the customer has TCR 2.x and Cognos 8.x, then the customer can run report installer to install IBM_Tivoli_Monitoring_OS_Agents_Reports.zip.  

The updated files,  OSAgentsReports_IV09922.zip (TCR 3.1) or IBM_Tivoli_Monitoring_OS_Agents_Reports_IV09922.zip (TCR 2.x) can be obtained from Fix Central using the link below.

Prerequisites

IBM Tivoli Monitoring OS Agent Reports 6.3.0.7

Download Package

Fix Central
To download the files using Fix Central use the following link:

Change History

2018-08-28:  Published

On
[{"DNLabel":"6.3.0.7-TIV-ITM_OS_REPORTS-IV99022","DNDate":"28 Aug 2018","DNLang":"English","DNSize":"74,864,780","DNPlat":{"label":"AIX","code":"PF002"},"DNURL":"http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm~Tivoli&product=ibm/Tivoli/IBM+Tivoli+Monitoring&platform=All&release=6.3.0.7&function=fixId&fixids=6.3.0.7-TIV-ITM_OS_REPORTS-IV99022","DNURL_FTP":" ","DDURL":null}]
[{"Business Unit":{"code":"BU004","label":"Hybrid Cloud"},"Product":{"code":"SSZ8F3","label":"IBM Tivoli Monitoring V6"},"Component":"ITM UNIX OS Agent Reports","Platform":[{"code":"PF002","label":"AIX"}],"Version":"6.3.0.7","Edition":""}]

Product Synonym

ITM OS Agent Reports

Document Information

Modified date:
29 August 2018

UID

ibm10729517