Home

Create databases with the database wizard

 

+

Search Tips   |   Advanced Search

 

Overview

Use the database wizard to create databases for the Lotus Connections features that you plan to install.

Before using the wizard for the first time, complete the steps described in the Prepare the database wizard topic.

When you are creating a database either with the database wizard or SQL scripts, log into the system where the database is hosted with the database administrator account.

The default values for DB2...

db2admin	Windows
db2inst1	Linux and AIX

The default values for Oracle...

system administrator	Windows
oracle	Linux and AIX

For SQL Server, the default value is the system administrator

Oracle and SQL Server connect to LC databases with the user accounts that are set up during database creation.

If you are creating a DB2 database...

• Manually create the lcuser account
• Run appGrants.sql to grant the appropriate privileges to the lcuser account.

You can use the LC database wizard to create, update, and remove databases.

You can review the scripts that the wizard executes by looking in connections.sql in the installation media.

• For DB2, the commands are shown in the log that the wizard creates.
• For Oracle and SQL Server, the log shows the results of the commands.

Create databases with the wizard

1. From the LC wizards directory, launch the wizard...
   ./dbWizard.sh

2. On the Welcome page, click...
   Launch Information Center | Next | Create a database | Next

3. Enter the details of the database you wish to create and then click Next:
   • Database type.
   • Location of the database.
   • Specify a database instance.

   The database instance that you specify must already exist on your system. For DB2, a default instance called db2inst1 is created during installation.

4. Select a feature and click Next.

   If you are creating databases, only features that have not already been installed to a database instance are available. If you are updating databases, you can only choose features that are already installed.

5. For Oracle or SQL Server, enter the password for the databases and then click Next.

   Choose one of the following options:

   • Use the Same password for all feature database users.

     Type the password in the Password and Confirm password fields.

   • Use a Different password for each feature database user.

     Type a different password for each feature database, and confirm the password in the confirm field.

6. For SQL Server only, you can specify the location of the database file and then click Next.

   • To use the same database file location for all features, select...
     Same database file location

     Type the location of the database or click Browse to choose a location.

   • To use a different database file location for each feature, select...
     Different database file location

     For each feature, type the location of the database file or click Browse to choose a location.

7. On the panel...
   Pre Configuration Task Summary

   ..ensure that the values entered correct. Click Back to edit values. Click Create to begin creating databases.

8. Review the panel...
   Post Configuration Task Summary panel

   ..and, if necessary, click...

   View Log

   ..to open the log file. Click Finish to exit the wizard.

 

Related tasks

Create databases with the database wizard
Prepare the database wizard
Create a dedicated DB2 user
Create databases with SQL scripts