Permission required: Privileged user.
The Name Server Maintenance Utility (iinamu) allows a system administrator or other privileged user to display server information and administer the Name Server.
The iinamu command has the following format:
iinamu
At the IINAMU prompt, enter one of the following commands:
Shows the list of registered servers. The svr_type can be:
Shows all servers registered with the Name Server.
(Default) Shows Ingres DBMS Server process
Shows GCC Communications Server process
Shows Name Server process
Shows Data Access Server process
Shows Star Server process
Shows Remote Command Server process
Shows ICE Server process
Shows Protocol Bridge Server process
Shows Recovery Server process
Shows Enterprise Access Server (gateway) process. Gateway can be: MSSQL, ORACLE, DB2UDB, INFORMIX, SYBASE, RDB, or RMS.
Shows user-defined DBMS server process, as defined in the server_class parameter for the DBMS Server in Configuration-By-Forms or Configuration Manager, for example BATCH, ONLINE, ACCOUNTS.
Adds a server to the list of registered servers. Only a privileged user can run this command. Adding entries is not recommended and should be unnecessary as the information is automatically obtained from the servers during registration (at startup) and is based on the configured server_classes.
Specifies the names of the objects that each server can service. Valid values are:
* (asterisk)—Is the default for DBMS Servers, which indicates that all databases can be accessed. All other servers do not register specific objects.
Database list—Is a single database or a comma separated list of databases that the Ingres DBMS Server can connect to.
flag can be one or more of the following values:
sole—Adds a sole server.
merge—Does not delete existing entries for the server at gcf_address when the new entry is added. Use this flag to add a new object to be serviced by an existing server.
Deletes a server from the list of registered servers. Only a privileged user can run this command. The svr_type and obj_name must associate with the information for the gcf_address.
Stops the Name Server. This command is the correct way to stop the Name Server process. If the Name Server is stopped while servers are running, users cannot connect to those servers. Connected users will not be affected until they need to connect to a server. Only a privileged user can run this command.
Displays command information.
Closes iinamu.
Note: At times, you may want to start DBMS servers that are not publicly registered with the Name Server. You can do this by setting the configuration parameter name_service to off. If this option is used, the server is not registered with the Name Server when it starts and is therefore invisible to iinamu. The GCF address can still be found and the server manually registered with the Name Server. If the server is a DBMS Server, connection can still be made by defining II_DBMS_SERVER to the server address.
The following command shows all servers registered with the Name Server:
IINAMU> show servers
UNIX: Here is sample output:
IINMSVR * 32770
IUSVR * 32775
INGRES * 32777
COMSVR * 32779
COMSVR * 32781
BRIDGE * 32793
JDBC * 32795
STAR * 32799
RMCMD * 32802
JOHN * 32810
DASVR * 32817
Windows: Here is sample output:
IINMSVR * EI\NMSVR\a10
IUSVR * EI\IUSVR\504
INGRES * EI\INGRES\f50
COMSVR * EI\COMSVR\e84
COMSVR * EI\COMSVR\cc8
BRIDGE * EI\BRIDGE\cb0
JDBC * EI\JDBC\ca8
STAR * EI\STAR\cd4
RMCMD * EI\RMCMD\cf8
JOHN * EI\JOHN\9b0
DASVR * EI\DASVR\924
The first column is the server type.
The second column is a list of databases registered to be served by the server. The entry * means that the server is registered to service requests for any database.
The third column is the server identifier, which is the GCF address for access to this server. This identifier can be used with the iimonitor command (in the case of DBMS, Recovery, and GCF servers).
This command shows all DBMS Servers:
IINAMU> show ingres
Here is sample output:
UNIX: Here is sample output:
INGRES * 3105
INGRES * 4204 
Windows: Here is sample output:
INGRES * II\INGRES\aa
INGRES * II\INGRES\ca 
The example shows two DBMS servers running at GCF addresses 3105 and 4204 (on UNIX), and with process IDs of aa and ca (on Windows).
This command shows the Communications Server registrations:
IINAMU> show comsvr
UNIX: This sample output shows that two Communications Servers are running:
COMSVR * 3197
COMSVR * 3321
Windows: This sample output shows that two Communications Servers are running:
COMSVR * II\COMSVR\b3
COMSVR * II\COMSVR\a2
UNIX: This command adds to the Name Server registry a DBMS Server with GCF address 1093 that can connect to any database:
IINAMU> add ingres * 1093
This command adds a DBMS Server with GCF address 2180 that can connect only to the salesdb database:
IINAMU> add ingres salesdb 2180
This command adds the accounts database to the existing DBMS Server with GCF address 2180:
IINAMU> add ingres accounts 2180 merge 
Windows: This command adds to the Name Server registry a DBMS Server with a process ID of "af" that can connect to any database:
IINAMU> add ingres * II\INGRES\af
This command adds a DBMS Server with a process ID of "ab" that can connect only to the salesdb database:
IINAMU> add ingres salesdb II\INGRES\ab
This command adds the accounts database to the existing DBMS Server II\INGRES\ab:
IINAMU> add ingres accounts II\INGRES\ab merge 
UNIX: This command deletes a DBMS Server with GCF address 1093 from the GCN registry so it is no longer visible from the Name Server:
IINAMU> delete ingres * 1093
Windows: This command deletes a DBMS Server with a process ID of "af" from the Name Server registry so it is no longer visible from the Name Server:
IINAMU> delete ingres * II\INGRES\af
This command stops the Name Server:
IINAMU> stop 