Before you begin
If the database server and IBM
Docs are installed on different systems, copy the SQL scripts to the system that hosts the database server.
When creating a database, you must log in to the system where the database is hosted using the database administrator account. The default values for DB2
® are db2admin
™ and db2inst1
™ and AIX
About this task
This procedure is required for the IBM
- Optional: This step is only required if the database server and IBM Docs are installed on different systems. Copy the IBM Docs SQL scripts to the DB2 database system and authorize a user ID to create the databases.
Note: The required SQL scripts are located in the IBMDocs_Install_Package/setupDB subdirectory directory of the IBM Docs setup directory.
Note: Ensure that the user ID also has write privileges for the directory in which these scripts reside.
- Log in to the DB2 database system using the user ID of the database instance owner. This user ID must have privileges to create a database, a tablespace, tables, and indexes.
- Start the DB2 command line processor in command mode and enter the following command:
Run the script to create the database.
- Windows: db2start
- Linux: db2start
Run the script to update the database schema:
- Windows: createDb.bat
- Linux: . ./createDb.sh
Close the DB2 command line processor.
- Windows: updateDBSchema.bat
- Linux: . ./updateDBSchema.sh
Note: Make sure the user ID has the write privilege for the directory of these scripts.
Parent topic: Creating databases for IBM Docs