Maxdb db_addvolume

[former_member614461]

Hi,

Referring to below link:

http://maxdb.sap.com/doc/7_7/44/ec7811606e2951e10000000a11466f/content.htm

Scenario 2

You have noticed that the fill level of the data area of DEMODB is approaching 95 %.However, you want a fill level of 50%.

The system should add as many volumes as necessary to achieve a database area fill level of 50%.

Procedure

Call Database Manager CLI, log on as operator OLEG with password MONDAY, connect to database DEMODB, and extend the data area so as to reach a fill level of 50 %:

>dbmcli –u OLEG,MONDAY –d DEMODB db_addvolume DATA –fd 50

OK

Result

To reach a fill level of 50%, the system has added 1 data volume.

--> My current data volumes:

dbmcli.exe on SDB>info data
OK
END
Name                | Value


Devspace Name       = D:\sapdb\SDB\sapdata\DISKD0001
   Total Space (KB) = 1024000
   Used Space (KB)  = 218712
   Used Space (%)   = 21
   Free Space (KB)  = 805288
   Free Space (%)   = 79
Devspace Name       = D:\sapdb\SDB\sapdata\DISKD0002
   Total Space (KB) = 1024000
   Used Space (KB)  = 218688
   Used Space (%)   = 21
   Free Space (KB)  = 805312
   Free Space (%)   = 79
Devspace Name       = D:\sapdb\SDB\sapdata\DISKD0003
   Total Space (KB) = 102400
   Used Space (KB)  = 102384
   Used Space (%)   = 100
   Free Space (KB)  = 16
   Free Space (%)   = 0

How do I read my current filled data area percentage? Is it 21% (based on DISKD0001 and DISKD0002 but exclude DISKD0003)?

If 21% is correct and I want to achieve a fill level of 15%. I ran below command but it gave an error:

dbmcli.exe on SDB>db_addvolume DATA -fd 15
ERR
-24642,ERR_ANALYZECMD: Could not analyze the parameters of the current command "
db_addvolume".
-24641,ERR_CMDSYNTAX: The given arguments do not match to the syntax of the comm
and.
26,Unexpected token '15' at position 3 in command
-24533,ERR_USAGE: Usage: <vol_mode> [<vol_name> <vol_type> <vol_size> [<mvol_nam
e> <mvol_type>] [PARTITION <partition>]][FORCE_LAST_VOLUME]

Please advise.

Thanks!