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.
1 reply Latest Post - 2012-11-16T10:05:37Z by SystemAdmin
Pinned topic Database DDL Scripts
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-11-16T10:05:37Z at 2012-11-16T10:05:37Z by SystemAdmin
SystemAdmin 110000D4XK340 PostsACCEPTED ANSWER
Re: Database DDL Scripts2012-11-16T10:05:37Z in response to SystemAdminHi,
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.