Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2007
    Posts
    34

    Unanswered: IBM Data Studio 2.2.0.2 performance versus IBM OSC 1.1. FP7

    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 .

  2. #2
    Join Date
    Apr 2005
    Location
    USA
    Posts
    130
    Are you looking this comparision on DB2 for z/OS in both these tools? or Is it DB2 LUW?

  3. #3
    Join Date
    Jul 2007
    Posts
    34
    We are working on DB2 v9 on z/OS and were very happy with OSC .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •