Progress
Database Administration
Guide and Reference
PROSTRCT CREATE Qualifier
Creates a void Progress database from a previously defined structure description (ST) file. The newly created database does not contain any Progress metaschema information. Rather, it consists of the database control (DB) area and whatever primary recovery (BI), after-image (AI), two-phase commit transaction log (TL), and application data (Dn) areas you defined in the ST file.
After you create a void database, you must add metaschema information. Therefore, Progress provides empty databases each the size of a supported database block size. The empty database and the database you want to copy it to must have the same block size.
NOTE: Never use operating system file commands to copy a Progress Version 9 database. Instead, use the PROCOPY or PRODB utilities.SYNTAX
db-name
Specifies the Progress database you want to create.
structure-description-file
Specifies the structure description (ST) file you want Progress to access for file information.
-blocksize
Specifies the Progress database block size in bytes (for example
-blocksize 1024
). The maximum number of indexes allowed in a database is based on the database blocksize. For more information of database limits, see Progress Database Limits."NOTES
- The default structure description (ST) file is
db-name.st.
If you have a structure description file that has the same name as the database you are creating, you do not have to specify the structure-description-file. Progress automatically creates the database from the structure description file that has the same name as your database with the extension .st.- You cannot create a Progress database if one already exists with the same name.
- If you use the -
blocksize
parameter, you must place it as the last parameter on the command line.- The PROSTRCT CREATE utility allows you to specify the minimum amount of information necessary to create a database. You must specify the area type and extent location. If the extent is fixed length, you must also specify the size. You need not provide specific filename or file extensions. The utility will generate filename and file extensions for all database files according to the following naming convention:
- If the pathname is for a raw device, the name is taken as-is, with no changes.
- If a relative pathname is provided, including using common “.” (dot) notation, the relative pathname will be expanded to an absolute pathname.
- For BI extents, the filename is the database name with a .bn extension, where n represents the number of extents created.
- For AI extents, the filename is the database name with a .an extension, where n represents the logical order in which the AI areas will be accessed during normal processing.
- For TL extents, the filename is the database name, with a .tl extension.
- For Schema area extents, the filename is the database name with a .dn extension, where n represents the order extents were created and will be used.
- For application data extents, the filename is the database name and an area number. The area number is a unique identifier set by Progress to differentiate between different areas. User extent filenames also have a .dn extension, where n represents the order extents were created and will be used.
- See "Maintaining Database Structure," for more information about the CREATE qualifier with the PROSTRCT utility.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |