This table maintains a catalog of storage nodes.
Table 1. Node table (ARSNODE)
| Column Name |
Data Type |
Description |
| sid |
INTEGER |
Storage set identifier |
| nid |
SMALLINT |
Storage node identifier |
| name |
VARCHAR(60) |
Name of storage node |
| description |
VARCHAR(120) |
Description of storage node |
| logon |
VARCHAR(128) |
Storage manager logon userid |
| passwd |
VARCHAR(128) |
Storage manager logon password |
| server |
VARCHAR(254) |
Name of OnDemand object server |
| status |
SMALLINT |
Current location of storage set |
| sec_nid |
SMALLINT |
Secondary storage node |
| upd_userid |
VARCHAR(128) |
Userid of last user to update storage node |
| upd_date |
BIGINT
(DB2®, SQL Server),
INT (Oracle) |
Date and time storage node
was last updated (in old style) |
| upd_dt |
TIMESTAMP (DB2, Oracle), DATETIME2(6) (SQL Server) |
Date and time storage node
was last updated |
Table 2. Indexes for node table (ARSNODE)
| Index name |
Columns in index |
Type of index |
| arsnode_idx |
sid, nid |
Unique cluster index for DB2; Unique index for Oracle and SQL Server |
| arsnode_name_idx |
sid, name, server |
Unique cluster index for DB2; Unique index for Oracle and SQL Server |