Hitachi

JP1 Version 12 JP1/Performance Management - Remote Monitor for Microsoft(R) SQL Server Description, User's Guide and Reference


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±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 Microsoft SQL Server don't use out of range of GBK. If you use out of range of GBK in database name, PFM - RM for Microsoft SQL Server collect performance data fail. In this case, "KAVL19812-E" is output by agent log error file (detail information: rc=0x80040e37, msg include "?").