System Reporter 2.8

3PAR System Reporter User’s Guide

Table 10-25.

statport_<res>_2 Table

Column

Type

Comment

 

 

 

porttype

VARCHAR(32) NOT

The port type. Currently, the port types

 

NULL

are:

 

 

disk - Fibre channel ports that disks are

 

 

connected to.

 

 

host -.Fibre channel ports that hosts are

 

 

connected to (directly or through a

 

 

fabric).

 

 

rcip - Remote Copy IP ports.

 

 

rcfc - Remote Copy fibre channel ports.

 

 

iscsi - iSCSI host ports.

 

 

free - ports that are not connected.

 

 

 

(common

 

The rest of the columns are the common

performance

 

performance columns described in

columns)

 

Common Performance Table Columns on

 

 

page 10.30).

 

 

 

10.4.15 The statportinv Table

The statportinv_<res>_1 table holds the inventory for the statport_<res>_2 table.

Table 10-26.statportinv_<res>_1 Table

Column

Type

Comment

 

 

 

tsecs

INTEGER NOT

Sample time in secs. This is the Unix time

 

NULL

and is the number of seconds since

 

 

0:00:00 Jan 1, 1970 GMT.

 

 

 

sys_uid

INTEGER NOT

A unique identifier for the InServ system

 

NULL

instance refers to the uniq_id for the

 

 

InServ system instance in the system_3

 

 

table.

 

 

 

The Sample Data and Inventory Tables 10.43