Is there any command line tool that I can use on a DB2 database to dump a specific set of tables?
The problem is that I work in an application that its database tables was created in an existing schema alongside another application tables what would cause a lot of concurrency with these applications.
So after long discussion with our client he finally decide to attend our request to separate our database server since our application grows very large (tables with 14kk rows) and have lots of simultaneous request.
I've searched through DB2 documentation without any success. All the methods I've found out doesn't seems to solve this specific problem.
I read about the Export command. And couldn't find anything the do what we need.
Thanks in advance.
As asked in comments dump a specific set of tables means that we need to dump some tables from the database not all of then. Say that we have on this database about 5k tables and about 200 of then belongs to our system, so how would we dump only those 200 tables?
Export command documentation (mentioned above) there is no mention about exporting a group of tables only a data set (through a SQL command) of tables which does not meet the requirements.
EXPORTdoes not do what you need? Can you explain in details what you mean by "dump a specific set of tables"?