Symptom
Server started with "-q" but database comes online.
Server was started ASE with "-q"
======
00:0006:00000:00002:2025/10/02 09:31:02.27 server Recovering database 'db01a'.
00:0006:00000:00002:2025/10/02 09:31:02.27 server Started estimating recovery log boundaries for database 'db01a'.
00:0006:00000:00002:2025/10/02 09:31:02.27 server Database 'db01a', checkpoint=(51657, 2), first=(51657, 2), last=(51657, 8).
00:0006:00000:00002:2025/10/02 09:31:02.27 server Completed estimating recovery log boundaries for database 'db01a'.
00:0006:00000:00002:2025/10/02 09:31:02.27 server Database 'db01a' is a copy taken under a QUIESCE/PREPARE DATABASE command. It will be recovered as for LOAD DATABASE and left offline.
00:0006:00000:00002:2025/10/02 09:31:02.27 server Started ANALYSIS pass for database 'db01a'.
00:0006:00000:00002:2025/10/02 09:31:02.27 server Completed ANALYSIS pass for database 'db01a'.
00:0006:00000:00002:2025/10/02 09:31:02.27 server Log contains all committed transactions until 2025/10/02 08:51:53.62 for database db01a.
00:0006:00000:00002:2025/10/02 09:31:02.27 server Started REDO pass for database 'db01a'. The total number of log records to process is 7.
00:0006:00000:00002:2025/10/02 09:31:02.27 server Redo pass of recovery has processed 2 committed and 0 aborted transactions.
00:0006:00000:00002:2025/10/02 09:31:02.27 server Completed REDO pass for database 'db01a'.
00:0006:00000:00002:2025/10/02 09:31:02.27 server Timestamp for database 'db01a' is (0x0000, 0x00002e94).
00:0006:00000:00002:2025/10/02 09:31:02.28 server Database 'db01a' appears to be in the process of being loaded; ASE will not bring it online automatically. Use the ONLINE DATABASE command to bring this database online.
======
We can see database "db01a" is offline.
Server was restarted with "-q":
======
00:0002:00000:00002:2025/10/02 09:48:20.40 server Recovering database 'db01a'.
00:0002:00000:00002:2025/10/02 09:48:20.40 server Started estimating recovery log boundaries for database 'db01a'.
00:0002:00000:00002:2025/10/02 09:48:20.40 server Database 'db01a', checkpoint=(51657, 2), first=(51657, 2), last=(51657, 11).
00:0002:00000:00002:2025/10/02 09:48:20.40 server Completed estimating recovery log boundaries for database 'db01a'.
00:0002:00000:00002:2025/10/02 09:48:20.40 server Started ANALYSIS pass for database 'db01a'.
00:0002:00000:00002:2025/10/02 09:48:20.40 server Completed ANALYSIS pass for database 'db01a'.
00:0002:00000:00002:2025/10/02 09:48:20.40 server Log contains all committed transactions until 2025/10/02 09:42:15.41 for database db01a.
00:0002:00000:00002:2025/10/02 09:48:20.40 server Started REDO pass for database 'db01a'. The total number of log records to process is 10.
00:0002:00000:00002:2025/10/02 09:48:20.40 server Redo pass of recovery has processed 3 committed and 0 aborted transactions.
00:0002:00000:00002:2025/10/02 09:48:20.40 server Completed REDO pass for database 'db01a'.
00:0002:00000:00002:2025/10/02 09:48:20.40 server Timestamp for database 'db01a' is (0x0000, 0x00002e99).
00:0002:00000:00002:2025/10/02 09:48:20.40 server Recovery of database 'db01a' will undo incomplete nested top actions.
00:0002:00000:00002:2025/10/02 09:48:20.40 server Cleanup of preallocated pages for database db01a completed, 0 extents cleaned.
00:0002:00000:00002:2025/10/02 09:48:20.40 server Started recovery checkpoint for database 'db01a'.
00:0002:00000:00002:2025/10/02 09:48:20.40 server Completed recovery checkpoint for database 'db01a'.
00:0002:00000:00002:2025/10/02 09:48:20.41 server Started filling free space info for database 'db01a'.
00:0002:00000:00002:2025/10/02 09:48:20.41 server Completed filling free space info for database 'db01a'.
00:0002:00000:00002:2025/10/02 09:48:20.41 server Started cleaning up the default data cache for database 'db01a'.
00:0002:00000:00002:2025/10/02 09:48:20.41 server Completed cleaning up the default data cache for database 'db01a'.
00:0002:00000:00002:2025/10/02 09:48:20.41 server Checking external objects.
00:0002:00000:00002:2025/10/02 09:48:20.42 server Cleanup of preallocated pages for database db01a completed, 0 extents cleaned.
00:0002:00000:00002:2025/10/02 09:48:20.42 server The transaction log in the database 'db01a' will use I/O size of 2 Kb.
00:0002:00000:00002:2025/10/02 09:48:20.42 server Database 'db01a' is now online.
======
We can see database "db01a" is online.
This only occurs if database is replicated on source server.
Read more...
Environment
SAP Adaptive Server 16.0 SP03 PL04
Product
Keywords
quiesce database, external dump, online, offline, replication, replicated, -q, SYNCDPDB, $rep_xact_for_dumpdb , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.
SAP Knowledge Base Article - Preview