Use the database wizard to create databases for the IBM® Connections applications that you plan to install.
Before you begin
Before using the wizard for the first time, you must complete the steps described in the
Preparing the database wizard for SQL topic.When you are creating a database either with the
database wizard or SQL scripts, you must log into the system where the database is hosted with the
database administrator account. For SQL Server, the default value is the system administrator.
SQL Server connects to IBM Connections
databases with the user accounts that are configured during database creation. The passwords of
those user accounts are defined later in this task.
Notes: (AIX® only) Download and install the
following packages from the AIX Toolbox
for Linux Applications webpage:
gtk2-2.10.6,
pango-1.14.5, fontconfig-2.4.2, pkg-config-0.19, libjpeg-6b, freetype2-2.3.9,
expat-2.0.1, zlib-1.2.3, xft-2.1.6, xcursor-1.1.7, glib-1.2.10, glib2-2.12.4,
atk-1.12.3, gettext-0.10.40, libpng-1.2.32, and libtiff-3.8.2
Note: Some
of these packages have dependencies on other packages. The AIX package installer alerts you
to any additional packages that might be required.
About this task
Use the IBM Connections database wizard to create,
update, and remove databases. You can review the scripts that the wizard executes by looking in
the connections.sql directory in the installation media. On SQL Server, the log
shows the results of the commands.
To create databases with the wizard, complete the following
steps:
Procedure
- From the IBM Connections Wizards directory, open the
following file to launch the wizard:
- AIX:
./dbWizard.sh
- Linux: ./dbWizard.sh
- Microsoft
Windows: dbWizard.bat
- Click Next to continue.
- Select the option to Create a database and click
Next.
- Enter the details of the database you wish to create and then click
Next:
- Select a database type.
- Select the location of the database.
- Specify a database instance.
Note: If attempting to use the actual name of the SQL Server as the database instance
(MSSQLSERVER or MSSQL11.MSSQLSERVER) yields errors,
use \ as the database instance.
- Select an application and click Next.
Notes: - If you are creating databases in this task, only applications that have not already been
installed to a database instance are available. If you are updating databases, you can only choose
applications that are already installed.
- The News and Search databases are contained in the Home page database.
- The Metrics application has some additional requirements:
- If you select the Metrics application, you must also select the IBM
Cognos® application.
- If you have already deployed Cognos components and have
a Cognos Content Store available, you do not need to create
another.
- If you do create a Cognos Content Store, only the
container is created now; the tables are created when you start the Cognos BI Server for the first time.
- You do not need a dedicated database server for Cognos
or for the Metrics application; you can host the Metrics database and the Cognos Content Store on the same database server as the other Connections
databases.
- Even if you do not plan to deploy Cognos yet, you
should create the Metrics database and the Cognos Content
Store now so that IBM Connections can begin collecting event
data immediately.
- IBM Connections Content Manager requires two databases: Global Configuration Database and Object
Store.
- Enter the password for the databases and then click Next. Choose one of
the following options:
- Use the same password for all applications. Enter the password in the
Password and Confirm password fields.
- Create different passwords for each application. Enter a different
password for each application database, and confirm the password in the confirm field.
- Specify the location of the database file and then click Next.
- Use the same database file location for all applications. Enter the
location of the database or click Browse to choose a location.
- Use different database file locations for each application. For each
application, enter the location of the database file or click Browse to
choose a location.
- Review the Pre Configuration Task Summary to ensure that the values you
entered on previous pages in the wizard are correct. If you want to make a change, click
Back to edit the value. Click Create to begin creating
databases.
Note: Click Show detailed database commands to preview each SQL command
before it is executed by the wizard. If you choose to save the commands, you must have write-access
to the folder you choose to save them in.
- Review the Post Configuration Task Summary panel and, if necessary, click
View Log to open the log file. Click Finish to exit
the wizard.