Changing Schema in IDT

building semantic layer
1

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 join manually to edit the SCHEMA name.
Is there an easier way to control this in IDT, or am I stuck with all this manual work with risk of error is higher?

DenominatorX (BOB member since 2015-03-23)

2

Its the same in IDT, no need to change the joins or the business layer

Maybe you didnt save the data foundation which is not reflecting changes in business layer

haider :es: (BOB member since 2005-07-18)

3

So do I need to make the change in both the dfx and blx layers, or just the dfx layer? When I do a find/replace, it doesn’t allow me to select the joins for modification. I can see them, but cannot check them off as they are greyed out.

DenominatorX (BOB member since 2015-03-23)

4

check this

And manually check few object definitions and joins for the schema changes made, it should show table identifier & owner prefixed to column names

haider :es: (BOB member since 2005-07-18)

5

But do I change it in both layers, or just the dfx layer? Should the blx layer pick it up?

DenominatorX (BOB member since 2015-03-23)

6

Just make those changes in dfx.

Andreas :de: (BOB member since 2002-06-20)

7

I made the changes in the DFX layer, saved it, opened the BLX layer and it updated there…
However all my joins in the DFX layer still have the old schema name in them, and the Find/Replace feature does not fix this… When I do find/replace, those boxes are greyed out and I cannot select them. This, along with all the derived tables, appears to be a manual change. Is this accurate? or is there a way to get these to update as well?

DenominatorX (BOB member since 2015-03-23)

8

joins, derived tables etc should pick the changes without any manual work

what version you are on, 4.0 or 4.1?
I have 4.1 SP4 and it behaves as described above with changes just required in dfx. Maybe someone else having BI 4.0 can comment if that is what you are using

haider :es: (BOB member since 2005-07-18)

9

We’re using BI4.1 SP3 w/ a DB2 database.

DenominatorX (BOB member since 2015-03-23)