Re: The reason for loving Usenet

From: onedbguru <>
Date: Fri, 27 Apr 2012 15:14:32 -0700 (PDT)
Message-ID: <30578346.62.1335564872731.JavaMail.geo-discussion-forums_at_vbak7>

On Thursday, April 26, 2012 6:35:03 PM UTC-4, TheBoss wrote:
> onedbguru <> wrote in
> news:9544139.2864.1335392559243.JavaMail.geo-discussion-forums_at_vbvx4:
> <...>
> > having had to chastise a development team for almost crashing a
> > mainframe - because the remote tables were actually accessed via
> > DB2Connect to a DB2 mainframe database, I would not have been as
> > polite as you were... [stupid idiots!!!]
> Your DEV team is allowed to get as much resources as to almost crash a
> mainframe?! It appears to me that someone else should have been
> chastised for not properly define settings for WLM and such as to make
> it impossible for a developer to get more than a fair share of available
> resources.
> Or for that matter for not properly capping LPARs in such a way that a
> DEV LPAR never can monopolise the entire mainframe.
> One shouldn't give a box full of candy to a kid, and than chastise
> him/her at the end of the day when the box appears empty...
> Cheers!
> --
> Jeroen
> [DB/SYS-Admin for DB2/LUW (incl. DB2Connect), DB2/zOS and OTG4DB2/zOS]

no, the dev team wrote the code and it got pushed to production. the dev nor prod team understood how database links really worked - especially for remote targets that are NOT Oracle. (I was the support team called in to fix stuff)

given where a, b and c are database links to DB2 tables on the main frame:

select a.1, b.2, c.3 from a , b , c, d, e where a.1=b.1 and b.1=c.1 and c.1=d.1 and e.1=d.1 and e.2='foo';

what DB2 sees:

select * from a;
select * from b;
select * from c;
select * from d;
select * from e where e2='foo'

and then the join is performed by Oracle.

total amount of data was > 500M [for each query] and there were hundreds of queries. Received on Fri Apr 27 2012 - 17:14:32 CDT

Original text of this message