Home

 

Prepare the database wizard

 

+

Search Tips   |   Advanced Search

 

Before you can use the wizard to create databases, create a dedicated DB2 database user named lcuser.

Ensure that you have given the necessary permissions to the user IDs that need to log into the database system and access the Lotus Connections Wizards

If you are planning to create multiple database instances, prepare and run the database wizard once for each instance.

For AIX, if you are downloading the wizard, the TAR program available by default with AIX does not handle path lengths longer than 100 characters. To overcome this restriction, use the GNU file archiving program instead. This program is an open source package that IBM distributes through the AIX Toolbox for Linux Applications at the IBM AIX Toolbox web site. Download and install the GNU-compatible TAR package. You do not need to install the RPM Package Manager because it is provided with AIX.

After installing the GNU-compatible TAR program, extract the wizard files...

gtar -xvf <Lotus_Connections_wizard>_aix.tar

To prepare the database wizard...

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

2. Copy the database wizard from Wizards directory in the LC installation media to the system that hosts the database server.

   For Linux and AIX, ensure that users other than root have permission to access the Lotus Connections Wizards

3. Configure X windows for GUI displays...

   Note, instead of the following procedure, you can use putty with a Mocha X server.

   1. For Linux and AIX, as root, grant display authority to all users...

      xhost +

      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.

      echo $DISPLAY

   2. For Linux and AIX, make sure that the current user is qualified or else switch to a qualified user...

      • DB2

        // db2inst1 is the default DB2 administrator
        su - db2inst1
        export DISPLAY=<hostname:displaynumber.screennumber>

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

        localhost:0.0

        Run...

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

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

      • Oracle

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

        // oracle is the Oracle database administrator
        su - oracle
        export DISPLAY=<hostname:displaynumber.screennumber>
        //Display the clock, confirming that the current user has display authority and can run the wizard
        xclock

        // 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

      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

   Run database commands as user with administrative access to the database.

   • AIX or Linux:

     • DB2

       cd /opt/ibm/db2/V9.1/instance
       ./db2istrt

     • Oracle

       Login as oracle or run su oracle

       export ORACLE_SID=orcl
       export ORACLE_HOME=/home/oracle/oracle/product/10.2.0/db_1
       cd
       $ORACLE_HOME/bin
       ./sqlplus "/ as sysdba"
       startup

   • Microsoft Windows

     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 shortcut menu, click Start to start the database manager.

     • Oracle

       1. Open the Windows Services panel...
          Start | All Programs | Administrative Tools | Services

       2. Right-click the Oracle service.

       3. From the context 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.

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

 

Related tasks

Create databases with the database wizard
Using the database wizard
Create a dedicated DB2 user