Platform Computing Corporation

Data Schema Tables for Platform Symphony 5.0

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

CONSUMER_RESOURCE_ALLOCATION

This table contains the periodically sampled resource allocation status of each consumer/resource group combination and the planned resource allocation.

Column Name Data Type Null (Y/N) Key (PK/FK) Comment
CLUSTER_NAME VARCHAR(128) N PK The name of the cluster.
CONSUMER_NAME VARCHAR(4000) N PK The name of the consumer. This is the fully-qualified consumer name.
RESOURCE_GROUP VARCHAR(256) N PK The allocated resource group.
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.
TIME_STAMP DATETIME N   The record sample time in the local cluster time zone.
ALLOCATED_BORROW NUMERIC(10) Y   The allocated number of slots borrowed from the other consumer and resource group. If this is null, the value is 0. This is the real-time allocation at the time of this record.
ALLOCATED_LEND NUMERIC(10) Y   The allocated number of slots lent to other consumer and resource group. If this is null, the value is 0. This is the real-time allocation at the time of this record.
ALLOCATED_OWN NUMERIC(10) Y   The allocated slot value owned by this consumer and resource group at the time of this record. If this is null, the value is 0. This is the real-time allocation at the time of this record.
ALLOCATED_SHARE NUMERIC(10) Y   The allocated number of slots shared with the other consumer and resource group. If this is null, the value is 0. This is the real-time allocation at the time of this record.
BORROW_FROM TEXT Y   The consumer from which this resource is borrowed. This data is collected in real time.
BORROW_LIMIT NUMERIC(10) Y   The borrowing limit for this consumer and resource group. If this is null, the value is infinite. This is from the cluster configuration.
INSERT_SEQ NUMERIC(15) 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.
LENDING_LIMIT NUMERIC(10) Y   The lending limit for this consumer and resource group. If this is null, the value is infinite. This is from the cluster configuration.
LEND_TO TEXT Y   The consumer to which this resource is lent. This data is collected in real time.
PLANNED_OWN NUMERIC(10) Y   The own value from the distribution tree of this consumer resource group. If this is null, the value is 0. This is from the cluster configuration.
POTENTIAL_DEMAND NUMERIC(10) Y   Reserved for future use.
SHARE_LIMIT NUMERIC(10) Y   The maximum number of slots that this consumer can obtain from the resource group share pool. This data is from the cluster configuration.
SHARE_QUOTA NUMERIC(10) Y   The maximum number of slots that this consumer can obtain from the share pool for this consumer and resource group combination. This data is collected in real time.
SHARE_RATIO NUMERIC(15,10)/Double Y   The share ratio of share pool slots for this consumer and resource group. This data is from the cluster configuration.
TOTAL_DEMAND NUMERIC(10) Y   Reserved for future use.
UNSATISFIED_DEMAND NUMERIC(10) Y   Reserved for future use.
USED NUMERIC(10) Y   The actual number of allocated resources. This data is collected in real time.

CONSUMER_DEMAND

This table contains the periodically sampled data of the consumer demand of resources (slots).

Column Name Data Type Null (Y/N) Key (PK/FK) Comment
CLUSTER_NAME VARCHAR(128) N PK The name of the cluster.
TIME_STAMP DATETIME N   The record sample time in the local cluster time zone.
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.
CONSUMER_NAME VARCHAR(4000) N PK The name of the consumer. This is the fully-qualified consumer name.
INSERT_SEQ NUMERIC(15) 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.
MAX_REQUESTED NUMERIC(10) Y   The maximum number of resource requested by the consumer.
USED NUMERIC(10) Y   The actual number of allocated resources.

Technical Support

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

Copyright

© 1994 - 2009 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.