When installing ILMT 7.5 how do the tables get created once the database is built. Where do the DDLs for creating the database reside. Does the database gets populated when the ILMT server is installed.
This topic has been locked.
Pinned topic Database DDL Scripts
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
SystemAdmin 110000D4XK340 Posts
Re: Database DDL Scripts2012-11-16T10:05:37ZThis is the accepted answer. This is the accepted answer.Hi,
The database creation scripts are being unpacked and launched from '<LMT-dir>/admin/db' directory, e.g. '/opt/IBM/LMT/admin/db':
* <LMT-dir>/admin/db - common sqls and bat/sh scripts
* <LMT-dir>/admin/db/db2 - new database creation + db population with initial database scripts
* <LMT-dir>/admin/db/migration - database migration scripts from some old to current version used in case of tool upgrade
The database is populated when the LMT database component is installed - when only the 'install administration server' option
was used then TLMA database will not be created and populated with the initial data.
The postings on this site are my own and don't necessarily represent IBM's positions, strategies or opinions.