How to set the datasource to point to specific schema of a DB2 database to install the tables (does this work schema=XXX).
Eg:
<local-tx-datasource>
<jndi-name>PortalDS</jndi-name>
<connection-url>jdbc:db2://server:port/database;schema=XXX</connection-url>
<driver-class>com.ibm.db2.jcc.DB2Driver</driver-class>
<user-name>portal</user-name>
portalpassword
</local-tx-datasource>
2. How to set the tablespace options ? and if possible how to generate DDL before setting up the database.