Managing the database connection

This topic provides an overview of database connection management tasks.

The installer for 

sets up all necessary database connections. After the installation, you might want to troubleshoot existing database connections and verify that connections are working properly. You also might want to create, add, modify or remove data sources. For information about how to perform these tasks, see the "Administration" and "Data Management" sections in the IBM Cognos Administration and Security Guide (Cognos documentation is available from the Help menu; for instructions on accessing it, see Additional-IBM-Cognos-documentation).

Changing the BMC Server Automation database connection parameters

If you need to reset the password connection for the 

database credentials (for example, if you want to change the BMC Server Automation database), use the following instructions.

Some of the scripts used in these instructions are included in the BDSSA82-servicepackVersion-external-files.zip file. If you have not already done so, download the scripts from the BDSSA82-servicepackVersion-external-files.zip file into a directory. If you extract the entire contents of the file, the scripts are copied into the /BSARA/Db_Scripts/sqlserver/schema and /BSARA/Db_Scripts/oracle/schema directories below the specified directory.

To change the BMC Server Automation database password connection parameters

1. Drop the current database link using the appropriate instructions for your database type.

   • For Oracle databases, use the following script:

     drop database link <databaseName>
   • For Microsoft SQL Server databases, log on to SQL Server Management Studio, navigate to Server Objects/Linked Severs, right-click the link to be deleted, and select Delete.
2. Create a link to the new 
   Warning

   The macro unmigrated-inline-wiki-markup from Confluence is no longer available.

   database by using the appropriate script for your database type (these are the scripts from the BDSSA82-servicepackVersion-external-files.zip file described earlier in this topic).
   • For Oracle databases, complete the following steps (these steps should be performed by the 
     Warning

     The macro unmigrated-inline-wiki-markup from Confluence is no longer available.

     database user, BSARA_DW by default):
     1. Log on to SQL Plus.

     2. Run the following script:

        create database link <linkName> connect to <BMCBladeLogicDatabaseUserName> identified by <BMCBladeLogicDatabasePassword> using '<SID>';

        where,

        • <linkName> is the name of the new link.
        • <BMCBladeLogicDatabaseUserName> is the user name to log on to the 
          Warning

          The macro unmigrated-inline-wiki-markup from Confluence is no longer available.

          database.
        • <BMCBladeLogicDatabasePassword> is the password to log on to the 
          Warning

          The macro unmigrated-inline-wiki-markup from Confluence is no longer available.

          database.
        • <SID> is the system ID for the BMC Server Automation database.
   • For SQL Server databases, use the create_linked_server_for_om.sql script (for more information, see Creating-a-linked-server-for-the-BMC-Server-Automation-database).

3. Run the Report Administration Utility and from the console, run the set context command.
    Command help is available by typing set context at the console prompt. A sample command input is shown as follows:

   set context
   {{Enter options for set context Enter site name:}} *Site1*
   {{Enter linked server/database link name:}} *Site1_link*
   {{Enter database type (sqlserver \| oracle):}} *oracle*
   {{Enter database user:}} *Site1*
   {{Enter database password \[Mandatory\]:}} *sa*
   {{Accept argument for command:JDBC Connection Params For ORACLE JDBC Url (y/n):}}*n*
   {{Accept argument for command:JDBC Connection Params For ORACLE (y/n):}}*y*
   {{Enter options for set context Enter database host:}} *10.20.86.90*
   {{Enter database port:}} *1521*
   {{Enter SID:}} *qa10lx1*
   {{Database link Site1_link connection test successful Set context successfully.}}
   

   When you see a message that context was set successfully, continue to the next step.

4. Run ETL. For more information, see Running-ETL.