Manual steps
from the Configuration Wizard are included in IBM Knowledge Center
for reference and for advanced users. The procedure includes variables
and steps for different databases. When you use the wizard to configure
your deployment, it replaces the variable with information that you
provided in the wizard. It also shows only the steps that are specific
to your environment. The instructions that the wizard generates are
specific to your environment.
Before you begin
Ensure your DB2® server is already
installed and running.About this task
Attention: All steps for all database environments are included without
consideration for your environment. Use the Configuration Wizard to generate custom instructions for
your environment.
Procedure
Instructions for
AIX, HP-UX, Linux, and Solaris
- Copy the JDBC
Driver JAR files from your database server to your portal server.
Example location:
/opt/ibm/db2/V10.5/java/db2jcc4.jar
/opt/ibm/db2/V10.5/java/db2jcc_license_cu.jar
Place the files on the portal
server in the directory that you specified for database library files.
db2.DbLibrary
- Log in as a DB2 system administrator
with the required database privileges (SYSADM or at a minimum SYSCTRL).
su - domain.DBA.DbUser
- Copy the script that you
downloaded for this step to the database server, and extract the file.
- Rename the file that
you downloaded to include a .sh extension.
- Run the shell file
on your database server.
/your_database_server_file_location/CreateDB2Database.sh
Example of the script that the Configuration Wizard generates.
db2set DB2COMM=TCPIP
db2set DB2_EVALUNCOMMITTED=YES
db2set DB2_INLIST_TO_NLJN=YES
db2 "UPDATE DBM CFG USING sheapthres 0"
db2 "CREATE DB WPSDB using codeset UTF-8 territory us PAGESIZE 8192"
db2 "UPDATE DB CFG FOR WPSDB USING locktimeout 30"
db2 "CONNECT TO WPSDB USER dba_ID USING dba_pwd"
db2 "CREATE BUFFERPOOL ICMLSFREQBP4 SIZE 1000 AUTOMATIC PAGESIZE 4K"
db2 "CREATE BUFFERPOOL ICMLSVOLATILEBP4 SIZE 16000 AUTOMATIC PAGESIZE 4K"
db2 "CREATE BUFFERPOOL ICMLSMAINBP32 SIZE 16000 AUTOMATIC PAGESIZE 32K"
db2 "CREATE BUFFERPOOL CMBMAIN4 SIZE 1000 AUTOMATIC PAGESIZE 4K"
db2 "CREATE REGULAR TABLESPACE ICMLFQ32 PAGESIZE 32K BUFFERPOOL ICMLSMAINBP32"
db2 "CREATE REGULAR TABLESPACE ICMLNF32 PAGESIZE 32K BUFFERPOOL ICMLSMAINBP32"
db2 "CREATE REGULAR TABLESPACE ICMVFQ04 PAGESIZE 4K BUFFERPOOL ICMLSVOLATILEBP4"
db2 "CREATE REGULAR TABLESPACE ICMSFQ04 PAGESIZE 4K BUFFERPOOL ICMLSFREQBP4"
db2 "CREATE REGULAR TABLESPACE CMBINV04 PAGESIZE 4K BUFFERPOOL CMBMAIN4"
db2 "CREATE SYSTEM TEMPORARY TABLESPACE ICMLSSYSTSPACE32 PAGESIZE 32K BUFFERPOOL ICMLSMAINBP32"
db2 "CREATE SYSTEM TEMPORARY TABLESPACE ICMLSSYSTSPACE4 PAGESIZE 4K BUFFERPOOL ICMLSVOLATILEBP4"
db2 "CREATE USER TEMPORARY TABLESPACE ICMLSUSRTSPACE4 PAGESIZE 4K BUFFERPOOL ICMLSVOLATILEBP4"
db2 "DISCONNECT WPSDB"
db2 "TERMINATE"
db2 "UPDATE DB CFG FOR WPSDB USING logfilsiz 16000"
db2 "UPDATE DB CFG FOR WPSDB USING logprimary 20"
db2 "UPDATE DB CFG FOR WPSDB USING logsecond 50"
db2 "UPDATE DB CFG FOR WPSDB USING logbufsz 500"
db2 "UPDATE DB CFG FOR WPSDB USING DFT_QUERYOPT 5"
Instructions for Windows
- Copy the
JDBC Driver JAR files from your database server to your portal server.
Example location:
C:\\Program Files\\IBM\\SQLLIB\\java\\db2jcc4.jar
C:\\Program Files\\IBM\\SQLLIB\\java\\db2jcc_license_cu.jar
Place the files on the portal server in the
directory that you specified for database library files.
db2.DbLibrary
- Log in as a DB2 system administrator.
This DB2 system
administrator must have the required database privileges (SYSADM or
at a minimum SYSCTRL) to create your database. This user is typically
a member of both the Administrators and DB2ADMNS groups.
- Copy the script
that you downloaded for this step to the database server, and extract
the file.
- Rename the file that you
downloaded to include a .bat extension.
- Run the batch
file on your database server.
db2cmdadmin.exe
-w C:\\your_database_server_file_location\\CreateDB2Database.bat
Example of the script is not available for Windows.