Symptom
- Moving a server to a new location.
- Same data moving from production (PRD) to Disaster Recovery (DR).
- There seems to be a problem when trying to rename the transaction log:
I. 07/22 14:12:19.005317 Starting database "DRIQ" (/DRIQ/data/DRIQ.db) at Fri Jul 22 20xx 14:12
HOS_MEMMGR: Heap memory tracking is enabled.
[hos_InMemMsgLog] Using perThreadBufferLength=1048576 bytes...
Starting database "DRIQ" (/DRIQ/data/DRIQ.db) at Fri Jul 22 20xx 14:12
I. 07/22 14:12:19.008417 Database recovery in progress
Database recovery in progress
I. 07/22 14:12:19.008469 Last checkpoint at Fri Jul 22 20xx 14:06
Last checkpoint at Fri Jul 22 20xx 14:06
I. 07/22 14:12:19.008500 Checkpoint log...
Checkpoint log...
I. 07/22 14:12:22.603411 UTC time zone offset for "DRIQ" set to -420 minutes
I. 07/22 14:12:22.603480 Transaction log: /DRIQ/data/tlog1 ...
I. 07/22 14:12:19. IQ OpenDatabase, checkpointblock: 13105938, recover: 1
I. 07/22 14:12:20. Using AIO based prefetch manager
I. 07/22 14:12:21. Using AIO based prefetch manager
I. 07/22 14:12:22. 140468089861888 [MpxTrace-GFLSHT]-stcxtlib/st_globalFlMgr.cxx:00076 The Diagnostic toggle value for st_globalFlMgr is set to 0
UTC time zone offset for "DRIQ" set to -420 minutes
Transaction log: /DRIQ/data/tlog1...
E. 07/22 14:12:22.604004 Error: Cannot open transaction log file -- No such file or directory
Error: Cannot open transaction log file -- No such file or directory
E. 07/22 14:12:25.114777 Cannot open transaction log file -- No such file or directory
Cannot open transaction log file -- No such file or directory
I. 07/22 14:12:25.114841 Database server shutdown due to startup error
Database server shutdown due to startup error
07/22 14:12:25.135673 Completing server shutdown
Read more...
Environment
- SAP IQ 16.0
- SAP IQ 16.1
Product
SAP IQ 16.1
Keywords
KBA , BC-SYB-IQ , Sybase IQ , How To
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.