on 11-28-2014 1:27 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This is documented in the IQ Installation and Configuration Guide for IBM AIX.
Chris
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
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Did you setup your Environment variables, by sourcing IQ-16_0.csh/.sh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
you need to verify your network connectivity
Verify Network Functionality - SAP IQ Installation and Configuration Guide - SAP Library
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
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.