I noticed that with DB2, Wildfire fails to run the SQL scripts for all plugins. I traced the problem to the executeSQLScript method in SchemaManager.java. DB2 throws an error for the statements that end with a semicolon. There is already code to remove the semicolon for an oracle database, the fix was to also do this for db2.
if (DbConnectionManager.getDatabaseType() == DbConnectionManager.DatabaseType.oracle || DbConnectionManager.getDatabaseType() == DbConnectionManager.DatabaseType.db2) {
command.deleteCharAt(command.length() - 1);
}