Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Dec 14, 2013 at 04:04 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 14, 2013 at 05:39 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 14, 2013 at 01:47 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 15, 2013 at 07:45 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 21, 2014 at 11:29 AM

    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

    Add comment
    10|10000 characters needed characters exceeded