Platform Computing Corporation

Data Schema Tables for Platform Symphony 5.1

This package is intended for users of the Platform Symphony software ("Symphony"). You do not need to understand the data schema to use the reporting features in Symphony. Platform provides this table as a convenience for experienced database administrators only.

Note that Microsoft SQL Server data types and Oracle data types do not always match exactly. The following table shows the relevant data type mapping for SQL Server and Oracle databases.

SQL Server Oracle
VARCHAR VARCHAR2
NUMERIC NUMBER
TEXT CLOB
DATETIME TIMESTAMP

RESOURCE_METRICS

This table contains the dynamic resource data as sampled from the host. The resource type is "Host" and the resource name is the name of the host.

Column Name Data Type Null (Y/N) Key (PK/FK) Comment
ATTRIBUTE_NAME VARCHAR(256) N PK The name of the resource attributes. The following metrics are collected:
  • ls: Number of login sessions.
  • r15m: 15-minute run queue length.
  • r15s: 15-second run queue length.
  • r1m: 1-minute run queue length.
  • ut: CPU utilization (%).
  • io: Disk I/O rate (KB/s).
  • mem: Available memory (MB).
  • swp: Available swap space (MB).
  • maxmem: Maximum memory available (MB).
  • maxswp: Maximum swap space available (MB).
  • maxtmp: Maximum space in /tmp (MB).
  • pg: Paging rate (pg/s).
  • Number of free slots.
  • Total number of slots.
  • Host status (OK, UNAVAILABLE, or CLOSED)
  • Numeric host-based load indices collected by the external ELIM of plug-in data sources.
  • nprocs: Number of physical processors. If ncpus is defined as processors, ncpus=nprocs.
  • ncores: Number of cores per processor. If ncpus is defined as cores, ncpus=nprocs*ncores.
  • nthreads: Number of threads per core. If ncpus is defined as threads, ncpus=nprocs*ncores*nthreads.
  • cit: Amount of time that the CPU has been idle (minutes). This is configurable in elim.sa.
  • cit_t: CPU idle time threshold (minutes). This is a configurable external attribute.
  • cu_t: CPU utilization threshold (%). This is a configurable external attribute.
  • uit_t: User idle time threshold (minutes). This is a configurable external attributes.
  • processpri: OS priority of cluster workloads (normal or lowest).
CLUSTER_NAME VARCHAR(128) N PK The name of the cluster.
RESOURCE_NAME VARCHAR(128) N PK The resource name. For resource_type="Host", this is the name of the host.
RESOURCE_TYPE VARCHAR(128) N PK The resource type. This table only logs host-related dynamic resource attributes. Therefore, this field is always "Host".
TIME_STAMP_GMT NUMERIC(13) N PK The record sample time in the GMT time zone. This is the number of seconds from midnight, 1 January, 1970.
ATTRIBUTE_TYPE VARCHAR(128) N   The attribute value data type: "String" or "Numeric".
TIME_STAMP DATETIME N   The record sample time in the local cluster time zone. This is based on the time of the host running the data loader.
ATTRIBUTE_VALUE_NUM NUMERIC(14,4) Y   The numeric attribute value.
ATTRIBUTE_VALUE_STR VARCHAR(128) Y   The attribute value converted into a string. Numeric data types are not converted.
INSERT_SEQ NUMERIC(18) Y   The order of sequence in which this record is inserted into the table. This field is auto-incremented whenever a new record is inserted into the table.

Technical Support

Email support@platform.com
Web www.platform.com
Contact information www.platform.com/company/contact-us

Copyright

© 1994 - 2011 Platform Computing Corporation

All Rights Reserved.

Although the information in this document has been carefully reviewed, Platform Computing Corporation ("Platform") does not warrant it to be free of errors or omissions. Platform reserves the right to make corrections, updates, revisions or changes to the information in this document.

UNLESS OTHERWISE EXPRESSLY STATED BY PLATFORM, THE PROGRAM DESCRIBED IN THIS DOCUMENT IS PROVIDED "AS IS" AND WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT WILL PLATFORM COMPUTING BE LIABLE TO ANYONE FOR SPECIAL, COLLATERAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING WITHOUT LIMITATION ANY LOST PROFITS, DATA, OR SAVINGS, ARISING OUT OF THE USE OF OR INABILITY TO USE THIS PROGRAM.

Document redistribution policy: This document is protected by copyright and you may not redistribute or translate it into another language, in part or in whole. You may only redistribute this document internally within your organization (for example, on an intranet).

Trademarks

LSF is a registered trademark of Platform Computing Corporation in the United States and in other jurisdictions.

ACCELERATING INTELLIGENCE, THE BOTTOM LINE IN DISTRIBUTED COMPUTING, PLATFORM COMPUTING, CLUSTERWARE, PLATFORM ACTIVECLUSTER, IT INTELLIGENCE, SITEASSURE, PLATFORM SYMPHONY, PLATFORM JOBSCHEDULER, PLATFORM INTELLIGENCE, PLATFORM INFRASTRUCTURE INSIGHT, PLATFORM WORKLOAD INSIGHT, and the PLATFORM and LSF logos are trademarks of Platform Computing Corporation in the United States and in other jurisdictions.

UNIX is a registered trademark of The Open Group in the United States and in other jurisdictions.

Microsoft is either a registered trademark or a trademark of Microsoft Corporation in the United States and/or other countries.

Windows is a registered trademark of Microsoft Corporation in the United States and other countries.

Other products or services mentioned in this document are identified by the trademarks or service marks of their respective owners.