getting error "Exec format error. Wrong Architecture" while starting iqdemo database

[Former Member]

Hi all,

i have installed VMWare fusion on my MAC OS(10.9) after that installed Linux OS

finally installed Sybase IQ16 on it.

i have set environment path using   in /opt/sybase/IQ-16_0 $   . ./IQ-16_0/IQ-16_0.sh

after that while i am executing    ./mkiqdemo.sh  in current directory (/opt/sybase/IQ-16_0/demo) i am getting below error

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

[root@localhost demo]# ./mkiqdemo.sh

Warning:  You are running this script as 'root'. 

          Sybase strongly recommend that servers not be run with root privileges.

This script will create the iqdemo database in the current

directory.  An existing iqdemo database in this directory

will need to be shutdown and over-written.

Continue <Y/N>? Y

Checking system ...

There are no servers running on this system

Starting Server ...

Starting server bld_demo_9858 on localhost at port 9858 (02/08 01:15:33)

Run Directory       : /opt/sybase/IQ-16_0/demo

Server Executable   : /opt/sybase/IQ-16_0/bin64/iqsrv16

Server Output Log   : /opt/sybase/IQ-16_0/logfiles/bld_demo_9858.0001.srvlog

Server Version      : 16.0.0.481/sp01

16.0.0/Linux 2.6.18-194.el5

Open Client Version : N/A

User Parameters     : '@bld_demo_9858.cfg'

Default Parameters  : -gc 20 -gl all -ti 4400 -gn 25

/opt/sybase/IQ-16_0/bin64/dbspawn: Exec format error. Wrong Architecture.

Server failed to start (Return Code 1)

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

please help me on this

regards

abhishek

[c_baker]

Looks like you may be trying to run 64-bit IQ on 32-bit Linux.

Chris.

[Former Member]

Hi Chris,

          Yes my Linux version is 32 bit and and installed SybaseIQ16 64 bit

should i keep both same version ?

or have any new way to keep this

please suggest me on this

regards

abhishek

[markmumy]

You will have to use a 64 bit operating system.

Mark

[Former Member]

Hi Mark/Chris,

please help me on this

How we can find total number of max_connection per user in SYBASE IQ 15.X  SAP IQ

How we can find total number of max_connection per user(not currently login) in SYBASE IQ 15.X

according to me

select * from sa_get_user_status() where user_name like '%user_id%'

this shows the total number of current logins (in connections COLUMN).

i want to get  max connections per user_id

as i create a login policy for restricting max_connections =15

then i add user in this login policy

now i want that user's "login_option_values=15"

Hoping revert from you  .

Regards

abhishek