Skip to Content
Author's profile photo arun kumar

Implementation SAP-NLS Solution with SAP IQ

Hi Friends,

This is my first blog in SCN.I am much interested to share my thoughts and knowledge.

Recently we have implemented NLS Solution for one of our Major Client.I am going to share the Experience.

OS Platform:SUSE Linux

Database :Sybase IQ Support Pack-08,Patch Level-10

What is meant by SYBASE IQ Server?

               SAP® Sybase® IQ is a high-performance decision-support server designed specifically for mission-critical business intelligence, analytics, and data warehousing. Component Integration Services within SAP Sybase IQ provide direct access to relational and non-relational databases on mainframe, UNIX, or Windows servers.

Since we have implemented on Linux,I am concentrating on Linux:

Pre-installation Tasks:

  • Check for Operating System Patches.
  • Increase the Swap Space.
  • Install Required Support Packages and Libraries.
  • Disable HugePages and Transparent HugePages.
  • Set the Kernel Parameters.

Swap Space:

1.PNG

Asynchronous I/O (AIO) Kernal Support

  • Asynchronous input/output (AIO) applications which use the native AIO interfaces require the libaio package. AIO provides an interface that submits multiple I/O operations and other processing requests in a single system call, and an interface that collects completed I/O operations associated with a given completion group.

2.PNG

Disable HugePages and Transparent Huge Pages

  • Allocating large amounts of memory to HugePages can significantly degrade SAP IQ performance. If the kernel allocates more than just a few MB of memory to HugePages, remove the HugePages options

3.PNG

Set the Kernel Parameters

  • Set the number of available semaphore identifiers
  • SEMMSL – maximum number of semaphores per set.
  • SEMMNS – maximum number of semaphores system–wide.
  • SEMOPM – maximum number of operations allowed for one semop call.
  • SEMMNI – maximum number of semaphore identifiers (sets).

Implementation SAP-NLS Solution with SAP IQ

Preinstallation Tasks:

  • Check for Operating System Patches.
  • Increase the Swap Space.
  • Install Required Support Packages and Libraries.
  • Disable HugePages and Transparent HugePages.
  • Set the Kernel Parameters.

Supported Server Platforms

  • SAP IQ is compatible with these platforms and operating systems in Linux:
  • Red Hat Enterprise Linux 6.2 (and later) Linux on POWER; 64-bit
  • Red Hat Enterprise Linux 6.2 (and later) x86-64, Advanced Server and Workstation Editions
  • Red Hat Enterprise Linux 5.5 (and later) Linux on POWER; 64-bit
  • Red Hat Enterprise Linux 5.5 (and later) x86-64, Advanced Server and Workstation Editions
  • SuSE Linux Enterprise Server SLES 11/Linux on POWER – minimum patch level SP1
  • SuSE Linux Enterprise Server SLES 11/X86_64 64-bit – minimum patch level SP1

Preinstallation Tasks

Swap Space:

  • The recommended minimum swap space is at least 1GB. Certain operations may cause the memory usage to grow dynamically. Changing the way SAP IQ uses buffers can dramatically change the way it uses memory.

1.PNG

Asynchronous I/O (AIO) Kernal Support

  • Asynchronous input/output (AIO) applications which use the native AIO interfaces require the libaio package. AIO provides an interface that submits multiple I/O operations and other processing requests in a single system call, and an interface that collects completed I/O operations associated with a given completion group.

2.PNG

Disable HugePages and Transparent Huge Pages

  • Allocating large amounts of memory to HugePages can significantly degrade SAP IQ performance. If the kernel allocates more than just a few MB of memory to HugePages, remove the HugePages options

3.PNG

Set the Kernel Parameters

Set the number of available semaphore identifiers.

  • SEMMSL – maximum number of semaphores per set.
  • SEMMNS – maximum number of semaphores system–wide.
  • SEMOPM – maximum number of operations allowed for one semop call.
  • SEMMNI – maximum number of semaphore identifiers (sets).

4.PNG

Check for Operating System Patches

5.PNG

INSTALLATION

–>Download Required Sybase Software from SMP.(We have used Sybase IQ SP 8 PL 10)

–>Transfer the file to your server.

–>Go to the path Where you transferred sybase software

–>Start installation ./setup.bin.

11.PNG12.PNG13.PNG14.PNG15.PNG116.PNG17.PNG18.PNG19.PNG20.PNG21.PNG22.PNG23.PNG

24.PNG

30.PNG31.PNG32.PNG33.PNG34.PNG35.PNG

We will see the rest of configuration and registration of SYBASE IQ System with BW on HANA Server in Blog 2.

Thanks,

Arunkumar.S

Assigned Tags

      5 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi Arun,

      the article could be interesting but there seem to be some parts doubled (at the start) and the pictures are really small and many times without explanation, which makes it hard to understand/decipher 🙁

      Regards, Philipp

      Author's profile photo arun kumar
      arun kumar
      Blog Post Author

      Hi Philipp,

      Thanks For your suggestion ,I will over come all the flaws in my Second document with good explanation. 🙂

      Thanks,

      Arunkumar.S

      Author's profile photo Former Member
      Former Member

      Hi Arun,

      Do you know if there is an impact on converting a standard Info Cube to HANA Optimized when you already archived data to Sybase IQ (NLS)?

      Regards,

      Joan

      Author's profile photo Samunder Singh
      Samunder Singh

      Hi Arun,

      Document is very good, kindly upload part 2

      Thanks
      Mubeen

      Author's profile photo Tikkana Akurati
      Tikkana Akurati

      Hi Arun,

      Just curious , what HA solution are you using for your NLS IQ ?