Schema/DB name, federation layer and deployment

[MarkP]

This may help:

120×120 10.4 KB

I work in DB2 and have to change the Schema for my database in each environment (DEV, TEST, PRODUCTION) to accommodate our database structure. In UDT, changing the schema was pretty simple… select all the tables, right click, rename table, and change the Owner. In IDT, it seems like a much more manual process. I have to go into the BLX layer, do a find/replace and run that. Then, do the same in the DLX layer. I also have 63 joins in my database - and it looks as though I have to go into each j…