Enterprise Edition Home | Express Edition Home | Previous Page | Next Page   Recovering Save Sets with ISM > Transferring Data with the Imported Restore >

Step 1: Backing Up the Source Database Server to ISM

Important:
If the hostname command outputs a fully-qualified hostname, use fully qualified hostnames in the imported restore procedure. An example of a qualified hostname is mycomputer@informix.com. If the command outputs the short hostname (mycomputer, for example), use the short form.
To back up the source database server to ISM
  1. Execute the hostname command on your source and target computers.
  2. Bring the database server to quiescent mode with the following command:
    onmode -s
  3. Set the following ISM environment variables:
    UNIX Only

    On UNIX:

    ISM_SERVER = source_hostname
    ISM_DATA_VOLUME_POOL = ISMData
    ISM_LOG_VOLUME_POOL = ISMLogs
    export ISM_SERVER 
    export ISM_DATA_VOLUME_POOL
    export ISM_LOG_VOLUME_POOL
    End of UNIX Only
    Windows Only

    On Windows:

    set ISM_SERVER = source_hostname
    set ISM_DATA_VOLUME_POOL = ISMData
    set ISM_LOG_VOLUME_POOL = ISMLogs
    End of Windows Only
  4. Perform a full backup of the source database server:
    onbar -b -L 0
  5. Back up copies of the following critical files located in the $INFORMIXDIR/etc (UNIX) or %INFORMIXDIR%\etc (Windows) directory. When you perform an imported restore to another computer system, you will need to restore these files.
    Dynamic Server

    On Dynamic Server, copy the following files:

    oncfg_source_dbservername.servernum
    ixbar.servernum
    # for UNIX users only
    $ONCONFIG
    sqlhosts 
    # for Windows users only
    %ONCONFIG%
    End of Dynamic Server
    Windows Only

    On Windows, use regedit to copy the sqlhosts information from the source computer to the target computer. Use the following registry entry:

    HKEY_LOCAL_MACHINE/SOFTWARE/Informix/SQLHOSTS/...
    End of Windows Only
    Extended Parallel Server

    On Extended Parallel Server, copy the following files:

    onconfig.sourcecomputer
    Bixbar.hostname.servernum
    # for all coserver numbers, copy the oncfg files
    oncfg_source_dbservername.servernumber.coservernumber
    sqlhosts
    xcfg_sourcecomputer.servernumber
    End of Extended Parallel Server
  6. Complete the following steps to make your security portable to the new computer:
    UNIX Only

    On UNIX:

    ism_add -admin root@target_hostname
    ism_add -admin informix@target_hostname
    End of UNIX Only
    Windows Only

    On Windows:

    ism_add -admin Administrators@target_hostname
    ism_add -admin informix@target_hostname
    End of Windows Only
  7. Save the bootstrap of your source ISM server:
    UNIX Only

    On UNIX:

    $INFORMIXDIR/bin/ism_catalog -create_bootstrap \
    -pool $ISM_DATA_VOLUME_POOL
    End of UNIX Only
    Windows Only

    On Windows:

    cd %INFORMIXDIR%\bin
    ism_catalog -create_bootstrap -pool %ISM_DATA_VOLUME_POOL%
    End of Windows Only
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]