ifx_setupDWA() function

The ifx_setupDWA() function creates an accelerator in an accelerator server. This function creates the connection between the database server and the accelerator server. You can also use this function to renew the connectivity information for an accelerator.

Syntax


1  ifx_setupDWA ( ' accelerator_name ' , ' ip ' , ' port_number ' , ' pairing_code ' )
accelerator_name
The name of the accelerator. You must use a name that does not exist in the accelerator server. The accelerator name has a maximum length of 128 characters.
ip
The IP address of the accelerator server. You obtain this value by running the ondwa getpin command. If you are renewing the connection for an accelerator, this value must be NULL.
port_number
The service port number of the accelerator server. You obtain this value by running the ondwa getpin command. If you are renewing the connection for an accelerator, this value must be NULL.
pairing_code
The pairing code. You obtain this value by running the ondwa getpin command. If you are renewing the connection for an accelerator, this value must be NULL.

Usage

Important: To run the ifx_setupDWA() function, you must be logged in as user informix and you must have write access to the sqlhosts file and to the directory where the sqlhosts file is located.

Return value

The ifx_setupDWA() function returns the text string "The operation was completed successfully." or an error message.

Examples

The following example shows how to create an accelerator with the name 'MyAccelerator'. The IP address, port number, and pairing code are the results of running the ondwa getpin command.

EXECUTE FUNCTION ifx_setupDWA('MyAccelerator', '127.0.0.1', '21022', '1234');

The following example shows how to renew the connection for an accelerator with the name 'MyAccelerator'. The last three parameters must be specified as NULL.

EXECUTE FUNCTION ifx_setupDWA('MyAccelerator', NULL, NULL, NULL);