BRTOOLS: Enable/Disable Tablespace Autoextend

1. Execute command brtools. Select option 2 – Space management.

BR*Tools main menu

1 = Instance management

2 - Space management

3 - Segment management

4 - Backup and database copy

5 - Restore and recovery

6 - Check and verification

7 - Database statistics

8 - Additional functions

9 - Exit program

2. Select option 5 – Alter data file.

Database space management

1 = Extend tablespace

2 - Create tablespace

3 - Drop tablespace

4 - Alter tablespace

5 - Alter data file

6 - Move data file

7 - Additional space functions

8 - Reset program status

3. You can select option 4 – Tablespace names (tablespace) to enable or disable specific tablespace. Press ‘c‘ to continue the execution.

BRSPACE options for alter tablespace

1 - BRSPACE profile (profile) ........ [initTR3.sap]

2 - Database user/password (user) .... [/]

3 ~ Alter tablespace action (action) . []

4 ~ Tablespace names (tablespace) .... []

5 - Confirmation mode (confirm) ...... [yes]

6 - Scrolling line count (scroll) .... [20]

7 - Message language (language) ...... [E]

8 - BRSPACE command line (command) ... [-p initTR3.sap -s 20 -l E -f tsalter]

4. Next, select option 3 – Turn on and maintain autoextend & select option 4 – Turn off autoextend.

Alter data file main menu

1 - Set data file online

2 - Set data file offline

3 - Turn on and maintain autoextend

4 - Turn off autoextend

5 - Resize data file

6 - Rename data file

7 - Drop empty data file

8 - Show data files

9 - Show tablespaces

10 - Show disk volumes

11 * Exit program

12 - Reset program status