ODBCLink/SE Reference Manual

Preparing the Database Server

Preparing the Database Server

Before you install ODBCLink/SE on the PC client, perform the following steps to prepare the database server:

Verify the software version numbers.

Verify the Connection Assurance Parameters.

Starting and Stopping the listener.

Gather information.

Create the DBEnvironment

Verify Software Version Numbers

Note: If you are using ALLBASE/SQL, version A.G1.15 or higher is required.

On the HP3000 enter:

: SQLVER.PUB.SYS

Note: If you are using IMAGE/SQL, the version number should be

B.G1.10 or higher. Type:

On the HP9000 enter:

$sqlver

:IMAGESQL.PUB.SYS

>>exit

Note: If both ALLBASE/SQL and IMAGE/SQL are installed, both must be either the respective version state above or newer in order to use ODBCLink/SE.

Verify the Connection Assurance Parameters

When the connected PC client application terminates abnormally or aborts, connection assurance parameters, set under MPE/iX, determine the length of time that the server takes to time out the connection. Because the server process may be holding locks when the PC aborts, it is important that these parameters are set properly.

Your network administrator should verify that the settings for Connection Assurance Interval and Maximum Connection Assurance Retransmissions parameters are set appropriately.

The Connection Assurance Interval specifies the amount of time between each polling event. The default value is 600 seconds.

The Maximum Connection Assurance Retransmissions specifies the number of retries the server is polled after a PC client abort has been detected by the polling event. The default value is four times.

After the connection abort, the server polls the connection five times (the polling event plus four retries). The connection times out after 4 ten-minute intervals plus the amount of time between the polling event and the first retry after the connection aborted.

ODBCLink/SE

 

©M.B. Foster Associates Limited 1995-2000

7

Page 17
Image 17
HP MPE/iX 6.x Operating System Verify Software Version Numbers, Verify the Connection Assurance Parameters, $sqlver, Exit