Sun Microsystems
Products & Services
 
Support & Training
 
 

Previous Previous     Contents     Index     Next Next

view_department_values

Department specific variables.

Column

Type

Description

department

text

Name of the department

time_start

timestamp

Start time for the validity of a value

time_end

timestamp

End time for the validity of a value

variable

text

Variable name, e.g. h_sum_jobs

str_value

text

Variable value, e.g. 5

num_value

double precision

Variable value as number

num_config

double precision

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

view_group_values

Group specific variables

Column

Type

Description

groupname

text

Name of the group

time_start

timestamp

Start time for the validity of a value

time_end

timestamp

End time for the validity of a value

variable

text

Variable name, e.g. h_sum_jobs

str_value

text

Variable value, e.g. 53

num_value

double precision

Variable value as number

num_config

double precision

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

view_host_values

Host specific variables

Column

Type

Description

hostname

text

The hostname

time_start

timestamp

Start time for the validity of a value

time_end

timestamp

End time for the validity of a value

variable

text

Variable name, e.g. load_avg

str_value

text

Variable value, e.g. 0.34

num_value

double precision

Variable value as number

num_config

double precision

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

view_project_values

Project specific variables

Column

Type

Description

project

text

Name of the project

time_start

timestamp

Start time for the validity of a value

time_end

timestamp

End time for the validity of a value

variable

text

Variable name, e.g. h_avg_cpu

str_value

text

Variable value, e.g. 345.5

num_value

double precision

Variable value as number

num_config

double precision

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

view_queue_values

Queue specific variables

Column

Type

Description

qname

text

Name of the queue

hostname

text

Name of host

time_start

timestamp

Start time for the validity of a value

time_end

timestamp

End time for the validity of a value

variable

text

Variable name, e.g. slots

str_value

text

Variable value, e.g. 5

num_value

double precision

Variable value as number

num_config

double precision

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

view_user_values

User specific variables.

Column

Type

Description

username

text

Name of the user

time_start

timestamp

Start time for the validity of a value

time_end

timestamp

End time for the validity of a value

variable

text

Variable name, e.g. h_sum_cpu

str_value

text

Variable value, e.g. 23.2

num_value

double precision

Variable value as number

num_config

double precision

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

List of Derived Values

Derived values stored in the database can highly reduce query processing time. The reporting databasel contains aggregated values (sum, average, min, max) on an hourly basis. After some time period (e.g. one year), these values can even be further compressed to daily, weekly or monthly values.

The following derived values are delivered:

table

variable

description

sge_host_values

h_sum_cpu, d_sum_cpu, m_sum_cpu

cpu usage per host and hour, day, month

sge_user_values

h_sum_cpu, d_sum_cpu, m_sum_cpu

cpu usage per user and hour, day, month

sge_group_values

h_sum_cpu, d_sum_cpu, m_sum_cpu

cpu usage per group and hour, day, month

sge_department_values

h_sum_cpu, d_sum_cpu, m_sum_cpu

cpu usage per department and hour, day, month

sge_project_values

h_sum_cpu, d_sum_cpu, m_sum_cpu

cpu usage per project and hour, day, month

sge_host_values

h_avg_load

average host load

sge_host_values

h_max_load

maximum host load

   

Rules for the generation of any derived value can be specified in a configuration file.

Previous Previous     Contents     Index     Next Next