Use the database wizard to create databases for Connections applications
- Prepare to use the database wizard.
- Log into the system where the database is hosted with the database administrator account...
DB OS Default user DB2 Windows db2admin DB2 Linux and AIX db2inst1 Oracle AIX and Linux oracle Oracle Windows system administrator SQL Server Windows system administrator
- (Oracle only) Set the Statement cache size for the data sources on WAS to be no larger than 50. A higher value could lead to Out Of Memory errors on the application server instance.
- (DB2 only) If we use only one database instance, and if that instance includes other databases besides IBM Connections, configure the numdb parameter to match the total number of databases on the instance.
If we migrated from IBM Connections 4.5, the numdb parameter was set to 14, the maximum number of Connections 4.5 databases. If the instance has additional databases, increase the value of the numdb parameter to match the total number of databases on the instance.
db2 UPDATE DBM CFG USING NUMDB nn
...where nn is a number of databases.
- Before removing (or dropping) a database, stop Connections first to ensure that no database connection is in use; otherwise you will not drop the user and the database removal will not occur.
- If we run dbWizard.bat but the database wizard does not launch, check whether you have 32-bit DB2 installed. We need to have 64-bit DB2 on a 64-bit system.
- If we are creating a DB2 database with SQL scripts, manually create the lcuser account on the operating system, and then run appGrants.sql.
When using the database wizard, this script runs automatically.
- AIX: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
- libtiff-3.8.2
- Review the scripts the wizard executes by looking in the connections.sql directory.
On DB2, the commands are shown in the log the wizard creates. On Oracle and SQL Server, the log shows the results of the commands.
- (DB2 on Windows 2008 64-bit) Log on as the instance owner and set privileges...
cd opt/ibm/sqllib/bin
db2cwadmin.bat
- Launch the wizard:
./dbWizard.sh
- Click Next to continue.
- Select the option to...
Create a database
- Enter the details of the database to create:
- Database type
- Location of the database
- Database instance
- Select an application, and click Next.
- If we are creating databases in this task, only applications that have not already been installed to a database instance are available. If we are updating databases, we 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 we select the Metrics application, also select the IBM Cognos application.
- If we have already deployed Cognos components and have a Cognos Content Store available, you do not need to create another.
- If we do create a Cognos Content Store, only the container is created now; the tables are created when we start the Cognos BI Server for the first time.
- We do not need a dedicated database server for Cognos or for the Metrics application; we 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
- Object Store
- (Oracle and SQL Server databases only) Password for the databases and then click Next.
Choose one of the following options:
- Use the same password for all applications.
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.
- (SQL Server only) 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 the values entereded on previous pages in the wizard are correct.
To make a change, click Back to edit the value. Click Create to begin creating databases.
To preview each SQL command before it is executed by the wizard, click...
Show detailed database commands
- Review the Post Configuration Task Summary panel and, if necessary, click View Log to open the log file. Click Finish to exit the wizard.
If the wizard returns a error indicating that it failed to create the Metrics database, see: Metrics database creation with error message and Cognos cube build failed.
Parent topic:
Create databases with the database wizard
Related:
Prepare the database wizard
Create a dedicated DB2 user
Create databases with SQL scripts