Sun Microsystems
Products & Services
 
Support & Training
 
 

Previous Previous     Contents     Index     Next Next

sge_share_log

The sge_share_log table contains information about the N1GE(EE) sharetree configuration and usage.

Further information can be found in the N1GE manual sharetree(5).

Column

Type

Description

sl_id

Integer

Unique identifier for share log record

sl_curr_time

timestamp

Current time

sl_usage_time

timestamp

Usage time

sl_node

text

Node name in the sharetree

sl_user

text

Name of the user (job owner)

References the user table.

sl_project

text

Name of the project

References the project table.

sl_shares

integer

shares configured in sharetree

sl_job_count

integer

number of jobs that are considered for share tree policy

sl_level

double

share in % within this tree level

sl_total

double

total share in % within whole sharetree

sl_long_target_share

double

targeted long term share in %

sl_short_target_share

double

targeted short term share in %

sl_actual_share

double

actual share in %

sl_usage

double

combined usage, weight of cpu, mem and io can be configured

sl_cpu

double

cpu usage in seconds

sl_mem

double

integral memory usage in Gbyte seconds

sl_io

double

The amount of data transferred in input/output operations.

sl_ltcpu

double

long term cpu

sl_ltmem

double

long term mem

sl_ltio

double

long term io

sge_host

The sge_host table lists all hosts in the Cluster.

Column

Type

Description

h_id

Integer

Unique host identifier

h_hostname

text

The hostname.

sge_host_values

The sge_host_values table stores the values of host variables that are subject to change, e.g. the load average.

In addition, derived host values will be stored, e.g. hourly averages, sums etc.

Column

Type

Description

hv_hostname

text

References the host table.

hv_time_start

timestamp

Start time for the validity of a value.

hv_time_end

timestamp

End time for the validity of a value.

hv_variable

text

Variable name, e.g. load_avg.

hv_value

text

Variable value, e.g. 0.34.

hv_dvalue

double precision

Variable value as number.

hv_dconfig

double precision

In case of consumables: Consumable maximum available value (configured value).

sge_queue

The sge_queue table lists all queues configured in the cluster.

Column

Type

Description

q_id

Integer

Unique queue identifier

q_qname

text

Name of the queue

q_hostname

text

Name of host

sge_queue_values

The sge_queue_values table stores the values of queue variables that are subject to change, e.g. the number of free slots.

In addition, derived queue values will be stored, e.g. hourly averages, sums etc.

Column

Type

Description

qv_parent

integer

References q_id in the sge_queue table.

qv_time_start

timestamp

Start time for the validity of a value.

qv_time_end

timestamp

End time for the validity of a value.

qv_variable

text

Variable name, e.g. slots.

qv_value

text

Variable value, e.g. 5.

qv_dvalue

double precision

Variable value as number.

qv_dconfig

double precision

In case of consumables: Consumable maximum available value (configured value).

sge_department

Lists all departments referenced in the database.

Column

Type

Description

d_id

Integer

Unique department identifier

d_department

text

Name of the department.

Table 9: The sge_department Table

sge_department_values

The sge_department_values table stores the values of department related variables that are subject to change. Currently these are derived values, e.g. hourly averages, sums etc.

Column

Type

Description

dv_parent

integer

References d_id in the sge_department table.

dv_time_start

timestamp

Start time for the validity of a value.

dv_time_end

timestamp

End time for the validity of a value.

dv_variable

text

Variable name, e.g. h_sum_jobs

dv_value

text

Variable value, e.g. 5.

dv_dvalue

double precision

Variable value as number.

dv_dconfig

double precision

In case of consumables: Consumable maximum available value (configured value).

sge_project

Lists all projects referenced in the database.

Column

Type

Description

p_id

Integer

Unique project identifier

p_project

text

Name of the project.

sge_project_values

The sge_project_values table stores the values of project related variables that are subject to change. Currently these values are derived values, e.g. hourly averages, sums etc.

Column

Type

Description

pv_parent

integer

References q_id in the sge_queue table.

pv_time_start

timestamp

Start time for the validity of a value.

pv_time_end

timestamp

End time for the validity of a value.

pv_variable

text

Variable name, e.g. h_avg_cpu

pv_value

text

Variable value, e.g. 345.5

pv_dvalue

double precision

Variable value as number.

pv_dconfig

double precision

In case of consumables: Consumable maximum available value (configured value).

Previous Previous     Contents     Index     Next Next