usage: db-scripts create-properties [-p, --properties-file <properties file>] | extract [-d, --output-directory <db script directory>] [-p, --properties-file <properties file>]
This command is used to extract database creation files from an installed system. This is useful when you want to change the Platform database type, e g from Derby to Oracle or PostgreSQL. For further information about how to change the database type, see 8.3 Changing Platform Database in the System Administrator's Guide.
create-properties
Use db-scripts create-properties to generate a properties file. For further information about the properties in this file, see 3.1.3.2 Properties for Oracle and 3.1.3.3 Properties for PostgreSQL in the Installation Instructions.
| Option | Description |
|---|---|
[-p, --properties-file <properties file> | The target path and filename for the properties file. |
Example - Creating the properties file
MZ>> db-scripts create-properties --properties-file /tmp/dbscript.prop
extract
Use db-scripts extract to extract the database creation files. The database scripts are based on the properties file.
For further information about how to use these scripts, see 8.3 Changing Platform Database in the System Administrator's Guide.
| Option | Description |
|---|---|
[-p, --properties-file <properties file> | The properties file to be used as input. |
| [-d, --output-directory <db script directory>] | The location of the database scripts to be extracted. |
Example - Extracting the create scripts
MZ>> db-scripts extract --output-directory /tmp/dbscripts \ --properties-file /tmp/dbscript.prop
Return Codes
db-scripts command: | Code | Description |
|---|---|
0 | Will be returned if the command was successful or unsuccessful. |
1 | Will be returned if the argument count is incorrect. |
| 2 | Will be returned if the properties file to be created already exists or if the specified target directory does not exist. |
| 3 | Will be returned if the specified target directory for the database scripts does not exist. |
| 4 | Will be returned if the database folder in the specified target directory for the database already exists. |