Class Reference
Cache for UNIX 2018.1.1
InterSystems: The power behind what matters   
Documentation  Search
Private  Storage  

persistent class SYS.History.Daily extends %Persistent, %XML.Adaptor

This class is a Daily summary of the detail PerfData and SysData collections. For each class sample collected you may chose to have the Average, Maximum, Minimum, Median, Standard Deviation, and Total maintained for the day. By default Average, Maximum, and Standard Deviation are kept. Use the SetSummary method in each individual class (Performance, SystemUsage, etc.) to modify this. Performance counters (SYS.History.Performance) are normalized to a per-second rate for all the calculations.

This data can be manually purged using the Purge() method.

Inventory

Parameters Properties Methods Queries Indices ForeignKeys Triggers
10 2 4 1


Summary

Properties
DB DateTime Perf PerfCount Sys
SysCount WD WDCount ZDATE ZTIME

Methods
%AddToSaveSet %AddToSyncSet %BMEBuilt %CheckConstraints
%CheckConstraintsForExtent %ClassIsLatestVersion %ClassName %ComposeOid
%ConstructClone %Delete %DeleteExtent %DeleteId
%DispatchClassMethod %DispatchGetModified %DispatchGetProperty %DispatchMethod
%DispatchSetModified %DispatchSetMultidimProperty %DispatchSetProperty %Exists
%ExistsId %Extends %GUID %GUIDSet
%GetLock %GetParameter %GetSwizzleObject %Id
%InsertBatch %IsA %IsModified %IsNull
%KillExtent %KillExtentData %LoadFromMemory %LockExtent
%LockId %New %NormalizeObject %ObjectIsNull
%ObjectModified %Oid %OnBeforeAddToSync %OnDetermineClass
%Open %OpenId %OriginalNamespace %PackageName
%PhysicalAddress %PurgeIndices %Reload %RemoveFromSaveSet
%ResolveConcurrencyConflict %RollBack %Save %SaveDirect
%SaveIndices %SerializeObject %SetModified %SortBegin
%SortEnd %SyncObjectIn %SyncTransport %UnlockExtent
%UnlockId %ValidateIndices %ValidateObject Export
Purge XMLDTD XMLExport XMLExportToStream
XMLExportToString XMLNew XMLSchema XMLSchemaNamespace
XMLSchemaType


Properties

• property DB as array of SYS.History.Database;
Database metrics
• property DateTime as %TimeStamp;
Time of summary
• property Perf as array of SYS.History.Performance;
Performance metrics
• property PerfCount as %Integer;
Number of Performance samples in this Daily period
• property Sys as array of SYS.History.SystemUsage;
System Usage metrics
• property SysCount as %Integer;
Number of SystemUsage samples in this Daily period
• property WD as array of SYS.History.WriteDaemon;
WriteDaemon metrics
• property WDCount as %Integer;
Number of WriteDaemon cycles in this Daily period
• property ZDATE as %Integer;
UTC date key
• property ZTIME as %Integer;
UTC time key

Methods

• classmethod Export(FileName As %String, Start As %TimeStamp, End As %TimeStamp, Class As %String, Function As %String, Database As %String) as %Status
Export Daily data for a time range in CSV format. The default is all of the Perf, Sys and WD data currently in the Daily class.

The default FileName is HistoryDay_config_date_time.csv in the MGR directory.
'Start' and 'End' times (if necessary) are in YYYY-MM-DD HH:MM:SS format.
'Class' can be a comma-delimited list one or more of these classes of metrics: "Perf", "Sys", "WD". Or it can be "DB" to select the Database properties. The Database class can not be mixed with the other classes since it uses a different key structure to accommodate multiple databaes.
'Function' can be a comma-delimited list one or more of these summary functions: "Avg", "Max", "Min", StDev", Med" or "Tot". The default is to include all summary functions.
'Database' can be used to select a specific database (by name). Only used if "DB" is selected in 'Class'
• classmethod Purge(Date As %String) as %Integer
Purge Summary data. Purge all days prior to the 'Date' parameter (in YYYY-MM-DD format). Returns the number of days purged.

Queries

• query DBDateList(Start As %TimeStamp = $zdt($h-1, 3), End As %TimeStamp = $zdt($h, 3))
SQL Query :
SELECT DateTime,Daily_DB.* FROM Daily,Daily_DB
WHERE ((Daily.ID = Daily_DB.Daily) AND (DateTime >= :Start) AND (DateTime <= :End))
Full listing of Daily Database metrics for a day or range of date/times. Default is yesterday.
• query PerfDateList(Start As %TimeStamp = $zdt($h-1, 3), End As %TimeStamp = $zdt($h, 3))
SQL Query :
SELECT DateTime,Daily_Perf.* FROM Daily,Daily_Perf
WHERE ((Daily.ID = Daily_Perf.Daily) AND (DateTime >= :Start) AND (DateTime <= :End))
Full listing of Daily Performance metrics for a day or range of date/times. Default is yesterday.
• query SysDateList(Start As %TimeStamp = $zdt($h-1, 3), End As %TimeStamp = $zdt($h, 3))
SQL Query :
SELECT DateTime,Daily_Sys.* FROM Daily,Daily_Sys
WHERE ((Daily.ID = Daily_Sys.Daily) AND (DateTime >= :Start) AND (DateTime <= :End))
Full listing of Daily SystemUsage metrics for a day or range of date/times. Default is yesterday.
• query WDDateList(Start As %TimeStamp = $zdt($h-1, 3), End As %TimeStamp = $zdt($h, 3))
SQL Query :
SELECT DateTime,Daily_WD.* FROM Daily,Daily_WD
WHERE ((Daily.ID = Daily_WD.Daily) AND (DateTime >= :Start) AND (DateTime <= :End))
Full listing of Daily WriteDaemon metrics for a day or range of date/times. Default is yesterday.

Indices

• index (ZDTindex on ZDATE,ZTIME) [IdKey];


Copyright © 1997-2019, InterSystems Corporation