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.

ACTIVE_DESKTOP_ACEVENTS

This table contains LSF event data for downloaded and reported jobs in desktop hosts.

Column Name Data Type Null (Y/N) Key (PK/FK) Comment
EVENT_TYPE VARCHAR(64) N PK The event type. The valid values in this table are 2 (JOB_REPORT) and 4 (JOB_DOWNLOAD).
JOB_ID NUMBER(15) N PK The LSF-assigned job ID.
JOB_ARRAY_INDEX NUMBER(15) N PK The job array index. This is 0 by default.
TIME_STAMP_GMT NUMBER(13) N PK The time of this record in GMT time. This is the number of milliseconds from midnight, 1 January, 1970.
TIME_STAMP TIME_STAMP N   The event time in the local server time zone.
SED_ID VARCHAR(256) N PK The ID of the SED host that executed this job.
SED_VERSION NUMBER(10) N   The SED version number.
SED_PLUG_IN NUMBER(10) N   The plug-in version number.
EXITED_CODE NUMBER(10) Y   The last exit code of the job.
FAILURE_CODE NUMBER(10) Y   The last failure code of the job.
ELAPSED_TIME NUMBER(10) Y   The job run time.
USER_TIME NUMBER(10) Y   The portion of CPU time that the user spent for this job.
KERNEL_TIME NUMBER(10) Y   The portion of CPU time that the job spent inside the kernel.
STATE NUMBER(10) Y   The job state.
INSERT_SEQ NUMBER(10) 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.

ACTIVE_DESKTOP_JOBDATA

This table contains LSF event data for completed jobs in desktop hosts.
Column Name Data Type Null (Y/N) Key (PK/FK) Comment
TIME_STAMP TIMESTAMP N   The event time in the local cluster time zone. This is based on the host that runs the data loader.
TIME_STAMP_GMT NUMBER(13) N PK The time of this record in GMT time. This is the number of milliseconds from midnight, 1 January, 1970.
MED_HOST VARCHAR(256) N PK The name of the MED host in which this loader resides.
JOB_ID NUMBER(15) N PK The LSF-assigned job ID.
JOB_ARRAY_INDEX NUMBER(15) N PK The job array index.
NUMBER_OF_RERUN NUMBER(10) N PK The number of times the job has been rerun.
SED_ID VARCHAR(256) N PK The ID of the SED host that executed this job.
EXITED_CODE NUMBER(10) Y   The last exit code of the job.
FAILURE_CODE NUMBER(10) Y   The last failure code of the job.
ELAPSED_TIME NUMBER(10) Y   The job run time.
USER_TIME NUMBER(10) Y   The portion of CPU time that the user spent for this job.
KERNEL_TIME NUMBER(10) Y   The portion of CPU time that the job spent inside the kernel.
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.