Skip to Content
Technical Articles

Q – the easy Installer for SAP IQ

last changed: 25th of May 2020

Motivation …

 

new Blog: SAP (Sybase) IQ – the hidden treasure …

in the last Months, actually beginning with 2019 the request for the Installation of SAP Sybase IQ growed for several reasons, everyone can understand:

Beside that, other bullet points came into the consideration:

 

So, since 2013 the SAP First Guidance – SAP NLS Solution with SAP IQ (V 2.37) became the “Almanack” for SAP IQ Database Implementations, despite for SAP-NLS or native usage.

Imagine there is a simple routine based on the SAPHostAgent to install SAP Sybase IQ 16.x with three input values:

  • <SID> (What, also IQ get’s a SAP <SID>?)
  • Instance Number (what’s about port 2638?)
  • Size of DB in GB (including all sizing considerations)

 


The Answer: Q – the easy Installer for SAP IQ

the following picture shows the Setup of Q, which is actually the same Installation Procedure as the SAP Datahub achritecturewise …

Either you call the SAPHostAgent via HTTP Port 1128 or HTTPS Port 1129

enable HTTPS Port 1129

make sure the following Variables are set (either as root or sapadm):

LD_LIBRARY_PATH=/usr/sap/hostctrl/exe
SECUDIR=/usr/sap/hostctrl/exe/sec

run the following command:

server:/usr/sap/hostctrl/exe #
./sapgenpse gen_pse -s 2048 -a sha256WithRsaEncryption -p SAPSSLS.pse -x is!seCret -r /usr/sap/hostctrl/exe/sec/server-csr.p10 -k GN-dNSName:server.domain.ext "CN=server.domain.ext, O=SAP, C=DE"

add the following parameter to the file host_profile and restart the SAP Host Agent

service/admin_users = sapadm nlsadm
ssl/server_pse = /usr/sap/hostctrl/exe/sec/SAPSSLS.pse

server:/usr/sap/hostctrl/exe # chmod -R 775 sec/
server:/usr/sap/hostctrl/exe # ./saphostexec -restart

now it is possible to call the SAP Host Agent on HTTPS Port 1129

Please Note: currently (also seen in the picture above), there is only one Version fitting to the installer, which is IQ 16.0 SP 11.17
You should first install this Version, configure the access to IQ and the IQ COCKPIT and then update the binaries to the current which is IQ 16.1 SP04.04.
As this is only a binary upgrade, the IQ database and the data will not be touched.

In case the /tmp Directory is mounted as read-only then follow the steps in the Note
Note 2104632 – ./setup.bin raises warning /tmp does not have enough disk space! – SAP IQ

server:/ebf29137 # ./setup.bin
Preparing to install
Extracting the JRE from the installer archive...
Unpacking the JRE...
Extracting the installation resources from the installer archive...
Configuring the installer for this system's environment...

Launching installer...

JRE libraries are missing or not compatible....
Exiting....
server:/ebf29137 # mount | grep "/tmp"
/dev/mapper/vg_sys_r1-tmp on /tmp type ext4 (rw,nodev,noexec,noatime,data=ordered)
server:/ebf29137 #
server:/ebf29137 # export IATEMPDIR=/sapmnt/tmp
server:/ebf29137 # ./setup.bin

 

The SAPHostAgent uses a routine called “sapinstancebuilder” which creates a complete file system structure equally to an existing SAP system like SAP HANA oder SAP BW/ERP/etc.

You can always watch the progress of the IQ Installation in the URL of the Browser

  • http:// server.domain.ext:1128/NLSSetup/prepare
    https:// server.domain.ext:1129/NLSSetup/execute

or alternatively in the SAPHostAgent working directory
/usr/sap/hostctrl/work # tail -f nls.execution.status

Once the IQ Database Installation is finished, you can use the iSQL Windows Client to connect to the Database and Check the status with the sp procedures

  • sp_iqstatus;
  • sp_iqlmconfig;
  • sp_iqcheckoptions;

 

SAP IQ allows you with the sql tool iqdsn to create a DSN entry directly in the file .odbc.ini located in the home directory of the SAP IQ Administrator.

sybase@server:/usr/sap/NLS/data/db>
iqdsn -y -w "SAPIQDB" -c "UID=DBA;PWD=dba;ServerName=SAPIQSERVER;DBN=SAPIQDB; Host='server.domain.net:34238'"
sybase@server:/usr/sap/NLS/data/db> dbping -d -c dsn=SAPIQDB

If for any reason it is not possible to connect to the IQ Database with the Windows Client, you can also directly call the Interface with the tool dbisql (also with the usage of the DSN above):

siqadm@server:/usr/sap/SIQ/data/db> dbisql -c "uid=dba;pwd=Password;dbn=SAPIQDB" -nogui
(DBA)>

 


the SAP IQ Cockpit

the URL is called like – https:// server.domain.ext:34283/cockpit/#

configure the correct Ports for the IQ COCKPIT usage:

stop_COCKPIT 
cdsw
cd COCKPIT4/bin
./cockpit.sh -port db=3<nr>80,msg=3<nr>81,http=3<nr>82,https=3<nr>83,rmi=3<nr>84,tds=3<nr>85
cddb 
start_COCKPIT

as the easy Installer improves a lot of the manual tasks, the IQ Agent Registration is easy as well


the SAP BW configuration


Blog – SAP-NLS Solution for SAP BW based on SAP IQ

for the SAP-NLS Implementation finally, you have to call some transactions in the SAP BW backend:

  • DBCO => depending on the scenario additional work for SDA is necessary
  • RSDANLCON => create the NLS storage target
  • DBACOCKPIT => reuse the DBCO connection to monitor the Database within BW

Done …


The needed files can be found here – Q – the easy IQ Installer

  • Easy Installer for SAP IQ V2.5.pptx
  • SAP First Guidance – SAP-NLS with IQ V2.37.pdf
  • NLSSETUP160_11_17.SAR
  • SAPHOSTAGENT_CGK.SAR
  • webroot.SAR
  • IQSERV160011P_17-20011180.TGZ (can also be downloaded from SMP)
    needed/used for the IQ easy Installer
  • current Version of SAP Sybase IQ 16.01 SP04.04
    IQSERV161004P_4-80002767.TGZ (can also be downloaded from SMP)
    to update the binaries to the latest version

 


Roland Kramer, SAP Platform Architect for Intelligent Data & Analytics, SAP SE
@SAPFirstGuidance

 

“I have no special talent, I am only passionately curious.”

2 Comments
You must be Logged on to comment or reply to a post.
  • Hi Roland Kramer,

    Thanks for sharing valuable knowledge and expertise with community. We have just  start  to Implement SAP NLS BW 7.4 with Sybase IQ 16.1 install on Windows Server 2016.After installation and configuration  with your Guide line for NLS.We have create DBCO connection with sybase IQ but connection not successfully showing error (ERROR Database connection SAPIQDB: ADBC error ‘Internal error 16 has occurred).We have implement relevant SAP Note but unfortunately can’t find any solution.

    Kindly give guideline regarding this.

    Regards,

    Muhammad Shafiq

     

    • Hello,

      If not already figured out the root case: there are no Windows based IQ Client drivers for Unix Based SAP BW Application Servers available.

      Please try to find a suitable OS-DB combination …

      Best regards Roland