Before You Begin
Chapter contents
Before upgrading to Pervasive PSQL v9 Service Pack 2, begin by reviewing the following documents for important information:
- Chapter 2, Preparing to Install Pervasive PSQL - This chapter provides important information including system requirements and platform specific notes that are relevant to your operation.
- README file - This file is located on the distribution media and contains late-breaking product news that could not be included in the product documentation.
Considerations
Once you have reviewed the latest product information, review this list of considerations to complete your upgrade installation preparation.
- Pervasive PSQL Applications - Be aware of what applications you have currently using previous versions of Btrieve or Pervasive PSQL in your environment. Don't forget to include both client and server-based applications, such as ArcServe.
- Vendor-Specific Information - Be sure and check with your application vendors for any specific information regarding their product with Pervasive PSQL.
- TCP/IP Protocol - DOS applications require different requesters, preferably BTRBOX95, BTRDRVR, or BREQTCP.
- New Features and File Rebuilding - In order to make use of all the new version features, you must rebuild your data files so that they use the newest version file format. Advanced Operations Guide includes a chapter that details using the Rebuild Utility to rebuild your data files, if you would like to take advantage of newer features.
- Back Up Data Files - Make sure you have a current backup of all your data files prior to beginning upgrade installation
Platform Notes for Windows
This section contains installation information specific to Windows 32-bit platforms.
Migration of Existing Configuration Settings
During the installation process, all of your existing engine configuration values are migrated to the new engine, with several exceptions. The exceptions are documented in Table 5-1.
Table 5-1 Configuration Setting Values not Migrated
|
Configuration Setting
|
New Value
|
|
Server4Debugging4Trace File Location
|
C:\pvsw\bin\mkde.tra [default]; or bin\mkde.tra file in selected installation directory.
|
|
Server4Directories4 Transaction Log Directory
|
C:\pvsw\bin\mkde\log [default]; or bin\mkde\log subdirectory of selected installation directory.
|
|
Server4Compatibility4 Create File Version
|
9.x. By default, new data files are always created in the most recent file format.
|
|
Server4Data Integrity4 Transaction Durability
|
Off. With the addition of a new setting, Transaction Logging (default: On), Transaction Durability is not needed to ensure multi-file transaction atomicity and data integrity. If your application requires true Transaction Durability, you will need to use Configuration to turn this setting On.
|
Installing Over Existing Pervasive Products
- If you are upgrading from older product versions such as Btrieve 6.15 and wish to make use of all the new version features, you must rebuild your data files so they use the v8 or v9 file formats. See the Advanced Operations Guide section for detailed information on how to use the Rebuild Utilities to convert your data files.
- If you install Pervasive PSQL v9 Service Pack 2 over an existing version such as Pervasive.SQL 2000 or Btrieve 6.15, then those products will be archived when you install Pervasive PSQL v9 Service Pack 2 so that there are no component conflicts. You can use Pervasive System Analyzer later to restore the archived products if necessary. Your licenses from previous Pervasive products such as Btrieve 6.x and Pervasive.SQL 2000 will not be migrated to Pervasive PSQL v9 Service Pack 2.
Installation Tips
- When installing Pervasive PSQL v9 Service Pack 2 for the first time on a system, Setup will check if all of the needed system files meet the minimum requirements. In some cases, these files are locked by the operating system and a reboot is required before Setup can continue. The following dialog box is displayed if this is the case.
Figure 5-1 Pervasive PSQL v9 Service Pack 2 Setup Reboot Required
Click Yes to reboot the system. Setup is then automatically be restarted.
Note
It is strongly recommended that you reboot your system if you encounter this message. If you do not reboot your system, Setup will encounter failures during engine and utilities configuration.
Accessing README file information
It is highly recommended that you go through the README file to find out the latest changes and additions to Pervasive PSQL v9 Service Pack 2.
