Kbase P122500: How to create a TEMP-DB Database?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/5/2007 |
|
Status: Unverified
GOAL:
How to create a TEMP-DB Database?
GOAL:
Creating a TEMP-DB
FIX:
The TEMP-DB database has a control table, temp-db-ctrl, that associates temp-table definitions and their include files. When the TEMP-DB Maintenance tool is launched for the first time with the TEMP-DB database, the system adds the control table to the database schema. The tool maintains the TEMP-DB schema and control table from that point.
Caution: Never use the Data Dictionary to maintain the TEMP-DB database. The new tool works by synchronizing the contents of include files with the database. If the Data Dictionary is used to modify the TEMP-DB database, the databases contents will not match up with the source files.
To create a TEMP-DB database:
1. Start the Data Administration tool.
2. Choose Database Create. The Create Database dialog box appears.
3. Type TEMP-DB for the New Physical Database Name. By default, the database is created in the working directory.
4. Select An EMPTY Database from the Start with radio set.
5. Click OK to create the database. The Connect Database dialog box appears.
6. Click Cancel and close the Data Administration tool.
The TEMP-DB database is just an empty database now. The TEMP-DB Maintenance tool checks that the TEMP-DB database has the appropriate control table in the schema when the too is Launchedl. If the control table is not present, the tool can apply the schema.