Recreating database tables from the exported table data definition language

When the WAS deployment tooling deploys an EJB jar file containing container-managed persistence (CMP) enterprise beans, it selects the target database and creates a corresponding Table.ddl file. This file contains the SQL statement necessary to generate the database table for the CMP beans.

The following steps demonstrate the process for creating tables in DB2.

 

1. Extract the Table.ddl file from the CMP enterprise bean JAR file and save it on the database server.

   • Save the file to a working directory, such as C:\temp, on the DB2 machine.

2. Run the Table.ddl file.

   • Run the command C:\temp>db2cmd, replacing C:\temp with your chosen directory. A DB2 command window is displayed, in which you enter the following commands (replacing C:\temp with the chosen directory):

     1. C:\temp>db2 connect to my_db_name

     2. C:\temp>db2 -tf Table.ddl //This command runs and creates tables for the CMP enterprise bean.

     3. C:\temp>db2 disconnect all
     
     [AIX] [HP-UX] [Solaris]

     If we run DB2 on supported UNIX systems, use these same commands. Run them from a user with permissions for DB2, rather than from a DB2 command window.

 

Results

The database tables are created.