pd_time

Table containing time information for a 24 hour day (1440 minutes = 1440 rows). The table is populated the first time it is accessed and does not grow once the 1440 rows are created. The table can be populated either by the Performance Domain Server (publishing of Performance Data) or by the pdtodb utility.

Column Name Column Datatype Column Null Option Column Comment
time_id integer not null Time identifier.
time_value nvarchar(5) not null Time value as in hh:mm (23:59).

Product Name: Unicenter Network and System Management/System Performance

Table Type: Table

Relationships:

Primary Key Related Table Related Column
time_id pd_val_10min machine_id
time_id pd_val_8hr machine_id
time_id pd_val_6hr machine_id
time_id pd_val_5min machine_id
time_id pd_val_4hr machine_id
time_id pd_val_1month machine_id
time_id pd_val_1min machine_id
time_id pd_val_1hr machine_id
time_id pd_val_1day machine_id
time_id pd_val_15min machine_id
time_id pd_val_12hr machine_id
time_id pd_val_3hr machine_id
time_id pd_val_30min machine_id
time_id pd_val_2hr machine_id
time_id pd_val_20min machine_id
time_id pd_val_1year machine_id
time_id pd_val_1week machine_id


Copyright © 2006 CA. All rights reserved.