SAP Knowledge Base Article - Preview

2768717 - create database returns 'transaction log file not found' error in SAP IQ

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

SAP BW/4HANA 1.0 ; SAP IQ 16.0 ; SAP IQ 16.1

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.