This structure is used to return information after a call to the Database
System Monitor APIs.
Table 58. Fields in the SQLM-RECORDING-GROUP Structure
| Field Name | Data Type | Description |
|---|---|---|
| INPUT_STATE | INTEGER | Required state for the specific monitor group. |
| OUTPUT_STATE | INTEGER | Returned information on the state of the specific monitor switch. |
| START_TIME | Structure | Time stamp when the monitoring group switch was turned on. |
Table 59. Fields in the SQLM-TIMESTAMP Structure
| Field Name | Data Type | Description |
|---|---|---|
| SECONDS | INTEGER | The date and time, expressed as the number of seconds since January 1, 1970 (GMT). |
| MICROSEC | INTEGER | The number of elapsed microseconds in the current second. |
For both input_state and output_state, a particular monitor switch is identified by its index in the array passed to db2MonitorSwitches - Get/Update Monitor Switches. The constants that map the indexes to the switches are called SQLM_XXXX_SW, where XXXX is the name of the monitor group. These constants are defined in sqlmon.h.
For information about programming the database monitor, see the System Monitor Guide and Reference.
Language Syntax
C Structure
/* File: sqlmon.h */
/* Structure: SQLM-RECORDING-GROUP */
/* ... */
typedef struct sqlm_recording_group
{
sqluint32 input_state;
sqluint32 output_state;
sqlm_timestamp start_time;
}sqlm_recording_group;
/* ... */
|
/* File: sqlmon.h */
/* Structure: SQLM-TIMESTAMP */
/* ... */
typedef struct sqlm_timestamp
{
sqluint32 seconds;
sqluint32 microsec;
}sqlm_timestamp;
/* ... */
|
COBOL Structure
* File: sqlmonct.cbl
01 SQLM-RECORDING-GROUP OCCURS 6 TIMES.
05 INPUT-STATE PIC 9(9) COMP-5.
05 OUTPUT-STATE PIC 9(9) COMP-5.
05 START-TIME.
10 SECONDS PIC 9(9) COMP-5.
10 MICROSEC PIC 9(9) COMP-5.
*
|
* File: sqlmonct.cbl
01 SQLM-TIMESTAMP.
05 SECONDS PIC 9(9) COMP-5.
05 MICROSEC PIC 9(9) COMP-5.
*
|