IBM® Informix® Warehouse Accelerator, Version 12.10
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
>>-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);
Release date: March 2015