Create a database structure extent

Use the PROSTRCT CREATE utility to create the physical database files for the database. The PROSTRCT CREATE syntax is:

prostrct create db-name [structure-description-file]
   [-blocksize blocksize]                        
   [-validate]

In the syntax block, structure-description-file represents the name of the .st file. If you do not specify the name of the .st file, PROSTRCT uses db-name.st.

The -blocksize parameter represents the database block-size in bytes or kilobytes (KB). For example, to create databases of block-size:
  • 4KB—Specify -blocksize 4096 or -blocksize 4.
  • 8KB—Specify -blocksize 8192 or -blocksize 8.
CAUTION: An incorrect input value for the -blocksize parameter results in the following error, which causes the database creation operation to fail:
Invalid -blocksize value entered. Please use 4 or 4096 for 4KB blocksize; and 8 or
8192 for 8KB blocksize. (20967)

For more information on PROSTRCT CREATE, see PROSTRCT CREATE qualifier.

If you specify -validate, PROSTRCT will check that the contents of your structure description file are accurate without creating the database.

To create a database named sports2020 from the sports2020.st structure description file using PROSTRCT CREATE:

  1. First verify that your structure description file is accurate.

    Use the -validate option to PROSTRCT CREATE as follows:

     prostrct create sports2020 sports2020.st -blocksize 4096 -validate

    If there are no errors in your structure description file, PROSTRCT returns a status similar to the following:

    The structure file format is valid. (12619)
Device: /usr1/dbs/, KBytes needed: 3488, KBytes available: 483876225 
(12616)
There is sufficient free space to initialize the defined extents. (12618)
  2. Second, create the database.
    Use the PROSTRCT CREATE command as follows: 
    prostrct create sports2020 sports2020.st -blocksize 4096