Problem about installation an IQ16 on AIX.

[Gisung]

Dear all,

I have a customer who has a problem to install IQ16 SP08 on AIX.

Ct tried to install with other version and machine.

But it’s returned same errors like below.

Os : oslevel –r : 7100-03

[Error]

• Start_iq –v2

       16.0.0.656  Unknown version – IQ library could not be loaded

• Dbisql –c xxxx

         Unable to start specified database: Could not find or load the physical store DLL.

Does anyone has a similar experience?

Any advice and comments will be greatly appreciated.

Thanks

Gi-Sung Jang

[Gisung · Accepted solution]

Hi,

I solved this problem.

2011336 - SAP Sybase IQ gets an error Unable to start specified database: Could not find or load the...

[former_member251152 · Accepted solution]

Hello,

Document link to the solution seems to be broken, could you please provide new one.

Facing the same IQ / AIX problem..

Thanks,

Gints

[markmumy · Accepted solution]

That link is to an internal SAP page that is only accessible to employees.  Here is the text form that case, though.  Basically, it is quite likely that async IO has not been configured/enabled (IOCP) at the OS level.

Symptom

SAP Sybase IQ gets an error Unable to start specified database: Could not find or load the physical store DLL

Symptoms may include ENOEXEC and Cannot load module messages.

This error reports different .so library depending upon the load sequence of the libraries. Some times it shows IQ library and sometimes OS level library.

Environment

AIX 6.x and above versions.

Problem is specific to AIX platform.

Cause

AIX I/O Completion Port (IOCP) status may be defined, but not enabled. This problem applies to all AIX platforms and may occur after an install or upgrade

For IQ server to function and start IOCP port must be ENABLED.

Resolution

ON AIX platform you check the PRE-INSTALLATION task mentioned in the installation and configuration guide of the product manual.

SAP Sybase IQ 16.0 SP03 > Installation and Configuration Guide for IBM AIX > Preparing for Installation > Preinstallation Tasks

Enable the I/O Completion Ports (IOCP)

AIX I/O Completion Port (IOCP) status may be defined, but not enabled. This problem applies to all AIX platforms and may occur after an install or upgrade.

Symptoms may include ENOEXEC and Cannot load module messages.

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 readsiocp0 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. Run lsdev -Cc iocp.

Output should read iocp0 Available I/O Completion Ports.

Another possibility is that IQ server might be installed by privileged user (root) and during installation proper permissions not given to other users.