Platform Computing Corporation

Data Schema Table for Platform LSF 7.0

This package is intended for users of the Platform LSF software ("LSF"). 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.

LSF_SLA

This table contains the sampled Service Level Agreement (SLA) data. The default sampling time is five minutes.

Column Name Data Type Null (Y/N) Key (PK/FK) Comment
CLUSTER_NAME VARCHAR(128) N   The cluster name.
SLA_NAME VARCHAR(128) N   SLA Class Name
TIME_STAMP TIMESTAMP N   The record sample time in the local cluster time zone. It is based on the host running the data loader.
TIME_STAMP_GMT NUMBER(13) N   The record sample time in GMT time. This is the number of seconds from midnight, 1 January, 1970.
PRIORITY FLOAT Y   The priority for this SLA.
USER_GROUP CLOB Y   The users or user groups that can submit into this class.
ACTIVE_WINDOW CLOB Y   The active window of this class during this sample.
SLA_CONSUMER VARCHAR(128) Y   EGO-enabled SLA scheduling.
SLA_GOALTYPE VARCHAR(60) Y   The type of service class goal and its configured value:
  • THROUGHPUT
  • VELOCITY
  • DEADLINE
SLA_GOALVALUE NUMBER(13) Y   Goal value configurated by user, either deadline GMT, velocity or throughput.
SLA_DEADLINE TIMESTAMP Y   If the goal is "deadline", this value is deadline local time.
SLA_STATUS VARCHAR(30) Y   Current status of the service class goal:
  • "Active: On time": The goal is active and meeting its target.
  • "Active: Delayed": The goal is active but is missing its target.
  • "Inactive": The goal is not active and its time window is closed. Jobs are scheduled as if no service class is defined. LSF does not enforce any service-level goals for an inactive SLA.
SLA_OPTIMUM NUMBER(13) Y   The optimum job number
SLA_THROUGHPUT NUMBER(13) Y   The current throughput for the SLA finished jobs per clean period.
EST_FINISH_TIME TIMESTAMP Y   For goals with a time window, estimated finish time of the SLA. If the service class status is on time, the finish time will be before the configured deadline. If the service class status is delayed, the service class is missing its goal and bsla shows a finish time later than the deadline.
SLA_NJOBS NUMBER(10) Y   The current number of job slots used by jobs in the specified service class. A parallel job is counted as 1 job, regardless of the number of job slots it will use.
SLA_NPEND NUMBER(10) Y   The number of job slots used by the pre-pending jobs in the specified service class.
SLA_NPSUSP NUMBER(10) Y   The number of job slots used by the pre-pending jobs in the specified service class.
SLA_NRUN NUMBER(10) Y   The number of job slots used by running jobs in the specified service class.
SLA_NSSUSP NUMBER(10) Y   The number of job slots used by the system-suspended jobs in the specified service class.
SLA_NUSUSP NUMBER(10) Y   The number of job slots used by user-suspended jobs in the specified service class.
SLA_NEXIT NUMBER(10) Y   The number of job slots exited in the specified service class.
SLA_NDONE NUMBER(10) Y   The number of job done in the specified service class. This is equal to NEXIT+NDONE.
INSERT_SEQ NUMBER(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
Contact information www.platform.com/company/contact-us

Copyright

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