Db_show
The db_show utility enables you to look at various properties of a database without actually connecting to the database.
To start db_show
-
Enter the following at the system prompt:
db_show [qualifiers] <database name>
Parameter
You must specify the name of the database whose information you want to view on the command line.
Qualifiers
You can use the following qualifiers, preceded by a "/" or "-" character, with the db_show command:
process
Use the process qualifier to show all of the processes connected to the database.
database
Use the database qualifier to show the characteristics of the database file.
all
Use the all qualifier to show both the processes connected to the database and the characteristics of the database file.
Example
W:\vaccess\test> db_show /process ds1
[TSK][Proc ID ][chix] PROCESS USER IMAGE
---------------------------------------------------------------
[ 1][000000B1] [ 0] Steinman db_view ds1
[ 2][00000111] [ 0] Steinman db_show /process ds1
Done with exit cleanup.
W:\vaccess\test> db_show /database ds1
Database name: DS1
Number of channels: 35
Created: 4-NOV-1998 12:54:33.87
From the file: test.adb
Disk file: test.idb
Version: 4.0
User Version: 0
VDB memory: 111 512-byte blocks
AST memory: 595 512-byte blocks
Total number of ASTs: 1903
ASTs available: 1903