esmith2112
unread,Apr 30, 2019, 5:03:21 PM4/30/19You do not have permission to delete messages in this group
Sign in to report message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
I had hoped to use "db2look" to recreate the infrastructure for my database (10.5 on Linux) on a different server (DB2 on Cloud). I am having difficult getting to generate the DDL in correct dependency order for views and procedures. There is a -ct option which generates the objects according to creation time, but that fails for views that were dropped and re-created after their initial creation. I would like to have a clean build, especially since I'm going to have repeat this process several times.
I tried my hand at a recursive query using SYSCAT.VIEWS and ySYSCAT.VIEWDEP trying to make a hierarchical parent/child tree, but thus far have not succeeded. Has anyone else come up with a methodology? I saw that there zOS Db2 Admin tool that looks like it might handle this, but I couldn't find anything in the way of LUW databases.
Thanks for your help,
Evan