IBM Support

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

Subscribe

You can track all active APARs for this component.

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

Temporary fix

Comments

APAR Information

  • APAR number

    IV99022

  • Reported component name

    OS AGENT TCR RP

  • Reported component ID

    5724C04OS

  • Reported release

    630

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-08-16

  • Closed date

    2018-08-29

  • Last modified date

    2018-08-29

  • 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



Document information

More support for: IBM Tivoli Monitoring V6
Tivoli Common Reporting TCR

Software version: 6.3.0

Reference #: IV99022

Modified date: 29 August 2018