cancel
Showing results for 
Search instead for 
Did you mean: 

Could not load the store DLL "libiq16.so"

Former Member
0 Kudos

Hi
I installed SAP Sybase IQ 16 on a Centos 7 server.
Permissions are correct. Before IQ installation:

glibc.i686

tcsh.x86_64

libXext-devel.i686

libXtst-devel.i686
ulimit -u 32000


Installation went well:

Installation: Successful.

294 Successes

0 Warnings

0 NonFatalErrors

0 FatalErrors

Then as user sybase I "source /opt/sybase/IQ.sh" and the environment is present

But when starting I get:

I. 11/28 15:17:16. Running Linux 3.10.0-123.el7.x86_64 #1 SMP Mon Jun 30 12:09:22 UTC 2014 on X86_64

I. 11/28 15:17:16. Server built for X86_64 processor architecture

I. 11/28 15:17:16. 8296K of memory used for caching

I. 11/28 15:17:16. Minimum cache size: 8296K, maximum cache size: 262144K

I. 11/28 15:17:16. Using a maximum page size of 4096 bytes

I. 11/28 15:17:16. Multiprogramming level: 25

I. 11/28 15:17:16. Automatic tuning of multiprogramming level is disabled

E. 11/28 15:17:16. Could not load the store DLL "libiq16.so"

I. 11/28 15:17:16. Database server shutdown due to startup error

I. 11/28 15:17:16. Database server stopped at Fri Nov 28 2014 15:17

DBSPAWN ERROR:  -82

Unable to start specified database: autostarting database failed

Could not load the store DLL "libiq16.so"

Server failed to start

Any ideas why it is not loaded? The file is fine and present in /opt/sybase/IQ-16_0/lib64

Accepted Solutions (0)

Answers (3)

Answers (3)

serkan_birkan
Explorer
0 Kudos

Hi, in case other people have the same issue, on AIX we solved the "Could not load the store DLL "libiq16.so" problem by enabling the AIX I/O Completion Port (IOCP):

1. Log in to the server as root.

2. Validate the current IOCP status by running:

lsdev -Cc iocp

lsdev returns one of these messages:

o If the message reads iocp0 Defined I/O Completion Ports, continue to the next step.

o If the message reads iocp0 Available I/O Completion Ports, there is no need to continue.

3. Issue the following command: smitty iocp

4. Select Configure Defined I/O Completion Ports.

When processing is complete, output should read iocp0 Available.

5. Press F10 to exit

6. Verify with the command: lsdev -Cc iocp

Regards.

Serkan Birkan

c_baker
Employee
Employee
0 Kudos

This is documented in the IQ Installation and Configuration Guide for IBM AIX.

http://help.sap.com/saphelp_iq1610_iqicg_aix/helpdata/en/a8/784f9f84f21015b51d8c4666a0f61b/content.h...

Chris

0 Kudos

iqsrv15 -n utility_db -ud

dbisql -c "uid=dba;pwd=sql;eng=utility_db;dbn=utility_db" -nogui

 

(dba)> select @@servername

@@servername

--------------------------------------------------------------------------------------------------------------------------------

utility_db

(1 rows)

Execution time: 0,014 seconds

(dba)> stop engine

(Not Connected)> quit

Regards,

cjd

Former Member
0 Kudos

I think it may be solved. Installed some of these and now I am getting a license not found error instead.

yum install csh

yum install file

yum install libaio

yum install libXext

yum install libXrender

yum install libXtst

yum install libXi

I am guessing the trial license does not work with existing databases copied from a previous licensed installation?

saroj_bagai
Contributor
0 Kudos

you do need served or unserved license for this database on this host

saroj_bagai
Contributor
0 Kudos

Did you setup your Environment variables, by sourcing IQ-16_0.csh/.sh

Former Member
0 Kudos

Yes the environment is set by source IQ.sh as said.
I also tried to run the utility_db and it runs, but cannot be connected to.
start_iq -n util -gu utility_db
dbisqlc -c "uid=dba;pwd=sql;eng=util;dbn=utility_db"
Unable to start specified database. Could not find the local physical storage.

c_baker
Employee
Employee
0 Kudos

Did you create a database?  Try the $IQDIR16/demo/mkiqdemo.sh script from a writeable directory.  This will create a demo database and test your installation.

Ensure the ksh is installed as well.

Chris

Former Member
0 Kudos

Tried creating the demo database. It stopped with:

Server started successfully

Connecting to server via TCPIP ...

Using: uid=DBA;pwd=sql;eng=bld_demo_9146;dbn=utility_db;links=tcpip{host=r-s-database;port=9146}

Creating database ... Error at line 1

Connection error: No IP address found for r-s-database

saroj_bagai
Contributor
0 Kudos

you can't connect to utility database.  once utility server is up , you can create database :

e.g

dbisql -c 'uid=DBA;pwd=sql;eng=eng=util;dbn=utility_db" -nogui  crdb.sql

and or try to create demo database

$SYBASE/IQ-16_0/demo/mkiqdemo.sh


saroj_bagai
Contributor
c_baker
Employee
Employee
0 Kudos

What is your hostid?  If it is '00000000' then your eth0 is not configured with an IP address.

In that case you need to assign an IP address to your machine.  The hostname 'r-s-database' is not resolvable either, so will need to be added to /etc/hosts or be resolvable once the host has been assigned an IP address via DHCP or hardcoded.

Chris