Here are notes on using DB2 (Version 8.1).
The type specified by Wagby is handled as follows in the database.
|String type (text area)||varchar(4000)|
|Date Time Type||timestamp|
|File type (file name)||varchar(255)|
|1 byte integer||smallint|
|2 byte integer||smallint|
|4 byte integer||integer|
|8 byte integer||bigint|
|4 byte floating point number||float|
|8 byte floating point number||double|
|Fixed value (creation date / update date)||timestamp|
|Other (URL type / mail address type etc.)||varchar(255)|
If you have to change the "table space page size" in DB2, you may be able to solve the problem by reviewing the definition of each item in the model before changing the page size.
Specifically, we refer to the DDL statement (create table statement) for DB2 that Wagby automatically generated.For example, in the case of a string type item, 255 characters are reserved on DDL automatically generated by Wagby.By fine-tuning this size, there is a possibility that you can suppress changing the page size.
For details, refer to "Repository> Definition of model item> Database detailsPlease read.
In addition, it is not possible to change the table space, page size, itself from Wagby.Follow the DB2 documentation.
There is an item that uses the text area in the system model defined internally in Wagby, but this may affect and an error may occur when creating the table when using DB2.In this case, it can be solved by setting the item length in the type of the text area.For example varchar (2000).