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
ODBCLink/SE |
|
©M.B. Foster Associates Limited | 7 |