Job Management Partner 1 Version 10, Job Management Partner 1/Performance Management - Remote Monitor for Microsoft(R) SQL Server Description, User's Guide and Reference

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

List of data types

The following table lists the data types for field values and the corresponding C and C++ data types. The values in the Format column of the record field tables have the types shown below in the Field column under Data type.

Table 5-5 List of summary rules

Data type Byte Description
Field C and C++
char(n) char( ) Number in parentheses Character data of n bytes.
double double 8 Numeric value (1.7E[Figure]308 (15 digits))
long long 4 Numeric value (-2,147,483,648 to 2,147,483,647)
string(n) char[ ] Number in parentheses Character string of n bytes.
  • Japanese Windows:
    Shift-JIS characters can be set.
  • Simplified-Chinese Windows:
    GB18030 characters can be set#.
  • Other Windows:
    Only 7-bit ASCII characters can be set.
The last character is null.
time_t unsigned long 4 Numeric value (0 to 4,294,967,295)
timeval Structure 8 Numeric value (first 4 bytes are seconds, next 4 bytes are microseconds)
ulong unsigned long 4 Numeric value (0 to 4,294,967,295)
utime Structure 8 Numeric value (first 4 bytes are seconds, next 4 bytes are microseconds)
word unsigned short 2 Numeric value (0 to 65,535)
(Not applicable) unsigned char 1 Numeric value (0 to 255)

#
In Simplified-Chinese Windows environment, database name of monitoring target SQL Server don't use out of range of GBK. If you use out of range of GBK in database name, PFM - RM for SQL Server collect performance data fail. In this case, "KAVL19812-E" is output by agent log error file (detail information: rc=0x80040e37, msg include "?").