DBACOCKPIT saptools

[Former Member]

Dear Experts,

In our organization there is no Database Administrator.I only the BASIS administrator.

Now i am facing one issue.In DBACOCKPIT when we going to configure any thing it is showing "Repair Data Collector".

Instructions from SAP support team, saptools size is 2 GB ,Now we need extend it to 10 GB.So please tell me how to

perform this action.

Thanks&Regards,

Patan Thavaheer.

[former_member3043 · Accepted solution]

Hello,

to increase the size for the data part of saptools you can use isql might be that you need to change the size of the saptools data device.

isql  -Usapsa -S<SID> -X

Password:

-> Check if there is enough space to expand the data device, to see what path saptools_data_001 is using you can use DBACockpit -> Space -> Devices -> saptools_data_001 or in isql just run:

sp_helpdevice saptools_data_001

go

The default size of saptools_data_001 is 2G you need 10G in total, so we add 8G to the device and we will expand the database also:

use maseter

go

disk resize name='saptools_data_001', size='8G'

go

alter database saptools on saptools_data_001 = '8G'

go

DBA Cockpit should now show that saptools is using 10 GB for data (DBACockpit -> Space -> Databases -> saptools) or you can use again ISQL:

sp_helpdb saptools

go

I hope this will help.

With kind regards

Stefan