Is there any way to programatically copy across schema (i.e. tables,functions,views) etc from one database over to another one. Assuming both are running same versions of DB2.
I found a few utilities like i) db2move -- i could not find a way to access it via jdbc. So is ruled out. ii) admin_copy_schema -- copies across schemas in same database. iii)db2look -- again a utility. no way to call it from jdbc.
Even if we find a way to run those utilites db2move or db2look produces files which then have to be copied over to the target machine - making it highly complicated to automate the whole thing.
Is there a simple way to clone over a database through jdbn