Entera 4.2.1 Release Notes

 

Data access servers

Entera/Fx

--------------------------------------------------------------------------------

Supported UNIX platforms

--------------------------------------------------------------------------------

The supported UNIX platforms for this release are:

   * AIX 4.2.1 and 4.3.2

   * HP-UX 10.20 and 11.0

   * Solaris 2.5.1 and 2.6

   * Digital Alpha 4.0 D

--------------------------------------------------------------------------------

DCE version requirements

--------------------------------------------------------------------------------

The following table lists the DCE version requirements for the supported platforms:

  AIX 4.3

  HP-UX 10.20

  HP-UX 11.0

  Solaris 2.5.1

  Solaris 2.6

  Digital Alpha 4.0 D

  Windows NT

Supported DBMS client libraries

  In contrast to previous versions, Entera 4.2.1 data access servers use shared  library versions for the DBMS client libraries as much as possible, where  they exist. These libraries need to be installed on any machine where the  data access servers are going to be run, and where the DBMS itself is  located on a remote machine. The following are the packages that should  contain the supported client runtime libraries for their respective DBMS.  Remember to update your LD_LIBRARY_PATH (Solaris), LIBPATH (for AIX) or  SHLIB_PATH (for HP-UX) to point to the appropriate shared library  directories installed by each of these packages.  When compiling Entera/FX servers, the appropriate Software Development Kits  (SDK's) for each of these DBMS's must also be installed.

 * HP-UX 10.20

     Server       Required DBMS package

     ora_start    None (uses static libraries). For remote DBMS access, a   proper Oracle SQL *Net 2.3.3.0 installation is required.  However, if the data access server is accessing a local   Oracle instance, SQL*Net does not need to be installed.

     syb_start    Sybase Open Client 11.1.1

     ifx_start    Informix Client SDK 2.10UC1-1

     db2_start    IBM DB2 Client Application Enabler (CAE) 2.1

     db2_startv5  IBM DB2 Client Application Enabler (CAE) 5.2

     idb_start    Interbase API 5.0

 * HP-UX 11.0

     Server     Required DBMS package

     ora_start  None (uses static libraries). For remote DBMS access, a proper

                Oracle SQL*Net 2.3.3.0 installation is required. However, if

                the data access server is accessing a local Oracle instance,

                SQL*Net does not need to be installed.

     syb_start  Sybase Open Client 11.1.1

     ifx_start  Informix Client SDK 2.10UC1-1

 * IBM AIX 4.2 and 4.3

     Server       Required DBMS package

     ora_start    None (uses static libraries). For remote DBMS access, a

                  proper Oracle SQL*Net 2.3.3.0 installation is required.

                  However, if the data access server is accessing a local

                  Oracle instance, SQL*Net does not need to be installed.

     syb_start    Sybase Open Client 11.1.1

     ifx_start    Informix Client-SDK 2.10UC1-1

     db2_start    IBM DB2/HPUX Client Application Enabler (CAE) 2.1

     db2_startv5  IBM DB2 Client Application Enable (CAE) 5.2

     Note: Entera 4.2.1 Informix data servers differ from Entera 4.0 servers in

     that they support Informix Client-SDK 2.10 (which incorporates Informix-CLI

     2.8) instead of Informix-CLI 2.5. You must upgrade to Informix Client-SDK

     2.10 because of the severe concurrency limitations of previous versions.

 * Solaris 2.5.1

     Server     Required DBMS package

     ora_start  None (uses static libraries). For remote DBMS access, a proper

                Oracle SQL*Net 2.3.3.0 installation is required. However, if

                the data access server is accessing a local Oracle instance,

                SQL*Net does not need to be installed.

     syb_start  Sybase Open-Client 11.1.1.

     idb_start  InterBase API 5.0

     Note: Entera 4.2.1 Sybase data servers differ from Entera 4.0 servers in

     that they support Sybase Open-Client 11.1.1 instead of Open-Client 11.1.0.

     We highly recommend you upgrade to 11.1.1 as this version offers

     significant performance improvements because it uses native Solaris

     threads instead of DCE wrapper threads.

 * Solaris 2.6

     Server     Required DBMS package

     ora_start  None (uses static libraries). For remote DBMS access, a

                proper Oracle SQL*Net 2.3.3.0 installation is required. However,

                if the data access server is accessing a local Oracle instance,

                SQL*Net does not need to be installed.

     syb_start  Sybase Open-Client 11.1.1

     idb_start  InterBase API 5.0

 * Digital Alpha 4.0 D

     Server     Required DBMS package

     ora_start  None (uses static libraries). For remote DBMS access, a proper

                Oracle SQL*Net 2.3.3.0 installation is required. However, if

                the data access server is accessing a local Oracle instance,

                SQL*Net does not need to be installed.

     Note: Use ora8_start when connecting to Oracle 8.0.5.

 * Windows NT

     Server     Required DBMS package

     orastart   None (uses static libraries). For remote DBMS access, a proper

                Oracle SQL*Net 2.3.3.0 installation is required. However, if

                the data access server is accessing a local Oracle instance,

                SQL*Net does not need to be installed.

     sybstart   Sybase Open-Client 11.1.1

     idbstart   InterBase API 5.0

     clistart   ODBC version 2.5

Configuring Informix-CLI

  Informix-CLI requires that the file .odbc.ini be present in the home

  directory of the user who is running an Informix Online client (in this

  case, ifx_start or any Entera/FX server that access Informix). Please

  consult your Informix-CLI documentation for instructions on how to

  configure this file. The Informix Client-SDK can be downloaded from the

  Informix web site at:

    http://www.informix.com/products/tools/

Using sql_close_session and sql_close_cursor

  The sql_close_session and sql_close_cursor functions' API has changed.

  Instead of accepting just an [in] parameter as documented in the current

  manual set, these functions now accept an [in, out] parameter.As an

  example, for sql_close_session the IDL declarations is now:

    signed32  sql_close_session_<interface> (

      [in, out] cursor* ctx);

  The resulting C function stub prototype for this would be:

    signed32 sql_close_session_<interface>

    (

      cursor  *ctx

    )

  On success, these functions not only return 1, but also modify *ctx (the

  cursor variable pointed to by ctx) so that it is set to NULL. On failure,

  these functions return 0; the state of *ctx is undefined.

DBMS client library multi-threaded support

  While Entera 4.x data access servers are fully multi-threaded and

  concurrent, testing has revealed that most DBMS libraries have various

  levels of support for this advanced feature. What follows is what we have

  determined to be the current level of support for all of the supported

  DBMS's.

    Level  Description

   

A      Supports multiple connections in a concurrent, thread-reentrant   manner. Supports multiple concurrent active SQL statements even on   a single connection.

B      Supports multiple connections in a concurrent, thread-reentrant   manner. Only supports a single active SQL statement per   connection.

C      Supports multiple connections in a thread-safe manner. Only   supports a single active SQL statement per connection.   Serialization of client API calls is handled transparently by the   DBMS client library.

D      Supports multiple connections in a thread-safe manner. Only  supports a single active SQL statement per connection.   Serialization of client API calls is left up to the user.

E      Supports multiple connections, as long as login is done from the   main program thread. Only supports a single active SQL statement  per connection. Serialization of client API calls is left up to  the user.    

F      Does not support multiple connections in any manner.  Note: Because shared libraries are used for the syb_start (except for  Solaris), ifx_start and db2_start executables, merely upgrading your DBMS  client library package to a higher version might change its multi-threaded  support level for the better. To determine if a particular configuration is  officially supported, please contact eCube Systems Developer Support.

 * HP-UX 10.20

About Us | Site Map | Contact Us | ©2008 eCube Systems