We installed IBM Data Studio 2.2.0.2 as IBM OSC will be decommissioned soon . While comparing both , it seems that Data Studio is much slower for some queries with many joins while doing access plan graph (300 secs for Data Studio where step "Show Formatter" lasted 280 secs) compared to less than 10 seconds for OSC .

Does anyone has experienced the same trouble ?

Query :

SELECT C1,
C2,
C3,
C4
FROM T1
INNER JOIN T3 ON C1 = T3.C6
INNER JOIN T2 on T1.C5 = T2.C1
optimize for 1 row

Performance for both are similar for simple selects without these joins .

Are you looking this comparision on DB2 for z/OS in both these tools? or Is it DB2 LUW?

We are working on DB2 v9 on z/OS and were very happy with OSC .