We are new to TOAD, having only recently acquired the DBA Suite for our DB2 LUW v9.5 database.
I asked my DBA if TOAD could create relationally intact subsets of data from a large database (for instance, to see a developer sized DB extracted from PROD). He wasn’t sure.
I once used a toolset called Princeton SofTech to do this effectively: Move for DB2. However, IBM (Optim) has acquired that tool and it now is embroiled in a huge feature set for a large price.
Since we only need this one capability found there, Optim isn’t an option for us due to licensing.
Does anyone know if TOAD can do this without all the heavy lifting of hand-crafted SQL?