Creating an accelerator

You create an accelerator by connecting the accelerator server to an Informix® database server. An accelerator is a logical entity that contains information for a connection to a database server and for the data marts associated with that connection. Set up the connection by using the ondwa getpin command to retrieve the IP address, port number, and pairing code from the accelerator server.

Procedure

On the computer where the accelerator server is installed, log on as user root.
Run the ondwa getpin command to retrieve the IP address, port number, and pairing code from the accelerator server. This information is needed to establish the initial connection from the Informix® database server to the accelerator server.
In the Workspace Launcher window you can use the default workspace, select an existing workspace, or create a new workspace:
- The file path and name of default workspace appears in the Workspace drop-down box. To accept the default workspace, click OK.
- To select an existing workspace, choose a workspace from the drop-down list and click OK.
- To create a new workspace, click Browse. Navigate to the directory location where you want to create the workspace and click Make New Folder. Type the name for the workspace and click OK. Then click OK again.
The first time a workspace is created, a Welcome screen appears. Close the Welcome screen. The newly created blank workspace appears.
Connect Smart Analytics Optimizer Studio to the Informix® database server and add the accelerator:
1. In the Data Source Explorer window, open the Database Connections folder.
2. Create a new connection to the Informix® database server. You must use the Informix® JDBC Driver for the connection.
  
  Restriction: The HCL Data Server Driver for JDBC is not supported for the connection between Smart Analytics Optimizer Studio and the Informix® database server.
3. To add a new accelerator to the database, right-click the Database Connection folder. Right-click the Accelerators folder and choose Add Accelerator.
4. Using the information you gathered in Step 2, type the name and pairing information for the accelerator.
5. Click OK.
A connection between the accelerator server and the database server is established, and the sqlhosts file on the Informix® database server is updated with the connection information. An example of an entry in the sqlhosts file is:
```
FLINS2 group - - c=1,
		a=4b3f3f457d5f552b613b4c587551362d2776496f226e714d75217e22614742677b424224
FLINS2_1 dwsoctcp 127.0.0.1 21022 g=FLINS2
```

Use the SET EXPLAIN statement to see the query plan.

If the query is accelerated, the Remote SQL Request section appears in the query plan. For example:

QUERY: DWA Executed(OPTIMIZATION TIMESTAMP: 02-20-2011 01:05:57)


------
select sum(units) from salesfact

Estimated Cost: 242522
Estimated # of Rows Returned: 1
Maximum Threads: 0

1) sk@FLINS2:dwa.aqt0f957100-cca1-406b-93cc-cae2117122ae: 

Remote SQL Request:
{QUERY {FROM dwa.aqt0f957100-cca1-406b-93cc-cae2117122ae} 
{SELECT {SUM {SYSCAST COL10 AS BIGINT} } } }



QUERY: IDS FYI(OPTIMIZATION TIMESTAMP: 02-20-2011 01:05:57)
------
select sum(units) from salesfact

Estimated Cost: 242522
Estimated # of Rows Returned: 1
Maximum Threads: 0

1) informix.salesfact: SEQUENTIAL SCAN


Query statistics:
-----------------

Table map :
----------------------------
Internal name Table name
----------------------------

type rows_prod est_rows time est_cost
-------------------------------------------------
remote 1 0 00:00.00 0