How to add a datafile to a Live Cache Database??

[Former Member]

How to add a datafile to a Live Cache Database??

[Former Member]

After adding data file in Live cache , not able to bring the livecache into online status , its keep on Admin mode .

I tried with many options .. some are below :

Status :

dbmcli -d <SID> -u <username>,<password>db_state

Stop:

dbmcli -d <SID> -u <username>,<password> db_offline

Start :

dbmcli -d <SID> -u <username>,<password> db_online

[Former Member]

if you have DB stdio manager you can add directly from Data Area, by right clicking on Inactive Data volume and Add

from os level you can do it by

dbmcli -d <db_name> -u control,<password>

db_addvolume DATA

the above command is fine, it will add the new data volumes by itself

[ahmed_ibrahim2]

Hi prakhar,

in addition to Benjamin you can use Data Base manager CLI

Connect to database  >dbmcli –u <username>,<password> –d <DBNAME>

dbmcli on <DBANME>>

Create the the Data Volume

dbmcli on DBNAME> db_addvolume DATA "fullpath\DISKNAME" F sizeK

Best Regards

AhMeD

[Reagan]

Hello

Install MaxDB Database Studio Manager

Connect the MaxDB database to the studio.

Follow this document

http://scn.sap.com/people/serge.appels/blog/2008/10/06/how-to-resize-maxdb-datafiles-online

You need to add a new volume to the data area

Regards

RB

[Former Member]

Hi,

Please use maxdb gui to login in the database and can add the datafile in there.

Please check the below notes.

767598 - Available SAP MaxDB documentation

846890 - FAQ: SAP MaxDB database management

Thanks

Rishi Abrol