Release Date: November 2006
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 EGO. Platform provides this table as a convenience for experienced database administrators only.
This table contains the periodically sampled resource allocation status of each consumer/resource group combination and the planned resource allocation.
The default sampling time is 5 minutes.
Column Name |
Data Type |
Null(Y/N) |
Key (PK/FK) |
Comment |
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. This is the number of seconds from midnight, January 1st, 1970. |
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. |
ALLOCATED_OWN |
NUMERIC(10) |
Y |
|
The allocated slot value owned by this consumer at the time of this record. If this is null, the value is 0. |
ALLOCATED_SHARE |
NUMERIC(10) |
Y |
|
The allocated number of slots shared with the other resource_group. If this is null, the value is 0. |
ALLOCATED_BORROW |
NUMERIC(10) |
Y |
|
The allocated number of slots borrowed from the other resource_group. If this is null, the value is 0. |
ALLOCATED_LEND |
NUMERIC(10) |
Y |
|
The number of slots lend out from this consumer-resource group. If this is null, the value is 0. |
PLANNED_OWN |
NUMERIC(10) |
Y |
|
The own value from the distribution tree of this consumer-resource_group combination. If this is null, the value is 0. |
LENDING_LIMIT |
NUMERIC(10) |
Y |
|
The lending limit for this consumer from this resource_group. If this is null, the value is infinite. |
BORROW_LIMIT |
NUMERIC(10) |
Y |
|
The borrowing limit for this consumer from this resource_group. If this is null, the value is infinite. |
BORROW_FROM |
CLOB |
Y |
|
The consumer from which this resource is borrowed. |
USED |
NUMERIC(10) |
N |
|
The actual number of allocated resources. |
LEND_TO |
CLOB |
Y |
|
The consumer to which this resource is lent. |
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. |
This table contains the periodically sampled data of the consumer demand of resources (slots).
The data is sampled together with CONSUMER_RESOURCE_ALLOCATION and has the default sampling time of 5 minutes.
Column Name |
Data Type |
Null(Y/N) |
Key (PK/FK) |
Comment |
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. This is the number of seconds from midnight, January 1st, 1970. |
CONSUMER_NAME |
VARCHAR(4000) |
N |
PK |
The name of the consumer. This is the fully qualified consumer name. |
MAX_REQUESTED |
NUMERIC(10) |
N |
|
The maximum number of resource requested by the consumer. |
USED |
NUMERIC(10) |
N |
|
The actual number of allocated resources. |
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. |
support@platform.com
www.platform.com
North America: +1 905 948 4297
Europe: +44 1256 370 530
Asia: +86 10 6238 1125
Toll-free: 1-877-444-4573
Platform Support
Platform Computing Corporation
3760 14th Avenue
Markham, Ontario
Canada L3R 3T7
© 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).
LSF is
a registered trademark of Platform Computing Corporation in the United States
and in other jurisdictions.
ACCELERATING INTELLIGENCE, PLATFORM
COMPUTING, PLATFORM SYMPHONY, PLATFORM JOBSCHEDULER, PLATFORM ENTERPRISE GRID
ORCHESTRATOR, PLATFORM EGO, 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.