Hi,

I have the db setup with some partition groups/ bufferpools and tablespaces as shown below --- if I want to back up the whole db except for one table that has it's data in it's own tablespace/bufferpool and group.. how can i do it? for example, the THIRD group/bpool/tblsp stores reading data and when I restore on dbserver 2 I don't want this data table to be touched on the backup server (server 2). is it as simple as giving this for the backup and restore commands--

db2 backup database dbname online tablespace ( first_tblsp, second_tblsp, fourth_tblsp) to /path/backup include logs

db2 restore db dbname from /path/backup/ taken at 20080917050002 logtarget /home/nrg1/logs/


What happens to the bufferpool and partition group corresponding to the readings table on the backup server where I give the restore command? Will it be touched? Am just wondering since I only mention the tablespace names in the backup command? Thanks!


-----------------------------------
-- DDL Statements for DATABASE PARTITION GROUPS --
-----------------------------------

CREATE DATABASE PARTITION GROUP "FIRST_GROUP" ON DBPARTITIONNUMS
(0);


CREATE DATABASE PARTITION GROUP "SECOND_GROUP" ON DBPARTITIONNUMS
(0);


CREATE DATABASE PARTITION GROUP "THIRD_GROUP" ON DBPARTITIONNUMS
(0);


CREATE DATABASE PARTITION GROUP "FOURTH_GROUP" ON DBPARTITIONNUMS
(0);


CREATE BUFFERPOOL "FIRST_BP" DATABASE PARTITION GROUP "FIRST_GROUP" SIZE 10000 PAGESIZE 8192 NOT EXTENDED STORAGE;

CREATE BUFFERPOOL "SECOND_BP" DATABASE PARTITION GROUP "SECOND_GROUP" SIZE 10000 PAGESIZE 8192 NOT EXTENDED STORAGE;

CREATE BUFFERPOOL "THIRD_BP" DATABASE PARTITION GROUP "THIRD_GROUP" SIZE 2000 PAGESIZE 8192 NOT EXTENDED STORAGE;

CREATE BUFFERPOOL "FOURTH_BP" DATABASE PARTITION GROUP "FOURTH_GROUP" SIZE 3000 PAGESIZE 8192 NOT EXTENDED STORAGE;


CREATE REGULAR TABLESPACE FIRST_TBLSP IN DATABASE PARTITION GROUP FIRST_GROUP PAGESIZE 8192 MANAGED BY SYSTEM
USING ('......')
EXTENTSIZE 32
PREFETCHSIZE 96
BUFFERPOOL FIRST_BP
OVERHEAD 24.100000
TRANSFERRATE 0.900000
FILE SYSTEM CACHING
DROPPED TABLE RECOVERY ON;

CREATE REGULAR TABLESPACE SECOND_TBLSP IN DATABASE PARTITION GROUP SECOND_GROUP PAGESIZE 8192 MANAGED BY SYSTEM
USING ('..... ')
EXTENTSIZE 32
PREFETCHSIZE 192
BUFFERPOOL SECOND_BP
OVERHEAD 24.100000
TRANSFERRATE 0.900000
FILE SYSTEM CACHING
DROPPED TABLE RECOVERY ON;


CREATE REGULAR TABLESPACE THIRD_TBLSP IN DATABASE PARTITION GROUP THIRD_GROUP PAGESIZE 8192 MANAGED BY SYSTEM
USING ('...')
EXTENTSIZE 32
PREFETCHSIZE 192
BUFFERPOOL THIRD_BP
OVERHEAD 24.100000
TRANSFERRATE 0.900000
FILE SYSTEM CACHING
DROPPED TABLE RECOVERY ON;

CREATE REGULAR TABLESPACE FOURTH_TBLSP IN DATABASE PARTITION GROUP FOURTH_GROUP PAGESIZE 8192 MANAGED BY SYSTEM
USING ('...')
EXTENTSIZE 32
PREFETCHSIZE 96
BUFFERPOOL FOURTH_BP
OVERHEAD 12.670000
TRANSFERRATE 0.180000
FILE SYSTEM CACHING
DROPPED TABLE RECOVERY ON;