SAP Knowledge Base Article - Preview

3669699 - Server started with -q but database comes online - SAP ASE

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

SAP Adaptive Server Enterprise 16.0

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.