This table holds server information including itself.
It extends use of Content Manager Version 6, and replaces the FRNOLINT.
Table 1. RMSERVER| Column Name |
Data Type |
Attribute |
|---|
| SVR_SERVERID |
SMALLINT |
NOT Null |
| SVR_SERVERTYPE |
CHAR(4) |
NOT Null |
| SVR_SERVERNAME |
CHAR(32) |
NOT Null |
| SVR_PROTOCOL |
CHAR(5) |
NOT Null |
| SVR_USERID |
SMALLINT |
NOT Null |
| SVR_HOSTNAME |
VARCHAR(254) |
NOT Null |
| SVR_PORT |
INTEGER |
NOT Null |
| SVR_SCHEMA |
CHAR(32) |
NULLABLE |
| SVR_PATH |
CHAR(254) |
NULLABLE |
| SVR_SERPLATFORM |
CHAR(17) |
NOT Null |
| SVR_TSMBUFFERSIZE |
INTEGER |
NULLABLE |
| SVR_TSMFSNAME |
VARCHAR(256) |
NULLABLE |
| SVR_TSMFSINFO |
VARCHAR(256) |
NULLABLE |
| SVR_DSMI_OPT |
VARCHAR(1024) |
NULLABLE |
- Primary Key
- (SVR_SERVERID)
- Indexes
-
Unique Index = (SVR_SERVERID ascending)
- Referential Constraints
-
FOREIGN KEY (SVR_USERID)
REFERENCES RMACCESS
ON DELETE RESTRICT
ON UPDATE RESTRICT
- Trigger (DB2® and Cloudscape only)
-
CREATE TRIGGER RMSERVER_CASECHECK
NO CASCADE BEFORE INSERT ON RMSERVER
REFERENCING NEW AS N
FOR EACH ROW MODE DB2SQL
WHEN (LCASE(N.SVR_SERVERNAME) = (SELECT LCASE(SVR_SERVERNAME)
FROM RMSERVER WHERE LCASE(N.SVR_SERVERNAME) = LCASE(SVR_SERVERNAME)))
SIGNAL SQLSTATE '75000' ('Servername already exists') ;
- SVR_SERVERID
- An ID number for reference by the RMVolumes table.
The next highest number is always used for inserts. A SVR_SERVERID
of 0 is reserved for the resource manager itself. It represents the
name that the resource manager uses when it connects to the library
server.
- SVR_SERVERTYPE
- Describes the server class. Allowed values are
RM, LS, TSM, VC, MA, and PLS.
- SVR_SERVERNAME
- DataBase name or a user specified identifier if dbname is not
relevant. All dbnames in the enterprise must be unique.
- SVR_PROTOCOL
- Protocol used to talk to server, one per server. Allowed values:
http, jdbc. Future values: https, ftp, rtp.
- SVR_USERID
- An ID that maps to an RMAccess row.
- SVR_HOSTNAME
- Fully qualified hostname. Should not be an IP number.
- SVR_PORT
- Port number used for the protocol. Currently only valid for HTTP.
- SVR_SCHEMA
- Schema name for databases.
- SVR_PATH
- Server pathname for HTTP access.
- SVR_SERPLATFORM
- Server platform. The currently accepted values are: WIN, AIX, SUN,
and S390.
- SVR_TSMBUFFERSIZE
- The buffer size used to transfer data to and from TSM.
- SVR_TSMFSNAME
- The file space name used by TSM.
- SVR_TSMFSINFO
- The resource manager unique identifier for objects in TSM.
- SVR_DSMI_OPT
- The fully-qualified path for the Tivoli Storage Manager client
options file.
