Using the database wizard
Use the database wizard to create databases for the IBM® Connections applications that you plan to install.
Before you begin
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. The default values for DB2® are db2admin on Microsoft™ Windows™, and db2inst1 on Linux™ and AIX®. For Oracle, the default value on AIX and Linux is oracle, and system administrator on Windows. For SQL Server, the default value is the system administrator.
Oracle and SQL Server connect 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.
(Oracle only) Ensure that the Statement cache size for the data sources on WebSphere Application Server is no larger than 50. A higher value could lead to Out Of Memory errors on the application server instance.
- If you migrated from IBM Connections 4.5 or 5.0, the numdb parameter was set to 14, the
maximum number of IBM Connections 4.5 or 5.0 databases. If the
instance has additional databases, increase the value of the numdb parameter to
match the total number of databases on the instance. To change the parameter, enter the following
command:
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 you run dbWizard.bat but the database wizard does not launch, check whether you have 32-bit DB2 installed. You need to have 64-bit DB2 on a 64-bit system.
DB2 uses a user account called lcuser
. If you are creating a DB2 database with SQL scripts, you must manually create the
lcuser
account on your operating system and then run the
appGrants.sql script to grant the appropriate privileges to the
lcuser
account. When you use the database wizard, this script runs automatically.
For more information, see the Creating a dedicated DB2
user topic.
- If you are using Linux on IBM System z® with the DASD driver, the SQL scripts are located in the connections.s390.sql/application_subdirectory directory of the IBM Connections setup directory or installation media.
- If you are using Linux on IBM System z with the SCSI driver, back up the connections.s390.sql directory and rename the connections.sql directory to connections.s390.sql.
(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
You can review the scripts that the wizard executes by looking in the connections.sql directory in the installation media. On DB2, the commands are shown in the log that the wizard creates. On Oracle and SQL Server, the log shows the results of the commands.
To create databases with the wizard, complete the following steps:
Procedure
What to do next
(DB2 for Linux on System z only.) To improve database performance, enable the NO FILE SYSTEM CACHING option. For more information, see the Enabling NO FILE SYSTEM CACHING for DB2 on System z topic.