SAP BASIS Study Notes 1 --Adjusting Tablespace

Issue:
We got warning emails saying that a tablespace may be out of free space soon.

Background:
A shell script runs nightly to verify the free tablespace of the database. If free space is less than 75% of recommended threshold number, it will send out an email to DBAs. The recommended threshold number is determined by 4 times monthly data growth.

Solutions:
Use BR*Tools to resize the data file or extend the tablespace.

Steps:

1. su to production account;
2. Start brtools and choose 2 - Space management;
3. Then choose 5 - alter data file;
4. Then BRSPACE asks you to enter input values; I picked 4 ~ Tablespace names and paste the tablespace name;
5. typed "c" to continue several times till we see menu 314;
6. Choose 5-Resize data file;
7. picked the data file;
8. entered the new size for the option with "?";
9. verified the sql statement is correct, and "c"ontinued;
10. got the successful message;
11. exit the program.