Sybase Version 2.2 manual Upgrading the PATRIOT database, $PATRIOT/release2.2/database directory

Upgrading the PATRIOT database

Windows example: JAVA_HOME=$JAGUAR\shared\sun\jdk\jdk.3

6Set the PATRIOT environment variable. This is the directory where you initially copied the contents of the PATRIOTcompliance Starter Kit Solution Template CD.

Solaris example: PATRIOT=$PATRIOT

Windows example: PATRIOT=%PATRIOT%

Upgrading the PATRIOT database

Release 2.2 includes scripts that allow you to upgrade the PATRIOT database (Patriotdb) and New Era of Networks database (NNSYdb). There are separate instructions for Solaris and Windows-based installations.

Solaris	Use these instructions to upgrade your database on Solaris.
	1	Open a command window. Navigate to the
		$PATRIOT/release2.2/database directory.
	2	Execute the PatriotDB2.2_Upgrade.sql script, with the following syntax:
		isql -S <ASE server name> -U <ASE_username> -P
		<ASE_password> -i PatriotDB2.2_Upgrade.sql -o
	3	Review and correct any errors in the output file.
Windows	Use these instruction to upgrade your database on Windows.
	1	Open a command window. Navigate to the %PATRIOT%\database
		directory.
	2	Execute the PatriotDB2.2_Upgrade.sql script, with the following syntax:
		isql -S <ASE server name> -U <ASE_username> -P
		<ASE_password> -i PatriotDB2.2_Upgrade.sql -o
	3	Review and correct any errors in the output file.

8 PATRIOTcompliance Starter Kit