MicroStrategy ONE

Creating Metadata, History List, and Statistics Tables

Creating Metadata, History List, and Statistics tables

If you selected option 1 in Creating a response.ini File, you can create metadata tables, History List tables, and statistics tables.

Creating Metadata Tables

If metadata tables already exist in the location you plan to store your metadata tables in and you do not want to overwrite the current metadata tables, you should use the option described below.

This procedure assumes you have already opened the Configuration Wizard in command line mode and selected to create metadata and statistics tables, as described in Creating a response.ini File.

To Create Metadata Tables

  1. In the prompt asking whether to create metadata tables, type Y and click Enter. You are then prompted for ODBC data source information.
  2. Type the number corresponding to the ODBC DSN for the database to store your metadata tables and click Enter.

    If you do not have a DSN defined on your Linux machine, see Creating a DSN for a Data Source.

  3. If the Configuration Wizard detects an existing metadata repository in the database location you specified, a message is displayed on whether to re-create the metadata tables. If you type Y and press Enter, all information in the existing metadata repository is overwritten when the response file is executed at a later time.
  4. Enter a login and password to your DSN and click Enter.
  5. Enter characters to use as a prefix for the names of your metadata tables or use no prefix and click Enter.

    The next steps depend on your ODBC data source details.

    To Configure DB2 MVS Database Options

  6. Enter the database name to use or use the default name and click Enter.
  7. Enter characters to use as a table space name for your metadata tables or use the default table space name and click Enter.

    To Select a Metadata Script

  8. Select the script used to create the metadata tables or use the default script and click Enter
  9. Type Y and click Enter to create History List tables.
  10. Type N and click Enter to skip History List table creation.
  11. Type Y and click Enter to create statistics tables.
  12. Type N and click Enter to skip statistics tables creation.
  13. By default, the configuration is saved as Response.ini in the /HOME_PATH/ directory, where HOME_PATH is the directory you specified as the Home Directory during installation. You can leave the field blank to use the default name or type a different name, and then click Enter. The response.ini file is generated, and you are prompted whether to run the configuration immediately.
  14. Type Y and click Enter.
  15. Type N and click Enter to quit without running the configuration.

Creating History List Tables

This procedure assumes you have already opened the Configuration Wizard in command line mode and selected to create metadata, History List, and statistics tables, as described in Creating a response.ini File.

  1. After you create metadata tables (see To Create Metadata Tables) or skip the creation of metadata tables, you are prompted to create History List tables.

    To create History List tables, type Y and click Enter.

  2. You can supply ODBC DSN information in various ways described below, which depend on whether you previously created metadata tables as part of the configuration process:
    • If you did not create metadata tables as part of the configuration process, you are prompted to enter ODBC DSN information. The steps to enter this information is described in the To Provide ODBC DSN Information section within this procedure.
    • If you created metadata tables as part of the configuration process, you are prompted whether to use the same metadata table ODBC DSN information for your History List tables. You have the following options:
      • Type Y and click Enter to create History List tables with the same ODBC DSN information entered for your metadata tables. You are then prompted to select a History List script to create the History List tables, which is described in the To Select a History List Script section within this procedure.
      • Type N and click Enter to provide different ODBC DSN information, which is described in the To Provide ODBC DSN Information section within this procedure.

To Provide ODBC DSN Information

  1. Type the number corresponding to the ODBC DSN for a database to create your History List tables in, and then click Enter.

    If you do not have a DSN defined on your Linux machine, see Creating a DSN for a Data Source.

  2. Depending on your database type, you may be prompted to provide a login and password to your DSN:
    • Type a login name for your database to create your History List tables in and click Enter.
    • Type a password for the login name provided and click Enter.
  3. The next configuration displayed depends on your ODBC data source details:
    • If the data source points to a DB2 MVS database, steps to configure a DB2 MVS database are displayed. These are described in the To Configure DB2 MVS Database Options section within this procedure.
    • If the data source does not point to a DB2 MVS database, the step to select a statistics script to create statistics tables is displayed. This step is described in the To Select a History List Script section within this procedure.

To Configure DB2 MVS Database Options

  1. You can enter the database name to use or use the default name, as described below:
    • Type the database name to use and click Enter.
    • Leave the prompt blank and click Enter to use the default database.

    You are then prompted to provide the MVS table space name.

  2. You can enter characters to use as a table space name for your metadata tables or use the default table space name, as described below:
    • Type the required table space name characters and click Enter.
    • Leave the prompt blank and click Enter to use the default table space name.

    You are then prompted to select a statistics script to create statistics tables.

To Select a History List Script

You can select the script used to create the History List tables or use the default script, as described below:

  • Enter a valid path to a script file and click Enter.
  • Leave the field blank and click Enter to use the default script for your database type.

To Create Statistics Tables

  • Type Y and click Enter to create statistics tables. Creating statistics tables is described in Creating Statistics Tables.
  • Type N and click Enter to skip statistics tables creation. You are then prompted to provide a name for the response.ini file, as described in the To Generate a response.ini File section within this procedure.

To Generate a response.ini File

  1. By default, the configuration is saved as Response.ini in the /HOME_PATH/ directory, where HOME_PATH is the directory you specified as the Home Directory during installation. You can leave the field blank to use the default name or type a different name and click Enter. The response.ini file is generated, and you are prompted whether to run the configuration immediately.
  2. You can choose to run the configuration you just completed or to run the configuration using the response.ini file at a different time, as described below:

Creating Statistics Tables

This procedure assumes you have already opened the Configuration Wizard in command line mode and selected to create metadata, History List, and statistics tables, as described in Creating a response.ini File.

To Create Statistics Tables

  1. After you create metadata tables (see To Create Metadata Tables), create History List tables (Creating History List Tables), or skip both of these procedures, you are prompted to create statistics tables.

    To create statistics tables, type Y and click Enter.

  2. You can supply ODBC DSN information in various ways described below, which depend on whether you previously created metadata tables as part of the configuration process:
    • If you did not create metadata tables as part of the configuration process, you are prompted to enter ODBC DSN information. The steps to enter this information is described in the To Provide ODBC DSN Information section within this procedure.
    • If you created metadata tables as part of the configuration process, you are prompted whether to use the same metadata table ODBC DSN information for your statistics tables. You have the following options:
      • Type Y and click Enter to create statistics tables with the same ODBC DSN information entered for your metadata tables. You are then prompted to select a statistics script to create the statistics tables, which is described in the To Select a Statistics Script section within this procedure.
      • Type N and click Enter to provide different ODBC DSN information, which is described in the To Provide ODBC DSN Information section within this procedure.

To Provide ODBC DSN Information

  1. Type a valid ODBC DSN for a database to create your statistics tables in and click Enter. You are then prompted to provide a login to your DSN.
  2. Type a login name for your database to create your statistics tables in and click Enter. You are then prompted to provide a password for the login name.
  3. Type a password for the login name provided and click Enter.

    The next configuration displayed depends on your ODBC data source details:

    • If the data source points to a DB2 MVS database, steps to configure a DB2 MVS database are displayed. These are described in the To Configure DB2 MVS Database Options section within this procedure.
    • If the data source does not point to a DB2 MVS database, the step to select a statistics script to create statistics tables is displayed. This step is described in the To Select a Statistics Script section within this procedure.

To Configure DB2 MVS Database Options

  1. You can enter the database name to use or use the default name, as described below:
    • Type the database name to use and click Enter.
    • Leave the prompt blank and click Enter to use the default database.

    You are then prompted to provide the MVS table space name.

  2. You can enter characters to use as a table space name for your metadata tables or use the default table space name, as described below:
    • Type the required table space name characters and click Enter.
    • Leave the prompt blank and click Enter to use the default table space name.

    You are then prompted to select a statistics script to create statistics tables.

To Select a Statistics Script

You can select the script used to create the statistics tables or use the default script, as described below:

  • Enter a valid path to a script file and click Enter.
  • Leave the field blank and click Enter to use the default script for your database type.

You are then prompted to provide a name for the response.ini file.

To Generate a response.ini File

  1. By default, the configuration is saved as Response.ini in the /HOME_PATH/ directory, where HOME_PATH is the directory you specified as the Home Directory during installation. You can leave the field blank to use the default name or type a different name and click Enter. The response.ini file is generated, and you are prompted whether to run the configuration immediately.
  2. You can choose to run the configuration you just completed or to run the configuration using the response.ini file at a different time, as described below: