Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
AtulKumarJain
Active Contributor

Sybase client installation

Enable remote/secondary connect to Sybase

1.  Sybase IQ server is installed.

    a) Minimum required version is 15.4 ESD3 (15.4.0.3027).

    b) The code page of the server must be CESU-8 with collation/sort
       order CESU8BIN binary. Incorrect code pages cause data corruption
       and require a reinstall of the IQ server.

2.  The SQL Anywhere ODBC driver is installed and accessible from the
     SAP NetWeaver Application Server.

    a) Minimum required version is 12.00.3027 - shipped as SQL Anywhere
       ODBC 15.4 ESD3.

    b) The SQL Anywhere ODBC driver is available for 64 -bit Linux AMD
       (linuxx86_64) and Windows for 64 bit (ntamd64)
       at:https://service.sap.com/swdc
       -> Support Packages and Patches
       -> Browse our Download Catalog
       -> Sybase Products
       -> SYBASE IQ ODBC NLS
       -> SYBASE IQ ODBC NLS 15.4
       -> Linux on x86_64 64bit or Windows on x64 64bit
       -> IQCLIENT154SP01

    c) Use SAPCAR -xvf IQCLIENT154.SAR to extract the libraries directly
                                                                

       into the instance exe directory (e.g. /usr/sap/SID/DVEBMGS00/exe).

       This way - once the lib_dbsl and the DBCO entries are available
       (see steps below) - no restart of the application server is
       required. Also no adaption of the library path is required.

Alternatively you can extract the archive to an empty directory
of your choice which will then contain only the
client,e.g./usr/sap/SID/DVEBMGS00/exe/iqodbc.

The library path of the application server must then be adapted
to include the ODBC driver. This requires a restart of the
application server after the installation of the driver:

Add the directory to the LD_LIBRARY_PATH environment variable of
<SAPSID>adm user (Windows: PATH variable) and restart the
application server (Windows: in addition the SAP service
(SAPService<SAPSID>) must be restarted).


3.  The SAP NetWeaver kernel release must be 720, 721 or 738.

    For 720 the required patch level is at least 321 for disp+work and
    420 for lib_dbsl.

    For 721 the required patch level is at least 30 for disp+work and
    110 for lib_dbsl.

    For 738 the required patch level is at least 0 for disp+work and 16
    for lib_dbsl.

    a) Only Unicode systems

    b) Only Linux AMD 64 bit (linuxx86_64) or Windows 64 bit (ntamd64)
       are supported.

    c) For 720 and 721 only the EXT kernel version is supported.

4.  The lib_dbsl for Sybase (dbsybslib.so/dll) must be copied to the
    standard exe directory AND the instance exe directory. If the SAP
    NetWeaver system is running with SAP Sybase ASE, this step is not
    required. lib_dbsl (dbsybslib.so/dll) is available on SAP Market
    Place under database component SYBASE ASE. E.g. for 7.20 EXT 64-BIT
    UC:

    Additional Components -> SAP Kernel -> SAP KERNEL 64-BIT UNICODE ->
    SAP KERNEL 7.20 EXT 64-BIT UC -> SYBASE ASE.

5.  A DBCO entry must be created for the connection to IQ:

DBMS: SYB

Connection info: SYBASE_CONTYPE=IQ SYBASE_SERVER=<IQ Server Host>
SYBASE_PORT=<IQ ServerPort> SYBASE_IQ_ENGINE=<IQ ServerName>
SYBASE_DBNAME=<IQ DatabaseName> SYBASE_IQ_LOCKWAIT=600
                                                             


The general format of the connection info is: key_1=<value_1>
key_2=<value_2> ....key_n=<value_n>

The key value pairs are separated by a space character.

SYBASE_SERVER, SYBASE_PORT, SYBASE_IQ_ENGINE, SYBASE_DBNAME,
SYBASE_CONTYPE are mandatory keys.

IQ SYBASE_IQ_LOAD, SYBASE_IQ_LOCKWAIT, SYBASE_IQ_BUFFER_SIZE are
optional.

a) SYBASE_CONTYPE:

    SYBASE_CONTYPE must be set to IQ.

    SYBASE_IQ_CESU-8:

    SYBASE_IQ_CESU-8 must be set to 1. This is the default.

b) SYBASE_IQ_LOAD:

    SYBASE_IQ_LOAD can be set to 0 or 1; 1 is default.

    If set to 1, the IQ load command will be used to insert mass
    data. The ABAP statement

    INSERT (iq_table_name) CONNECTION (iq_db_connection) FROM TABLE
    <data>

    will use the IQ load statement. This results in a performance
    gain of approximately factor 6 to 8 compared to the array insert
      for mass data.

      If ACCEPTING DUPLICATE KEYS is specified - that is

      INSERT (iv_table_name) CONNECTION (iv_db_connection) FROM TABLE
      <data> ACCEPTING DUPLICATE KEYS

      the insert will be executed using array insert.

      Also, if the table definition in the SAP ABAP Dictionary and in
      the IQ database do not match completely, the insert will be
      executed using array insert.

      SYBASE_IQ_LOAD set to 1 requires READCLIENTFILE authorization in
      the IQ server:

      set option allow_read_client_file=on

   c) SYBASE_IQ_LOCKWAIT:

      Before execution of the load command the table will be locked for
      write access. With SYBASE_IQ_LOCKWAIT it is possible to overwrite
      the lock wait time. Default is 300 seconds.

      Example: SYBASE_IQ_LOCKWAIT=600 will set a lock wait time of 600
      seconds.
                                                               


   d) SYBASE_IQ_BUFFER_SIZE:

      The buffer size for array operation to IQ can be modified using
      SYBASE_IQ_BUFFER_SIZE - to be set in bytes. Default is 40k.

      Example: SYBASE_IQ_BUFFER_SIZE=500000 will set a buffer size of
      500k.

      Note that the ODBC driver has a fixed limit of 32 kB rows per
      buffer.

please check below screenshot for same.

1.

2.

2.

3.

4.

6.

7.

8.

9.

Labels in this area