Enlarge the existing MAXDB Database size

[aprao]

Introduction:

The purpose of this article is to describe the procedure to enlarge the MAXDB database size running on any SAP application. There was an alert that the database size used was getting full.

The procedure for enlarging MAXDB datafiles is described below.

 

Login using SAPGUI  in any productive client.

To identify and confirm  the type of database used,  in the menu path, select System -->Status

As shown above,  MAXDB was running on Windows Server.

Check available disk space for all disk drives as shown below.

Select properties by clicking the right button of the mouse on the SAPDATA drive (in this case

K: drive).

 

As shown above, SAPDATA  drive  (for example Drive K:  has enough disk space for enlarging  the database manually

Open the SAPDB Database studio

 

 

After entering the password, a screen appears as shown below

Select <SID>  where the database size used was full.

Click the Administration tab highlighted in the red color circle as shown above.

You will get the details information  on the right side of the screen as shown below

On the tab, click Data Area.  You can see that out of 22GB used in each data file, approx 2.6GB was free for each data file.  However, a warning alert was appearing frequently that the database size used was almost full. This is because the threshold value  that crossed  89%  triggered the alert. 

To clear the alert, we need to enlarge the database size by adding new data files.

The procedure to add new data files will be described below.

Make sure there should be enough disk space available in the SAPDATA drive. If not then add more disk space (extend disk space in the same drive or  add a new disk drive with sufficient  disk space )

Procedure :

Select new DATA0006, click the right button of  a mouse, then select New  as shown below

 

 

Enter the size and device / File location. Make sure the size of the new datafile must the same for all existing datafiles such as DISKD0001, DISKD0002, DISKD0003, etc. Click Ok.

You can see the status "Adding volume DATA0006"  was running. Wait for a few minutes to complete and the status should show volume added.

 

The status for DATA0006 was changed to green as shown below.

Repeat the same procedure for adding new Datafile  DATA0007

 

Click Ok. The status  for adding volume DATA0007 is as shown below

 

 

 

After DATA0007 was added, the reorganization of each data file was carried out automatically as shown above. The used size was distributed in all Active datafiles as shown below highlighted in yellow color.

 

Check the available disk space in the SAPDATA drive.

Now available disk was reduced after enlarging the size of the database.

Conclusion:  There is no need for downtime in the system to enlarge the existing database size. The above procedure can be used online while end users can continue to do business transactions.

 

Thanks for reading!

Follow for more such posts by clicking on FOLLOW => aprao9089

Please share your thoughts and feedback on this blog in a comment.