Platform Computing Corporation

Data Schema Table for Platform EGO 1.2

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

CONSUMER_RESOURCELIST

This table contains consumer-host relationship data at each sampling point of the CONSUMER_RESOURCE_ALLOCATION table. This is sampled together with CONSUMER_RESOURCE_ALLOCATION. The default sample time is 5 minutes.

Column Name Data Type Null (Y/N) Key (PK/FK) Comment
CLUSTER_NAME VARCHAR(128) N PK This is the cluster name.
TIME_STAMP TIMESTAMP N   The record sample time in the local cluster time zone.
TIME_STAMP_GMT NUMERIC(13) N PK The record sample time in GMT time.
CONSUMER_NAME VARCHAR(4000) N PK The name of the consumer. This is the fully qualified consumer name.
RESOURCE_NAME VARCHAR(128) N PK The resource name for resource_type="Host"; this is the host name.
RESOURCE_TYPE VARCHAR(128) N PK The resource type. The default is "HOST".
RESOURCE_GROUP VARCHAR(256) N PK The resource group in which this host participated in.
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.

Technical Support

Email support@platform.com
Web www.platform.com
   
North America +1-905-948-4297
Europe +44-(0)-1256-370530
Asia +86 10 62381125
Toll-free 1-877-444-4573
   
Mail Platform Support
Platform Computing Inc.
3760 14th Avenue
Markham, Ontario
Canada L3R 3T7

Copyright

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