0 Replies Latest reply on Sep 9, 2008 9:04 PM by user Java

    Portal Installation/settings for DB2 (with a specific schema

    user Java Newbie

      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.