has not been set to false
in the notes.ini
, the IBM Notes
Traveler server will automatically update the DB schema as needed. As a result, you can skip the rest of this information.
has been set to false
in the notes.ini
, then you must manually update the DB schema as part of the IBM Notes
Traveler server upgrade process.
Perform the following procedure to manually upgrade the DB Schema:
- Determine the current DB Schema level being used by the IBM Notes Traveler HA Servers:
- On pre-9.0 servers, run the following command: tell traveler sql select * from schemaversion
- On 9.0 and later releases run this command: tell traveler version
The Schema version will be in the format version.builddate, for example: 126.96.36.199.20130115.
Install the Notes IBM Traveler server on a test system or on the first IBM Notes Traveler system to be upgraded.
From the IBM Notes Traveler server, copy either the file <domino install data dir>\traveler\cfg\db\TravelerSQL.zip or TravelerSQL.tar.gz to the directory <sqldir> on the Enterprise DB server.
Unzip or Untar the TravelerSQL file and CD to the correct directory for your Enterprise DB server (DB2, SQLSERVER, or AS400).
There will be a numbered list of fixup#.sql files. Determine the one which corresponds to the current schema version by looking at the end of the file. Start your search with the fixup#.sql file after the one which contains a statement similar to the following, with the current Schemaversion:
Note: In many cases this will not match the IBM Notes Traveler version and build date. Ensure you note the Schema version and not the IBM Notes Traveler version.
Once the correct starting fixup#.sql has been determined, edit the file, as well as all of the following files, and update the Database name, Schema name and path name if you used any value other than the default when creating the database and schema.
Starting with the correct fixup#.sql you located in step 5, execute each fixup#.sql file in order on the DB server using the following commands.
DB2® on Windows™: db2cmd -c -w -i db2 -tvf fixup#.sql
Once all fixup#.sql scripts have run, proceed with upgrading the IBM Notes Traveler servers.
DB2 on Linux™: db2 -tvf fixup#.sql
SQL Server: sqlcmd -U <admin_user>-P <admin_password> -i "fixup#.sql"
AS400 Server: RUNSQLSTM SRCSTMF('/QIBM/Proddata/lotus/traveler900/traveler900/data/traveler/cfg/db/AS400/fixup#.sql') PROCESS(*RUN) NAMING(*SQL) USRPRF(*USER)
Note: On an AS400 server, you can also copy the fixup#.sql to a local directory on your workstation. Then, select System i Navigator > Databases > Run SQL Scripts, and load and run the fixup#.sql.
Parent topic: Configuring the IBM Notes Traveler High Availability Pool