Step 3: Restoring Data from ISM to the Target Database

To restore the data from ISM to the target database server

Log in as user informix.
If the Informix database server is online, shut it down.
Dynamic Server
On Dynamic Server:
```
onmode -ky
```
End of Dynamic Server

Extended Parallel Server
On Extended Parallel Server:
```
xctl onmode -ky
```
End of Extended Parallel Server

Configure the following ISM environment variables for this session. For example:

UNIX Only

On UNIX:

ISM_CLIENT = source_hostname
ISM_SERVER = target_hostname
ISM_DATA_VOLUME_POOL = same_value_on_source_host
ISM_LOG_VOLUME_POOL = same_value_on_source_host
export ISM_CLIENT ISM_SERVER 
export ISM_DATA_VOLUME_POOL
export ISM_LOG_VOLUME_POOL

End of UNIX Only

Windows Only

On Windows:

set ISM_CLIENT = source_hostname
set ISM_SERVER = target_hostname
set ISM_DATA_VOLUME_POOL = same_value_on_source_host
set ISM_LOG_VOLUME_POOL = same_value_on_source_host

End of Windows Only

Recover your media database for each of your data volume pools (ISMData, ISMLogs):
```
ism_catalog -recreate_from device_name
```
Synchronize the media index database:
```
nsrim -v
```

To mark your media as appendable for each of your volume pools (ISMData, ISMLogs), complete the following steps:

ism_show -devices
ism_op -unmount device_name
ism_show -volumes
ism_config -volume volume_name -only_restore no
ism_op -mount device_name

On Dynamic Server, restore copies of the following critical files located in the $INFORMIXDIR/etc (UNIX) or %INFORMIXDIR%\etc (Windows) directory:
```
oncfg_source_dbservername.servernum
ixbar.servernum
# for UNIX users only
$ONCONFIG
sqlhosts 
# for Windows users only
%ONCONFIG%
```
Windows Only
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/...
```
Rename the oncfg* file and replace the host database server name with the target database server name. For example:
```
oncfg_target_dbservername.servernum
```
End of Windows Only
On Extended Parallel Server, restore copies of the following critical files located in the $INFORMIXDIR/etc directory from each coserver on the target computer:
```
onconfig.sourcecomputer
Bixbar.hostname.servernum
oncfg_source_dbservername.servernumber.coservernumber
sqlhosts
xcfg_sourcecomputer.servernumber
```
For the following files, replace the host database server name with the target database server name:
```
oncfg_source_dbservername.servernumber.coservernumber
xcfg_hostname.servernumber
Bixbar.hostname.servernum
```
Edit the xcfg_hostname.servernumber file to change the source database server name to the target database server name.
Update the sqlhosts file or registry entry and include the proper shared memory settings for the target database server.
UNIX Only

In the sqlhosts file, change the database server name in the first and fourth entries on each line, if necessary. Change the hostname in the third entry to the target hostname.

End of UNIX Only
Update the ONCONFIG file and replace the source database server name with the target database server name. For example:
```
DBSERVERNAME target_dbservername
```
Extended Parallel Server

For Extended Parallel Server only, change the hostnames in the NODE lines. Delete the SADDR, LADDR, and HADDR lines that follow each NODE line in the ONCONFIG file.

End of Extended Parallel Server
Create new dbspaces if you have not already done so.
Make sure they reside at the same path locations as they do on the source database server. User informix and group informix also should own these dbspaces.
Perform the imported restore on the target database server:
```
onbar -r 
```
Reconfigure your ISM settings for daily backup and restore operations.
Do not change the settings of the ISM_CLIENT and ISM_SERVER environment variables.

Important:

If the imported restore fails with an error about the source hostname not having access, grant permission for local users to access the indexes for the source client. For details, see steps 15 and 16 on page 15.