This section contains the specific database parameters for the IBM DB2 DBMS (v5.0 and later): disk drive, backup directory, etc.
If using the section in the Java version of the database management tool, only the "General settings" section below applies.
[DB2]
database_drive = C
database_comment = Base DB2
…
Parameter |
Type |
Mandat. |
Default |
Description |
General settings |
||||
UserUtil |
string |
no |
Used to impose a default connection profile if the profile is not specified in the tool's settings. |
|
PasswordUtil |
string |
no |
Used to impose the default user profile password. |
|
GrantedErrors |
string |
no |
List of SQL error codes (in an absolute value, i.e. unsigned), separated by commas. The listed error codes are ignored when interpreting a SQL script and do not stop processing. |
|
| GrantedSQLStates | string | no | List of SQLSTATE error codes, separated by commas. The listed error codes are ignored when interpreting a SQL script and do not stop processing. This parameter acts as a complement to the "GrantedErrors" parameter for DBMSs that do not return SQLCODE codes. |
|
Creation |
||||
database_unit |
string |
no |
C |
Database unit. |
database_comment |
string |
no |
Database comment. |
|
CfgScript |
string |
no |
Name of the database configuration script. This script is executed after the base is created, but before the files (PDM) are created. This script can contain SQL commands and escape sequences. A typical application might be a user creation script for Oracle or SQL Server bases. |
|
Backup |
||||
backup_directory |
string |
no |
Backup directory. |
|
Restoration |
||||
database_unit |
char. |
no |
depends on the context |
Database unit (in the case of creations from a backup copy). |
backup_directory |
string |
no |
Backup directory. |
|
orig_database |
string |
no |
Name of the origin database. |
|
timestamp |
string |
no |
Backup timestamp (mandatory with several backup images). |
|
force_overwrite |
bool |
no |
0 |
Overwrites an existing database without confirmation. |