CODEWITHSUNDEEP
sqldb2
Sparker0i
Sparker0i

Reputation: 1851

Backup specific tables in db2

I know about backing up databases in online and offline mode. I also know about backing up tablespaces in db2. I wanted to know if there's any way we could back up only some specific tables inside a given schema/tablespace.

Upvotes: 0

Views: 4218

Answers (2)

data_henrik
data_henrik

Reputation: 17118

It is not possible to back up individual tables using the BACKUP command. A common approach is to use EXPORT command. If you need to backup the schema, use db2look to extract the DDL for that table.

Upvotes: 2

Mark Barinstein
Mark Barinstein

Reputation: 12299

No, you can't backup specific tables in db2 for Linux, Unix and Windows.

Upvotes: 0

Related Questions