Configuring DBLoad Utility

You need to configure the DBLoad Utility to execute the DBLoad scripts.

This task explains how to configure the DBLoad Utility:

  1. Update the file setupEnv.bat (for Windows), or setupEnv.sh (for UNIX) for the following variables. The file is located under <installed path>\<OS>\resources\sdm\exploreJS\bin\(<nt for Windows> or <unix for UNIX>)\

    XJS_ROOT to <installed path>\<OS>\resources\sdm\exploreJS

    JAVA_HOME to <JAVA HOME DIRECTORY>

    LIB_DIR to <installed path>\<OS>\docs\java

    WAS_HOME to (available under :setWASClasspath) <installed WebSphere application directory>

    XJS_STUBS_JAR (available under :setWASClasspath) to the file xjsbeans_ws50.jar with path.

    Example for Windows:

    set XJS_ROOT=D:\SDM\SDM_R16_QA\intel_a\resources\sdm\exploreJS

    set JAVA_HOME=D:\WebSphere5.1\AppServer\java

    set LIB_DIR=D:\SDM\SDM_R16_QA\intel_a\docs\java

    set WAS_HOME=D:\WebSphere5.1\AppServer

    set XJS_STUBS_JAR=%LIB_DIR%\xjsbeans_ws50.jar

  2. Modify the dbload.bat script  (for Windows) or  dbload.sh (for UNIX). The file is located under <installed path>\<OS>\resources\sdm\exploreJS\bin\(<nt for Windows> or <unix for UNIX>)\.

    The values should contain the following:

    For Windows:

    setlocal
    call <installed path>\<OS>\resources\sdm\exploreJS\bin\nt\setupEnv.bat
    set CLASSPATH=%LIB_DIR%\dbload.jar;%LIB_DIR%\xjs.jar;%XJS_ROOT%\admin\configs\locale;%CLASSPATH%
    %JAVA_HOME%\jre\bin\java -DXJS_ROOT=%XJS_ROOT% com.ds.explore.batchimportexport.dbload.DBLoad %*

    For UNIX:

    #! /usr/bin/sh

    . <installed path>/<OS>/resources/sdm/exploreJS/bin/unix/setupEnv.sh
    CLASSPATH=$LIB_DIR/dbload.jar:$LIB_DIR/xjs.jar:$XJS_ROOT/admin /configs/locale:$CLASSPATH
    export CLASSPATH
    $JAVA_HOME/jre/bin/java -DXJS_ROOT=$XJS_ROOT com.ds.explore.batchimportexport.dbload.DBLoad "$@"

  3. Modify the file dbload.cfg located under <installed path>\<OS>\resources\sdm\exploreJS\admin\configs 

    <
    dbservice="<database name>"
    dblabel="<The Database Label of database configuration file>"
    j2eeserver="WAS50"
    appserverport="<Bootstrap Port of the CES server>"
    appserverhost="<Server name where the WAS is running>"
    imageserverport="<Bootstrap Port of the CES server>"
    imageserverhost="<Server name where the WAS is running>"
    username="cisdba"
    password="cisdba"
    numberofworkers="1"
    protocol="iiop"
    >

    For example,

    <
    dbservice="CESSP4"
    dblabel="CESSP4"
    j2eeserver="WAS50"
    appserverport="2810"
    appserverhost="cesserver"
    imageserverport="2810"
    imageserverhost="cesserver"
    username="cisdba"
    password="cisdba"
    numberofworkers="1"
    protocol="iiop"
    >
     

    Configuration Name Description

    dbservice

    This is a unique name to identify a service entry in the dbload.cfg file. This entry is case-sensitive.

    dblabel

    Label from the dbinfo.cfg (on the server) to identify a particular database. This entry is case-sensitive.

    j2eeserver

    Name of the J2EE server. For example, WLS81 on WAS50 on WebSphere Application Server.

    appserverhost

    Name of the machine on which the application server is running.

    appserverport

    BootStrapPort number at which the application server is running.

    username

    Default user name for connecting to the database.

    password

    Default password for connecting to the database.

    numberofworkers

    Specific number for defining the parallel processes that will be executed during the processing of instructions.

    protocol

    Protocol for establishing the connection to the database.

Do not use any keywords supported in DBLoad for any property label or pointer property label. For example, keywords like InsertRandom, UpdateRandom, and OPTIONS.

Configuring XML Import and Export Utility

This task explains how to configure XML Import and Export utility:

  1. Update the file setupEnv.bat (for Windows), or setupEnv.sh (for UNIX) for the following variables. The file is located under <installed path>\<OS>\resources\sdm\exploreJS\bin\(<nt for Windows> or <unix for UNIX>)\

    XJS_ROOT to <installed path>\<OS>\resources\sdm\exploreJS

    JAVA_HOME to <JAVA HOME DIRECTORY>

    LIB_DIR to <installed path>\<OS>\docs\java

    WAS_HOME to (available under :setWASClasspath) <installed WebSphere application directory>

    XJS_STUBS_JAR (available under :setWASClasspath) to the file xjsbeans_ws50.jar
    with path.

  2. Modify the xmlimport.bat script (for Windows) or xmlimport.sh (for UNIX). The file is located under <installed path>\<OS>\resources\sdm\exploreJS\bin\(<nt for Windows> or <unix for UNIX>)\.

    The values should contain the following:

    For Windows

    setlocal
    call <installed path>\<OS>\resources\sdm\exploreJS\bin\nt\setupEnv.bat
    set CLASSPATH=%LIB_DIR%\dbload.jar;%LIB_DIR%\xjs.jar;%XJS_ROOT%\admin\configs\locale;%CLASSPATH%
    %JAVA_HOME%\jre\bin\java -DXJS_ROOT=%XJS_ROOT% com.i2.explore.batchimportexport.axml.XMLImport %*


    For UNIX

    #! /usr/bin/sh

    . <installed path>/<OS>/resources/sdm/exploreJS/bin/unix/setupEnv.sh
    CLASSPATH=$LIB_DIR/dbload.jar:$LIB_DIR/xjs.jar:$XJS_ROOT/admin /configs/locale:$CLASSPATH
    export CLASSPATH
    $JAVA_HOME/jre/bin/java -DXJS_ROOT=$XJS_ROOT com.i2.explore.batchimportexport.axml.XMLImport "$@"

  3. Modify the xmlexport.bat script (for Windows) or xmlexport.sh (for UNIX). The file is located under <installed path>\<OS>\resources\sdm\exploreJS\bin\(<nt for Windows> or <unix for UNIX>)\.

    The values should contain the following:

    For Windows

    setlocal
    call <installed path>\<OS>\resources\sdm\exploreJS\bin\nt\setupEnv.bat
    set CLASSPATH=%LIB_DIR%\dbload.jar;%LIB_DIR%\xjs.jar;%XJS_ROOT%\admin\configs\locale;%CLASSPATH%
    %JAVA_HOME%\jre\bin\java -DXJS_ROOT=%XJS_ROOT% com.i2.explore.batchimportexport.axml.XMLExport %*


    For UNIX

    #! /usr/bin/sh

    . <installed path>/<OS>/resources/sdm/exploreJS/bin/unix/setupEnv.sh
    CLASSPATH=$LIB_DIR/dbload.jar:$LIB_DIR/xjs.jar:$XJS_ROOT/admin /configs/locale:$CLASSPATH
    export CLASSPATH
    $JAVA_HOME/jre/bin/java -DXJS_ROOT=$XJS_ROOT com.i2.explore.batchimportexport.axml.XMLExport "$@"