Showing Disk Volumes with BR*Tools

You can use BR*Tools for Oracle to show information about database disk volumes.

BRSPACE searches in the SAPDATA_HOME directory (on UNIX) or on all local drives (on Windows) for all available sapdata<N> directories, regardless of whether they already contain database files. It displays these in the List of database disk volumes, as described below. The column Dbfs/Lnks indicates how many database files or softlinks already exist in these directories.

Procedure

Start the procedure using BRGUI or BRTOOLS, or from the command line:

BRGUI or BRTOOLS:

Choose Space management Additional space functions Show disk volumes
BRGUI or BRTOOLS displays the menu BRSPACE main options for showing database information, where you specify the options with which you call BRSPACE.

Set the required options:

Menu Entry	Equivalent BRSPACE Command Option
BRSPACE profile (profile)	-p\|-profile
Database user/password (user)	-u\|-user
Create log file (log)	-f dbshow -l\|-log
Confirmation mode (confirm)	-c\|-confirm
Scrolling line count (scroll)	-s\|-scroll
Message language (language)	-l\|-language
BRSPACE command line (command)	This shows you the BRSPACE -f dbshow -c dvinfo command that is to be executed using the current settings.

Choose Continue.
BRGUI or BRTOOLS prompts you to start BRSPACE.

Command line:
Enter at least the following command:

brspace –f dbshow –c dvinfo

You can enter more parameters if required. For more information, see BRSPACE -f dbshow.

BRSPACE starts and you see a message that includes Start of BRSPACE processing. From now on, BRSPACE writes a detail log if you set the option Create log file (parameter -l|-log).

Note Note

If you started BRSPACE from the command line without the information class name (-c|-class) – that is, with brspace –f dbshow – BRSPACE displays the Show database information main menu.

Choose Start of the navigation path Show database space information Next navigation step Show disk volumes End of the navigation path .

End of the note.

BRSPACE displays the List of database disk volumes:

List Entry	Meaning
Pos.	List sequence number
Device	Disk device ID for the disk volume
Total [KB]	Total space on volume
Used [%)	Used space on volume
Free[KB]	Free space on volume
Usable [KB]	Usable space
Dbfs/Lnks	Number of database files or softlinks on volume
Directory/RawDisk	Name of directory or raw disk where volume is located

To see more information, select one or more disk volumes.

Example Example

These examples apply only to input in character mode.

To select the first three entries in the list, enter 1-3.

To select the first and third entries, enter 1,3.

To select the first three entries and the fifth, enter 1-3,5.

To select all entries, enter 0.

End of the example.

BRSPACE displays Information about disk volume:

List Entry	Meaning
Disk device Id (device)	Disk device ID for the disk volume
Total space in KB (total)	Total space on volume
Used space in % (used)	Used space on volume
Free space in KB (free)	Free space on volume
Usable space in KB (usable)	Usable space on volume (1023/1024 of free space)
All free space in KB (afree)	All free space on volume including space reserved for superuser
Database file/link count (count)	Number of database files or links on volume
Max. still needed space in KB (needed)	Additional space needed by autoextensible files to achieve maximum file size
Max. missing space in KB (missing)	Missing space if all autoextensible files had maximum file size

If you specified multiple disk volumes, choose Continue to scroll through.

Result

If you set the option Create log file (parameter -l|-log), check the results in the BRSPACE logs:

The summary log space<DBSID>.log displays the return code.
The detail logs <encoded timestamp>.dbw displays the details.

For more information about how to view the logs with BR*Tools, see Showing Profiles and Logs with BR*Tools.