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.

LSB_EVENTS

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:
  1. Action started
  2. One action preempted other actions
  3. Action succeeded
  4. Action failed
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:
  • J_EXCEPT_OVERRUN 0x02
  • J_EXCEPT_UNDERUN 0x04
  • J_EXCEPT_IDLE 0x80
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.

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.