Before you begin
Before using the wizard for the first time, you must complete the steps described in the Preparing the database wizard
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
® and db2inst1 on Linux
® and AIX
®. For Oracle, the default value is oracle on AIX
, 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 set up during database creation. The passwords of those user accounts are defined later in this task . DB2
uses a user account called lcuser. If you are creating a DB2
database, 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
- 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 set-up 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.
About this task
You can 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
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:
- (DB2 on Windows 2008 64-bit) On Windows 2008, you must perform DB2 administration tasks with full administrator privileges.
- Logged in as the instance owner, open a command prompt and change to the DB2 bin directory. For example: C:\Program Files\IBM\SQLLIB\BIN.
- Enter the following command: db2cwadmin.bat. This command opens the DB2 Command Line Processor while also setting your DB2 privileges.
- From the IBM Connections Wizards directory, open the following file to launch the wizard:
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:
- AIX: ./dbWizard30.sh
- Linux: ./dbWizard30.sh
- Microsoft Windows: dbWizard30.bat
Select an application and click Next.
- Select a database type.
- Select the location of the database.
Note: For an Oracle database on Windows 2008 64-bit, enter the value of the ORACLE_HOME registry key. For example, the key for Oracle 11g on Windows 2008 64-bit is HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\Key_OraDb11g_home1 and the value is C:\app\Administrator\product\11.2.0\dbhome_1.
- Specify a database instance.
Note: The database instance that you specify must already exist on your system.
(Oracle and SQL Server databases only) Enter the password for the databases and then click Next. Choose one of the following options:
If you are creating databases, 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.
(SQL Server only) Specify the location of the database file and then click Next.
- 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.
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.
- 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.
Note: Click Show detailed database commands to preview each SQL command before it is executed by the wizard.
Review the Post Configuration Task Summary panel and, if necessary, click View Log to open the log file. Click Finish to exit the wizard.
What to do next
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
Parent topic: Creating databases with the database wizard
Preparing the database wizard
Creating a dedicated DB2 user
Creating databases with SQL scripts