Data Model Adapter and Domain Category Specifications

DT Perf Sentry Adapter - DT Perf Sentry Server-Based Domain Categories

These domain categories represent a subset of data collected by Performance Sentry software that is available from Demand Technology Software. They focus on server-level activity and performance on the Windows platform. These adapter and domain category combinations use the server activity strategy for the staging and aggregating of data. A SAS IT Resource Management staging transformation is used in staging the data. The following table lists the various domain categories and staged tables that are output from the adapter staging job that is created by the Adapter Setup wizard.
Domain Categories for Staged Tables (DT Perf Sentry Server Domain Category)
Domain Category
Staged Table
Server ProcessorCpu
NTPRCSR
Server Network
NTINTRF
Server System
NTSYSTEM_ITRM
Server Disk
NTLGDSK
Server PhysicalDisk
NTPHDSK
Server PagingFile
NTPGNFL
These staged tables are input to a series of aggregation jobs that create aggregation tables across a spectrum of daily, weekly, monthly, and sub-hourly time periods. Hourly and shift-based activity is included in a number of these aggregation tables.
The following key classifications are found in this domain category:
  • Domain
  • System (Machine)
  • CPU ID
  • Disk ID
  • Network Interface
In all the domain categories that are listed in the previous table, one or more metrics are designated as key or ranked metrics. These metrics are included in special Key Metrics aggregation tables that are intended for longer aging periods and used for capacity planning and forecasting reporting. They are also included in other aggregation tables as ranked metrics to enable the comparison of resource usage among a large number of servers or other classifications within the data. For specific information about the key and ranked metrics for this adapter and domain category, see What Are Key Metrics?.
Report-ready data for this adapter focuses primarily on the following areas:
  • utilization of CPU, memory, queuing, cache, and paging on the global server level
  • utilization of CPU for individual CPU processors
  • utilization, response times, transfer rates, and wait and queuing for logical and physical disks
  • packet and data volume transfer activity, utilization, and queuing for network interfaces

DT Perf Sentry Adapter - DT Perf Sentry Exchange Domain Category

This domain category represents a subset of data that is collected by Performance Sentry software, which focuses on Microsoft Exchange server activity and performance on the Windows platform. This adapter and domain category combination uses the server activity strategy for the staging and aggregating of data. A SAS IT Resource Management staging transformation is used in staging the data. The following table lists the various domain categories and staged tables that are output from the adapter staging job that is created by the Adapter Setup wizard.
Domain Categories for Staged Tables (DT Perf Sentry Exchange Domain Category)
Domain Category
Staged Table
Exchange Mailbox Information Store
NTSMLBX
Exchange Information Store
NTMSEIS
Exchange Public Information Store
NTSPBLC
Exchange Private Information Store
NTSPRVT
Mail Server Activity
NTMSRVR
These staged tables are input to a series of aggregation jobs that create aggregation tables across a spectrum of daily, weekly, monthly, and sub-hourly time periods. Hourly and shift-based activity is included in a number of these aggregation tables.
The following key classifications are found in this domain category:
  • Domain
  • System (Machine)
  • Information Store ID
  • Mail Server ID
In all the domain categories that are listed in the previous table, one or more metrics are designated as key or ranked metrics. These metrics are included in special Key Metrics aggregation tables that are intended for longer aging periods and used for capacity planning and forecasting reporting. They are also included in other aggregation tables as ranked metrics to enable the comparison of resource usage among a large number of servers or other classifications within the data. For specific information about the key and ranked metrics for this adapter and domain category, see What Are Key Metrics?.
Report-ready data for this adapter focuses primarily on the following areas:
  • Remote Procedure Call (RPC) response times, transfer rates, and request and operation rates at the global Exchange server level
  • total and active user counts at the global Exchange server level
  • virtual memory utilization at the global Exchange server level
  • delivered, sent, and submitted messages and receive and send queue lengths for mailboxes and public and private information stores
  • message rates, data transfer rates, and queue lengths for Exchange mail servers

BMC Perf Mgr Adapter - BMC Perf Mgr Domain Category

This adapter and domain category combination uses the server activity strategy for the staging and aggregating of data. A SAS IT Resource Management staging transformation is used in staging the data. The following table lists the various domain categories and staged tables that are output from the adapter staging job that is created by the Adapter Setup wizard.
Domain Categories for Staged Tables (BMC Perf Mgr Domain Category)
Domain Category
Staged Table
CacheWindows
PTCACHE
CpuUnix
PTUCPU
CpuWindows
PTNTCPU
DiskUnix
PTUDISK
FilesystemUnix
PTUFSTM
KernelUnix
PTUKRNL
LogicalDiskWindows
PTLGDSK
MemoryUnix
PTUMMRY
MemoryWindows
PTMEMRY
NetworkUnix
PTUNWRK
NetworkWindows
PTNTWRK
Paging FileWindows
PTPGFLE
PhysicalDiskWindows
PTPHDSK
ProcessUnix
PTUPRCS
SwapUnix
PTUSWAP
SystemWindows
PTNTSYS
These staged tables are input to a series of aggregation jobs that create aggregation tables across a spectrum of daily, weekly, monthly, and sub-hourly time periods. Hourly and shift-based activity is included in a number of these aggregation tables. Filters that query the CPU instance are used to divide aggregation tables that contain global CPU measurements from those that contain individual CPU processor measurements.
The following key classifications are found in this domain category:
  • System (Machine)
  • CPU ID
  • Disk ID
  • Filesystem ID
  • Network Interface
In all the domain categories that are listed in the previous table, one or more metrics are designated as key or ranked metrics. These metrics are included in special Key Metrics aggregation tables that are intended for longer aging periods and used for capacity planning and forecasting reporting. They are also included in other aggregation tables as ranked metrics to enable the comparison of resource usage among a large number of servers or other classifications within the data. For specific information about the key and ranked metrics for this adapter and domain category, see What Are Key Metrics?.
Report-ready data for this adapter focuses primarily on the following areas:
  • utilization of CPU, memory, queuing, cache, paging, and swapping on the global server level
  • utilization of CPU for individual CPU processors
  • utilization, response times, transfer rates, and wait and queuing for physical disks
  • utilization of space for file systems
  • packet and data volume transfer activity, utilization, and queuing for network interfaces

HP Perf Agent and HP Reporter Adapters

This group of adapter and domain categories consists of the following entities that apply to both the HP Perf Agent and HP Reporter adapters:
  • Disk UNIX
  • Disk Windows
  • LogicalSystem UNIX
  • Network UNIX
  • Network Windows
  • ProcessorCpu UNIX
  • ProcessorCpu Windows
  • System UNIX
  • System Windows
These domain categories focus on server level activity and performance on the UNIX and Windows platforms. With recent changes made to data collection by HP Perf Agent and HP Reporter, it is possible to monitor the performance of logical systems that are configured as virtual guests of host servers. These adapters provide some support of the new technology of virtualization. Operating environments that are currently supported for virtualization are HP Virtual machines, AIX LPARs, and VMWARE ESX guests on Linux. These adapters use the server activity strategy for the staging and aggregating of data. A SAS IT Resource Management staging transformation is used in staging the data. The following table lists the various domain categories and staged tables that are output from the adapter staging job that is created by the Adapter Setup wizard.
Domain Categories for Staged Tables (HP Perf Agent and HP Reporter Domain Categories)
Domain Category
Staged Table
Processor CPU
PCSCPU
Network Activity
PCSNET
System, Global CPU, Queuing, Memory, Paging, Swap, Cache, Kernel, Global Disk, Global Network
PCSGLB
Disk Activity
PCSDSK
Logical and Virtual System CPU and Memory
PCSLS
These staged tables are input to a series of aggregation jobs that create aggregation tables across a spectrum of daily, weekly, monthly, and sub-hourly time periods. Hourly and shift-based activity is included in a number of these aggregation tables. Filters that query the operating system are used to divide aggregation tables that contain UNIX platform performance measurements from those that contain Windows platform performance measurements.
The following key classifications are found in this domain category:
  • System (Machine)
  • CPU ID
  • Disk ID
  • Network Interface
  • Logical System ID
  • Logical System name
In all the domain categories listed in the previous table, one or more metrics are designated as key or ranked metrics. These metrics are included in special Key Metrics aggregation tables that are intended for longer aging periods and used for capacity planning and forecasting reporting. They are also included in other aggregation tables as ranked metrics to enable the comparison of resource usage among a large number of servers or other classifications within the data. For specific information about the key and ranked metrics for this adapter and domain category, see What Are Key Metrics?.
Report-ready data for this adapter focuses primarily on the following areas:
  • utilization of CPU, memory, queuing, paging, swap, disk, and network on the global server level
  • utilization of CPU for individual CPU processors
  • utilization, response times, transfer rates, and wait and queuing for physical disks
  • packet and data volume transfer activity, utilization, queuing, and error rates for network interfaces
  • utilization of CPU and memory for logical systems to determine the share of resource utilization for the virtual guests associated with host servers

SAPR3 Adapter - Systems, Machines, Tasks, and Transactions

This group of adapter and domain categories consists of the following entities:
  • SAPR3 Adapter - SAP R/3 System Domain Category
  • SAPR3 Adapter - SAP R/3 Host Domain Category
  • SAPR3 Adapter - SAP R/3 System Host TaskType Domain Category
  • SAPR3 Adapter - SAP R/3 System TaskType Domain Category
  • SAPR3 Adapter - SAP R/3 TransactionCode Domain Category
SAP R/3 performance data is collected by using the SAS IT Management Adapter for SAP in conjunction with SAS/ACCESS to SAP R/3 software. This adapter and domain category combination uses the event hourly summarization strategy for the staging and aggregating of data. A SAS IT Resource Management staging transformation is used in staging the data. The following table lists the various domain categories and staged tables that are output from the adapter staging job that is created by the Adapter Setup wizard.
Domain Categories for Staged Tables (SAPR3 Adapter Domain Categories for Systems, Machines, Tasks, and Transactions)
Domain Category
Staged Table
System Summary
SAPSYS
System-Host Summary
SAPHST
System-Host-TaskType Summary
SAPSMT
System-TaskType Summary
SAPTSK
System-Transaction
SAPTRN
These staged tables are input to a series of aggregation jobs that create aggregation tables across a spectrum of daily, weekly, and monthly time periods. Hourly activity is included in a number of these aggregation tables. (There are no sub-hourly aggregation tables for this domain category due to the staged data being pre-summarized to the hourly level.) There are groups of aggregation tables that are created for each of the staged tables in the previous table. Filters that query the transaction code are used to exclude blank transaction codes from the system-transaction aggregation tables.
The following key classifications are found in this domain category:
  • System
  • Machine (Host or Application Server)
  • Account ID
  • Task Type
  • Transaction Code
  • Elapsed Time Goal
  • Program Name
There are metrics that are designated as key or ranked metrics. These metrics are included in a special Key Metrics aggregation table that is intended for longer aging periods and used for capacity planning and forecasting reporting. These metrics are also included in other aggregation tables as ranked metrics to enable the comparison of resource usage among various classification values within the data. For specific information about the key and ranked metrics for this adapter and domain category, see What Are Key Metrics?.
Report-ready data for this adapter focuses primarily on the following areas for various groups of classifications:
  • event, task type, and transaction counts
  • total and average values for CPU, database, elapsed, response, processing, overhead, wait, and RFC times
  • total and average values for database requests and physical database accesses and changes
  • total and average values for kilobytes of data transferred
  • request counts and time expended for sequential reads, direct reads, update, insert, and delete operations
  • counts of physical records read, updated, inserted, and deleted
  • lock counts

SAPR3 Adapter - SAPBTCH (Batch Job) and SAPWKLD (Workload)

SAP R/3 performance data is collected by using the SAS IT Management Adapter for SAP in conjunction with SAS/ACCESS to SAP R/3 software. This adapter and domain categories combination uses the event activity strategy for the staging and aggregating of data. A SAS IT Resource Management staging transformation is used in staging the data. The following table lists the various domain categories and staged tables that are output from the adapter staging job that is created by the Adapter Setup wizard.
Domain Categories for Staged Tables (SAPBTCH and SAPWKLD Domain Categories)
Domain Category
Staged Table
Batch Jobs
SAPBTCH
Workloads
SAPWKLD
These staged tables are input to a series of aggregation jobs that create aggregation tables for daily, weekly, and monthly time periods. (At this time, there is no hourly, sub-hourly, or shift-based activity in these aggregations.) There are several groups of aggregation tables that are created for each of the staged tables that are listed in the previous table. Filters that query transaction code are used to exclude blank transaction codes from the workload-related aggregation tables that focus on transaction activity.
The following key classifications are found in these domain categories:
  • System
  • Machine (Host or Application Server)
  • Account ID
  • Job Name
  • Transaction Code
  • Module
  • Sub-Application
  • Development Class
  • Task Type
  • Program Name
There are metrics that are designated as key or ranked metrics. These metrics are included in a special Key Metrics aggregation table that is intended for longer aging periods and used for capacity planning and forecasting reporting. These metrics are also included in other aggregation tables as ranked metrics to enable the comparison of resource usage among various classification values within the data. For specific information about the key and ranked metrics for this adapter and domain category, see What Are Key Metrics?.
Report-ready data for this adapter focuses primarily on the following areas for various groups of classifications:
  • event, job, and transaction counts
  • total and average values for CPU, database, elapsed, response, processing, overhead, wait, and RFC times
  • total and average values for database requests and physical database accesses and changes
  • total and average values for kilobytes of data transferred
  • request counts and time expended for sequential reads, direct reads, update, insert, and delete operations
  • counts of physical records read, updated, inserted, and deleted
  • lock counts

SAR Adapter - SAR Domain Category

This domain category represents a subset of data collected by the System Activity Reporter (SAR) utility on various UNIX environments and focuses on server level activity and performance on the UNIX platform. This adapter and domain category combination uses the server activity strategy for the staging and aggregating of data. A SAS IT Resource Management staging transformation is used in staging the data. The following table lists the various domain categories and staged tables that are output from the adapter staging job that is created by the Adapter Setup wizard.
Domain Categories for Staged Tables (SAR Domain Category)
Domain Category
Staged Table
Processor CPU
SARCPUB
Network Activity
SARIFAC
System, Global CPU, Queuing, Memory, Paging, Swap, Cache, Kernel
SAR
Disk Activity
SARDEV
These staged tables are input to a series of aggregation jobs that create aggregation tables across a spectrum of daily, weekly, monthly, and sub-hourly time periods. Hourly and shift-based activity is included in a number of these aggregation tables.
The following key classifications are found in this domain category:
  • System (Machine)
  • CPU ID
  • Disk ID
  • Network Interface
In all the domain categories that are listed in the previous table, one or more metrics are designated as key or ranked metrics. These metrics are included in special Key Metrics aggregation tables that are intended for longer aging periods and used for capacity planning and forecasting reporting. They are also included in other aggregation tables as ranked metrics to enable the comparison of resource usage among a large number of servers or other classifications within the data. For specific information about the key and ranked metrics for this adapter and domain category, see What Are Key Metrics?.
Report-ready data for this adapter focuses primarily on the following areas:
  • utilization of CPU, memory, queuing, cache, paging, and swapping on the global server level
  • utilization of CPU for individual CPU processors
  • utilization, response times, transfer rates, and wait and queuing for physical disks
  • packet and data volume transfer activity for network interfaces

SMF Adapter - RMF Domain Category

Resource Management Facility (RMF) data collection represents a subset of the following record types: 70, 71, 72, 74, 75, 77, and 78. These record types are collected by SMF on the z/OS platform. This adapter and domain category combination uses the server activity strategy for staging and aggregating data. MXG software is the primary tool that is used in staging the data. A SAS IT Resource Management staging transformation uses the MXG staged output to complete the staging of the data. The following table lists the various domain categories and staged tables that are output from the adapter staging job that is created by the Adapter Setup wizard.
The Adapter Setup Wizard Default Availability legend is applicable to the following RMF based tables:
  • 1 — Available when the Minimal configuration level is selected
  • 2 — Available when the Typical configuration level is selected
  • 3 — Available when the Full configuration level is selected
Domain Categories and Staged Tables Output from the Adapter Staging Job (RMF Report Group)
Domain Category
Staged Table
MXG Feeder Data Sets
Adapter Setup Wizard Default Availability
Comments and Significant Changes for SAS IT Resource Management 3.2
System-wide CPU, Memory, I/O, Queueing, Service Usage, and Paging and Swapping
XRMFSYS
RMFINTRV TYPE71
Yes - 1, 2, 3
New table. New metrics for hardware-based MSU and MIPS are included. zAAP and zIIP specialty engine metrics are included. Paging and swapping metrics are included.
System-wide CPU, Memory, I/O, Queueing, Workload measurements
XRMFINT
RMFINTRV
No
Legacy table with imbedded Workload measurements that are not normalized. New metrics for hardware-based MSU and MIPS are included. zAAP and zIIP specialty engine metrics are included.
Memory, Paging, Swapping
XTY71
TYPE71
Yes - 3
Legacy table. Large number of metrics are included in new XRMFSYS table.
LPAR CPU and Service usage activity by Sysplex per System
XASM70L
ASUM70LP
Yes - 1, 2, 3
New metrics for hardware-based MSU and MIPS are included. zAAP and zIIP specialty engine metrics are included.
LPAR CPU and Service usage activity by CEC
XASMCEL
ASUMCELP
Yes - 1, 2, 3
New metrics for hardware-based MSU and MIPS are included. zAAP and zIIP specialty engine metrics are included.
Workload Resource utilization
XRMFWKL
RMFWKLRV
Yes - 1, 2, 3
New table. Metrics are normalized by Workload ID and Description to enable easier reporting by workload. New metrics for software-based MSU and MIPS are included. zAAP and zIIP specialty engine metrics are included.
Goal Mode Period Resource utilization
XTY72GO
TYPE72GO
Yes - 1, 2, 3
New metrics for software-based MSU and MIPS are included. zAAP and zIIP specialty engine metrics are included.
Workload And Workload Period Cross Reference Resource utilization
XRMFWKP
TYPE72GO RMFWKLRV
Yes - 3
New table. Provides side-by-side view of Workloads and the Workload periods that comprise the individual workloads. New metrics for software-based MSU and MIPS are included. zAAP and zIIP specialty engine metrics are included.
Processor CPU utilization
XTY70CP
TYPE70
Yes - 3
zAAP and zIIP specialty engine metrics are now included.
Device Activity (Disk and Tape)
XTY74
TYPE74
Yes - 2
No changes.
Paging Data Set Activity
XTY75
TYPE75
Yes - 3
No changes.
These staged tables are input to a number of aggregation jobs that create aggregation tables across a spectrum of daily, weekly, monthly, and sub-hourly time periods. Hourly and shift-based activity is included in many of these aggregations. These aggregations are structured by domain categories. In some cases, domain categories are further broken down into subsets of aggregations known as sub-categories. The following table summarizes these domain categories and sub-categories.
Domain Categories for Staged Tables (RMF Report Group)
Domain Category Area
Staged Table Used as Input
Domain Category Name
Sub-Category Names
Adapter Setup Wizard Default Availability
Comments Specific to Sub-Category Aggregation Processing
System-wide CPU, Memory, I/O, Service usage, Paging, and Swapping
XRMFSYS
RMF System
Yes - 1, 2, 3
System-wide CPU, Memory, I/O, Queuing, Workload measurements
XRMFINT
RMF Interval
No
Memory, Paging, Swapping
XTY71
RMF Paging and Swapping
Yes - 3
LPAR CPU and Service usage activity by Sysplex per System
XASM70L
RMF Lpar
Yes - 1, 2, 3
LPAR CPU and Service usage activity
XASMCEL
RMF CecLpar
Yes - 1, 2, 3
Workload Resource utilization
XRMFWKL
RMF Workload
Yes - 1, 2, 3
Goal Mode Period Resource utilization
XTY72GO
RMF GoalModeService
GoalModeService
Yes - 1, 2, 3
No filters used, so all Response time types are included
Goal Mode Period Resource utilization
XTY72GO
RMF GoalModeService
ServicePctResponse
No
Filter used to select only Percentile Response response type activity
Goal Mode Period utilization
XTY72GO
RMF GoalModeService
ServiceExVelocity
No
Filter used to select only Execution Velocity response type activity
Goal Mode Period utilization
XTY72GO
RMF GoalModeService
ServiceSysDiscrete
No
Filter used to select only System Discretionary response type activity
Workload and Workload Period Cross Reference Resource utilization
XRMFWKP
RMF WorkloadPeriod
Yes - 3
These aggregations contain a composite set of metrics that cross-reference workloads and workload periods
Processor CPU utilization
XTY70CP
RMF Processor
ProcessorCpu
Yes - 3
Filter used to select only Standard engine processor activity
Processor CPU utilization
XTY70CP
RMF Processor
EnginIfaZip
Yes - 3
Filter used to select only specialty (zAAP and zIIP) engine processor activity
Device Activity (Disk)
XTY74
RMF Device
Disk
Yes - 2, 3
Filter used to select only Disk-related activity
Device Activity (Tape)
XTY74
RMF Device
Tape
Yes - 3
Filter used to select only Tape related activity
Paging Data Set Activity
XTY75
RMF PagingFile
Yes - 3
The following key classifications are found in this domain category:
  • Sysplex
  • CEC
  • System (Machine)
  • CPU ID
  • LPAR name
  • LPAR number-name concatenation
  • Service Class
  • Service Class Period
  • Workload ID
  • Workload ID-Description concatenation
  • Workload Period
  • Device Number or Volume
  • Paging data set name
In all the domain categories that are listed in the previous table, one or more metrics are designated as key or ranked metrics. These metrics are included in special Key Metrics aggregation tables that are intended for longer aging periods and used for capacity planning and forecasting reporting. They are also included in other aggregation tables to enable the comparison of resource usage among various classification values within the aggregated data. They also provide the ability to filter on the top or bottom rated resource values within a set of classification values. The latter ranking filters are very useful to limit the number of reports that are created to those classifications with the greatest or the least resource utilization. For specific information about the key and ranked metrics for this adapter and domain category, see What Are Key Metrics?.
Report-ready data for this adapter focuses primarily on the following domain categories:
  • utilization of CPU, memory, queuing, paging, and swap activity on the global server level
  • CPU-based hardware MSU and MIPS usage on the global server level and by Processor engine type
  • utilization of CPU and level of service measurements by logical partition (LPAR)
  • CPU-based hardware MSU and MIPS usage by LPAR and by Processor engine type
  • utilization of CPU for individual CPU processors
  • utilization of CPU, memory, I/O, and level of service measurements by defined workload
  • CPU-based software MSU and MIPS usage by defined workload and by Processor engine type
  • utilization of CPU, memory, I/O, and level of service measurements by defined Service class and period
  • CPU-based software MSU and MIPS usage by defined Service class and period and by Processor engine type
  • utilization, response times, and wait and queuing for devices (disk and tape)

SMF Adapter - Jobs, TSO, and OMVS Domain Categories

Batch Job, TSO session, and OMVS session data collection represents a subset of record types (6, 26, and 30) collected by SMF on the z/OS platform. The full complement of data that is collected by SMF for these record types contains performance measurements for batch jobs, TSO sessions, started tasks, Open Edition MVS sessions, and APPC tasks. For SAS IT Resource Management 3.2, this domain category focuses solely on Batch job, TSO sessions, and OMVS session activity. This adapter and domain category combination uses the event activity strategy for the staging and aggregating of data. MXG software is the primary tool that is used in staging the data. A SAS IT Resource Management staging transformation uses the MXG staged output as input and then completes the staging of the data. The following table lists the various domain categories and staged tables that are output from the adapter staging job that is created by the Adapter Setup wizard.
Domain Categories and Staged Tables Output from the Adapter Staging Job (Jobs, TSO, and OMVS Domain Categories)
Domain Category
Staged Table
MXG Feeder Data Sets
Adapter Setup Wizard Default Availability
Comments and Significant Changes for SAS IT Resource Management 3.2
Batch Job activity and performance
XJOBS
JOBS
Yes - 1, 2, 3
New metrics for software-based MSU and MIPS are included. zAAP and zIIP specialty engine metrics are included.
TSO Session activity and performance
XJOBS
JOBS
Yes - 1, 2, 3
New metrics for software-based MSU and MIPS are included. zAAP and zIIP specialty engine metrics are included.
OMVS Session activity and performance
XJOBS
JOBS
Yes - 1, 2, 3
New metrics for software-based MSU and MIPS are included. zAAP and zIIP specialty engine metrics are included. OMVS activity performance is new.
This staged table is input to a number of aggregation jobs that create aggregation tables across a spectrum of daily, weekly, and monthly time periods. Shift-based activity is included in a number of these aggregation tables. These aggregations are structured by domain categories. All domain categories in this group are further broken down into subsets of aggregations known as sub-categories. The following table summarizes these domain categories and sub-categories.
Domain Categories for Staged Tables (Jobs, TSO, and OMVS Domain Categories)
Domain Category
Staged Table Used as Input
Domain Category Name
Sub-Category Names
Adapter Setup Wizard Default Availability
Comments Specific to Sub-Category Aggregation Processing
Batch Job activity and performance
XJOBS
JOBS
JobAbends
Yes - 1, 2, 3
Filter used to select only Jobs that have abended
JobClass
Yes - 1, 2, 3
Job activity is summarized by Job class
JobDetail
Yes - 3
Filter used to select activity for individual jobs that use some resources. These aggregations can be quite high in volume.
JobGroup
Yes - 2, 3
Job activity is summarized by Groups of users
JobMachine
Yes - 2, 3
Job activity is summarized by Machine
JobServiceClass
Yes - 3
Job is summarized by Service class
JobSummary
Yes - 1, 2, 3
Job activity is summarized by Job name
JobUser
Yes - 2,3
Job activity is summarized by User
JobSysplex
No
Job activity is summarized by Sysplex
JobSystemName
No
Job activity is summarized by SystemName
JobTape
No
Filter used to select only Jobs that have used Tape resource
TSO Sessions activity and performance
XJOBS
TSO
TsoAbends
No
Filter used to select only TSO sessions that have abended
TsoDetail
Yes - 3
Filter used to select activity for individual TSO sessions that use some resources
TsoGroup
Yes - 2, 3
TSO session is summarized by Groups of users
TsoMachine
Yes - 2, 3
TSO session activity is summarized by Machine
TsoServiceClass
No
TSO session activity is summarized by Service class
TsoSummary
Yes - 2, 3
TSO session activity is summarized by Session mane
TsoSysplex
No
TSO session is summarized by Sysplex
TsoSystemName
No
TSO session is summarized by System name
TsoUser
Yes - 2, 3
TSO session activity is summarized by User
OMVS Session activity and performance
XJOBS
OMVS
OmvsAbends
No
Filter used to select only OMVS sessions that have abended
OmvsDetail
Yes - 3
Filter used to select activity for individual OMVS sessions that use some resources
OmvsGroup
Yes - 2, 3
OMVS session activity is summarized by Groups of users
OmvsMachine
Yes - 2, 3
OMVS session activity is summarized
OmvsServiceClass
No
OMVS session activity is summarized by Service class
OmvsSummary
Yes - 2, 3
OMVS session activity is summarized by Session name
OmvsSysplex
No
OMVS session activity is summarized by Sysplex
OmvsSystemName
No
OMVS session activity is summarized by System name
OmvsUser
Yes - 2, 3
OMVS session activity is summarized by User
The following key classifications are found in this domain category:
  • Sysplex
  • System (Machine)
  • Job class
  • Job name
  • Job number, TSO session number, or OMVS session number
  • Service class
  • Group ID
  • User ID
In all the domain categories that are listed in the previous table, one or more metrics are designated as key or ranked metrics. Key metrics and specified statistics are included in special Key Metrics aggregations that are intended for longer aging periods and used for capacity planning and forecast reporting. Ranked metrics and specified statistics are included in other aggregation tables to enable the comparison of resource usage among various classification values within the aggregated data. They are also used to filter on the top or bottom rated resource values within a set of classification values. The latter ranking filters are very useful to limit the number of reports that are created to those classifications with the greatest or the least resource utilization. For specific information about the key and ranked metrics for this adapter and domain category, see What Are Key Metrics?.
Report-ready data for this adapter focuses primarily on the following domain categories:
  • job counts, TSO session counts, and OMVS session counts for various groups of classifications
  • accumulated service and times for CPU, memory, and I/O for individual batch jobs, TSO sessions, OMVS sessions across various groups of classifications
  • accumulated CPU-based software MSU and MIPS by Engine type for individual batch jobs, TSO sessions, and OMVS sessions across various groups of classifications
  • printing output associated with batch jobs and TSO sessions
  • utilization of tape resources for batch jobs
  • batch job, TSO session, and OMVS abends and associated return codes

SMF Adapter - CICS Domain Category

CICS data represents record type 110 collected by SMF on the z/OS platform. This adapter and domain category combination uses the event hourly summarization strategy for the staging and aggregating of data. MXG software is the primary tool that is used in staging the data and in performing the hourly summarization of the staged data. A SAS IT Resource Management staging transformation uses the MXG staged output as input, and then completes the staging of the CICS transaction data. The staging job generates the XCICSUM staged table as output. The following table lists the domain categories and staged tables that are output from the adapter staging job that is created by the Adapter Setup wizard.
Domain Categories and Staged Tables Output from the Adapter Staging Job
Domain Category
Staged Table
MXG Feeder Data Sets
Adapter Setup Wizard Default Availability
Comments and Significant Changes for SAS IT Resource Management 3.2
CICS transaction activity and performance
XCICSUM
CICS
Yes - 1, 2, 3
None
This staged table is input to a number of aggregation jobs that create aggregation tables across a spectrum of daily, weekly, and monthly time periods. Hourly and shift-based activity is included in many of these aggregations. There are no sub-hourly aggregations for this domain category because the staged data is pre-summarized to the hourly level. A filter that queries transaction ID is used to exclude all CICS management transactions from the aggregated data. Other filters can easily be created that can be used to exclude conversational transactions, and to include or exclude various operating environments (such as production, test, development, or quality assurance) from the aggregated data. These aggregations are structured by domain categories. All domain categories are further broken down into subsets of aggregations known as sub-categories. The following table summarizes these domain categories and sub-categories.
Domain Categories for Staged tables (CICS Domain Category)
Domain Category
Staged Table Used as Input
Domain Category Name
Sub-Category Names
Adapter Setup Wizard Default Availability
Comments Specific to Sub-Category Aggregation Processing
CICS transaction activity and performance
XCICSUM
CICS
CicsEnvironment
Yes - 2, 3
CICS transaction activity summarized by processing environment (that is, Production, Test, Development, Quality Assurance, and so on) as customized by the local site
CicsApplid
Yes - 1, 2, 3
CICS transaction activity summarized by Application Region
CicsApplidTran
Yes - 1, 2, 3
CICS transaction activity summarized by Application Region and Transaction ID
CicsSystem
No
CICS transaction activity summarized by Machine
CicsTran
Yes - 3
CICS transaction activity summarized by Transaction ID
CicsTranApplidUser
No
CICS transaction activity summarized by Application region, Transaction ID, and User ID
CicsuserTran
No
CICS transaction activity summarized by User ID and Transaction ID
The following key classifications are found in this domain category:
  • Processing environment
    Note: The customer must customize this value by adding code or logic to the staged table Environment column that computes the valid applicable values for the local customer site.
  • System (Machine)
  • Application region
  • Transaction ID
  • User ID
In all the domain categories that are listed in the previous table, one or more metrics are designated as key or ranked metrics. Key metrics and specified statistics are included in special Key Metrics aggregations that are intended for longer aging periods and used for capacity planning and forecasting reporting. Ranked metrics and specified statistics are included in other aggregation tables to enable the comparison of resource usage among various classification values within the aggregated data. They are also used to filter on the top or bottom rated resource values within a set of classification values. The latter ranking filters are very useful to limit the number of reports that are created to those classifications with the greatest or the least resource utilization. For specific information about the key and ranked metrics for this adapter and domain category, see What Are Key Metrics?.
Report-ready data for this adapter focuses primarily on the following areas, using the classifications previously specified:
  • transaction counts
  • average response time
  • average and accumulated CPU time
  • file access counts
  • counts and percentages of selected response time criteria
  • monitoring of service level objectives for transactions
Note: SAS IT Resource Management includes the new metrics that the ASUMCICX member creates. This MXG member is stored in the SAS IT Resource Management CPMISC PDS on z/OS, or the misc folder on UNIX, or the sasmisc folder on Windows. Before you use the ASUMCICX member, you must run the UTILEXCL MXG job. This job creates and implements the IMACEXCL member that is customized for your site. Documentation for ASUMCICX and UTILEXCL can be found inside each member.

SMF Adapter - DB2 Domain Category

DB2 data represents record type 101 collected by SMF on the z/OS platform. This adapter and domain category combination uses the event activity strategy for the staging and aggregating of data. MXG software is the primary tool that is used in staging the data. A SAS IT Resource Management staging transformation uses the MXG staged output as input, and then completes the staging of the DB2 accounting data. The staging job that the Adapter Setup wizard creates from the DB2 report group generates the XDBACCT staged table as output. The following table lists the various domain categories and staged tables that are output from the adapter staging job that is created by the Adapter Setup wizard.
Domain Categories and Staged Tables (DB2 Domain Category)
Domain Category
Staged Table
MSG Feeder Data Sets
Adapter Setup Wizard Default Availability
Comments and Significant Changes for SAS IT Resource Management 3.2
DB2 Batch job thread activity and performance
XDBACCT
DB2ACCT
Yes
DB2 CICS transaction thread activity and performance
XDBACCT
DB2ACCT
Yes
DB2 Global thread activity and performance (includes all categories of activity together, that is, batch jobs, CICS, and DDF)
XDBACCT
DB2ACCT
Yes
This staged table is input to a number of aggregation jobs that create aggregation tables across a spectrum of daily, weekly, and monthly time periods. Hourly and shift-based activity is included in many of these aggregations. These aggregations are structured by domain categories. All domain categories are further broken down into subsets of aggregations known as sub-categories. The following table summarizes these domain categories and sub-categories.
Domain Categories for Staged Tables (DB2 Domain Category)
Domain Category
Staged Table Used as Input
Domain Category Name
Sub-Category Names
Adapter Setup Wizard Default Availability
Comments Specific to Sub-Category Aggregation Processing
DB2 Batch Job thread activity and performance
XDBACCT
DB2 Batch
DB2BatchAttach
Yes - 3
Batch thread activity summarized by Attachment type
DB2BatchJobAttach
Yes - 1, 2, 3
Batch thread activity summarized by Job name and Attachment type
DB2BatchConName
Yes - 3
Batch thread activity summarized by Connection name
DB2BatchJopbConName
Yes - 2, 3
Batch thread activity summarized by Job name and Connection name
DB2BatchJob
Yes - 3
Batch thread activity summarized by Job name
DB2BatchLocation
Yes - 3
Batch thread activity summarized by Location
DB2BatchPlan
Yes - 3
Batch thread activity summarized by Plan name
DB2BatchJobPlan
Yes - 2, 3
Batch thread activity summarized by Job name and Plan name
DB2 CICS transaction thread activity and performance
XDBACCT
DB2 Cics
DB2CicsConName
No
CICS thread activity summarized by Connection name
DB2CicsCorrelate
No
CICS thread activity summarized by Correlation ID
DB2CicsPlan
Yes - 3
CICS thread activity summarized by Plan
DB2CicsTrans
No
CICS thread activity summarized by Transaction ID
DB2CicsTransPlan
Yes - 2, 3
CICS thread activity summarized by Transaction ID and Plan name
DB2 DDF thread activity and performance
XDBACCT
DB2 DDG
DB2DdfAttach
Yes - 2, 3
DDF thread activity summarized by Attachment type
DB2DdfJobAttach
Yes - 1, 2, 3
DDF thread activity summarized by Job name and Attachment type
DB2DdfClientAppl
No
DDF thread activity summarized by Client environment and Application name
DB2DdfNetLocation
Yes - 3
DDF thread activity summarized by Local and Remote network IDs and Location name
DB2DdfServClass
No
DDF thread activity summarized by Service class
DB2 Global thread activity and performance (includes all categories of activity, that is, batch jobs, CICS, and DDF)
XDBACCT
DB2 Global
DB2Environment
Yes - 3
DB2 thread activity summarized by processing environment (that is, Production, Test, Development, Quality Assurance, and so on) as customized by the local site
DB2Subsystem
Yes - 1, 2, 3
DB2 thread activity summarized by subsystem
DB2Attach
Yes - 3
DB2 thread activity summarized by Attachment type
DB2ConType
Yes - 2, 3
DB2 thread activity summarized by Connection type
DB2ThreadType
No
DB2 thread activity summarized by Thread type
DB2ConName
No
DB2 thread activity summarized by Connection name
DB2AttachConName
Yes - 1, 2, 3
DB2 thread activity summarized by Attachment type and Connection name
DB2Correlate
No
DB2 thread activity summarized by Correlation ID
DB2JobAttach
Yes - 2, 3
DB2 thread activity summarized by Job name and Attachment type
DB2Location
Yes - 3
DB2 thread activity summarized by Location name
DB2Plan
Yes - 2, 3
DB2 thread activity summarized by Plan name
DB2Trans
No
DB2 thread activity summarized by Transaction ID
The key classifications that are found in this domain category are:
  • Processing environment
    Note: The customer must customize this value by adding code or logic to the staged table Environment column in order to compute the valid applicable values for the local customer site. For optimal reporting, sites need to customize the classification column ENVIRONMENT to reflect the applicable Processing environments that are defined locally. This customization, which ideally is performed before any data collection, would typically correlate the processing environment with activity on one or more DB2 subsystems. For example, activity on DB2 subsystems DB2P and DB2A could be considered production work, so the ENVIRONMENT column could be set to 'Production' for them. Activity on DB2 subsystem DB2D could be considered development work, so the ENVIRONMENT column could be set to 'Development' for it. Activity on DB2 subsystem DB2Q could be considered quality assurance work, so the ENVIRONMENT column could be set to 'QA' or 'Quality Assurance' for it. Other criteria, along with the subsystem, might be used to establish the proper processing environment to be used in reporting. The customization of the ENVIRONMENT column is part of the staging transformation customization.
    To perform the customization, perform the following steps:
    1. Open the staging job that performs the staging of the DB2 accounting data (it outputs XDBACCT)
    2. Right-click XDBACCT and select Properties.
    3. Click the Columns tab.
    4. Scroll down to the ENVIRONMENT column.
    5. In the Expression column, replace the " " code with your replacement code that assigns the proper values for processing environment at your local site.
    6. To verify your code changes, stage some DB2 accounting data using the staging job. Then, review the output to check that the ENVIRONMENT column contains the values that you expect for your local site.
  • System (Machine)
  • DB2 subsystem
  • Connection type
  • Connection name
  • Attachment type
  • Plan name
  • Location name
  • Correlation ID
  • Authorization ID
  • Job name
  • Transaction ID
  • Network ID (Local and Remote)
  • Client platform
  • Client application
In all the domain categories that are listed in the previous table, one or more metrics are designated as key or ranked metrics. Key metrics and specified statistics are included in special Key Metrics aggregations that are intended for longer aging periods and used for capacity planning and forecasting reporting. Ranked metrics and specified statistics are included in other aggregation tables to enable the comparison of resource usage among various classification values within the aggregated data. They are also used to filter on the top or bottom rated resource values within a set of classification values. The latter ranking filters are very useful to limit the number of reports that are created to those classifications with the greatest or the least resource utilization. For specific information about the key and ranked metrics for this adapter and domain category, see What Are Key Metrics?.
Report-ready data for this adapter focuses primarily on the following areas, using the classifications previously specified:
  • thread counts
  • CPU, Elapsed, and I/O time in DB2
  • CPU and Elapsed total time (inside and outside DB2)
  • CPU and Elapsed percentages in DB2
  • lock, latch, and I/O wait time in DB2
  • lock escalations
  • SQL operations counts

SNMP Adapter - Network Activity, Device and Interface Data, and System Data

The SNMP adapter contains several domain categories that are based on MIB II SNMP metrics. The data that is collected by default by the SNMP adapter is focused on measuring network activity through several protocols (IP, TCP, UDP, and ICMP), as well as device and interface data and system data. The SAS IT Resource Management staging transformation for SNMP is used in staging the data. The following table lists the various staged tables that are output from the adapter staging job that is created by the Adapter Setup wizard.
Domain Categories for Staged Tables (SNMP Adapter Domain Categories for Network Activity)
Domain Category
Staged Table
Device and Interface data
SNMP_IF
System data
SNMP_System
IP protocol data
SNMP_IP
TCP protocol data
SNMP_TCP
ICMP protocol data
SNMP_ICMP
UDP protocol data
SNMP_UDP
These staged tables are input into a series of aggregation jobs that create aggregation tables across a spectrum of daily, weekly, and monthly time periods. Hourly and shift-based activity is included in a number of these aggregation tables, as well as several simple aggregations.
The following key classifications are found in these domain categories:
  • Device
  • Interface
In all the domain categories that are listed in the previous table, one or more metrics are designated as key or ranked metrics. These metrics are included in special Key Metrics aggregation tables that are intended for longer aging periods and used for capacity planning and forecasting reporting. They are also included in other aggregation tables as ranked metrics to enable the comparison of resource usage among a large number of servers or other classifications within the data. For specific information about the key and ranked metrics for this adapter and domain category, see What Are Key Metrics?.
Report-ready data for this adapter focuses primarily on the following areas:
  • Throughput - bits per second, packets or datagrams per second, packet sizes, and packet types
  • Error Rates
  • Utilization and Availability by interface
  • TCP Connections

VMware Adapter - Guest and Host Disk, Network, and System Domain Categories

These domain categories represent a subset of data stored in the VMware vCenter database. They focus on host and guest level activity and performance. These adapter and domain category combinations use the server activity strategy for the staging and aggregating of data. A SAS IT Resource Management staging transformation is used in staging the data. The following table lists the various domain categories and staged tables that are output from the adapter staging job that is created by the Adapter Setup wizard.
Domain Categories for Staged Tables (VMware vCenter Adapter)
Domain Category
Staged Table
Guest Disk
GUESTDISK
Guest Network
GUESTNETWORK
Guest System
GUESTSYSTEM
Host Disk
HOSTDISK
Host Network
HOSTNETWORK
Host System
HOSTSYSTEM
These staged tables are input to a series of aggregation jobs that create aggregation tables across a spectrum of daily, weekly, monthly, and sub-hourly time periods. Hourly and shift-based activity is included in a number of these aggregation tables.
The following key classifications are found in this domain category:
  • Cluster
  • Guest
  • Host
  • DiskUnit
In all the domain categories that are listed in the previous table, one or more metrics are designated as key or ranked metrics. These metrics are included in special Key Metrics aggregation tables that are intended for longer aging periods and used for capacity planning and forecasting reporting. They are also included in other aggregation tables as ranked metrics to enable the comparison of resource usage among a large number of servers or other classifications within the data. For specific information about the key and ranked metrics for this adapter and domain category, see What Are Key Metrics?.
Report-ready data for this adapter focuses primarily on the following areas:
  • utilization of CPU and memory, CPU ready, memory ballooning, and paging for Guests
  • utilization of CPU and memory, memory ballooning, and paging for Hosts
  • transfer rates and counts of reads and writes for disks
  • packet and data volume transfer activity for network interfaces

MS System Center Operations Manager - MS SCOM Server-Based Domain Categories

These domain categories represent a subset of data collected by a Microsoft product called System Center Operations Manager. They focus on server-level activity and performance on the Windows platform. These adapter and domain category combinations use the server activity strategy for the staging and aggregating of data. A SAS IT Resource Management staging transformation is used in staging the data. The following table lists the various domain categories and staged tables that are output from the adapter staging job that is created by the Adapter Setup wizard.
Domain Categories for Staged Tables (MS System Center Operations Manager for Server Domain Category)
Domain Category
Staged Table
Server Disk
SCOM_WinServerDisk
Server Network
SCOM_WinServerNwInterface
Server Paging File
SCOM_WinServerPagingFile
Server PhysicalDisk
SCOM_WinServerPhysicalDisk
Server ProcessorCpu
SCOM_WinServerProcessor
Server System
SCOM_WinServerSystem
These staged tables are input to a series of aggregation jobs that create aggregation tables across a spectrum of daily, weekly, monthly, and sub-hourly time periods. Hourly and shift-based activity is included in a number of these aggregation tables.
The following key classifications are found in this domain category:
  • System (Machine)
  • CPU ID
  • Disk ID
  • Network Interface
  • Paging File ID
In all the domain categories that are listed in the previous table, one or more metrics are designated as key or ranked metrics. These metrics are included in special KeyMetrics aggregation tables that are intended for longer aging periods and used for capacity planning and forecasting reporting. They are also included in other aggregation tables as ranked metrics to enable the comparison of resource usage among a large number of servers or other classifications within the data. For specific information about the key and ranked metrics for this adapter and domain category, see What Are Key Metrics?.
Report-ready data for this adapter focuses primarily on the following areas:
  • utilization of CPU and memory the global server level
  • utilization, response times, transfer rates, and wait and queuing for logical and physical disks

MS System Center Operations Manager Adapter - MS SCOM Exchange Domain Category

This domain category represents a subset of data that is collected by a Microsoft product called System Center Operations Manager, which focuses on Microsoft Exchange server activity and performance on the Windows platform. This adapter and domain category combination uses the server activity strategy for the staging and aggregating of data. A SAS IT Resource Management staging transformation is used in staging the data. The following table lists the various domain categories and staged tables that are output from the adapter staging job that is created by the Adapter Setup wizard.
Domain Categories for Staged Tables (MS System Center Operations Manager Exchange Domain Category)
Domain Category
Staged Table
Exchange Disk
SCOM_ExDisk
Exchange InfoStore
SCOM_InfoStore
Exchange InfoStoreMailbox
SCOM_Mailbox
Exchange InfoStorePublic
SCOM_Public
Exchange MailServer
SCOM_SmtpServer
Exchange Network
SCOM_ExNetworkInterface
Exchange Paging File
SCOM_ExPagingFile
Exchange PhysicalDisk
SCOM_ExPhysicalDisk
These staged tables are input to a series of aggregation jobs that create aggregation tables across a spectrum of daily, weekly, monthly, and sub-hourly time periods. Hourly and shift-based activity is included in a number of these aggregation tables.
The following key classifications are found in this domain category:
  • System (Machine)
  • Information Store ID
  • Mail Server ID
In all the domain categories that are listed in the previous table, one or more metrics are designated as key or ranked metrics. These metrics are included in special KeyMetrics aggregation tables that are intended for longer aging periods and used for capacity planning and forecasting reporting. They are also included in other aggregation tables as ranked metrics to enable the comparison of resource usage among a large number of servers or other classifications within the data. For specific information about the key and ranked metrics for this adapter and domain category, see What Are Key Metrics?.
Report-ready data for this adapter focuses primarily on the following areas:
  • Remote Procedure Call (RPC) response times, transfer rates, and request and operation rates at the global Exchange server level
  • total and active user counts at the mailboxes' information stores
  • delivered, sent, and submitted messages and receive and send queue lengths for mailboxes' information stores

Web Log Adapter - All Domain Categories

The Web Log adapter contains four domain categories that are supported by the Adapter Setup wizard. These domain categories represent different categorizations of the same, limited set of metrics that are available from Web logs. The data that is collected focuses on measuring page counts and requests, the size of those requests and the response time to service those requests. The SAS IT Resource Management staging transformation for Web Log is used in staging the data. The following table lists the various staged tables that are output from the adapter staging job that is created by the Adapter Setup wizard.
Domain Categories for Staged Tables (Web Log Adapter)
Domain Category
Staged Table
Browser Activity
WEBBRW
Server Activity
WEBSRV1
Visitor Organization Activity
WEBORG
Web Page Activity
WEBRSC
These staged tables are input into a series of aggregation jobs that create aggregation tables across a spectrum of daily, weekly, and monthly time periods. Hourly and shift-based activity is included in a number of these aggregation tables, but no simple aggregations are included.
The following key classifications are found in these domain categories:
  • Host Name
  • Site Name
  • Machine
  • Domain
  • Browser Name
  • State
  • Country
  • Organization Type
  • URL
  • Status
In all but the Browser Activity domain category, one or more metrics are designated as key or ranked metrics. These metrics are included in special Key Metrics aggregation tables that are intended for longer aging periods and used for capacity planning and forecasting reporting. They are also included in other aggregation tables as ranked metrics to enable the comparison of resource usage among a large number of servers or other classifications within the data. For specific information about the key and ranked metrics for this adapter and domain category, see What Are Key Metrics?.
Report-ready data for this adapter focuses primarily on the following metrics:
  • Bytes sent and received
  • Number of pages received
  • Number of requests sent
  • Response time
Copyright © SAS Institute Inc. All rights reserved.