Trace: • Using DB2 on IBM i (AS/400)
We support most operations of DB2 on IBM i series but it depends on your configuration. If you don't use journaling, it's not possible to update/delete records. If you work with journaling it's not possible to drop or alter columns. But this shouldn't be a big deal for developers.
We introduced additional configuration parameters:
jdbc:as400://pub400.com/SIB2;sqlObjectsOnly=true;currentSchemaOnly=true;
or
jdbc:as400://pub400.com/SIB2;sqlObjectsOnly;currentSchemaOnly;
Both parameters can impact performance and speed up access.
sqlObjectsOnly
Only tables, views, and aliases created with SQL (types T, V, A) will be displayed. By default, this is set to false, meaning that types P = Physical File (PF) and L = Logical File (LF) will also be shown.
currentSchemaOnly
Only the current schema is visible. By default, this is set to false, meaning all objects from all schemas you have access rights to will be displayed.