Troubleshooting guide

Adding a Temporary Tablespace to the Primary Database
Add a temporary tablespace to the primary database.
1.
Start the DB2 UDB command-line processor (CLP):
%>bash
%>source /db2home/db2inst1/sqllib/db2profile
%>db2
2.
Connect to the primary DB2 UDB database:
db2=>connect to pdb user db2_admin_user using db2_admin_password
where db2_admin_user and db2_admin_password are the administrative user ID and
password for the primary database.
3.
Create a buffer pool:
db2=>create bufferpool pdb_buffer_name size 1000 pagesize
same_pagesize_as_pdb
where
pdb_buffer_name is the buffer name, and same_pagesize_as_pdb is the page size at
the primary database.
4.
Create a temporary tablespace:
db2=>create user temporary tablespace pdb_temp_space_name
pagesize same_pagesize_as_pdb managed by automatic storage
bufferpool
pdb_buffer_name
where
pdb_temp_space_name is the tablespace name, same_pagesize_as_pdb is the page
size at the primary database, and pdb_buffer_name is the buffer name.
Note: You can determine what the DB2 UDB page size is with the LIST TABLESPACES
SHOW DETAIL command.
For example, to create a temporary tablespace named deep13 with a 16KB page size and
buffer pool named tom_servo, enter:
create user temporary tablespace deep13 pagesize 16K managed
by automatic storage bufferpool tom_servo
Creating the Replication Agent Instance
Prepare and create a Replication Agent instance for replication of each DB2 UDB database.
A single installation of the Replication Agent can support replication from multiple databases.
However, one Replication Agent instance is needed for each DB2 UDB database that is to be
replicated.
Note: To replicate from multiple databases, using one Replication Agent instance for each
database, you must create a separate DB2 UDB user for each primary database, as described in
"Creating a DB2 UDB User and Granting Permissions." You cannot use the same user for
multiple Replication Agents.
CHAPTER 6: DB2 UDB-to-SAP HANA Database Replication Setup
94 Replication Server