How can I see what repotools -createTables is going to create?
One answer
There is a logger in log4j.properties for each application, e.g., in server/conf/jts/log4j.properties:
# Turn on debugging of all SQL queries
#log4j.logger.sqlTxLogger=DEBUG
If you enable that logger, then all the SQL executed by repotools will get logged (to the createTables log file that gets generated). So, you can install CLM and your database on a test machine and run repotools -createTables against a test database with logging enabled to see the SQL being executed. Just be sure not to enable this in production as it would log excessively when the server is running.
This is a way to see what will happen, but it is not sufficient to *only* run the SQL commands; repotools must be run on any new database to set up bootstrapping data. In other words, running repotools will show the DDL that will be used but the DDL cannot be used itself to create the new database.
Martha (Ruby) Andrews
Jazz L3 Developer
Comments
It is also possible to use IBM Data Studio to export the DDL, which may be wa bit more readable than the repotools tracing.
The IBM Data Studio full client is an Eclipse-based component of the IBM Data Studio product that provides an integrated development environment for database administration and application development. You can use the client to perform database administration tasks, including query analysis and tuning, and you can create, deploy, and debug database applications.
Once you install the data studio, you define a database connection within the data studio (machine, port, id, password, and so on). Then you can "Connect" to the data base and there is a right mouse button option to "Generate DDL"
One more note:
The names in the DDL are not fixed. For example, you could have a different DB name.
And one more note:
This tech note explains how to turn on tracing with repotools:
http://www-01.ibm.com/support/docview.wss?uid=swg21322003