Modify a Connectable (connectableModify)

The connectableModify command modifies a connectable object.

ttGridAdmin connectableModify [-only hostname[.instancename]]
                              filepath

Options

The connectableModify command has the options:

Option Description

Option	Description
`-only` `hostname[.instancename]`	For connectables created for client/server connections (as determined by the `-cs` option of `connectableCreate`), optionally specifies that applications connecting through this connectable should connect to the indicated instance. By default, all data instances in the grid are available and connections are distributed among them. You need to specify the instance name only if there is more than one instance on the host. You can specify multiple `-only` options, in which case client/server applications can connect to any instance listed in the `-only` settings. Note: Instances specified with `connectableModify -only` replace any instances specified with `connectableCreate -only`.
`filepath`	Path and name of the connectable file, which contains the new set of connection attribute settings. The file name must be of the form `connname.connect`, where `connname` is the name of the connectable.

-only hostname[.instancename]

For connectables created for client/server connections (as determined by the -cs option of connectableCreate), optionally specifies that applications connecting through this connectable should connect to the indicated instance. By default, all data instances in the grid are available and connections are distributed among them.

You need to specify the instance name only if there is more than one instance on the host.

You can specify multiple -only options, in which case client/server applications can connect to any instance listed in the -only settings.

Note: Instances specified with connectableModify -only replace any instances specified with connectableCreate -only.

filepath

Path and name of the connectable file, which contains the new set of connection attribute settings. The file name must be of the form connname.connect, where connname is the name of the connectable.

Examples

The example modifies the client/server connectable created in the connectableCreate example, editing database1client.connect to add a PermWarnThreshold setting:

ConnectionCharacterSet=AL32UTF8
UID=ttclient
PermWarnThreshold=80

Modify the connectable:

% ttGridAdminttGridAdmin connectableModify /sw/tten/grid/conndefs/database1client.connect
Connectable database1client modified.

Notes

All connection attribute settings from the previous connectable file are replaced with the connection attribute settings in the specified file.
You cannot modify a connectable to change from client/server use to direct mode use, or from direct mode use to client/server use. Instead, delete the connectable and create a new one.
When you apply the model after modifying a connectable, new versions of all necessary configuration files are written to each data instance, with the connectable entry modified according to the new settings. (Never edit configuration files manually. They are overwritten each time the model is applied.)