RMSERVER

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') ;

Column Definitions

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.