Platform Computing Corporation
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 |
This table contains the event data of the allocation request.
Column Name | Data Type | Null (Y/N) | Key (PK/FK) | Comment |
---|---|---|---|---|
ALLOCATION_ID | VARCHAR(64) | N | PK | The allocation record ID. |
CLUSTER_NAME | VARCHAR(128) | N | PK | The name of the cluster. |
EVENT_TIME_GMT | NUMERIC(13) | N | PK | The event time in the GMT time zone. This is the number of seconds from midnight, 1 January, 1970. |
EVENT_TYPE | VARCHAR(64) | N | PK | The type of event (ALLOC_NEW, ALLOC_UPDATE, or ALLOC_DONE). |
FILE_POSITION | NUMERIC(30) | N | PK | The file position of the allocation record in the event file. |
EVENT_TIME | DATETIME | N | The event time in the local server time zone. | |
ALLOCATION_NAME | VARCHAR(128) | Y | The name of the allocation. | |
BLHOSTS | TEXT | Y | The list of blocked hosts. | |
CLIENT | VARCHAR(128) | Y | The name of the requesting client. | |
CONSUMER_NAME | VARCHAR(4000) | Y | The name of the consumer. | |
CONTAINER_ID | NUMERIC(10) | Y | Reserved for future use. The requesting container ID. | |
FILTER | TEXT | Y | The filter requirement. | |
FLAGS | NUMERIC(10) | Y | The flags for this allocation request. | |
HOSTS | TEXT | Y | The list of allocated hosts. | |
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_SLOT | NUMERIC(10) | Y | The maximum number of requested slots. | |
MIN_SLOT | NUMERIC(10) | Y | The minimum number of requested slots. | |
RESOURCE_GROUP | VARCHAR(256) | Y | The allocated resource group. | |
RESOURCE_GROUP_LISTS | TEXT | Y | The list of allocated resource groups. | |
TILE | NUMERIC(10) | Y | The tile for this allocation request. | |
USER_NAME | VARCHAR(256) | Y | Reserved for future use. The requesting user name. |
support@platform.com | |
Web | www.platform.com |
Contact information | www.platform.com/company/contact-us |
© 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, 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.