![](/images/backgrounds/286310/hp-3par-system-reporter-e-media-kit-users-manual-156017335x1.png)
System Reporter 2.8 | 3PAR System Reporter User’s Guide |
Table | 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 |
|
| 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) |
| |
|
| |
|
|
|
10.4.15 The statportinv Table
The statportinv_<res>_1 table holds the inventory for the statport_<res>_2 table.
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