IBM Support

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

Technical Blog Post


Abstract

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)

image

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

image

image

image

  



 

Check out all our other posts and updates:

Academy Blogs: https://goo.gl/U7cYYY
Academy Videos: https://goo.gl/TLfMoF
Academy Google+: https://goo.gl/HnTs0w
Academy Twitter : https://goo.gl/AhR8CL








 

[{"Business Unit":{"code":"BU011","label":"Systems - zSystems software"},"Product":{"code":"SSVJUL","label":"IBM Application Performance Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":""}]

UID

ibm11277218