IV99022: AE IV75662 - ERROR LOADING UNIX OS REPORTS DUE TO MISSING LAT_MOUNT_POINT_U COLUMN IN AGGREGATED DISK TABLES AND VIEWS.
A fix is available
Closed as program error.
Affected environments: 06.30.07.00 / 063007000 level of UNIX OS agent - UX - on all platforms Problem Description: Changes shipped in 6.3 FP7 release of UNIX OS agent application support prevents running of OS TCR reports. In the ODI file (dockux), a primary key has been added to the column UMOUNTPT(Mount_Point_U) in the table UNIXDISK ( Object Disk). Due to this change, the LAT_Mount_Point_U column cannot be created in all aggregated disk tables and views by the Summarization Pruning Agent - SY component. 6.3 FP6 dockux file: *ATTR: Mount_Point_U *CAPTION: Mount\Point (Unicode) *COLUMN: UMOUNTPT *TYPE: S,768 *BEHAV: PROPERTY *DOMAIN: UTF8L768 *REM: *AFFIN: -AFF_V1 *DVERSION: 2 *ATOMIZE: *TEXT: The path name of the directory to which a filesystem is mounted. 6.3 FP7 dockux file: *ATTR: Mount_Point_U *CAPTION: Mount\Point (Unicode) *COLUMN: UMOUNTPT *TYPE: S,768 *OPTION: PRIMARYKEY=1 *DOMAIN: UTF8L768 *REM: *AFFIN: -AFF_V1 *DVERSION: 2 *ATOMIZE: *TEXT: The path name of the directory to which a filesystem is mounted. Symptoms / Diagnostics: Running an OS agent report that relies on DISK attributes will fail resulting in an error reporting - 'sqlPrepareWithOptions' status='-69' UDA-SQL-0107 A general exception has occurred during the operation "prepare". ORA-00904: "Disk_HV"."LAT_Mount_Point_U": invalid identifier Reviewing the contents of TDW database tables, the column cited in the error as an invalid identifier does not exist in the Disk summary tables / views. Additional Keywords / information: dWAnswer: Getting error 'SQL0206N "Disk_DV.LAT_Mount_Point_U" is not valid in the context where it is used' , when running Disk Utilization reports for UNIX OS Agent https://developer.ibm.com/answers/questions/383579/getting-error -sql0206n-disk-dvlat-mount-point-u-is.html RTC defect 106942
*NOTE* use of local fix may result in loss of historical data when dropping aggregate summary tables / views. Any data that has been pruned from the raw historical table due to Summarization / Pruning settings for DISK attribute group can not be recreated and reinserted into the aggregate tables. 1. Edit dockux under TEPS <CANDLEHOME>/cq/data directory. In the table UNIXDISK edit the section for the column UMOUNTPT (Mount_Point_U) remove the line: *OPTION: PRIMARYKEY=1 and replace it with the line: *BEHAV: PROPERTY The resulting segment for this column definition should be: *ATTR: Mount_Point_U *CAPTION: Mount\Point (Unicode) *COLUMN: UMOUNTPT *TYPE: S,768 *BEHAV: PROPERTY *DOMAIN: UTF8L768 *REM: *AFFIN: -AFF_V1 *DVERSION: 2 *ATOMIZE: *TEXT: The path name of the directory to which a file system is mounted. 2. Stop KSY agent: /opt/IBM/devops/ITM/bin/itmcmd agent stop sy 3. Drop the aggregated Disk tables and views in WAREHOUS database: drop table ITMUSER."Disk_D"; drop table ITMUSER."Disk_H"; drop table ITMUSER."Disk_M"; drop table ITMUSER."Disk_Q"; drop table ITMUSER."Disk_W"; drop table ITMUSER."Disk_Y"'; drop view ITMUSER."Disk_DV"; drop view ITMUSER."Disk_HV"; drop view ITMUSER."Disk_MV"; drop view ITMUSER."Disk_QV"; drop view ITMUSER."Disk_WV"; drop view ITMUSER."Disk_YV"; 4. Edit ksy config file (<CANDLEHOME>/config/sy.ini) and add KSY_ON_DEMAND=Y 5. Start KSY agent: <CANDLEHOME>/bin/itmcmd agent start sy 6. Check to see if LAT_Mount_Point_U column is created in aggregated disk tables and views. For example: db2 connect to WAREHOUS user ITMUSER using <ITMUSER password> db2 describe table \"Disk_D\" |grep LAT_Mount_Point_U 7. Once LAT_Mount_Point_U column is created comment out KSY_ON_DEMAND=Y in SY config file - sy.ini, and recycle KSY agent.
The reports have been updated to account for the change in the primary key.
The fix for this APAR has been included in patch which can be downloaded from Fix Central: http://www.ibm.com/support/docview.wss?uid=ibm10729517
Reported component name
OS AGENT TCR RP
Reported component ID
NoSpecatt / Xsystem
Last modified date
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fixed component name
OS AGENT TCR RP
Fixed component ID
Applicable component levels