This structure is used to return information after a call to the Database
System Monitor APIs. It will only be filled in for snapshot requests
made at the SQLM_DBMON_VERSION5_2 level and lower.
Table 57. Fields in the SQLM-COLLECTED Structure
| Field Name | Data Type | Description |
|---|---|---|
| SIZE | sqluint32 | The size of the structure. |
| DB2 | sqluint32 | Obsolete. |
| DATABASES | sqluint32 | Obsolete. |
| TABLE_DATABASES | sqluint32 | Obsolete. |
| LOCK_DATABASES | sqluint32 | Obsolete. |
| APPLICATIONS | sqluint32 | Obsolete. |
| APPLINFOS | sqluint32 | Obsolete. |
| DCS_APPLINFOS | sqluint32 | Obsolete. |
| SERVER_DB2_TYPE | sqluint32 | The database manager server type (defined in sqlutil.h). |
| TIME_STAMP | TIMESTAMP | Time that the snapshot was taken. |
| GROUP_STATES | OBJECT SQLM_ RECORDING_ GROUP | Current state of the monitor switch. |
| SERVER_PRDID | CHAR(20) | Product name and version number of the database manager on the server. |
| SERVER_NNAME | CHAR(20) | Configuration node name of the server. |
| SERVER_ INSTANCE_NAME | CHAR(20) | Instance name of the database manager. |
| RESERVED | CHAR(22) | Reserved for future use. |
| NODE_NUMBER | UNSIGNED SHORT | Number of the node sending data. |
| TIME_ZONE_DISP | sqlint32 | The difference (in seconds) between GMT and local time. |
| NUM_TOP_LEVEL_ STRUCTS | sqluint32 | The total number of high-level structures returned in the snapshot output buffer. A high-level structure can be composed of several lower-level data structures. This counter replaces the individual counters (such as table_databases) for each high-level structure, which are now obsolete. |
| TABLESPACE_ DATABASES | sqluint32 | Obsolete. |
| SERVER_VERSION | sqluint32 | The version of the server returning the data. |
For information about programming the database monitor, see the System Monitor Guide and Reference.
Language Syntax
C Structure
/* File: sqlmon.h */
/* Structure: SQLM-COLLECTED */
/* ... */
typedef struct sqlm_collected
{
sqluint32 size;
sqluint32 db2;
sqluint32 databases;
sqluint32 table_databases;
sqluint32 lock_databases;
sqluint32 applications;
sqluint32 applinfos;
sqluint32 dcs_applinfos;
sqluint32 server_db2_type;
sqlm_timestamp time_stamp;
sqlm_recording_group group_states[SQLM_NUM_GROUPS];
_SQLOLDCHAR server_prdid[SQLM_IDENT_SZ];
_SQLOLDCHAR server_nname[SQLM_IDENT_SZ];
_SQLOLDCHAR server_instance_name[SQLM_IDENT_SZ];
_SQLOLDCHAR reserved[22];
unsigned short node_number;
long time_zone_disp;
sqluint32 num_top_level_structs;
sqluint32 tablespace_databases;
sqluint32 server_version;
}sqlm_collected;
/* ... */
|
COBOL Structure
* File: sqlmonct.cbl
01 SQLM-COLLECTED.
05 SQLM-SIZE PIC 9(9) COMP-5.
05 DB2 PIC 9(9) COMP-5.
05 DATABASES PIC 9(9) COMP-5.
05 TABLE-DATABASES PIC 9(9) COMP-5.
05 LOCK-DATABASES PIC 9(9) COMP-5.
05 APPLICATIONS PIC 9(9) COMP-5.
05 APPLINFOS PIC 9(9) COMP-5.
05 DCS-APPLINFOS PIC 9(9) COMP-5.
05 SERVER-DB2-TYPE PIC 9(9) COMP-5.
05 TIME-STAMP.
10 SECONDS PIC 9(9) COMP-5.
10 MICROSEC PIC 9(9) COMP-5.
05 GROUP-STATES OCCURS 6.
10 INPUT-STATE PIC 9(9) COMP-5.
10 OUTPUT-STATE PIC 9(9) COMP-5.
10 START-TIME.
05 SERVER-PRDID PIC X(20).
05 SERVER-NNAME PIC X(20).
05 SERVER-INSTANCE-NAME PIC X(20).
05 RESERVED PIC X(32).
05 TABLESPACE-DATABASES PIC 9(9) COMP-5.
05 SERVER-VERSION PIC 9(9) COMP-5.
*
|