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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
36 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 | |
4 | |
3 | |
3 |