LISTDB

Using the listdb command displays the list of databases sorted first by Instance Name and followed by Database Name. It provides a structured and intuitive output, grouped by instance, for better clarity and management.

Syntax

listdb {options}

Other options

-h

displays this help

-d dbasename

only for this database

-s delimiter

change default delimiter (|)

-r

gives resilience type

-t

gives type of database

-o

return database owner

-l

return database locked state

-i

return database instance path

-a

gives all information (-r,-t,-o,-l,-i)

Extended options

-I return database instance number

-S return database size type

-m return database emulation code

-u/-w return user licence usage or full details

-c return the status of the instance

-e return resilience configuration

-f return resilience status

-p return database space usage

-V display all extended information

-H display in Human readable format

Example 1

The following example illustrates that using this command lists all the databases:

listdb -a
ace|/export/home/dbases/ace|V15.1.0.0446|1|NA;N;Standalone|realman|notlocked|
delacc1|/realman/delacc1|V15.1.0.0446|1|NA;N;Standalone|realman|owner|/usr/realman/15.1
clone1|/export/home/dbases/clone1|V15.1.0.0446|1|;N;Standalone|realman|notlocked|/usr/realman/15.1_1
clone2|/export/home/dbases/clone2|V15.1.0.0446|1|;N;Standalone|realman|notlocked|/usr/realman/15.1_2				

Example 2

listdb -r
ace.tester|C:/dbases/ace.tester|V15.1.0.0457|FS;N;Primary
devtest|C:/dbases/devtest|V15.1.0.0457|;N;Standalone
qatest|C:/dbases/qatest|V15.1.0.0457|;N;Standalone
regression|C:/dbases/regression|V15.1.0.0457
				

Example 3

listdb -S
ace.tester|C:/dbases/ace.tester|V15.1.0.0457|0
devtest|C:/dbases/devtest|V15.1.0.0457|0
qatest|C:/dbases/qatest|V15.1.0.0457|0
regression|C:/dbases/regression|V15.1.0.0457|0
				

Example 4

listdb -pH
======================================================================
Name              : ace.tester
Path              : C:/dbases/ace.tester
Version           : V15.1.0.0457
Database usage    :
Total size 3.0 GB
Total free 2.1 GB
Percent free 69.11
======================================================================
Name              : regression
Path              : C:/dbases/regression
Version           : V15.1.0.0457
Database usage    :
Total size 1.0 GB
Total free 970.4 MB
Percent free 94.74