Kbase P80185: What is the easiest way to set up a database that is OS copied into a directory that has a space(s)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/14/2004 |
|
Status: Unverified
GOAL:
What is the easiest way to set up a database that is OS copied into a directory that has a space(s) in the directory name.
GOAL:
How to avoid error(6830) "Fixed length flag incorrect" when running prostrct repair on a database copied into a directory with a space(s) in its name.
GOAL:
How to avoid error(6822) "Area information is only valid for data extents." when running prostrct repair on a database copied into a directory with a space(s) in its name.
GOAL:
How to avoid errors (6830) and (6822) when running prostrct repair on a database copied by the OS into the Program Files directory.
FACT(s) (Environment):
Windows 32 Intel
FACT(s) (Environment):
Progress 9.x
FIX:
Following the procedure below is one way to allow the running of prostrct repair, without error, if the database has been copied into a directory that has spaces.
1. Copy the database to the Program Files directory.
2. Modify the current .st file so it has relative paths.
Original paths in andy.st file:
#
b C:\wrk91d\andy.b1
#
d "Schema Area":6,32 C:\wrk91d\andy.d1
#
d "Info Area":7,32 C:\wrk91d\andy_7.d1
#
d "Order Area":8,32 C:\wrk91d\andy_8.d1
Change to relative paths:
#
b .\andy.b1
#
d "Schema Area":6,32 .\andy.d1
#
d "Info Area":7,32 .\andy_7.d1
#
d "Order Area":8,32 .\andy_8.d1
3. Run prostrct repair dbname dbname.st
4. Run prostrct list andy.st.
Paths in the new andy.st file:
#
b !"C:\Program Files\db2\andy.b1"
#
d "Schema Area":6,32 !"C:\Program Files\db2\andy.d1"
#
d "Info Area":7,32 !"C:\Program Files\db2\andy_7.d1"
#
d "Order Area":8,32 !"C:\Program Files\db2\andy_8.d1"
The newly configured database can be added to progress explorer (don't use quotes or progra~1 in the path as you configure the database in progress explorer).
The database can be started and stopped with progress explorer or with the command line utility dbman.
Client connections will require double quotes around the full path to the database unless run from within the directory in which the database reside, i.e. <path to executable> "C:\Program Files\db2\andy".