I see nothing untoward about a 40 table query. And obviously DB2 should not
be crashing.

As Serge says, check you're on 8.1.5, then open a PMR against the bug.

"Mark A" <ma@switchboard.net> wrote in message
news:4GZmc.1453$hy5.36078@news.uswest.net...
> "Philip Sherman" <psherman@ameritech.net> wrote in message
> news:guZmc.397$gV7.360@newssvr32.news.prodigy.com. ..
> > SELECT columns
> > FROM t1
> > JOIN t2
> > .
> > .
> > .
> > WHERE predicates
> >
> > The from/join contains 5 tables, one of which is created from a select
> > statement.
> >
> > The columns area contains 35 selects, some of them containing a join,
> > referencing a total of 40 tables.
> >
> > UDB 8.1 Windows and Linux both hard crashed (complete instance shutdown)
> > trying to process this statement. (Yes, I have dumps from Linux and may
> > be able to get to the Windows dumps next week.)
> >
> > Please don't ask me where this came from - I didn't write it and just
> > have to make it work within the next two days.
> >
> Check the SQL limits in the SQL Reference for the most tables or joins in
> one statement. If you are not on fixpak 5, I would install it now.
>
> I don't care where it came from, but the person who did it should be
tarred
> and feathered.
>
>