Topic
  • 1 reply
  • Latest Post - ‏2012-11-16T10:05:37Z by SystemAdmin
SystemAdmin
SystemAdmin
340 Posts

Pinned topic Database DDL Scripts

‏2012-11-09T19:35:09Z |
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.

Thanks
Bharan B
Updated on 2012-11-16T10:05:37Z at 2012-11-16T10:05:37Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    340 Posts

    Re: Database DDL Scripts

    ‏2012-11-16T10:05:37Z  
    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.

    Best regards,
    Dariusz Glocki

    The postings on this site are my own and don't necessarily represent IBM's positions, strategies or opinions.