Preparing the database wizard 

Before you can use the wizard to create databases for your IBM Connections deployment, prepare the database server.


Before starting

Create a dedicated IBM DB2 database user named lcuser. For more information, see the Create a dedicated DB2 user topic.

Ensure that you have given the necessary permissions to the user IDs that need to log in to the database system and access the IBM Connections Wizards directory.

Notes:


About this task

To prepare the database wizard...


Procedure

  1. Log in to your database server as the root user or system administrator.

  2. (AIX and Linux only) Grant display authority to all users by running the following commands under the root user or system administrator:

      xhost + // Grant display authority to other users

      Note: If granting display authority to all users is a security concern for you, change the command to grant display authority to a specific user or users. For more information about this command, consult your AIX or Linux administrator guide.

      echo $DISPLAY // Echo the value of DISPLAY under the root user

  3. (AIX and Linux only) Make sure that the current user is qualified or else switch to a qualified user by running the following commands:

    • DB2

        su – db2inst1 // db2inst1 is the default DB2 administrator

        export DISPLAY=<hostname:displaynumber.screennumber>

        where <hostname:displaynumber.screennumber> represents the client system, monitor number, and window number. For example: localhost:0.0

        xclock // Display the clock, confirming that the current user has display authority and can run the wizard

        // Press Ctrl + C to close the clock and return to the command prompt

    • Oracle

        Note: Before running the database wizard, create an Oracle database instance.

        su – oracle // oracle is the Oracle database administrator

        export DISPLAY=<hostname:displaynumber.screennumber>

        xclock //Display the clock, confirming that the current user has display authority and can run the wizard

        // Press Ctrl + C to close the clock and return to the command prompt

        where <hostname:displaynumber.screennumber> represents the client system, monitor number, and window number. For example: localhost:0.0

      Note: If you can see the xclock application running after issuing the xclock command, then you have permission to run the database wizard. If you cannot see the xclock application, run the xhost + command as root user and then run the su command.

  4. Start the database instance:

      Note: Run the database commands under the user account that has administrative access to the database.

      • AIX or Linux:

        • DB2

        • Oracle (login as oracle or use the su oracle command to change to oracle)

            export ORACLE_SID=orcl // Specify the current Oracle database

            export ORACLE_HOME=/home/oracle/oracle/product/10.2.0/db_1 // Specify the Oracle home directory

            cd $ORACLE_HOME/bin

            ./sqlplus "/ as sysdba"

            startup // Start the current Oracle database

      • Microsoft™ Windows™:

          Note: Windows registers most database instances as a service. You can start or stop a database service manually if necessary.

          • DB2

            1. Log in to the Control Center.

            2. In Object View, right-click the database instance.

            3. In the menu, click Start to start the database manager.

          • Oracle

            1. Open the Windows Services panel: Click Start > All Programs > Administrative Tools > Services.

            2. Right-click the Oracle service.

            3. From the menu, click Start to start the database service.

          • SQL Server

            1. Open SQL Server Management Studio.

            2. Connect the database instance.

            3. Start the database instance from the studio.

  5. Copy the database wizard from the Wizards directory in the IBM Connections installation media to the system that hosts the database server.

      Notes:

      • If you have more instances, exit from the current instance and repeat this step for each instance.

      • (AIX and Linux only) Ensure that users other than root have permission to access the IBM Connections Wizards directory.

      • (DB2 only) For more information about working with multiple instances, see the Setting the current instance environment variables topic in the DB2 information center.


Parent topic

Create databases with the database wizard


Related tasks


Create IBM DB2 databases manually
Use the database wizard

+

Search Tips   |   Advanced Search