IBM Support

IC76597: WLM - UOW_TOTAL_TIME_TOP IS NOT RESET

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • UOW_TOTAL_TIME_TOP value does not get reset.
    
    
    Example:
    
    
    $ db2 "select substr(service_superclass_name,1,25),
    substr(service_subclass_name,1,25), uow_total_time_top,
    last_reset from table(wlm_get_service_subclass_stats_v97('', '',
    -2)) t"
    
    1                         2
    UOW_TOTAL_TIME_TOP   LAST_RESET
    ------------------------- -------------------------
    -------------------- --------------------------
    SYSDEFAULTSYSTEMCLASS     SYSDEFAULTSUBCLASS
          - 2011-05-24-13.28.31.478023
    SYSDEFAULTMAINTENANCECLAS SYSDEFAULTSUBCLASS
          - 2011-05-24-13.28.31.478075
    SYSDEFAULTUSERCLASS       SYSDEFAULTSUBCLASS
          - 2011-05-24-13.28.31.478126
    
    
    
    
    $ db2 "alter service class sysdefaultsubclass under
    sysdefaultuserclass collect aggregate activity data base"
    DB20000I  The SQL command completed successfully.
    
    
    $ db2 "select substr(service_superclass_name,1,25),
    substr(service_subclass_name,1,25), uow_total_time_top,
    last_reset from ta>
    
    1                         2
    UOW_TOTAL_TIME_TOP   LAST_RESET
    ------------------------- -------------------------
    -------------------- --------------------------
    SYSDEFAULTSYSTEMCLASS     SYSDEFAULTSUBCLASS
          - 2011-05-24-13.28.31.478023
    SYSDEFAULTMAINTENANCECLAS SYSDEFAULTSUBCLASS
          - 2011-05-24-13.28.31.478075
    SYSDEFAULTUSERCLASS       SYSDEFAULTSUBCLASS
          5 2011-05-24-13.28.59.766290
    
    
    $ db2 "select * from syscat.columns order by colname" >
    /dev/null
    
    $ db2 "select substr(service_superclass_name,1,25),
    substr(service_subclass_name,1,25), uow_total_time_top,
    last_reset from ta>
    
    1                         2
    UOW_TOTAL_TIME_TOP   LAST_RESET
    ------------------------- -------------------------
    -------------------- --------------------------
    SYSDEFAULTSYSTEMCLASS     SYSDEFAULTSUBCLASS
          - 2011-05-24-13.28.31.478023
    SYSDEFAULTMAINTENANCECLAS SYSDEFAULTSUBCLASS
          - 2011-05-24-13.28.31.478075
    SYSDEFAULTUSERCLASS       SYSDEFAULTSUBCLASS
        922 2011-05-24-13.28.59.766290
    
    
    
    $ db2 "call wlm_collect_stats"
    
      Return Status = 0
    
    
    $ db2 "select substr(service_superclass_name,1,25),
    substr(service_subclass_name,1,25), uow_total_time_top,
    last_reset from ta>
    
    1                         2
    UOW_TOTAL_TIME_TOP   LAST_RESET
    ------------------------- -------------------------
    -------------------- --------------------------
    SYSDEFAULTSYSTEMCLASS     SYSDEFAULTSUBCLASS
          - 2011-05-24-13.31.13.598868
    SYSDEFAULTMAINTENANCECLAS SYSDEFAULTSUBCLASS
          - 2011-05-24-13.31.13.598868
    SYSDEFAULTUSERCLASS       SYSDEFAULTSUBCLASS
        922 2011-05-24-13.31.13.598868
    
    
    
    Expected result: value should have changed to a smaller value.
    Actual result: value stays the same as before.
    

Local fix

Problem summary

  • WLM - UOW_TOTAL_TIME_TOP IS NOT RESET
    

Problem conclusion

  • The problem is first fixed in v9.7 Fix Pack 5 (s111017)
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC76597

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-05-24

  • Closed date

    2011-12-16

  • Last modified date

    2011-12-16

  • 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

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC76597

Modified date: 16 December 2011