Dumping data from DB2 database
Posted on 2014-09-19
I need to check if a piece of data (a password) is present anywhere in a DB2 database. Seems like the easiest way to do that is to dump the database to plain text (similar to mysqldump) and then grep the resulting file. However I can't find any easy way to dump the whole database. Any suggestions?
I know how to dump individual tables with export command, however, since there are quite a lot of tables, it will take a while.
Alternatively if there is a way to a full text search on the whole database (all tables), this will solve my problem too.