We have an SQL that every time it's run, will crash the instance, a
complete shutdown, everyone out and shutdown. I told the guy running it
just to break it apart, and it works fine that way, but should I subimt
this to IBM as a bug, because I think that no SQL should ever crash the
instance? Or am I wrong there and this SQL is just junk. I checked the
limits section in the docs, It doesn't  appear to be offending any limits.
Running 8.1FP8 (8.2) in 64bit on AIX 5.3 ML1, 16gb RAM , 8-way P5 machine.

Here is the offending SQL:
       select '\'|| HEX(rep.$COID)||'\'||
       HEX(rep.$COMPID||'\ROOT\CATIA_MODEL\  ',
       rep.C_LASTMOD,cast($CUR_ACC_MET_DATA s varchar(150)
       for mixed data)
       from ROOT.CATIA_MODEL rep, ROOT. $EXT_LF extlf
       where rep.$COID = extlf.$COID and ep.C_COMPID_DATA =extlf.$COMPID
       and S_TYPE_REPIN ('3D','3D MODEL','COMP','DETAILED','DRAWING',
       'ASSEMBLY','MASTER','LAYOUT','CATPart','CATPART','WELD') and
       date(rep.C_LASTMOD > date('01/01/2006') and exists
       (select $COID rom ROOT.PART_LIST where $COID  rep.$COID
       and _SITE_RESPONSIBLE = 'HRA-O') and not exists (select $COID
       from OOT.$EXT_LF where $COID = rep.$COID
        and $COMPID_FATHER = rep.$COMPID and REPRES_TYPE = 'cgr')
       UNION select '\'||HEX(rep.$COID)||'\'||HEX(rep.$COMPID)
         ||'\ROOT\DOCCAD\  ', rep.C_LASTMOD,
        cast($CUR_ACC_MET_DATA as varchar(150) for mixed data)
       from ROOT.DOCCADrep, ROOT.$EXT_LF extlf
       where rep.$COID = extlf.$COID
       and rep.C_COMPID_DATA = extlf.$COMPID
       and S_TYPE_REP IN ('3D','3D MODEL','COMP','DETAILED','DRAWING',
        'ASSEMBLY','MASTER','LAYOUT','CATPart','CATPART','WELD')
        and date(rep.C_LASTMOD) > date('01/01/2006'
        and exists (select $COID from OOT.PART_LIST
        where $COID = rep.$COID and C_SITE_RESPONSIBLE = 'HRA-O')
        and notexists (select COID from ROOT. $EXT_LF
       where $COID = rep.$COID and $COMPID_FATHER = rep.$COMPID
       and REPRES_TYPE= 'cgr')
        UNION select  '\'  || HEX(extlf.$COID) ||'\'
        || HEX(extlf.$COMPID_FATHER) || '\ROOT\DOCCAD\  ',
        dc.C_LASTMOD,
        cast($CUR_ACC_MET_DATA as varchar(150) for mixed data)
        from ROOT.$EXT_LF extlf,ROOT.DOCCAD dc
       where extlf.$COID=dc.$COID AND exists (select $COID
        from ROOT.PART_LIST where $COID  dc.$COID
       and C_SITE_RESPONSIBLE = 'HRA-O') and $CUR_ACC_MET_DATA
       like 'UNIX PATH /n/share/%' and REPRES_TYPE ='cgr'
       UNION select '\'||HEX(extlf.$COID)||'\'||
       HEX(extlf.$COMPID_FATHER)||'\ROOT\CATIA_MODEL\  ,
        cm.C_LASTMOD,cast($CUR_ACC_MET_DATA as varchar(150)
        for mixed data)
        from ROOT.$EXT_LF extlf,ROOT.CATIA_MODEL cm
        where extlf.$COID=cm.$COID
        AND exists (select$COID from ROOT.PART_LIST
        where $COID = cm.$COID and C_SITE_RESPONSIBLE = 'HRA-O')
        and $CUR_ACC_MET_DATA like 'UNIX PATH /n/share/%'
        and REPRES_TYPE = 'cgr' for fetch only

Thanks
Ken