Xerox DocuShare Support & Software Installation Guide
DB2
5–6
DocuShare Installation Guide
DB2
The database must be established and running before you start a DocuShare software installation.
On the DB2 side
Before starting the DocuShare software installation, the DB2 database administrator must do the following:
•
Create a DocuShare/DB2 user and tablespace.
The database administrator can choose to create the tablespace manually and during the
DocuShare installation, specify the tablespace to use, or let the DocuShare install Wizard create
the tablespace.
DocuShare installation, specify the tablespace to use, or let the DocuShare install Wizard create
the tablespace.
A manually created tablespace must have a 32K bufferpool. DocuShare requires both a regular
and a system temporary tablespace, each with a 32K bufferpool.
and a system temporary tablespace, each with a 32K bufferpool.
As an option, the database administrator can create a large tablespace to store LOBs and an
index tablespace to store site indexes.
index tablespace to store site indexes.
If you choose to use an existing DB2 database or prefer to manually create and define an DB2
tablespace, the following is an example of a typical DocuShare tablespace creation script.
tablespace, the following is an example of a typical DocuShare tablespace creation script.
CREATE BUFFERPOOL DSBP IMMEDIATE SIZE 250 PAGESIZE 32 K;
CREATE REGULAR TABLESPACE DSDATADMS PAGESIZE 32 KMANAGED BY DATABASE USING (FILE
'C:\DB2\DB2Data\DSData' 3200)EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE 16
TRANSFERRATE 0.14 BUFFERPOOL DSBP DROPPED TABLE RECOVERY ON;
'C:\DB2\DB2Data\DSData' 3200)EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE 16
TRANSFERRATE 0.14 BUFFERPOOL DSBP DROPPED TABLE RECOVERY ON;
CREATE LARGE TABLESPACE DSLargeDms PAGESIZE 32 K MANAGED BY DATABASE USING (FILE
'C:\DB2\DB2Data\Docushare' 3200) EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE 16
TRANSFERRATE 0.14 BUFFERPOOL DSBP ;
'C:\DB2\DB2Data\Docushare' 3200) EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE 16
TRANSFERRATE 0.14 BUFFERPOOL DSBP ;
CREATE SYSTEM TEMPORARY TABLESPACE DSTEMPDMS PAGESIZE 32 K MANAGED BY SYSTEM
USING ('C:\DB2\DB2Temp') EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE 16
TRANSFERRATE 0.14 BUFFERPOOL DSBP;
USING ('C:\DB2\DB2Temp') EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE 16
TRANSFERRATE 0.14 BUFFERPOOL DSBP;
•
Designate a location on the DB2 system that has the required space for the new tablespace file.
On the DocuShare side
To configure DocuShare to work with DB2, the install Wizard requires the following information:
•
Database User — the account that DocuShare uses to log into the database
•
Database User Password — the password for the Database User account
•
Database Port — the port that DocuShare uses to connect to the database
•
Database Name — the name of the database used to store DocuShare data
•
Tablespace Name — the name of the tablespace where the database stores all DocuShare data
•
Large Tablespace Name — the name of the tablespace where the database stores LOBs
•
Indexspace Name — the name of the tablespace where the database stores all DocuShare
indices
indices
•
Database Host Name — the name of the database server
•
Create Database — select if a database has not been created and you want the Wizard to create
the database for you
the database for you