Job Management Partner 1/Performance Management Planning and Configuration Guide

[Contents][Glossary][Index][Back][Next]


Appendix H.1 Data model

This subsection describes data models for the health check agent. The following table shows the data model versions for the health check agent that correspond to the PFM - Manager versions.

PFM - Manager version Data model version
08-11 3.0
09-00 or later 4.0
5.0

The following table shows the records that support data model versions.

Record name (record ID) Data model version Description
3.0 4.0 5.0
Health Check Detail(PD_HC) Y Y Y Detailed information of health check results
Host Availability(PI_HAVL) -- Y Y Performance and running rate of each host
Host Detail(PD_HOST) -- Y Y Details on the health check result for each host
Reserved Interval(PI) Y Y Y Reserved record
Reserved Detail(PD) Y Y Y Reserved record
System Overview(PI_SYS) -- Y Y Operational status summary of hosts in the system

Legend:
Y: Supported
--: Unsupported
Organization of this subsection
(1) Health Check Detail (PD_HC)
(2) Host Availability (PI_HAVL)
(3) Host Detail (PD_HOST)
(4) Reserved Interval (PI)
(5) Reserved Detail (PD)
(6) System Overview (PI_SYS)
(7) Fields added to records stored in the Store database

(1) Health Check Detail (PD_HC)

Function
This record stores the operating status data of PFM - Agent or PFM - RM, or the operating status data of hosts where PFM - Agent or PFM - RM operates. It is a multi-instance record. You can use this record to perform the following:
  • Configure alarms or actions that respond to changes in the operating status of agents.
    You can use integrated management products, such as JP1/IM, to monitor status changes made by the agent.
  • Confirm the monitoring result report in the service-level operating status monitoring mode.
    You can confirm detailed information collected in the service-level operating status monitoring mode, such as the status of agents and services that make up the agents, or the date and time when the status was updated.

Default values and changeable values
Item Default value Changeable
Log No Yes
Collection Interval 300 Yes
Collection Offset from Top of Minute 0 Yes
LOGIF Blank Yes

ODBC key field
PD_HC_AGENT

Lifetime
From the first time the agent was started until unsetup or uninstallation.

Record size
  • Fixed part: 716 bytes
  • Variable part: 1,023 bytes

Fields

Common fields
PFM - View name
(PFM - Manager name)
Description Summary Format Delta Data source
Record Type
(INPUT_RECORD_TYPE)
The name of the record. The value of this field is always HC. -- char 8 No --
Record Time
(RECORD_TIME)
The time when the record was created. -- pwbTIMET No --
Interval
(INTERVAL)
The collection interval of the record (in seconds). -- pwbULONG No --
Monitoring Level by Num
(MONITORING_LEVEL_NUM)
The monitoring level of the health check function (numerical value). This is a reserved field and cannot be used. -- pwbSHORT No --
Monitoring Level
(MONITORING_LEVEL)
The monitoring level of the health check function (character string) as one of the following values:
  • Host: Host-level operation status monitoring
  • Service: Service-level operation status monitoring
-- pwbSTRING 33 No --

Fields for determining the agent operating status
PFM - View name
(PFM - Manager name)
Description Summary Format Delta Data source
Agent
(AGENT)
The service ID of the monitored agent. -- pwbSTRING259 No --
Host
(HOST)
The host where the monitored agent is running. -- pwbSTRING256 No --
Agent Category by Num
(AGENT_CATEGORY_NUM)
The type of the monitored agent (numerical value). This is a reserved field and cannot be used. -- pwbSHORT No --
Agent Category
(AGENT_CATEGORY)
The type of the monitored agent (numerical value), as one of the following values:
  • Agent: PFM - Agent
  • Remote Monitor: PFM - RM
  • Remote Agent: Remote agent
-- pwbSTRING33 No --
Polling Date and Time
(POLLING_DATETIME)
The date and time at which the monitored agent was polled. -- pwbTIMET No --
Agent Op Status by Num
(AGENT_STATE_NUM)
The status of the monitored agent (numerical value), as one of the following#:
  • 0: Not Supported
  • 4: Running
  • 8: Incomplete
  • 12: Stopped
  • 16: Unconfirmed
  • 24: Host Not Available
-- pwbSHORT No --
Agent Op Status
(AGENT_STATE)
The status of the monitored agent (character string), as one of the following#:
  • Not Supported
  • Running
  • Incomplete
  • Stopped
  • Unconfirmed
  • Host Not Available
-- pwbSTRING 33 No --
Agent Op Status Change
(AGENT_STATE_CHANGE)
A flag indicating whether the status of the monitored agent has changed since the last time the agent was polled. This field can contain the following values:
  • 0: The status is unchanged
  • 1: The status has changed
-- pwbSHORT No --

#
The status displayed for the agent depends on the monitoring level of the health check agent. For details on the status, see the chapter that describes detecting problems within Performance Management in the Job Management Partner 1/Performance Management User's Guide.

Fields for determining the host operating status
PFM - View name
(PFM - Manager name)
Description Summary Format Delta Data source
Host Op Status by Num
(HOST_STATE_NUM)
The status of the host where the monitored agent is running (numerical value). This is a reserved field and cannot be used. -- pwbSHORT No --
Host Op Status
(HOST_STATE)
The status of the host where the monitored agent is running (character string), as one of the following:
  • Success: Communication with the host was successful
  • Failure: Communication with the host failed
  • Unknown: Unknown status
-- pwbSTRING 33 No --

Fields for determining the service operating status (Agent Collector and Remote Monitor Collector services)
PFM - View name
(PFM - Manager name)
Description Summary Format Delta Data source
Collector Inclusion in Agent
(COLLECTOR_INCL_AGENT)
A flag indicating whether the status of the Agent Collector and Remote Monitor Collector services is considered when evaluating the agent status. 0 is set when the operating status of the host is monitored, and 1 is set when the operating status of the service is monitored.
  • 0: Not included
  • 1: Included
-- pwbSHORT No --
Collector Op Status by Num
(COLLECTOR_STATE_NUM)
Operating status of Agent Collector and Remote Monitor Collector services (numeric value). This is a reserved field and cannot be used. -- pwbSHORT No --
Collector Op Status
(COLLECTOR_STATE)
Operating status of Agent Collector and Remote Monitor Collector services (string). The values are as follows:
  • Start Pending: The service is starting
  • Active: The service has started
  • Standalone Active: The service has started (in stand-alone mode)
  • Busy: The service is processing a request
  • Standalone Busy: The service is processing a request (in stand-alone mode)
  • Too Long Busy: The service is taking a long time to process a request#1
  • Standalone Too Long Busy: The service is taking a long time to process a request (in stand-alone mode)#1
  • Stop Pending: The service is stopping
  • Inactive: The service is stopped
  • Unknown: The status is unknown#2
-- pwbSTRING 33 No --
Collector Op Status Last-Updated
(COLLECTOR_STATE_LAST_UPDATE)
Date and time when the operating status of Agent Collector and Remote Monitor Collector services was updated -- pwbTIMET No --
Collector Op Status Cont-Period
(COLLECTOR_STATE_CONT_PERIOD)
The duration of the operating status of the Agent Collector and Remote Monitor Collector services (in seconds)#3. -- pwbTIMET No --
Collector Op Status Change
(COLLECTOR_STATE_CHANGE)
A flag indicating whether the status of the Agent Collector and Remote Monitor Collector services has changed since the last time the agent was polled. This field can contain the following values:
  • 0: The status is unchanged
  • 1: The status has changed
-- pwbSHORT No --

#1
If Yes is specified for Busy as Inactive in the properties of the health check agent, this value is set when the service remains in Busy or Standalone Busy status for longer than the period of time specified as the Time to Busy as Inactive setting. In this case, the health check agent considers the service inactive when it determines the operating status of the agent.

#2
This value is set when performing host-level monitoring of operating statuses, or in the following cases when performing service-level monitoring of operating statuses:
  • When the service is not specified as a monitoring target.
  • When the host or the Status Server on the host is stopped.
  • When the service does not support the status management function.
  • When the status management function is unable to confirm the status of the service for reasons such as the service having terminated abnormally, despite the service supporting the status management function. In this case, the health check agent considers the service inactive when it determines the operating status of the agent. You will need to restart the service to allow the service status to be recognized correctly.

#3
The duration of the operating status of a service is calculated from the difference between the time when polling took place (Polling Date and Time) and the time when the service entered the current operating status (Collector Op Status Last-Updated, Store Op Status Last-Updated, or AH Op Status Last-Updated). For this reason, make sure that the clocks are synchronized on all hosts that run Performance Management services.

Fields for determining the service operating status (Agent Store and Remote Monitor Store services)
PFM - View name
(PFM - Manager name)
Description Summary Format Delta Data source
Store Inclusion in Agent
(STORE_INCL_AGENT)
A flag indicating whether the status of the Agent Store and Remote Monitor Store services is considered when evaluating the agent status. 0 is set when the operating status of the host is monitored, and 1 is set when the operating status of the service is monitored.
  • 0: Not included
  • 1: Included
-- pwbSHORT No --
Store Op Status by Num
(STORE_STATE_NUM)
Operating status of Agent Store and Remote Monitor Store services (numeric value). This is a reserved field and cannot be used. -- pwbSHORT No --
Store Op Status
(STORE_STATE)
Operating status of Agent Store and Remote Monitor Store services (string). The values are as follows:
  • Start Pending: The service is starting
  • Active: The service has started
  • Standalone Active: The service has started (in stand-alone mode)
  • Busy: The service is processing a request
  • Standalone Too Long Busy: The service is processing a request (in stand-alone mode)
  • Too Long Busy: The service is taking a long time to process a request#1
  • Standalone Too Long Busy: The service is taking a long time to process a request (in stand-alone mode)#1
  • Stop Pending: The service is stopping
  • Inactive: The service is stopped
  • Unknown: The status is unknown#2
-- pwbSTRING 33 No --
Store Op Status Last-Updated
(STORE_STATE_LAST_UPDATE)
Date and time when the operating status of Agent Store and Remote Monitor Store services was updated -- pwbTIMET No --
Store Op Status Cont-Period
(STORE_STATE_CONT_PERIOD)
The duration of the operating status of Agent Store and Remote Monitor Store services (in seconds)#3 -- pwbTIMET No --
Store Op Status Change
(STORE_STATE_CHANGE)
A flag indicating whether the status of the Agent Store and Remote Monitor Store services has changed since the last time the agent was polled. This field can contain the following values:
  • 0: The status is unchanged
  • 1: The status has changed
-- pwbSHORT No --

#1
If Yes is specified for Busy as Inactive in the properties of the health check agent, this value is set when the service remains in Busy or Standalone Busy status for longer than the period of time specified as the Time to Busy as Inactive setting. In this case, the health check agent considers the service inactive when it determines the operating status of the agent.

#2
This value is set when performing host-level monitoring of operating statuses, or in the following cases when performing service-level monitoring of operating statuses:
  • When the service is not specified as a monitoring target.
  • When the host or the Status Server on the host is stopped.
  • When the service does not support the status management function.
  • When the status management function is unable to confirm the status of the service for reasons such as the service having terminated abnormally, despite the service supporting the status management function. In this case, the health check agent considers the service inactive when it determines the operating status of the agent. You will need to restart the service to allow the service status to be recognized correctly.

#3
The duration of the operating status of a service is calculated from the difference between the time when polling took place (Polling Date and Time) and the time when the service entered the current operating status (Collector Op Status Last-Updated, Store Op Status Last-Updated, or AH Op Status Last-Updated). For this reason, make sure that the clocks are synchronized on all hosts that run Performance Management services.

Fields for determining the service operating status (Action Handler service)
PFM - View name
(PFM - Manager name)
Description Summary Format Delta Data source
AH Inclusion in Agent
(AH_INCL_AGENT)
A flag indicating whether the status of the Action Handler service is considered when evaluating the agent status.
  • 0: Not included
  • 1: Included
-- pwbSHORT No --
AH Op Status by Num
(AH_STATE_NUM)
The operating status of the Action Handler service (numerical value). This is a reserved field and cannot be used. -- pwbSHORT No --
AH Op Status
(AH_STATE)
The operating status of the Action Handler service (character string), as one of the following values:
  • Start Pending: The service is starting
  • Active: The service has started
  • Standalone Active: The service has started (in stand-alone mode)
  • Busy: The service is processing a request
  • Standalone Busy: The service is processing a request (in stand-alone mode)
  • Too Long Busy: The service is taking a long time to process a request#1
  • Standalone Too Long Busy: The service is taking a long time to process a request (in stand-alone mode)#1
  • Stop Pending: The service is stopping
  • Inactive: The service is - stopped
  • Unknown: The status is unknown#2
-- pwbSTRING 33 No --
AH Op Status Last-Updated
(AH_STATE_LAST_UPDATE)
The date and time when the operating status of the Action Handler service was last updated. -- pwbTIMET No --
AH Op Status Cont-Period
(AH_STATE_CONT_PERIOD)
The duration of the operating status of the Action Handler service (in seconds)#3. -- pwbTIMET No --
AH Op Status Change
(AH_STATE_CHANGE)
A flag indicating whether the status of the Action Handler service has changed since the last time the agent was polled. This field can contain the following values:
  • 0: The status is unchanged
  • 1: The status has changed
-- pwbSHORT No --

Message text field
PFM - View name
(PFM - Manager name)
Description Summary Format Delta Data source
Message Text
(MESSAGE_TEXT)
Detailed information about the operating status of the agent being monitored. -- pwbSTRING 256 No --

#1
If Yes is specified for Busy as Inactive in the properties of the health check agent, this value is set when the service remains in Busy or Standalone Busy status for longer than the period of time specified as the Time to Busy as Inactive setting. In this case, the health check agent considers the service inactive when it determines the operating status of the agent.

#2
This value is set when performing host-level monitoring of operating statuses, or in the following cases when performing service-level monitoring of operating statuses:
  • When the service is not specified as a monitoring target.
  • When the host or the Status Server on the host is stopped.
  • When the service does not support the status management function.
  • When the status management function is unable to confirm the status of the service for reasons such as the service having terminated abnormally, despite the service supporting the status management function. In this case, the health check agent considers the service inactive when it determines the operating status of the agent. You will need to restart the service to allow the service status to be recognized correctly.

#3
The duration of the operating status of a service is calculated from the difference between the time when polling took place (Polling Date and Time) and the time when the service entered the current operating status (Collector Op Status Last-Updated, Store Op Status Last-Updated, or AH Op Status Last-Updated). For this reason, make sure that the clocks are synchronized on all hosts that run Performance Management services.

Message text
Messages in the message text field are displayed as follows.

When performing host-level monitoring, or when service-level monitoring yields an agent status of Not Supported, Unconfirmed, or Host Not Available:
HC: HC_AGT

When service-level monitoring yields an agent status of Running, Incomplete, or Stopped:
HC: HC_AGT (Collector: HC_AC, Store: HC_AS [, Action Handler: HC_AH])

Legend:
HC_AGT: The operating status of the agent
HC_AC: The operating status of Agent Collector and Remote Monitor Collector services
HC_AS: The operating status of Agent Store and Remote Monitor Store services
HC_AH: The operating status of the Action Handler service
 

Example of message output
The following are examples of messages output to the Message Text field of a PD_HC record.
HC: Not Supported
HC: Running (Collector: Active, Store: Active)
HC: Incomplete (Collector: Active, Store: Inactive, Action Handler: Active)
HC: Stopped (Collector: Inactive, Store: Inactive)
HC: Host Not Available

(2) Host Availability (PI_HAVL)

Function
This record stores the performance and running rate data of hosts that make up the system. It is a multi-instance record. You can use this record to perform the following:
  • Confirm the running rate of hosts in a timescale.
    You can confirm the performance of each host.
Please note that for any host monitored only by a remote agent whose status is Unknown, the corresponding data for that host will not be stored.

Default values and changeable values
Item Default value Changeable
Log No Yes
Sync Collection With Detail Records, HC No
LOGIF Blank Yes

Common ODBC key field
PI_HAVL_AGENT

Lifetime
From the first time the agent was started until unsetup or uninstallation

Record size
  • Fixed part: 681 bytes
  • Variable part: 292 bytes

Field

Common fields
PFM - View name
(PFM - Manager name)
Description Summary Format Delta Data source
Record Type
(INPUT_RECORD_TYPE)
The name of the record COPY char 8 No --
Record Time
(RECORD_TIME)
The time when the record was created COPY pwbTIMET No --
Interval
(INTERVAL)
The collection interval of the record (in seconds) COPY pwbULONG No --

Fixed field
PFM - View name
(PFM - Manager name)
Description Summary Format Delta Data source
Host
(HOST)
Host name COPY pwbSTRING 256 No --
Availability
(AVAILABILITY)
Running rate (%)
(Running: 100%; Stopped: 0%)
AVG pwbFLOAT No --
Total Available Time
(TOTAL_AVAILABLE_TIME)
Running time (second)
(Running: Interval; Stopped: 0)
ADD pwbULONG No --
Total Not Available Time
(TOTAL_NOTAVAILABLE_TIME)
Stopping time (seconds)
(Running: 0; Stopped: Interval)
ADD pwbULONG No --
Total Monitoring Time
(TOTAL_MONITORING_TIME)
Monitoring time (seconds).
Always Interval.
ADD pwbULONG No --
Summary Start Date and Time
(SUMMARY_START_DATETIME)
The first storage time in the summary period.
Always Record Time when stored.
LO pwbTIMET No --
Summary End Date and Time
(SUMMARY_END_DATETIME)
The final storage time in the summary period.
Always Record Time when stored.
COPY pwbTIMET No --

(3) Host Detail (PD_HOST)

Function
This record stores the information that summarizes the results for health check performed by hosts. It is a multi-instance record, and its key is the host name. You can use this record to perform the following:
  • Configure alarms and actions that respond to changes in the status of hosts.
    You can use integrated management products, such as JP1/IM, to monitor status changes made by the host.

Default values and changeable values
Item Default value Changeable
Log No Yes
Sync Collection With Detail Records, HC No
LOGIF blank Yes

Common ODBC key field
PD_HOST_AGENT

Lifetime
From the first time the agent was started until unsetup or uninstallation

Record size
  • Fixed part: 716 bytes
  • Variable part: 325 bytes

Field

Common fields
PFM - View name
(PFM - Manager name)
Description Summary Format Delta Data source
Record Type
(INPUT_RECORD_TYPE)
The name of the record -- char 8 No --
Record Time
(RECORD_TIME)
The time when the record was created -- pwbTIMET No --
Interval
(INTERVAL)
The collection interval of the record (in seconds) -- pwbULONG No --
Monitoring Level by Num
(MONITORING_LEVEL_NUM)
The monitoring level of the health check function (numerical value). This is a reserved field and cannot be used. -- pwbSHORT No --
Monitoring Level
(MONITORING_LEVEL)
The monitoring level of the health check function (character string) as one of the following values:
  • Host: Host-level operation status monitoring
  • Service: Service-level operation status monitoring
-- pwbSTRING 33 No --

Fixed field
PFM - View name
(PFM - Manager name)
Description Summary Format Delta Data source
Host
(HOST)
Host name -- pwbSTRING 256 No --
Polling Date and Time
(POLLING_DATETIME)
Polling date and time -- pwbTIMET No --
Status
(STATE)
Status
(Running: Available; Stopped: Not Available; Unconfirmed: Unknown)
-- pwbSTRING 33 No --
Status by Num
(STATE_NUM)
Status
(Running: 0; Stopped: 1; Unconfirmed: 2)
-- pwbSHORT No --
Status Change
(STATE_CHANGE)
Indicates whether there was a status change.
(No change: 0; Changed: 1)
-- pwbSHORT No --
Num of Agents
(NUM_AGENTS)
Total number of agents on the host -- pwbULONG No --
Num of Not Supported
(NUM_NOTSUPPORTED)
Number of Not Supported agents on the host
For details on the operating status, see the chapter that describes detecting problems within Performance Management in the Job Management Partner 1/Performance Management User's Guide.
-- pwbULONG No --
Num of Running
(NUM_RUNNING)
Number of Running agents on the host
For details on the operating status, see the chapter that describes detecting problems within Performance Management in the Job Management Partner 1/Performance Management User's Guide.
-- pwbULONG No --
Num of Incomplete
(NUM_INCOMPLETE)
Number of Incomplete agents on the host
For details on the operating status, see the chapter that describes detecting problems within Performance Management in the Job Management Partner 1/Performance Management User's Guide.
-- pwbULONG No --
Num of Stopped
(NUM_STOPPED)
Number of Stopped agents on the host
For details on the operating status, see the chapter that describes detecting problems within Performance Management in the Job Management Partner 1/Performance Management User's Guide.
-- pwbULONG No --
Num of Unconfirmed
(NUM_UNCONFIRMED)
Number of Unconfirmed agents on the host
For details on the operating status, see the chapter that describes detecting problems within Performance Management in the Job Management Partner 1/Performance Management User's Guide.
-- pwbULONG No --
Num of Host Not Available
(NUM_HOSTNOTAVAILABLE)
Number of Host Not Available agents on the host
For details on the operating status, see the chapter that describes detecting problems within Performance Management in the Job Management Partner 1/Performance Management User's Guide.
-- pwbULONG No --

(4) Reserved Interval (PI)

This is a reserved record and cannot be used.

(5) Reserved Detail (PD)

This is a reserved record and cannot be used.

(6) System Overview (PI_SYS)

Function
This record stores select information, such as the number and availability of running hosts, as the operating status summary of the hosts that make up the system. It is a single-instance record. You can use this information to perform the following:
  • Use a snapshot to confirm the system's operating status summary.
    You can confirm the current system status, as well as the status history and trends.

Default values and changeable values
Item Default value Changeable
Log No Yes
Sync Collection With Detail Records, HC No
LOGIF Blank Yes

Common ODBC key field
None

Lifetime
From the first time the agent was started until unsetup or uninstallation.

Record size
  • Fixed part: 801 bytes
  • Variable part: 0 bytes

Field

Common fields
PFM - View name
(PFM - Manager name)
Description Summary Format Delta Data source
Record Type
(INPUT_RECORD_TYPE)
The name of the record -- char 8 No --
Record Time
(RECORD_TIME)
The time when the record was created -- pwbTIMET No --
Interval
(INTERVAL)
The collection interval of the record (in seconds) -- pwbULONG No --

Fixed field
PFM - View name
(PFM - Manager name)
Description Summary Format Delta Data source
% Available Hosts
(PCT_AVAILABLE_HOSTS)
Running rate of host (%)
(number of running hosts/total number of hosts)
HILO pwbFLOAT No --
Num of Available Hosts
(NUM_AVAILABLE_HOSTS)
Number of running hosts HILO pwbULONG No --
Num of Not Available Hosts
(NUM_NOTAVAILABLE_HOSTS)
Number of stopped hosts HILO pwbULONG No --
Num of Unknown Hosts
(NUM_UNKNOWN_HOSTS)
Number of unconfirmed hosts HILO pwbULONG No --
Num of Hosts
(NUM_HOSTS)
Total number of hosts HILO pwbULONG No --

(7) Fields added to records stored in the Store database

The following table describes the fields that are added to a record only when the record is stored in the Store database.

PFM - View name
(PFM - Manager name)
Description Format Delta Supported version Data source
Agent Host
(DEVICEID)
Name of the host running PFM - Agent or PFM - RM string(256) No All --
Agent Instance
(PROD_INST)
Name of the host running PFM - Agent or PFM - RM string(256) No All --
Agent Type
(PRODID)
Product ID of PFM - Agent or PFM - RM. Indicated as a single-byte identifier. char No All --
Date
(DATE)
The date when the record was created, in GMT#1, #3. char(3) No All --
Date and Time
(DATETIME)
A combination of the Date (DATE) and Time (TIME) fields#3. char(6) No All --
Drawer Type
(DRAWER_TYPE)
For PI-type records, the summary category for the data. The name of each category is displayed differently in reports in PFM - Web Console and in the output of the ODBC driver#2. char No All --
GMT Offset
(GMT_ADJUST)
The difference between Greenwich Mean Time and local time, in seconds. long No All --
Time
(TIME)
The time when the record was created, in GMT#1, #3. char(3) No All --

Legend:
--: Indicates that the health check function has processed the performance data and no value was assigned to the field.

#1
PI-type records present data in summarized form. To help the system summarize the data, a time is assigned to each record that provides a basis for use in the summarization process. The following table lists the time set for each record category.
Category Setting used for each category
Per-minute The time when the record was created with the seconds set to zero.
Hourly The time when the record was created with the minutes and seconds set to zero.
Daily 00:00:00 on the day when the record was created.
Weekly 00:00:00 on the Monday of the week when the record was created.
Monthly 00:00:00 on the first day of the month when the record was created.
Yearly 00:00:00 on the first day of the year when the record was created.

#2
The following table lists the difference between how the categories are displayed in PFM - Web Console reports and in the output of the ODBC driver.
Category PFM - Web Console ODBC driver
Per-minute Minute m
Hourly Hour H
Daily Day D
Weekly Week W
Monthly Month M
Yearly Year Y

#3
When you display data in a report or by using the ODBC driver, the Date field is displayed in the format YYYYMMDD, the Date and Time field is displayed in the format YYYYMMDD hh:mm:ss, and the Time field is displayed in the format hh:mm:ss.

[Contents][Back][Next]


[Trademarks]

All Rights Reserved. Copyright (C) 2009, Hitachi, Ltd.