IBM Business Process Manager, V8.0.1, All platforms > Install and configure IBM Business Process Manager > IBM Business Process Manager Advanced > Install and configure IBM Business Process Manager Advanced > On AIX > Network deployment environment > Creating databases and database design files > For DB2 > Creating database design files
Troubleshooting the database design tool
If you have errors in your database scripts, you can use the diagnostic and validation information provided by the database design tool to diagnose the problems.
Required property is empty errors
When the required userName and password properties are not set, you might see messages of the following type in the output:
[status] WBI_BSPACE is not complete with 2 remaining item(s): [ 1 ] BSpace.WBI_BSPACE : authAlias : required property 'userName' for userId is empty. [ 2 ] BSpace.WBI_BSPACE : authAlias : required property 'password' for DB_PASSWORD is empty.Sample output of running a validation of the existing database design
When you run a validation of the existing database design, you might see warnings of the following type in the output:
DbDesignGenerator.bat -v DB2-distributed- ... [WARNING] 2 potential problems are found in the scripts. They are DB_USER @ line 46 in file configCommonDB.bat DB_USER @ line 80 in file configCommonDB.shContents of the database design tool log file
When you run the database design tool, a dbDesignGenerator.log file is created in the location from which the database design tool command is run. The log contains all the prompts and values entered. The log file does not contain any additional trace output.
Parent topic: Creating database design files for DB2