DB2 backup excluding one table

[Former Member]

Hello all,

We have AIX 5.3 and DB2 9.1 for our CRM 2007 server. There is a table which contains CVV number. Is it possible to take the backup by excluding that table. Are there any tools that would help in taking backup excluding the table containing CVV number.

Best Regards,

Ninad

[Former Member]

a) You can encrypt the cvv column only - either using db2's encrypt function or encrypting the data before it hits the database.

b) If you have to exclude only CVV numbers, instead of dropping the entire table, you can consider setting the cvv value to null after exporting the data. after the backup completes, you can re-import the cvv data.

This approach is expensive and may take long time. In addition, you will not be able to insert new data into the table for the backup duration

c) You can consider setting up a nickname (reference to a remote table in a different database) for the entire table or the cvv column only. You need not take a backup of this database.

HTH

[Former Member]

Hi,

I agree with Paul. You can write a small script which can export your table data and drop it before taking the backup and recreate it once the backup has finished. This way you will meet the policies, but this is gonna be pain. If you setup a small script once, you'll be fine.

Good Luck!

Thanks,

Afi

Edited by: Afi C on Apr 1, 2010 8:47 AM

[hans-juergen_zeltwanger]

Hello,

I understood your problem is compliance due to the CVV numbers in the table.

Do you see strong encryption of the backup image as a possible option to stay compliant?

If yes, it may be worth to evaluate whether DB2 Encryption Expert is an option for you.

[Setting up IBM Database Encryption Expert in an SAP Environment|http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/00d8f606-f30a-2c10-f19b-a92f7d0af4d0]

[paul_power]

Hello Ninand,

The only possibility I can think of would be to export the content of the table to a file, then drop the table, do the backup and then recreate the table and import the contents again. This would need to have a secure way to store the contents while the table is dropped and if it was lost, you would not have the contents in the backup. But this is just something that came to mind as an option, perhaps there is a better way than this.

Regards,

Paul

[Former Member]

Well... you could create a new tablespace, move that table into it (search sap notes for the 'db6conv' tool), then backup all tablespaces except the new one... No idea how that would go if you had to restore.

Why do you want to exclude a table from your backup?

[Former Member]

The Table contains CVV number . Its against compliance to store CVVnumbers in backup.

[Former Member]

Hi Mahesh,

It is not possible. When you a backup, it backs up everything.

Thanks,

Afi

[Former Member]

Mahesh,

You cannot exclude a single table when taking a database backup. A full database backup will include all the objects within the database. A tablespace level backup will include all objects within a given tablespace.

- Sameer