Skip to Content
Technical Articles

Q – the easy Installer for SAP IQ

last changed: 12th of August 2019

Motivation …

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 Document became the “Almanack” for IQ Implementations

recently the following twitter account was created by Roland Kramer => #sapfirstguidance

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.01. As this is only a binary upgrade, the IQ database and the data will not be touched.

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

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;

 

If for any reason it is not possible to connect to the Database with the Windows Client you can also directly call the Interface:

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

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

  • Q – the Easy Installer for SAP IQ.pdf
  • SAP First Guidance – SAP-NLS with IQ V2.34.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.01
    IQSERV161004P_1-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

Be the first to leave a comment
You must be Logged on to comment or reply to a post.