InterPlay 2.3.0 Installation Guide Add entire publication Select collection Cancel Create a New Collection Set as my default collection Cancel This topic and sub-topics have been added to MyDocs. Ok No Collection has been selected. --> Database-related silent file parameters You can define the parameters related to database connections and other specific information. For example, indexes, tablespace names, SIDs for Oracle databases and other database-specific information. Some of the most important parameters are listed in the table. Parameter Description Additional comments DB_TYPE The type of database used Possible values (depending on the actual product, of course): Oracle12, MySql5, Internal DB_URL_TYPE The type of the URL used to connect to the database To connect to the database, a certain URL address must be created/formed; if the value of this variable is BasicURL, then the credentials specified in the silent file (see below the other variables) are used to automatically create this URL; else, if the value is CustomURL, then the silent file must contain a variable named CustomURL having the value set to the string representing the custom URL DB_URL_TYPE.Default Default value CHECK_INFORMATION Whether to check the database credentials or not For example, one silent file could choose not to execute the database scripts (see the DB_SCRIPTS variable below), and still check the connection to the database, if it’s valid; possible values: true or false CHECK_INFORMATION.Default Default value DB_NAME Database name DB_NAME.Default Default value DB_HOST Database host DB_HOST.Default Default value DB_PORT Database port used by the product to connect to the database DB_PORT.Default Default value DB_ADMIN_LOGIN Username (with admin privileges) used by the product to connect to the database (to run scripts, etc.) DB_ADMIN_LOGIN.Default Default value DB_ADMIN_PASSWORD Password used by the product to connect to the database (to run scripts, etc.) DB_ADMIN_PASSWORD.Default Default value DB_ADMIN_PASSWORD.Format Password encryption algorithm Example: AES128 DB_USER Username used by the product to connect to the database (to run scripts, etc.) Generally used when selecting a database DB_USER.Default Default value DB_PWD Password used by the product to connect to the database (to run scripts, etc.) Generally used when selecting a database DB_PWD.Format Password encryption algorithm used Example: AES128 DB_SCRIPTS Whether to also execute the database scripts or only to generate them Possible values are: ONLY_COPY (only generates the database scripts) , COPY_LAUNCH (generates and executes the database scripts) DB_SCRIPTS.Default Default value XD_DATA_WORK, XD_INDEX_WORK, XD_LOB_WORK Various tablespace names… XD_DATA_WORK.Default, XD_INDEX_WORK.Default, XD_LOB_WORK.Default … and their default values Related Links
Database-related silent file parameters You can define the parameters related to database connections and other specific information. For example, indexes, tablespace names, SIDs for Oracle databases and other database-specific information. Some of the most important parameters are listed in the table. Parameter Description Additional comments DB_TYPE The type of database used Possible values (depending on the actual product, of course): Oracle12, MySql5, Internal DB_URL_TYPE The type of the URL used to connect to the database To connect to the database, a certain URL address must be created/formed; if the value of this variable is BasicURL, then the credentials specified in the silent file (see below the other variables) are used to automatically create this URL; else, if the value is CustomURL, then the silent file must contain a variable named CustomURL having the value set to the string representing the custom URL DB_URL_TYPE.Default Default value CHECK_INFORMATION Whether to check the database credentials or not For example, one silent file could choose not to execute the database scripts (see the DB_SCRIPTS variable below), and still check the connection to the database, if it’s valid; possible values: true or false CHECK_INFORMATION.Default Default value DB_NAME Database name DB_NAME.Default Default value DB_HOST Database host DB_HOST.Default Default value DB_PORT Database port used by the product to connect to the database DB_PORT.Default Default value DB_ADMIN_LOGIN Username (with admin privileges) used by the product to connect to the database (to run scripts, etc.) DB_ADMIN_LOGIN.Default Default value DB_ADMIN_PASSWORD Password used by the product to connect to the database (to run scripts, etc.) DB_ADMIN_PASSWORD.Default Default value DB_ADMIN_PASSWORD.Format Password encryption algorithm Example: AES128 DB_USER Username used by the product to connect to the database (to run scripts, etc.) Generally used when selecting a database DB_USER.Default Default value DB_PWD Password used by the product to connect to the database (to run scripts, etc.) Generally used when selecting a database DB_PWD.Format Password encryption algorithm used Example: AES128 DB_SCRIPTS Whether to also execute the database scripts or only to generate them Possible values are: ONLY_COPY (only generates the database scripts) , COPY_LAUNCH (generates and executes the database scripts) DB_SCRIPTS.Default Default value XD_DATA_WORK, XD_INDEX_WORK, XD_LOB_WORK Various tablespace names… XD_DATA_WORK.Default, XD_INDEX_WORK.Default, XD_LOB_WORK.Default … and their default values