2. Using Ingres Commands : logstat Command—Display Logging Status : Logstat Command Output – List of Active Databases
 
Share this page                  
Logstat Command Output – List of Active Databases
The List of Active Databases provides statistical information on all active databases in the logging system. You can use the information in this section and the List of Active Transactions section to determine which databases are open and active. Before shutting down an installation, you should ensure that all databases are closed. Knowing which databases are open and active allows you to determine whom to notify of the impending shutdown.
This section has the following fields:
Id
Identifies the logging system ID number of an active database
Database
Identifies the name of the database and of the DBA.
Status
Indicates the current state of the database.
Tx_cnt
Indicates the number of transactions currently active in the database
Begin
Indicates the number of transactions started in this database
End
Indicates the number of transactions ended in this database
Read
Indicates the number of reads that the logging system performed on behalf of this database
Write
Indicates the number of writes that the logging system performed on behalf of this database
Force
Indicates the number of times that the logging system had to force out the log buffer on behalf of this database
Wait
Indicates the number of times that the logging system had to wait for a log buffer on behalf of this database
Location
Indicates the physical location of this database in the file system
Journal Window
Indicates the active journal window on this database. If no journaling is active on the database, the window has boundaries <0,0,0>. .<0,0,0>.
Start Backup Location
Indicates the log file end-of-file (EOF) address when a database backup is started. This address is used during online backup processing.