Hello,
I need to make backup of a big production database, but some data should
never be stored
in backups.
Assume that the table/tablespace contains volatile private keys, which are
stored in
some separate database and are maintained (also backed up) separatelly.
Our production database contains only temporary copy of those keys.

In Oracle I have a posibility to exclude a tablespace from backups with a
command:
CONFIGURE EXCLUDE FOR TABLESPACE privkeys;

As you can read in:
http://publib.boulder.ibm.com/infoce.../r0001933.html
there seems to be a possibility in DB2 to backup only selected tablespaces
- what would solve my problem. But as I read in other sources - this is not
so simple,
first I need to have a full backup and vary some other constraints.

Is there a simple solution for DB2 ?

Hello,

for this data federation would be a nice thing...


On Jun 14, 12:26*pm, "sielim" <sielim_tnij... (AT) to (DOT) tez.wp.pl> wrote:

On Jun 14, 2:26*pm, "sielim" <sielim_tnij... (AT) to (DOT) tez.wp.pl> wrote:
Hello.

You don't have to have a full backup for that since DB2 9.1
You can use rebuild option of restore command.
See Rebuild examples:
http://publib.boulder.ibm.com/infoce.../c0024712.html
and rebuild restrictions:
http://publib.boulder.ibm.com/infoce.../c0022322.html

Sincerely,
Mark B.

Uzytkownik "MarkB" <mark.barinstein (AT) gmail (DOT) com> napisal w wiadomosci
news:a6e7029e-d190-41fa-afe9-14c52966830b (AT) e35g2000yqc (DOT) googlegroups.com...
Thanks, I didn't know about REBUILD option.

I consider just marking a tablespace with private keys as temporary:
http://publib.boulder.ibm.com/infoce.../c0022663.html
and use DECLARE GLOBAL TEMPORARY TABLE command to create table, but as i
see,
there is no possibility to share data across connections.

So - I have to use REBUILD option and it is the solution.

Uzytkownik "stefan.albert" <stefan.albert (AT) spb (DOT) de> napisal w wiadomosci
news:cc70996e-66b7-4312-a927-5a0f2fb70174 (AT) p20g2000yqg (DOT) googlegroups.com...

Yes, I noticed this just after I'd written the post
Tiny database with one table and link to that table
in any other databases.
And, as I can read, it is simply achievable with
DB2 Express-C - so easy to test

Thanks.