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). |
|