Symptom
Following steps mentioned in SAP First Guidance for BW NLS for Create Database (2.3.1 Create the SAP IQ database for NLS), one can get the following error
(dba)> CREATE DATABASE 'SAPIQDB.db' LOG ON '../data/log/SAPIQDB.log' CASE RESPECT PAGE SIZE 4096 COLLATION 'CESU8BIN' ENCODING 'CESU8' DBA USER 'DBA' DBA PASSWORD 'XXXXXX' BLANK PADDING ON JCONNECT ON IQ PATH '../data/main/SAPIQDB_main_001.iq' IQ SIZE 20 IQ PAGE SIZE 262144 BLOCK SIZE 16384 MESSAGE PATH '../data/messages/SAPIQDB_msg.iqmsg' TEMPORARY PATH '../data/temp/SAPIQDB_tmp_001.iqtmp' TEMPORARY SIZE 20
Could not execute statement.
Unable to start specified database: ../data/log/SAPIQDB.log: transaction
log file not found
SQLCODE=-82, ODBC 3 State="08001"
Line 1, column 1
CREATE DATABASE 'SAPIQDB.db' LOG ON '../data/log/SAPIQDB.log' CASE RESPECT PAGE SIZE 4096 COLLATION 'CESU8BIN' ENCODING 'CESU8' DBA USER 'DBA' DBA PASSWORD 'XXXXXX' BLANK PADDING ON JCONNECT ON IQ PATH '../data/main/SAPIQDB_main_001.iq' IQ SIZE 20 IQ PAGE SIZE 262144 BLOCK SIZE 16384 MESSAGE PATH '../data/messages/SAPIQDB_msg.iqmsg' TEMPORARY PATH '../data/temp/SAPIQDB_tmp_001.iqtmp' TEMPORARY SIZE 20
Press ENTER to continue...
Read more...
Environment
- SAP IQ 16.0
- SAP IQ 16.1
- SAP BW/4HANA 1.0
Product
Keywords
Nearline storage ; archive ; business warehouse ; IQ ; sybase , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.