Resize or add datafiles using brspace

This is a quick reference for SAP brspace utility.

* To add a new file to tablespace (to keep the same size as the previous file and keep the same location) run:

brspace -c force -f tsextend -t [tablespace name]

The file properties such as size, autoextend, filesystem will default to the file that was added previously


* To add a new file and specify a filesystem run:

brspace -c force -f tsextend -t [tablespace name] -f [filesystem name]


* To resize database file using brspace utility

brspace -c force -f dfalter -a resize -f [path to file] -s [size in Mb]


* To view system tablespace information i.e. free space, run:

brspace -f dbshow -c tsinfo -s SYSTEM