3.1 Database Extent Management Problem - Offload servers in use.
Table of Contents
Problem
The RecTrac server implementation is split between a database server and a report offload server. We need to add more RecTrac database extents but, because of the offload server, we can't run the add database extents program in RecTrac. The process does not complete. The RecTrac database has an extent file that is well over 2 Gigabytes in size, indicating a new extent should be added.
Solution
When an offload server is utilized, this prevents the RecTrac application from executing an add extent command from the Add Extents program. In this cases you must run the extent creation manually.
Steps For Solution
- Backup your RecTrac database and make a copy of your rectrac.st file. Do not continue until you have done this.
- Create an add.st file in X:\VSI3\RecTrac\Data\LIVE\add.st then open current rectrac.st file and copy the last two lines of the database area for which you want to create extents.
- Paste those two lines into the add.st file. Edit them so that they are numerically sequential.
For example, if the current rectrac.st file is RecTrac_13.d6 and you want to create two more extents, then you would edit the add.st file to the following.
d "RT BLOBII":13,1;512 C:\VSI3\RecTrac\Data\LIVE\RecTrac_13.d7 f 1024000
d "RT BLOBII":13,1;512 C:\VSI3\RecTrac\Data\LIVE\RecTrac_13.d8 f 1024000
d "RT BLOBII":13,1;512 C:\VSI3\RecTrac\Data\LIVE\RecTrac_13.d9 - Save the add.st file with the new changes.
- In Windows, open Proenv in C:\ProgramData\Microsoft\Windows\Start Menu\Programs\OpenEdge 11.7\ as an administrator by right-clicking on it and selecting "Run as administrator"
- Type the following proenv> prostrct addonline <path to database> <path to add.st> and press <Enter> on your keyboard. (Example: prostrct addonline X:\VSI3\RecTrac\Data\LIVE\RecTrac X:\VSI3\RecTrac\Data\LIVE\add.st)
- Once complete, run the following command in the PROenv session: proenv>prostrct list <path to database> (For example: prostrct list X:\VSI3\RecTrac\Data\LIVE\RecTrac). This will generate a new rectrac.st file that has the new extents added
- Exit ProEnv by typing exit at the Prompt
- Review the newly created rectrac.st file in X:\VSI3\RecTrac\Data\LIVE\ and confirm the new extents are listed.