Platform Computing Corporation
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.
This table contains LSF event data.
Column Name | Data Type | Null (Y/N) | Key (PK/FK) | Comment |
---|---|---|---|---|
CLUSTER_NAME | VARCHAR(128) | N | PK | This is the cluster name. |
VERSION_NUMBER | VARCHAR(10) | N | The version of LSF. | |
EVENT_TYPE | VARCHAR(64) | N | PK | The event type. |
EVENT_TIME | TIMESTAMP | N | The event time in the local server time zone. | |
EVENT_TIME_GMT | NUMBER(13) | N | PK | The time of this record in GMT time. This is the number of seconds from midnight, 1 January, 1970. |
JOB_ID | NUMBER(15) | N | PK | The LSF-assigned job ID. |
USER_ID | NUMBER(15) | Y | The user ID of the user who submitted this job. | |
OPTIONS | NUMBER(15) | Y | The bit flags for job processing. | |
NUM_PROCESSORS | NUMBER(15) | Y | The number of processors that the job initially requested for execution. | |
SUBMIT_TIME | TIMESTAMP | Y | The job submission time. | |
BEGIN_TIME | TIMESTAMP | Y | The job start time. The job should be started at or after this time. | |
TERM_TIME | TIMESTAMP | Y | The job termination deadline. The job should be terminated by this time. | |
SIG_VALUE | DOUBLE/NUMBER | Y | The signal value. | |
CHKPNT_PERIOD | NUMBER(15) | Y | The checkpointing period. | |
RESTART_PID | NUMBER(15) | Y | The new process ID of the restarted job. | |
USER_NAME | VARCHAR(128) | Y | The user name of the user who submitted this job. | |
RLIMIT_SCPU | DOUBLE/NUMBER | Y | The soft CPU time limit. | |
RLIMIT_FILESIZE_LIMIT | DOUBLE/NUMBER | Y | The soft file size limit. | |
RLIMIT_SEGMENT_SIZE | DOUBLE/NUMBER | Y | The soft data segment size limit. | |
RLIMIT_STACK_SIZE | DOUBLE/NUMBER | Y | The soft stack segment size limit. | |
RLIMIT_CORE_SIZE | DOUBLE/NUMBER | Y | The soft core file size limit. | |
RLIMIT_MEMORY_SIZE | DOUBLE/NUMBER | Y | The soft memory size limit. | |
RLIMIT_SWAP_SIZE | DOUBLE/NUMBER | Y | The virtual memory size limit. | |
RLIMIT_NOFILE | DOUBLE/NUMBER | Y | The NOFILE limit. | |
RLIMIT_OPEN_MAX | DOUBLE/NUMBER | Y | The number of maximum open file. | |
RLIMIT_PROCESS | DOUBLE/NUMBER | Y | The process limit. | |
RLIMIT_RUNTIME | DOUBLE/NUMBER | Y | The soft run time limit. | |
HOST_SPEC | VARCHAR(128) | Y | The model or host name for normalizing CPU time and run time. | |
HOST_FACTOR | DOUBLE/NUMBER | Y | The CPU factor of the host specified in the "HOST_SPEC" field. | |
UMASK | DOUBLE/NUMBER | Y | The file creation mask for this job. | |
QUEUE | VARCHAR(128) | Y | The name of job queue to which the job was submitted. | |
RES_REQ | CLOB | Y | The resource requirements of this job. | |
FROM_HOST | VARCHAR(256) | Y | The name of the host that submitted this job. This includes the cluster name. | |
FROM_HOST_CLUSTER | VARCHAR(128) | Y | The name of the cluster that submitted this job. This field is extracted from the "FROM_HOST" field. | |
CWD | CLOB | Y | The current working directory of this job. | |
CHKPNT_DIR | CLOB | Y | The checkpoint directory of this job. | |
IN_FILE | CLOB | Y | The input file name. | |
OUT_FILE | CLOB | Y | The output file name. | |
ERR_FILE | CLOB | Y | The error output file name. | |
SUB_HOME_DIR | CLOB | Y | The home directory of the user who submitted this job. | |
JOB_FILE | CLOB | Y | The name of the job file. | |
NUM_ASKED_HOSTS | NUMBER(15) | Y | The number of candidate host for job dispatching. | |
ASKED_HOSTLISTS | CLOB | Y | The list of names of candidate hosts for job dispatching. | |
DEPEND_COND | CLOB | Y | The job dependency condition. | |
PRE_EXEC_CMD | CLOB | Y | The job pre-execution command. | |
TIME_EVENT | VARCHAR(20) | Y | The time event for job dependency condition. This field indicates when the time event ended. | |
JOB_NAME | CLOB | Y | The name of this job. | |
COMMAND | CLOB | Y | The job command. | |
NXF | NUMBER(15) | Y | The number of files to transfer. | |
XF | CLOB | Y | The list of file transfer specifications. | |
MAIL_USER | VARCHAR(1024) | Y | The name of the mail user. | |
PROJECT_NAME | CLOB | Y | The name of the project. | |
PROJECT_TAG | VARCHAR(4000) | Y | A limited length version of the "PROJECT_NAME" field for easy parsing. | |
NIOS_PORT | DOUBLE/NUMBER | Y | The callback port number. This field is for batch interactive jobs only. | |
MAX_NUM_PROCESSORS | NUMBER(15) | Y | The maximum number of processors for this job. | |
SCHED_HOST_TYPE | VARCHAR(128) | Y | The execution host type. | |
LOGIN_SHELL | VARCHAR(256) | Y | The login shell type. | |
USER_GROUP | VARCHAR(128) | Y | The user group of the user who submitted this job. | |
EXCEPT_LIST | VARCHAR(1024) | Y | The exception handlers for the job. | |
OPTIONS2 | DOUBLE/NUMBER | Y | The bit flags for job processing. | |
OPTIONS3 | DOUBLE/NUMBER | Y | The bit flags for job processing. | |
JOB_ARRAY_INDEX | NUMBER(15) | N | PK | The job array index. |
IN_FILE_SPOOL | CLOB | Y | The input spool file. | |
COMMAND_SPOOL | CLOB | Y | The command spool file. | |
JOB_SPOOL_DIR | CLOB | Y | The job spool directory. | |
USER_PRIORITY | NUMBER(15) | Y | The priority level of the user who submitted this job. | |
RSV_ID | VARCHAR(128) | Y | The advance reservation ID, for example, "user2#0". | |
JOB_GROUP | CLOB | Y | The job group under which the job runs. | |
EXT_SCHED | VARCHAR(256) | Y | The external scheduling options. | |
WARNING_ACTION | VARCHAR(256) | Y | The job warning action. | |
WARNING_TIME_PERIOD | DOUBLE/NUMBER | Y | The job warning time period in seconds. | |
SLA | VARCHAR(128) | Y | The SLA service class name under which the job runs. | |
SLA_RUN_LIMIT | DOUBLE/NUMBER | Y | The absolute run time limit of the job for SLA service classes. | |
LICENSE_PROJECT | VARCHAR(128) | Y | The LSF License Scheduler project name. | |
DEL_OPTIONS | DOUBLE/NUMBER | Y | Delete options for the "OPTIONS" field. | |
DEL_OPTIONS2 | DOUBLE/NUMBER | Y | Delete options for the "OPTIONS2" field. | |
DEL_OPTIONS3 | DOUBLE/NUMBER | Y | Delete options for the "OPTIONS" field. | |
REASON | DOUBLE/NUMBER | Y | The pending or suspended reason code. For further details of these codes, see <lsbatch/lsbatch.h>. | |
SUBREASON | DOUBLE/NUMBER | Y | The pending or suspended subreason code. For further details of these codes, see <lsbatch/lsbatch.h>. | |
CPU_TIME | DOUBLE/NUMBER | Y | The CPU run time so far. | |
END_TIME | TIMESTAMP | Y | The job completion time. | |
RU | DOUBLE/NUMBER | Y | The resource usage flag. | |
RU_UTIME | DOUBLE/NUMBER | Y | The amount of user time in seconds. | |
RU_STIME | DOUBLE/NUMBER | Y | The sytem time used in seconds. | |
RU_MAXRSS | DOUBLE/NUMBER | Y | The maximum shared text size in KB. | |
RU_IXRSS | DOUBLE/NUMBER | Y | The integral of the shared text size over time (in KB·seconds). | |
RU_ISMRSS | DOUBLE/NUMBER | Y | The Integral of the shared memory size over time (in KB·seconds). This field is only valid on Ultrix systems. | |
RU_IDRSS | DOUBLE/NUMBER | Y | The integral of the unshared data size over time (in KB·seconds). | |
RU_ISRSS | DOUBLE/NUMBER | Y | The integral of the unshared stack size over time (in KB·seconds). | |
RU_MINFLT | DOUBLE/NUMBER | Y | The number of page reclaims. | |
RU_MAJFLT | DOUBLE/NUMBER | Y | The number of page faults. | |
RU_NSWAP | DOUBLE/NUMBER | Y | The number of times that the process was swapped out. | |
RU_INBLOCK | DOUBLE/NUMBER | Y | The number of block input operations. | |
RU_OUBLOCK | DOUBLE/NUMBER | Y | The number of block output operations. | |
RU_IOCH | DOUBLE/NUMBER | Y | The number of characters read and written. This field is only valid on HP-UX systems. | |
RU_MSGSND | DOUBLE/NUMBER | Y | The number of System V IPC messages sent. | |
RU_MSGRCV | DOUBLE/NUMBER | Y | The number of messages received. | |
RU_NSIGNALS | DOUBLE/NUMBER | Y | The number of signals received. | |
RU_NVCSW | DOUBLE/NUMBER | Y | The number of voluntary context switches. | |
RU_NIVCSW | DOUBLE/NUMBER | Y | The number of involuntary context switches. | |
RU_EXUTIME | DOUBLE/NUMBER | Y | The exact user time used. This field is only valid on ConvexOS systems. | |
EXIT_STATUS | DOUBLE/NUMBER | Y | The exit status of the job. For further details of these exit status codes, see <lsbatch/lsbatch.h>. | |
EXIT_INFO | DOUBLE/NUMBER | Y | The job termination reason. For further details of these reason codes, see <lsbatch/lsbatch.h>. | |
JSTATUS | NUMBER(15) | N | PK | The job status. This field can be a combined status. The default is "-1" for a non-JOB_STATUS event. |
JOB_STATUS_STR | VARCHAR(256) | Y | The "JSTATUS" field converted into a string. If "JSTATUS" was a combined status, this field is a list. | |
NUM_RESERVE_HOSTS | NUMBER(15) | Y | The number of reserved hosts in the remote cluster. | |
RESERVE_HOSTLISTS | CLOB | Y | The reserve host lists. | |
REMOTE_JID | NUMBER(15) | Y | The job ID at the submission cluster. | |
REMOTE_CLUSTER | VARCHAR(128) | Y | The name of the remote cluster. | |
JOB_PID | NUMBER(15) | N | PK | The job process ID. |
JOB_PGID | NUMBER(15) | Y | The job process group ID. | |
NUM_EXEC_HOSTS | NUMBER(15) | Y | The actual number of slots used for job execution. | |
QUEUE_PRE_CMD | VARCHAR(1024) | Y | The pre-execution command. | |
QUEUE_POST_CMD | VARCHAR(1024) | Y | The post-execution command. | |
JFLAGS | DOUBLE/NUMBER | Y | Job processing flags. | |
ADDITIONAL_INFO | CLOB | Y | The placement information of HPC jobs. | |
POSITION | DOUBLE/NUMBER | Y | The LSF_JOB_MOVE position number. | |
BASE | DOUBLE/NUMBER | Y | The LSF_JOB_MOVE operation code, (TO_TOP or TO_BOTTOM). For further details of these codes, see <lsbatch/lsbatch.h>. | |
NOT_SWITCHED | DOUBLE/NUMBER | Y | A flag to indicate that mbatchd has switched the job to a new queue, but sbatchd has not been informed of the switch. | |
SIG | DOUBLE/NUMBER | Y | A flag to indicate that this signal has not been sent to the job. | |
SIG1 | DOUBLE/NUMBER | Y | A flag to indicate that the job has not been sent this signal to checkpoint itself. | |
SIG1_FLAGS | DOUBLE/NUMBER | Y | The checkpoint flags. For further details of these flags, see <lsbatch/lsbatch.h>. | |
PERIOD | DOUBLE/NUMBER | Y | The action period in seconds. | |
FLAGS | DOUBLE/NUMBER | Y | The action flags. For further details of these see <lsbatch/lsbatch.h>. | |
ACT_STATUS | DOUBLE/NUMBER | Y | Action status code:
|
|
SIGNAL_SYMBOL | VARCHAR(128) | Y | The action name. This is accompanied by actFlags. | |
RUN_COUNT | NUMBER(15) | Y | The number of times this job has been run. | |
EXEC_UID | NUMBER(15) | Y | The mapped UNIX user ID on the execution host. | |
EXEC_CWD | CLOB | Y | The current working directory job used on the execution host. | |
EXEC_HOME | CLOB | Y | The home directory that the job used on the execution host. | |
EXEC_USERNAME | VARCHAR(128) | Y | The mapped user name on the execution host. | |
SLA_SCALED_RUNLIMIT | DOUBLE/NUMBER | Y | The run time limit for the job scaled by the execution host. | |
MSG_IDX | DOUBLE/NUMBER | Y | The message index in the list. | |
DATA_SIZE | DOUBLE/NUMBER | Y | The size of the data if it has any; otherwise, this is 0. | |
POST_TIME | DOUBLE/NUMBER | Y | The message sending time. | |
DATA_STATUS | DOUBLE/NUMBER | Y | The status of the attached data. | |
MSG_DESC | CLOB | Y | A text description of the message. | |
FILE_NAME | CLOB | Y | The file name of the attached data. | |
MEM_BSIZEQ | DOUBLE/NUMBER | Y | The size of the membJobId array. | |
MEM_BJOBID | CLOB | Y | The job IDs of the chuck jobs. | |
NEW_STATUS | DOUBLE/NUMBER | Y | The new status of the job. | |
MSG_ID | NUMBER(15) | ID of the message. | ||
SEQ | DOUBLE/NUMBER | Y | The sequence status of the job for LSF_SBD_UNREPORTED_STATUS. | |
MEM | DOUBLE/NUMBER | Y | The total resident memory usage of all currently running processes in given process groups, in KB. | |
SWAP | DOUBLE/NUMBER | Y | The total virtual memory usage of all currently running processes in given process groups in kilobytes. | |
UTIME | DOUBLE/NUMBER | Y | The cumulative total user time in seconds. | |
STIME | DOUBLE/NUMBER | Y | The cumulative total system time in seconds. | |
NPIDS | NUMBER(15) | Y | The number of currently active processes in these process groups. | |
NPGIDS | NUMBER(15) | Y | The number of pgids for this job. | |
JOB_PGIDS_STR | CLOB | Y | The NGID string from the JOB_RUSAGE record. | |
JOB_PID_INFO_STR | CLOB | Y | The NPID string from the JOB_RUSAGE record. | |
NTHREADS | NUMBER(15) | Y | The number of threads from the JOB_RUSAGE record. | |
LIC_USAGE_AMT | DOUBLE/NUMBER | Y | The license usage amount. | |
LIC_FEATURE_NAME | VARCHAR(128) | Y | The license feature name. | |
APPLICATION_TAG | VARCHAR(128) | Y | The application tag assigned to this job. | |
DURATION4PREEMPTBACKFILL | DOUBLE/NUMBER | Y | The duration for preemptive backfill class in seconds. This field is valid for HPC only. | |
JOB_RMATTR | DOUBLE/NUMBER | Y | The job remote attribute flag, set in JOB_FORWARD. | |
NOT_MODIFIED | VARCHAR(1) | Y | A flag to indicate the running job's bmod parameters. | |
MAX_RMEM | DOUBLE/NUMBER | Y | This is the maximum resident memory usage of all processes in this job, in KB. | |
MAX_RSWAP | DOUBLE/NUMBER | Y | The maximum resident virtual memory of all processes in job, in KB. | |
EXCEPT_MASK | DOUBLE/NUMBER | Y | The job exception handling status. Valid values are as follows:
|
|
CHARGED_SAAP | VARCHAR(64) | Y | The SAAP charged to a job. | |
EXEC_RUSAGE | VARCHAR(4000) | Y | The resource usage (or rusage string) satisfied at runtime. | |
ACT_MASK | DOUBLE/NUMBER | Y | The job action handling status. | |
EXCEPT_INFO | DOUBLE/NUMBER | Y | The exception information. | |
ACT_PID | NUMBER(15) | Y | The action process ID. | |
MISC_OPTS4PENDSIG | DOUBLE/NUMBER | Y | Miscellaneous options for the pending signal. | |
START_TIME | TIMESTAMP | Y | The job start_time in the JOB_FINISH event. | |
NUM_ARRAY_ELEMENTS | NUMBER | Y | The number of job array elements in the job array for "JOB_NEW" and "JOB_MODIFY2" events. The default is 1. | |
JOB_INDEX_LIST | CLOB | Y | This is a list of job array index for "JOB_NEW", and "JOB_MODIFY2" events based on the "JOB_NAME" field. | |
NIOS_PORT_2ND | DOUBLE/NUMBER | Y | The second NIOS port based on the condition of SUB2_BSUB_BLOCK bit is set. | |
RLIMIT_THREAD | DOUBLE/NUMBER | Y | The number of threads of this job. | |
POST_EXEC_CMD | CLOB | Y | The job post-execution command. | |
RUNTIME_ESTIMATION | NUMBER(15) | Y | The estimated run time. | |
EXEC_HOSTS | CLOB | Y | The list of execution hosts. | |
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. |
support@platform.com | |
Web | www.platform.com |
Contact information | www.platform.com/company/contact-us |
© 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).
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.