ALTER SYSTEM

Use the ALTER SYSTEM command to change the default and current settings of the ObjectServer. Run the command to set properties, shut down the ObjectServer, drop user connections, redirect clients to a different ObjectServer, or back up the ObjectServer.

Syntax

ALTER SYSTEM
 {
 SHUTDOWN |
 SET 'property_name' = value [ ... ] |
 DROP CONNECTION connection_id [, ... ] |
 REDIRECT CONNECT 'servername' | 
 BACKUP 'directory_name'
 }
;

Stopping ObjectServers

You can stop the ObjectServer with the ALTER SYSTEM SHUTDOWN command.

Setting ObjectServer properties

You can set ObjectServer properties with the SET keyword followed by the property name in quotation marks and a value for the property. You can change more than one property in a single command. In addition to updating the catalog.properties table, the changed properties are written to the properties file.
The following sample shows the SET keyword with the ALTER SYSTEM command.
alter system set 'Auto.StatsInterval' = 15 set 'AlertSecurityModel' = 1;

alter system shutdown;

Dropping user connections

You can drop user connections with the ALTER SYSTEM DROP CONNECTION command. Specify one or more connection identifiers in a comma-separated list. You can find the identifiers for all current connections by querying the catalog.connections system table. The ConnectionID column contains the connection identifier.

Resolved from fix pack 4

Redirect client connections

You can redirect a client to connect to a different ObjectServer in the pre_connect signal by using the alter system redirect connection command. Specify the server name for the ObjectServer you want the client to be redirected to. The server name must exist in the local omni.dat file.

Note: The redirect feature requires the following versions or later of the following products and components:
  • IBM Tivoli Netcool/OMNIbus 8.1 server component Fix Pack 4
  • IBM Tivoli Netcool/OMNIbus Web GUI component 7.4
  • IBM Tivoli Netcool/Impact 6.1
  • IBM Tivoli Network Manager IP Edition 3.9 Fix Pack 4
  • IBM Tivoli Network Manager IP Edition 4.1.1 Fix Pack 1 with Web GUI 7.4 Fix Pack 3

Backing up ObjectServers

You can back up the ObjectServer with the ALTER SYSTEM BACKUP command. Specify the path to an existing directory where you want to back up the files. This value must be in quotation marks. The backup generates copies of the ObjectServer .tab files in the specified directory. The directory cannot be the one in which ObjectServer data files are stored, which is $NCHOME/omnibus/db/server_name by default.

Tip: The triggers in the automatic_backup_system trigger group, which are defined in the $NCHOME/omnibus/etc/automation.sql file, use the ALTER SYSTEM BACKUP command to provide an automatic backup facility. The automatic_backup trigger is disabled by default; you must enable it to create backups automatically. You can also customize this trigger to suit your environment. For example, you can change the number of backups saved.

Restoring ObjectServers

To recover the ObjectServer to the point in time at which the BACKUP command was issued, copy the ObjectServer .tab files into the ObjectServer data file directory. You can use the backup files only on a computer that has the same operating system as the computer on which the files were created.