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

Step 2: Porting ISM to Your Target Database Server

You need to port and replicate ISM on the target database server.

To port ISM to your target database server
  1. Log in as user root (UNIX) or Administrator (Windows) on the target database server.
  2. Shut down the Informix database server and ISM.
    Dynamic Server

    On Dynamic Server:

    onmode -ky
    ism_shutdown
    End of Dynamic Server
    Extended Parallel Server

    On Extended Parallel Server:

    xctl onmode -ky
    ism_shutdown
    End of Extended Parallel Server
  3. Unset the ISM_CLIENT environment variable as follows:
    unset ISM_CLIENT
  4. Edit the ism_startup script or ism_startup.bat script:
    UNIX Only

    On UNIX:

    1. Locate the following line in the $INFORMIXDIR/bin/ism_startup script and type hostname verbatim:
      hostname=$(hostname)
    2. Add the following line immediately after that line:
      hostname=source_hostname
    End of UNIX Only
    Windows Only

    On Windows:

    1. Locate the following line in the %INFORMIXDIR%\bin\ism_startup.bat script:
      Set nextLabel = ask_init
    2. Add the following line immediately before that line:
      set hostname = source_hostname
    End of Windows Only
  5. Reinitialize ISM:
    ism_startup -init
  6. Using a text editor, create a temporary file and enter the following information:
    UNIX Only

    On UNIX:

    create type: NSR client; name: source_hostname; remote
    access: root@target_hostname, informix@target_hostname
    End of UNIX Only
    Windows Only

    On Windows:

    create type: NSR client; name: source_hostname;
    remote access: Administrator@target_hostname,
    informix@target_hostname
    End of Windows Only
  7. Run the following command against the temporary file:
    nsradmin -s target_hostname -i temporary_file
Important:
After you run this command, you might receive an error message similar to the following message. Ignore this message and complete the procedure as outlined.
create failed: save set of All for client source_hostname in group 
Default excludes any clients with the same name from the group.
To replicate ISM with the same resources that you have on the source host, you must recover your bootstrap
  1. If your source INFORMIXDIR does not match your target INFORMIXDIR, you need to create a symbolic link to recover the bootstrap from the source computer.

    For example, if INFORMIXDIR on your source computer is /usr2/informix and INFORMIXDIR on your target computer is /usr/local/informix, create the /usr2 directory on the target computer and symbolic link as follows:

    UNIX Only

    On UNIX:

    mkdir /usr2
    ln -s /usr/local/informix /usr2/informix
    End of UNIX Only
    Windows Only

    On Windows:

    Create a shortcut from your source INFORMIXDIR to your target INFORMIXDIR. For information on how to create a shortcut, see your operating-system documentation.

    End of Windows Only
  2. Add the device that contains the volume pool that contains the bootstrap file:
    ism_add -device device_name -type device_type
  3. Add the remaining devices for the other volume pools.
  4. Mount the storage volume that contains the most recent backup from the ISMData volume pool.
  5. Mount the remaining storage volumes.
  6. Scan the volume for the most recent bootstrap save set:
    ism_catalog -find_bootstrap device_name

    ISM displays the ssid numbers for all bootstrap save sets on the volume. Record the most recent ssid number because you will need to use this number again in step 8.

  7. Recover the most recent bootstrap save set:
    ism_catalog -recover
  8. Enter the most recent bootstrap save set number you recorded earlier in step 6.

    Wait until the following message appears. Ignore the warning and proceed to the next step:

    nsrindexasm: Didn't find earlier versions to recover!
    WARNING: The online index for hostname was NOT fully
    recovered...
  9. Shut down ISM:
    ism_shutdown
  10. Recover the res.R file from the source database server.

    The res.R file contains the resource configuration information for the source database server.

    UNIX Only

    On UNIX:

    cd $INFORMIXDIR/ism
    rm -rf res
    mv res.R res
    End of UNIX Only
    Windows Only

    On Windows:

    cd %ISMDIR%
    del res
    rmdir res
    move res.R res
    End of Windows Only
  11. Important:
    Perform step 11 for disaster recovery only if you did not issue the ism_add -admin command on the source computer because it was unavailable.
  12. Create the following temporary file and then run the nsradmin command against that file.
    UNIX Only

    On UNIX:

    print type:NSR;
    
    update administrator:informix@source_host,
    root@source_host,informix@target_host,
    root@target_host
    
    nsradmin -f $INFORMIXDIR/ism/res/nsr.res -i temporary_file
    End of UNIX Only
    Windows Only

    On Windows:

    print type:NSR;
    
    update administrator:informix@source_host,
    Administrator@source_host,informix@target_host,
    Administrator@target_host
    
    nsradmin -f %ISMDIR%\res\nsr.res -i temporary_file
    End of Windows Only
  13. Start ISM:
    ism_startup
  14. Remove the device entries from the source computer that do not exist on the target computer:
    ism_show -devices
    ism_rm -device device_name
  15. Create any additional media device entries that do not appear in ISM to match those that exist on your target host:
    ism_show -devices
    ism_add -device device_name -type device_type
  16. Grant permission for local users to access the indexes for the source client.

    Using a text editor, create a temporary file and enter the following information:

    Important:
    You must enter the command exactly as it appears, including the space between the two lines.
    UNIX Only

    On UNIX:

    print type: NSR client; name: source_hostname 
    
    update remote access: informix@target_hostname,
    root@target_hostname
    End of UNIX Only
    Windows Only

    On Windows:

    print type: NSR client; name: source_hostname 
    
    update remote access: informix@target_hostname,
    Administrator@target_hostname
    End of Windows Only
  17. Run the following command against the temporary file:
    nsradmin -s target_hostname -i temporary_file
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]