IV99022: AE IV75662 - ERROR LOADING UNIX OS REPORTS DUE TO MISSING LAT_MOUNT_POINT_U COLUMN IN AGGREGATED DISK TABLES AND VIEWS.

IBM Tivoli Monitoring OS Agent Reports - APAR IV99022

APAR status

• Closed as program error.

Error description

• 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
  

Local fix

• *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.
  

Problem summary

• The reports have been updated to account for the change in the
  primary key.
  

Problem conclusion

• 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
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  OS AGENT TCR RP

• Fixed component ID

  5724C04OS

Applicable component levels

• R630 PSY

     UP