9.7.1 ALTER

Purpose

The ALTER command performs an action on or changes attributes of a single database server object or multiple objects. The ALTER command can be used to change an attribute or to take an action upon the object.

Syntax

ALTER { object_type object_name[, object_name]... operation
      | attribute_name = attribute_value 
        [, attribute_name = attribute_value]...
     }

Usage Notes

The following arguments can be used with the command:

• object_type can be the following:
  • ALERTHISTORY
  • DBSERVER
  • IBPORT (not available in user domain (domU) environments)
  • THRESHOLD (not available in user domain (domU) environments)
  • USER (not available in user domain (domU) environments)
• object_name is the name or identifier of an alert history, database server, LUN, or threshold.
• operation is a valid action for the specified object_type.

When multiple objects are the target of an ALTER command, there is the possibility of partial success. If an error occurs, then the command is interrupted, and the remaining objects are not changed.

• ALTER ALERTHISTORY
  
• ALTER DBSERVER
  The ALTER DBSERVER command changes the attributes of the database server.
• ALTER IBPORT
  
• ALTER METRICDEFINITION
  
• ALTER THRESHOLD
  
• ALTER USER