1796393 - SAP BW near-line solution with Sybase IQ

Symptom

This SAP Note delivers the SAP BW-specific near-line storage solution with Sybase IQ.
The solution is documented under the following link:
http://help.sap.com/saphelp_nw73ehp1/helpdata/en/60/cf63e1bbbb49429ee6c35e6ad03a45/content.htm?frameset=/en/4c/75184b167821d1e10000000a42189c/frameset.htm

Other Terms

Archiving, package RSDA_SYB, NLS, near-line storage, Sybase IQ

Reason and Prerequisites

This is an advance development.
Near-line storage for Sybase IQ is released only for BW systems that already run under Unicode. See SAP Note 1737415 (section 3.a) for more details.

Solution

You cannot implement this function as an advance correction using correction instructions (with this SAP Note). For this, import the specified Support Packages:

• SAP NetWeaver BW 7.30
  
  Import Support Package 9 for SAP NetWeaver BW 7.30 (SAPKW73009) into your BW system. The Support Package is available when SAP Note 1750249 ("SAPBWNews NW 7.30 BW ABAP SP9"), which describes this Support Package in more detail, is released for customers.

• SAP NetWeaver BW 7.31 (SAP NW BW 7.0 Enhancement Package 3)
  
  Import Support Package 7 for SAP NetWeaver BW 7.31 (SAPKW73107) into your BW system. The Support Package is available when SAP Note 1782744 "SAPBWNews NW BW 7.31/7.03 ABAP SP7", which describes this Support Package in more detail, is released for customers.

To implement the solution as an advance correction on:

• SAP NetWeaver BW 7.00 from SAPKW70028 to SAPKW70030

• SAP NetWeaver BW 7.01 from SAPKW70110 to SAPKW70113

• SAP NetWeaver BW 7.02 from SAPKW70210 to SAPKW70214

• SAP NetWeaver BW 7.30 from SAPKW73005 to SAPKW73008

• SAP NetWeaver BW 7.31 from SAPKW73102 to SAPKW73106

refer to SAP Note 1858550.


The SAP BW-specific near-line storage solution with Sybase IQ consists of the following components:

1. ABAP package RSDA_SYB, which contains the implementation of the SAP BW near-line interface

2. DBSL implementation in the SAP NetWeaver kernel

3. Sybase IQ Server and SYBASE IQ ODBC NLS client driver The installation of an Sybase IQ server for the SAP BW near-line storage solution is subject to a license.

Installation:

  1.  You can install the ABAP package RSDA_SYB with the specified Support Packages SAP NetWeaver BW 7.30 (SAPKW73009) or SAP
       NetWeaver BW 7.31 (SAPKW73107).

  2.  For the minimum prerequisites regarding the SAP NetWeaver kernel for the above SAP BW releases,
       refer to SAP Note 1737415.

3.  Sybase

• The IQ 15.4 or IQ 16.0 server can be downloaded/installed using SAP Service Marketplace (SMP). This is described in SAP Note 1737415. For IQ 16.0 Server SP08, you must also meet the prerequisites stated in SAP Note 2016130.
• Go to SAP Service Marketplace (SMP) to download/install the SQL Anywhere ODBC client driver for IQ Server Version 15.4 and 16.0. This is described in SAP Note 1737415. Also note the restrictions with regard to the operating system platforms for the Application Server ABAP described further below.
• The installation and configuration guide of Sybase IQ 15.4 or 16.0 is available at:
  Sybase IQ 15.4:
  http://infocenter.sybase.com/help/index.jsp?docset=/com.sybase.infocenter.help.iq.15.4/title.htm& docSetID=1817.
  Sybase IQ 16.0 SP1:
  http://infocenter.sybase.com/help/index.jsp?workingSet=Sybase%20IQ%2016.0%20SP01
  Also refer to the document "SAP First Guidance - SAP-NLS Solution with Sybase IQ" at https://scn.sap.com/docs/DOC-39627

Note the following restrictions for the SAP BW-specific near-line storage solution with Sybase IQ.

At the moment, the following IQ servers are supported for productive use:

• 15.4 ESD #3 - IQ SERVER
• 16.0 SP01 PLXX - 64-bit
• 16.0 SP04 PLXX - 64-bit
• 16.0 SP08 PLXX - 64-bit
• 16.0 SP10 PLXX - 64-bit

PLXX stands for the highest patch level available at the SAP Service Marketplace.
In addition, you must implement SAP Note 1966432 following installation of the IQ Server in BW. With regard to database inconsistencies and IQ server, also see SAP Notes 2023695 and 2088943.
The following restrictions also apply to production use with regard to the operating system platforms for the Application Server ABAP (SYBASE IQ ODBC NLS):
For the IQ Server 15.4, the operating system platforms

• Linux on x86_64 64bit
• Windows on x64 64bit

are supported.
For IQ Server 16.0 SP01 PLXX - 64-bit, the following operating system platforms are also supported:

• AIX 64bit
• IBM i (aka OS/400)
• Solaris on SPARC 64-bit 

.
For IQ Server 16.0 SP04 PLXX - 64-bit, the following operating system platform is also supported:

• HP-UX on IA64 64 bit

are supported.
Also note that the Sybase IQ ODBC NLS client 16.0 SP03 is relevant for the IQ Server 16.0 SP04 PLXX - 64-bit.
For IQ Server 16.0 SP08 PLXX - 64-bit, the following operating system platforms are also supported:

• Linux on IA32 32-bit
• Linux on Power 64-bit
• Solaris on x86 64 64-bit
• Windows Server on IA32 32-bit

.

If you have successfully installed the above components, you can carry out the BW configuration.

The configuration contains two steps:

• You use transaction DBCO (table DBCON) to set up the additional second database connection. The configuration is described in SAP Note 1737415.

• You use transaction RSDANLCON to set up the near-line connection.

See the documentation at:
http://help.sap.com/saphelp_nw73ehp1/helpdata/en/e8/395401e46f4edca50aefeead7f3a44/frameset.htm


Note the following distinction with regard to the SAP Support components:

• For problems with the ABAP Adapter or with the near-line storage solution in general, use the component BW-WHM-DST-ARC.

• For problems in the DBSL implementation, use the component BC-DB-SYB.

• For problems with the SQL Anywhere ODBC client driver or with the Sybase IQ server, use the component BC-SYB-IQ.