V11 SP8
Loading...

Configuring the SAP MaxDB Parameter File

After you install the SAP MaxDB agent, configure the parameter file.

Procedure

  1. Configure the backup device as a medium and then define the path for the storage media stream and pipe.

    Windows Configuration

    Note: You must specify the pipes from the "\\." directory.

    Use the following format to specify pipes.

    \pipe\[pipe_name]

    Log on to the database and then type the following command from the DBM client interface, substituting the database_name, user_name, and password:

    dbmcli -d <database_name> -u <user_name,password>

    Example

    In this example, "BackData2", "BackLog", and "CompleteF" are the backup devices.

    dbmcli -d cert1 -u DBM,DBM
    medium_put BackData2\mem1 \\.\pipe\pipe_mem1 PIPE DATA 0 0 NO NO '' BACK
    medium_put BackLog\mem1 \\.\pipe\pipe_mem5 PIPE LOG 0 0 NO NO '' BACK
    medium_put CompleteF F:\sdb\cert1\data\complete FILE DATA 0 0 YES

    UNIX Configuration

    Note: You can specify any file path and then create the pipes in the operating system.

    Use the following format to specify pipes.

    \pipe\[pipe_name]

    Log on to the database and then type the following command from the DBM client interface, substituting the database_name, user_name, and password:

    dbmcli -d <database_name> -u <user_name,password>

    Example

    In this example, "BackData2", "BackLog", and "CompleteF" are the backup devices.

    test:/opt/sdb# dbmcli -d cert1 -u DBM,DBM
    medium_put BackData2\mem1 /space/sdb/data/cert1/files/pipe_mem1 PIPE DATA 0 0 NO NO '' BACK
    medium_put BackLog\mem1 /space/sdb/data/cert1/files/pipe_mem5 PIPE LOG 0 0 NO NO '' BACK
    medium_put CompleteF\mem1 /space/sdb/data/cert1/files/complete FILE DATA 0 0 YES

  2. Run the command from the DBM client interface to associate the SAP MaxDB database with the product software.

    Windows Configuration

    Note: You must use double quotes when there is a space in the path that points to the backint.conf file.

    dbm_configset -raw BSI_ENV <software install path>\SapMaxDbAgent\backint.conf

    Example

    In this example, you do not need the double quotes.

    dbm_configset -raw BSI_ENV C:\SapMaxDB\backint.conf

    In this example, you must use double quotes because the path contains a space ("Program Files").

    dbm_configset -raw BSI_ENV "C:\Program Files\CommVault\ContentStore\SapMaxDbAgent\backint.conf"

    UNIX Configuration

    Log on to the database and then type the following command from the DBM client interface, substituting the database_name, user_name, and password:

    dbm_configset -raw BSI_ENV <software install path>/SapMaxDbAgent/backint.conf
    dbm_configset -raw set_variable_0 LD_LIBRARY_PATH=/<software install path>/Base
    dbm_configset -raw set_variable_1 SHLIB_PATH=/<software install path>/Base

    Example

    dbm_configset -raw BSI_ENV /opt/commvault/SapMaxDbAgent/backint.conf
    dbm_configset -raw set_variable_0 LD_LIBRARY_PATH=/opt/commvault/Base
    dbm_configset -raw set_variable_1 SHLIB_PATH=/opt/commvault/Base

    Configure the shared library path in the .profile file from the root directory.

    AIX and HP-UX Configuration:

    SHLIB_PATH=/<software install path>/Base:/<software install path>/Base64
    export SHLIB_PATH
    For Linux and Solaris:
    LD_LIBRARY_PATH=/<software install path>/Base:/<software install path>/Base64
    export LD_LIBRARY_PATH

  3. Configure the SAP MaxDB parameter file (param). Include the required and optional parameters.

    For information on the parameters, see Supported SAP MaxDB Configuration File Parameters.

    Windows Configuration

    The parameter file is located under the <software_install_folder>\SapMaxDbAgent.

    numstreams
    1
    CvInstanceName
    Instance001
    CvClientName
    magnum_SN
    SelectiveOnlineFull
    1
    CV_restCopyPrec
    2
    srcCrossClient
    sde-sap5

    UNIX Configuration

    The parameter file is located under the <software_install_folder>/SapMaxDbAgent.

    numstreams
    1
    CvInstanceName
    Instance001
    CvClientName
    magnum_SN
    SelectiveOnlineFull
    1
    CV_restCopyPrec
    2
    srcCrossClient
    sde-sap5

  4. Verify that the backup tool is specified as BACKINT in the backup template if you intend to run backup and restore jobs from the SAP Database Studio.