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.
SAP Knowledge Base Article - Preview