Restoring remote database schemas on i5/OS

Portal Express, Version 6.0
Operating systems: i5/OS, Linux, Windows

Restoring remote database schemas on i5/OS

Follow these steps to restore remote database schemas on IBM^® i5/OS.

Before restoring the saved version of the IBM WebSphere^® Portal Express profile, this script renames Integrated File System (IFS) data associated with the existing profile, and duplicates the schema data. This protects against the case where the user specifies the wrong profile name and the wrong profile is restored. To avoid unnecessarily using up storage on your system, delete the renamed and duplicated data after you have verified that the restore occurred successfully (check the log file for details on the renamed profile data). In addition, you can specify the -x parameter to prevent the schema data for the profile from being duplicated.
If WebSphere Portal Express is not installed on the system containing the remote schemas, copy the file /QIBM/ProdData/PortalExpress/V6/Tools/rstWpRmtDb.sh from a system where WebSphere Portal Express is installed to a location in the IFS of the system where the remote database schemas are located.
Start the QShell Interpreter on the system containing the remote database by entering the following on an i5/OS command line:
STRQSH
Change to the directory containing the rstWpRmtDb.sh file. If WebSphere Portal Express is not installed on the system, change to the directory where you copied the rstRmtDb.sh file. If WebSphere Portal Express is installed on the system, change to the PortalExpress tools directory by entering the following:
cd /QIBM/ProdData/PortalExpress/V6/Tools
Enter the following command to back up your profile:
rstWpRmtDb.sh parameters
The command takes the following parameters as listed in the table, with these being required:

a list of schemas (-t)
either a media device (-m) and a save date (-d) or save file library (-s)

Parameter names are case-sensitive.
Parameter Description
-help (-h)
Displays help for the command

-schemaList (-t)
Specifies a list of schemas to restore. Schemas listed must be separated by commas, with no spaces in between.

-date (-d) The date of the schema data to restore. Do not use this parameter unless you are restoring from a media device. This value should be in the format used by the system for date/time values (for example, 060105 for June 1st 2005, if MDY format being used on the system). Check the QDATFMT system value to determine which format to use.
-mediaDevice (-m)
Specifies a media device to restore from

-saveFileLib (-s)
Specifies a library to restore from. The library name must be 10 characters or less.

-logDir (-l)
Where to save log files for this command. If a log directory is not specified using this parameter, logs are created by default in /savRstWp60.

If you specify a path using this parameter, the command will create only the last directory in the path. The other directories in the path must already exist. For example, if you specify -l /wcs01/logs, the /wcs01 directory must already exist.
-noSaftyNet (-x)
Do not duplicate existing schema data.

By default, the command duplicates existing schema data before deleting it. This protects against the case where the user enters the wrong profile name and the wrong profile is restored. Only use this parameter if you wish to prevent this duplication from happening.

-seqNum (-q)
The starting sequence number of the file set you want to restore. Normally you will not need this parameter, but if you saved multiple copies of the same instance on the same day on the same tape, you may need to distinguish which save set you want. This parameter is only valid with -m option and the media device must be a tape drive.

-verify (-v)
Verifies the command. If this parameter is used, the command outputs what would be done according to the parameters being used, without actually performing the restore.
Check the log file to verify that the script completed successfully. Once you have verified that the restore completed as expected, you can also delete any renamed profile data.
Example:
In the following example, 8 schemas are restored from library savlib1:
rstWpRmtDb.sh -saveFileLib savlib1 -schemaList lib1,lib2,lib3,lib4,lib5,wcs01,wcs02,wcs03
Parent topic:
Backup and restore on i5/OS

Parameter	Description
-help (-h)	Displays help for the command
-schemaList (-t)	Specifies a list of schemas to restore. Schemas listed must be separated by commas, with no spaces in between.
-date (-d)	The date of the schema data to restore. Do not use this parameter unless you are restoring from a media device. This value should be in the format used by the system for date/time values (for example, 060105 for June 1st 2005, if MDY format being used on the system). Check the QDATFMT system value to determine which format to use.
-mediaDevice (-m)	Specifies a media device to restore from
-saveFileLib (-s)	Specifies a library to restore from. The library name must be 10 characters or less.
-logDir (-l)	Where to save log files for this command. If a log directory is not specified using this parameter, logs are created by default in /savRstWp60. If you specify a path using this parameter, the command will create only the last directory in the path. The other directories in the path must already exist. For example, if you specify -l /wcs01/logs, the /wcs01 directory must already exist.
-noSaftyNet (-x)	Do not duplicate existing schema data. By default, the command duplicates existing schema data before deleting it. This protects against the case where the user enters the wrong profile name and the wrong profile is restored. Only use this parameter if you wish to prevent this duplication from happening.
-seqNum (-q)	The starting sequence number of the file set you want to restore. Normally you will not need this parameter, but if you saved multiple copies of the same instance on the same day on the same tape, you may need to distinguish which save set you want. This parameter is only valid with -m option and the media device must be a tape drive.
-verify (-v)	Verifies the command. If this parameter is used, the command outputs what would be done according to the parameters being used, without actually performing the restore.