Error 'SQL0206N "Disk_DV.LAT_Mount_Point_U" running the Tivoli Common Report.

Body

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 know 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.  

Please contact the IBM support an request the OSAgentsReports.zip (TCR 3.1) or IBM_Tivoli_Monitoring_OS_Agents_Reports.zip (TCR 2.x)

Subscribe and follow us for all the latest information directly on your social feeds: