How to export and import DB2 database?

bloodwing

I want to make a small program. . Export the DB2 database, rebuild a database, and then import the data to the new database. . How does this work?

There is another difficulty, how to solve the self-growth variable?

Looking forward to expert help.

bloodwing

By the way, there are more than 200 tables. The amount of data is large, and some tables have hundreds of thousands of data. .

bloodwing

Explain the reason: because the original database may be damaged and cannot be backed up. . Had to do so. .

vincentpan

You can traverse the table in the program, then use db2export to export to text, db2import to import

However, additional processing is required for large object fields, but the program logic implementation is still very simple.

bloodwing

The principle seems simple. . But consider independent growth variables and factors with more data. . It's not easy to implement. .

琳儿宝贝

Sometimes there are problems with export and import,
It is recommended to install DB2 on a good computer to create a new database! Then copy all the tables of the previous database by copying tables, so that there will be no problems!

bloodwing

There are too many watches. . There are also indexes, views, and stored procedures. . . That's not easy. .

xsxlucifre

Is it for the entire library? If it is the entire library, it can be realized through backup and restoration.

bloodwing

The database cannot be backed up. .

bicyycle

Use tools, manual work is too much, use this:
Quest Central for DB2
DB2 professional tool, with data migration function (MIGRATE), hundreds of thousands is not big, I am a data warehouse, hundreds of millions are small cases, you can talk about it if you have any problems