Platform Computing Corporation
This package is intended for users of the Platform Symphony software ("Symphony"). You do not need to understand the data schema to use the reporting features in Symphony. Platform provides this table as a convenience for experienced database administrators only.
Note that Microsoft SQL Server data types and Oracle data types do not always match exactly. The following table shows the relevant data type mapping for SQL Server and Oracle databases.
SQL Server | Oracle |
---|---|
VARCHAR | VARCHAR2 |
NUMERIC | NUMBER |
TEXT | CLOB |
DATETIME | TIMESTAMP |
The sampled session and summarized task information. The default sampling interval is 5 minutes.
Column Name | Data Type | Null (Y/N) | Key (PK/FK) | Comment |
---|---|---|---|---|
APP_NAME | VARCHAR(256) | N | PK | The name of the application. |
CLUSTER_NAME | VARCHAR(128) | N | PK | The name of the cluster. |
SESSION_ID | NUMERIC(10) | N | PK | The unique session ID. |
TIME_STAMP_GMT | NUMERIC(13) | N | PK | The record sample time in the GMT time zone. This is the number of seconds from midnight, 1 January, 1970. |
TIME_STAMP | DATETIME | N | The record sample time in the local cluster time zone. This is based on the time of the host running the data loader. | |
ABORT_SESSION_IF_TASK_FAIL | CHAR | Y | Specifies that this session fails if any task fails. This is from the application profile configuration. Possible values are 0 (false) and 1 (true). | |
COMMON_DATA_COMPRESSED | CHAR | Y | A flag to indicate whether compression was applied to the common data for this session. Possible values are 0 (false) and 1 (true). | |
COMMON_DATA_SIZE | NUMERIC(10) | Y | The size of the common data for this session, in bytes. | |
COMPRESSION_ENABLED | CHAR | Y | A flag to indicate whether compression was enabled for this session. Possible values are 0 (false) and 1 (true). | |
COMPRESSION_THRESHOLD | NUMERIC(10) | Y | The compression threshold in bytes. Data that exceeds this threshold is compressed if compression is enabled. | |
CONSUMER_NAME | VARCHAR(4000) | Y | The name of the consumer. This is the fully-qualified consumer name. | |
CREATE_TIME | DATETIME | Y | The time when this session was created, in the local cluster time zone. This is based on the time of SSM host. | |
DIRECT_DATA_TRANSFER_ENABLED | CHAR | Y | A flag to indicate whether direct data transfer is enabled. Possible values are 0 (false) and 1 (true). | |
END_TIME | DATETIME | Y | The time when this session was closed or aborted, in the local time zone. This is based on the time of SSM host. | |
LAST_ERROR_TIME | DATETIME | Y | The last time that the task ended with an error, in the local cluster time zone. This is based on the time of SSM host. | |
NUM_COMMON_DATA_UPDATES | NUMERIC(10) | Y | The total number of common data updates received for this session. | |
NUM_TASK_CANCELED | NUMERIC(10) | Y | The number of canceled tasks. | |
NUM_TASK_ERROR | NUMERIC(10) | Y | The number of tasks ending with an error. | |
NUM_TASK_PENDING | NUMERIC(10) | Y | The number of pending tasks in open sessions. | |
NUM_TASK_RUNNING | NUMERIC(10) | Y | The number of running tasks. | |
PERSIST_SESSION_HISTORY | VARCHAR(10) | Y | Specifies whether to persist the session history. This is from the application profile configuration. The possible values are "all" or "none". | |
PERSIST_TASK_HISTORY | VARCHAR(10) | Y | Specifies whether to persist all of the task history. This is from the application profile configuration. The possible values are "all", "none", or "error". | |
PREEMPTIVE | CHAR | Y | Flag that indicates whether this session can preempt other over-allocated sessions to balance resources among sessions according to the configured SSM policy. Possible values are 0 (false) and 1 (true). | |
PREEMPT_TIME | NUMERIC(13) | Y | The total runtime of task invocations, in milliseconds, that were interrupted by preemption. | |
PRIORITY | NUMERIC(10) | Y | The session priority. | |
PROTOCOL_VERSION | NUMERIC(5) | Y | Admin API version. This indicates that some new added metrics may not available. For example, if this metric is set to 1 (the Symphony 3.1 protocol version), all the metrics described above are unavailable. | |
RAW_COMMON_DATA_SIZE | NUMERIC(10) | Y | The initial size of the common data when it was passed from the client to Symphony. The data size may change depending on which feature set is being used by the application. For example, the data size may decrease if the application enables the data compression feature. | |
REASON | VARCHAR(512) | Y | Reason for suspending, resuming, or killing this session. | |
RECLAIM_RANK | NUMERIC(5) | Y | The reclaim rank of the session. |
|
RECLAIM_TIME | NUMERIC(13) | Y | The total runtime of task invocations, in milliseconds, that were interrupted by reclaim. | |
RECOVERABLE | CHAR | Y | Specifies whether this session can be recovered if the session manager is recovered. This is from the application profile configuration. Possible values are 0 (false) and 1 (true). | |
RESOURCE_GROUP_FILTER | VARCHAR(1024) | Y | Tasks from this session can only run on resources that belong to one of the resource groups listed in the filter. | |
SERVICE | VARCHAR(256) | Y | The name of this service. | |
SERVICE_INSTANCES | NUMERIC(10) | Y | The number of service instances assigned to this session. | |
SERVICE_TO_SLOT_RATIO | VARCHAR(16) | Y | The slot usage requirement for the session. Tasks from this session can only run on service instances that occupy the appropriate number of slots. | |
SESSION_BINDING_FAILURES | VARCHAR(2048) | Y | Host names and process IDs for the last five service instances that experienced service-side session binding failures in the SessionEnter method. | |
SESSION_NAME | VARCHAR(256) | Y | The name of this session. | |
SESSION_RETRY_LIMIT | NUMERIC(10) | Y | The maximum number of times to retry a session. This is from the application profile configuration. | |
SESSION_STATE | VARCHAR(128) | Y | The session state. | |
SESSION_TAG | VARCHAR(128) | Y | The tag given to a group of sessions belonging to a particular application. | |
SESSION_TYPE | VARCHAR(4000) | Y | The session type. | |
SESSION_UPDATE_FAILURES | VARCHAR(2048) | Y | Host names and process IDs for the last five service instances that experienced service-side session update failures. | |
SUBMISSION_USER | VARCHAR(128) | Y | The user name of the account client application used to create this session. | |
SYMPHONY_VERSION | VARCHAR(10) | Y | The version of Symphony on which this session is running. | |
TASK_RETRY_LIMIT | NUMERIC(10) | Y | This limit the number of retry of a task under this session. | |
TASKS_INTERRUPTED_BY_PREEMPT | NUMERIC(10) | Y | The number of times that tasks in this session have been interrupted by preemption. (In the Oracle DB, the maximum column length is 30 characters) | |
TASKS_INTERRUPTED_BY_RECLAIM | NUMERIC(10) | Y | The number of times that tasks in this session have been interrupted by reclaim. | |
TOTAL_COMMON_DATA_UPDATE_SIZE | NUMERIC(15) | Y | The total size of all common data updates sent over the network for this session, in bytes. | |
TOTAL_INPUT_SIZE | NUMERIC(15) | Y | Total size of input sent over the network for this session from all tasks, in bytes. This metric has the same meaning as Task::inputSize. | |
TOTAL_OUTPUT_SIZE | NUMERIC(15) | Y | Total size of output sent over the network for this session from all tasks, in bytes. This metric has the same meaning as Task::outputSize. If the task failed, this value includes the error message size. | |
TOTAL_TASKS_RUNTIME | NUMERIC(14,4) | Y | Total run time of all tasks in seconds. This includes all try times and the last run time. This is the wall clock time, not the CPU time. For running tasks, this is the total run time up to the time of this entry. | |
TOTAL_TASKS_SUBMIT2START_TIME | NUMERIC(14,4) | Y | The total time of all tasks during this sample. The time is defined as the time between task submit time and task start time. This only counted for the first try or successful run. If a task has not been started, then its time will not be counted. | |
TOTAL_UNSUCCESS_TASKRUNS | NUMERIC(10) | Y | Total number of times all tasks were tried (not completed). | |
TOTAL_UNSUCCESS_TASKSRUNTIME | NUMERIC(14,4) | Y | Total try time (not completed) of all retried tasks in seconds. | |
CLIENT_VERSION | VARCHAR(16) | Y | The version of Symphony library in use by the client at run time (not the version of Symphony used to compile the client). |
|
CLIENT_HOST_NAME | VARCHAR(128) | Y | The local host name of the host running the client. In a multi-homed host, it is the name of the host that connects to the session. |
|
CLIENT_IP_ADDRESS | VARCHAR(40) | Y | The IP address of the host running the client. In a multi-homed host, it is the IP address used to connect to the session. |
|
CLIENT_OS_USER_NAME | VARCHAR(64) | Y | The name of the OS user running the client. |
|
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. |
support@platform.com | |
Web | www.platform.com |
Contact information | www.platform.com/company/contact-us |
© 1994 - 2009 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.