This statement adds a database to the distribution rule.
Scope of validity
SESDCN administration
See also
SESDCN control statement ADD-DISTRIBUTION-RULE-LIST on "ADD-DISTRIBUTION-RULE-LIST"
SESDCN control statement ADD-NETWORK-LINK-LIST on "ADD-NETWORK-LINK-LIST"
Function
The ADD-DISTRIBUTION-RULE-ENTRY statement adds a database entry to the distribution rule.
The logical name of the database you want to add to the distribution rule must be unique in the distributed application and thus throughout the network. If the distribution rule already contains an entry with the same logical database name, the administration statement is rejected.
Together with the entries created implicitly by SESAM/SQL (see the note on "Entering SESDCN control statements") the distribution rule may contain a maximum of 340 entries. You can, however, explicitly enter at least 300 databases and their associated networks. If the distribution rule is full, SESAM/SQL-DCN rejects the administration statement.
The administration statement is also rejected if a DBH would be assigned to several SESDCNs as a result of accepting it.
ADD-DISTRIBUTION-RULE-ENTRY |
CATALOG-NAME = <filename 1..18 without-cat-user-gen-vers> ,DBH-NAME = *BLANK / <alphanum-name 1..1> ,DCN-NAME = *BLANK / <alphanum-name 1..1> ,CONFIGURATION-NAME = *STD / <alphanum-name 1..1> / *BLANK ,HOST-NAME = *STD / <name 1..8> |
Operands
CATALOG-NAME = <filename 1..18 without-cat-user-gen-vers>
Logical database name of the SESAM/SQL database or CALL DML table to be entered. The logical database name is the name by which a database or CALL DML table is addressed in the application program. The logical database name must be unique throughout the network.
DBH-NAME = *BLANK / <alphanum-name 1..1>
Name of the SESAM/SQL DBH to which the database is assigned
DCN-NAME = *BLANK / <alphanum-name 1..1>
Name of the remote DCN that forwards remote accesses to the database
CONFIGURATION-NAME = *STD / <alphanum-name 1..1> / *BLANK
Name of the configuration to which the remote DCN is assigned.
The default is the name of the configuration in which administration is being carried out, i.e. the configuration assigned to the SESDCN that is carrying out administration. This is the configuration specified by the last START-DCN-ADMINISTRATION statement.
HOST-NAME = *STD / <name 1..8>
Symbolic device name of the computer on which the database to be entered resides.The default is the name of the computer on which the SESDCN carrying out administration is running. This is the computer specified by the last START-DCN-ADMINISTRATION statement.
Administration command in ISP format
The UPD administration command corresponds to the ADD-DISTRIBUTION-RULE-ENTRY administration statement here.
[tsn,]UPD,CATALOG=db-name,PRO=processor[,CNF=k][,DCN=x][,DBH=z]
CNF, DCN and DBH can contain blanks as parameter values. You must enter an underscore (_) as a metacharacter for a blank.