IQ 16 SP08 on AIX - procedure not found

[Former Member]

Hi all,

We’re facing issue with SAP IQ on AIX. Interestingly, we’re unable to execute procedure. Sample of error screen is shown below. although we can create database, can start database.

Any advice on the above?

Many thanks

Quang.

[Masahiro_K]

Hi,

When you run CREATE DATABASE statement with multiple lines on nogui mode dbisql,
first line only is performed.

(dba)> create database '/sybasefs/dwh/dwh.db'  <=== This line only is performed
DBA PASSWORD 'sql' COLLATION 'UTF8BIN'
message path    '/sybasefs/dwh/dwh.iqmsg'
temporary path  '/sybasefs/dwh/dwh.iqtmp'
log on          '/sybasefs/dwh/dwh.log'
IQ PATH         '/sybasefs/dwh/dwh.iq'
….

So, you will not see .iqmsg or .iqtmp files under /sybasefs/dwh.
You should write CREATE DATABASE statement in text file, and read the file on dbisql with nogui mode.
Or run CREATE DATABASE statement on dbisql with GUI mode.

Sample)

(dba)> read createdb.sql
CHAR collation sequence:  ISO_BINENG(CaseSensitivity=Respect)
CHAR character set encoding:  ISO_8859-1:1987
NCHAR collation sequence:  UCA(CaseSensitivity=UpperFirst;AccentSensitivity=Respect;PunctuationSensitivity=Primary)
NCHAR character set encoding:  UTF-8
Database is not encrypted
Creating system tables
Creating system views
Setting option values
Execution time: 20.652 seconds

(dba)>

HTH,
Masahiro

[Former Member]

It did solve my issue. Many thanks!