Привет

вот это:

select * from prf_v_ac_iat where ("SN","Control Point","Date") in ( select "SN", "Control Point", max("Date") from prf_v_ac_iat where "Date" < '2003-03-22' group by "SN","Control Point" ) and "
SN"='900812'
SQL1224N A database agent could not be started to service a request, or was
terminated as a result of a database system shutdown or a force command.
SQLSTATE=55032


валит сервер.

А вот это нет:

db2 => select * from prf_v_ac_iat where ("SN","Control Point","Date") in ( select "SN", "Control Point", max("Date") from prf_v_ac_iat where "Date" < '2003-03-22' group by "SN","Control Point" )

SN Control Point Date Equvalent Flight Hours Demage Index MA date Flight Hours to MA
------ ------------------------------------------------ ---------- ------------------------ ------------------------ ---------- ------------------------
900812 B1230AA 03/27/2002 +3.31754648131547E+003 +3.16895421803195E+001 08/12/2008 +5.22433561457494E+003
999999 B1230AA 08/16/1993 +1.09000000000000E+001 +1.04117911146348E-001 01/09/2011 +5.23268209589041E+003
900812 T7467AA 03/27/2002 +9.63484589228582E+003 +3.57281498280713E+001 03/03/2028 +1.10931655348499E+004
999999 T7467AA 08/16/1993 +7.88099269684736E+003 +2.92244724009900E+001 05/28/2025 +9.54871873028832E+003

4 record(s) selected.

как лечить ?

Привет
статистика свежая.

суппорт есть. уже неделю потеет в штатах.

шлю.

8.1.3 тот же результат