Platform Computing Corporation

 

Data Schema Table for Platform EGO 1.2

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.

ALLOCATION_ EVENT

This table contains the event data of the allocation request.

 

Column Name

Data Type

Null(Y/N)

Key (PK/FK)

Comment

EVENT_TYPE

VARCHAR(64)

N

PK

The type of event (ALLOC_NEW, ALLOC_UPDATE, or ALLOC_DONE).

EVENT_TIME

TIMESTAMP

N

 

The event time in the local server time zone.

EVENT_TIME_GMT

NUMERIC(13)

N

PK

The event time in GMT time. This is the number of seconds from midnight, January 1st, 1970.

ALLOCATION_ID

VARCHAR(64)

N

PK

The allocation record ID.

ALLOCATION_NAME

VARCHAR(128)

Y

 

The name of the allocation.

CLIENT

VARCHAR(128)

Y

 

The name of the requesting client.

CONSUMER_NAME

VARCHAR(4000)

Y

 

The name of the consumer.

RESOURCE_GROUP

VARCHAR(256)

Y

 

The allocated resource group.

FILTER

CLOB

Y

 

The filter requirement.

MIN_SLOT

NUMERIC(10)

Y

 

The minimum number of requested slots.

MAX_SLOT

NUMERIC(10)

Y

 

The maximum number of requested slots.

FLAGS

NUMERIC(10)

Y

 

The flags for this allocation request.

TILE

NUMERIC(10)

Y

 

The tile for this allocation request.

HOSTS

CLOB

Y

 

The list of allocated hosts.

BLHOSTS

CLOB

Y

 

The list of blocked hosts.

RESOURCE_GROUP_LISTS

 

CLOB

Y

 

The list of allocated resource groups.

USER_NAME

VARCHAR(256)

Y

 

Reserved for future use. The requesting user name.

CONTAINER_ID

NUMERIC(10)

Y

 

Reserved for future use. The requesting container ID.

FILE_POSITION

NUMERIC(30)

N

PK

The file position of the allocation record in the event file.

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

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

Copyright

© 1994 - 2006 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, 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.