#out-of-memory #shared-memory #informix
Вопрос:
Когда я пытаюсь выполнить представление в базе данных Informix, я получаю сообщение об ошибке, например:
SQL Error [IX000]: Cannot write sorted rows
ISAM error: no free disk space for sort
Моя конфигурация системы такова
ОС: Windows server 2019
Оперативная память:32 ГБ
Версия Informix : 12.10
Объем БД : 2 ТБ
ниже добавлено определение представления.
create view "informix".fan_sensor_view (localcol,tef_1,tef_2,tef_3,tef_4,tef_5,tef_6,tef_7,tef_8,tvf_1,tvf_1a,tvf_2,tvf_2a,tvf_3,tvf_3a,tvf_4,tvf_4a,tvf_5,tvf_6,station,corridor) as
select x0.sti_energy_tef_localcol ,TO_CHAR (round(x0.tef_1_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x0.tef_2_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x0.tef_3_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x0.tef_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'NA' ,TO_CHAR (round(x1.tvf_1_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x1.tvf_2_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x1.tvf_3_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x1.tvf_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'STI' ,'Corridor2' from ("informix".sti_energy_tef x0 join "informix".sti_energy_tvf x1 on (EXTEND (x0.sti_energy_tef_localcol ,year to second) = EXTEND (x1.sti_energy_tvf_localcol ,year to second) ) )
union select x2.sat_energy_tef_localcol ,TO_CHAR (round(x2.tef_1_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x2.tef_2_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x2.tef_3_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x2.tef_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'NA' ,TO_CHAR (round(x3.tvf_1_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x3.tvf_2_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x3.tvf_3_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x3.tvf_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'SAT' ,'Corridor2' from ("informix".sat_energy_tef x2 join "informix".sat_energy_tvf x3 on (EXTEND (x2.sat_energy_tef_localcol ,year to second) = EXTEND (x3.sat_energy_tvf_localcol ,year to second) ) )
union select x4.sae_energy_tef_localcol ,TO_CHAR (round(x4.tef_1_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x4.tef_2_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x4.tef_3_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x4.tef_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'NA' ,TO_CHAR (round(x5.tvf_1_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x5.tvf_2_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x5.tvf_3_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x5.tvf_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'SAE' ,'Corridor2' from ("informix".sae_energy_tef x4 join "informix".sae_energy_tvf x5 on (EXTEND (x4.sae_energy_tef_localcol ,year to second) = EXTEND (x5.sae_energy_tvf_localcol ,year to second) ) )
union select x6.ssn_energy_tef_localcol ,TO_CHAR (round(x6.tef_1_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x6.tef_2_fan_vibrationmm_mm_per_s , 1 ) ),TO_CHAR (round(x6.tef_3_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x6.tef_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'NA' ,TO_CHAR (round(x7.tvf_1_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x7.tvf_2_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x7.tvf_3_fan_vibrationmm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x7.tvf_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'SSN' ,'Corridor2' from ("informix".ssn_energy_tef x6 join "informix".ssn_energy_tvf x7 on (EXTEND (x6.ssn_energy_tef_localcol ,year to second) = EXTEND (x7.ssn_energy_tvf_localcol ,year to second) ) )
union select x8.spc_energy_tef_localcol ,TO_CHAR (round(x8.tef_1_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x8.tef_2_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x8.tef_3_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x8.tef_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'NA' ,TO_CHAR (round(x9.tvf_1_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x9.tvf_2_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x9.tvf_3_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x9.tvf_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'SPC' ,'Corridor2' from ("informix".spc_energy_tef x8 join "informix".spc_energy_tvf x9 on (EXTEND (x8.spc_energy_tef_localcol ,year to second) = EXTEND (x9.spc_energy_tvf_localcol ,year to second) ) )
union select x10.skm_energy_tef_localcol ,TO_CHAR (round(x10.tef_1_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x10.tef_2_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x10.tef_3_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x10.tef_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'NA' ,TO_CHAR (round(x11.tvf_1_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x11.tvf_2_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x11.tvf_3_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x11.tvf_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'SKM' ,'Corridor2' from ("informix".skm_energy_tef x10 join "informix".skm_energy_tvf x11 on (EXTEND (x10.skm_energy_tef_localcol ,year to second) = EXTEND (x11.skm_energy_tvf_localcol ,year to second) ) )
union select x12.snp_energy_tef_localcol ,TO_CHAR (round(x12.tef_1_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x12.tef_2_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x12.tef_3_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x12.tef_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'NA' ,TO_CHAR (round(x13.tvf_1_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x13.tvf_2_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x13.tvf_3_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x13.tvf_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'SNP' ,'Corridor2' from ("informix".snp_energy_tef x12 join "informix".snp_energy_tvf x13 on (EXTEND (x12.snp_energy_tef_localcol ,year to second) = EXTEND (x13.snp_energy_tvf_localcol ,year to second) ) )
union select x14.seg_energy_tef_localcol ,TO_CHAR (round(x14.tef_1_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x14.tef_2_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x14.tef_3_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x14.tef_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'NA' ,TO_CHAR (round(x15.tvf_1_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x15.tvf_2_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x15.tvf_3_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x15.tvf_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'SEG' ,'Corridor2' from ("informix".seg_energy_tef x14 join "informix".seg_energy_tvf x15 on (EXTEND (x14.seg_energy_tef_localcol ,year to second) = EXTEND (x15.seg_energy_tvf_localcol ,year to second) ) )
union select x16.ssa_energy_tef_localcol ,TO_CHAR (round(x16.tef_1_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x16.tef_2_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x16.tef_3_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x16.tef_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'NA' ,TO_CHAR (round(x17.tvf_1_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x17.tvf_2_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x17.tvf_3_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x17.tvf_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'SSA' ,'Corridor1' from ("informix".ssa_energy_tef x16 join "informix".ssa_energy_tvf x17 on (EXTEND (x16.ssa_energy_tef_localcol ,year to second) = EXTEND (x17.ssa_energy_tvf_localcol ,year to second) ) )
union select x18.scr_energy_tef_localcol ,TO_CHAR (round(x18.tef_1_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x18.tef_2_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x18.tef_3_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x18.tef_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'NA' ,TO_CHAR (round(x19.tvf_1_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x19.tvf_2_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x19.tvf_3_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x19.tvf_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'SCR' ,'Corridor1' from ("informix".scr_energy_tef x18 join "informix".scr_energy_tvf x19 on (EXTEND (x18.scr_energy_tef_localcol ,year to second) = EXTEND (x19.scr_energy_tvf_localcol ,year to second) ) )
union select x20.ste_energy_tef_localcol ,TO_CHAR (round(x20.tef_1_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x20.tef_2_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x20.tef_3_fan_vibrationmm_mm_per_s , 1 ) ),TO_CHAR (round(x20.tef_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'NA' ,TO_CHAR (round(x21.tvf_1_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x21.tvf_2_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x21.tvf_3_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x21.tvf_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'STE' ,'Corridor1' from ("informix".ste_energy_tef x20 join "informix".ste_energy_tvf x21 on (EXTEND (x20.ste_energy_tef_localcol ,year to second) = EXTEND (x21.ste_energy_tvf_localcol ,year to second) ) )
union select x22.sgm_energy_tef_localcol ,TO_CHAR (round(x22.tef_1_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x22.tef_2_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x22.tef_3_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x22.tef_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'NA' ,TO_CHAR (round(x23.tvf_1_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x23.tvf_2_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x23.tvf_3_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x23.tvf_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'SGM' ,'Corridor1' from ("informix".sgm_energy_tef x22 join "informix".sgm_energy_tvf x23 on (EXTEND (x22.sgm_energy_tef_localcol ,year to second) = EXTEND (x23.sgm_energy_tvf_localcol ,year to second) ) )
union select x24.stl_energy_tef_localcol ,TO_CHAR (round(x24.tef_1_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x24.tef_2_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x24.tef_3_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x24.tef_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'NA' ,TO_CHAR (round(x25.tvf_1_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x25.tvf_2_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x25.tvf_3_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x25.tvf_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'STL' ,'Corridor1' from ("informix".stl_energy_tef x24 join "informix".stl_energy_tvf x25 on (EXTEND (x24.stl_energy_tef_localcol ,year to second) = EXTEND (x25.stl_energy_tvf_localcol ,year to second) ) )
union select x26.sli_energy_tef_localcol ,TO_CHAR (round(x26.tef_1_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x26.tef_2_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x26.tef_3_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x26.tef_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'NA' ,TO_CHAR (round(x27.tvf_1_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x27.tvf_2_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x27.tvf_3_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x27.tvf_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'SLI' ,'Corridor1' from ("informix".sli_energy_tef x26 join "informix".sli_energy_tvf x27 on (EXTEND (x26.sli_energy_tef_localcol ,year to second) = EXTEND (x27.sli_energy_tvf_localcol ,year to second) ) )
union select x28.sge_energy_tef_localcol ,TO_CHAR (round(x28.tef_1_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x28.tef_2_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x28.tef_3_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x28.tef_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'NA' ,TO_CHAR (round(x29.tvf_1_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x29.tvf_2_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x29.tvf_3_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x29.tvf_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'SGE' ,'Corridor1' from ("informix".sge_energy_tef x28 join "informix".sge_energy_tvf x29 on (EXTEND (x28.sge_energy_tef_localcol ,year to second) = EXTEND (x29.sge_energy_tvf_localcol ,year to second) ) )
union select x30.scc_c1_energy_tef_localcol ,TO_CHAR (round(x30.tef_1_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x30.tef_2_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x30.tef_3_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x30.tef_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'NA' ,TO_CHAR (round(x31.tvf_1_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x31.tvf_2_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x31.tvf_3_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x31.tvf_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'SCC_C1' ,'Corridor1' from ("informix".scc_c1_energy_tef x30 join "informix".scc_c1_energy_tvf x31 on (EXTEND (x30.scc_c1_energy_tef_localcol ,year to second) = EXTEND (x31.scc_c1_energy_tvf_localcol ,year to second) ) )
union select x32.shc_energy_tef_localcol ,TO_CHAR (round(x32.tef_1_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x32.tef_2_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x32.tef_3_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x32.tef_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'NA' ,TO_CHAR (round(x33.tvf_1_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x33.tvf_2_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x33.tvf_3_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x33.tvf_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'SHC' ,'Corridor1' from ("informix".shc_energy_tef x32 join "informix".shc_energy_tvf x33 on (EXTEND (x32.shc_energy_tef_localcol ,year to second) = EXTEND (x33.shc_energy_tvf_localcol ,year to second) ) )
union select x34.swa_energy_tef_localcol ,TO_CHAR (round(x34.tef_1_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x34.tef_2_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x34.tef_3_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x34.tef_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'NA' ,TO_CHAR (round(x35.tvf_1_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x35.tvf_2_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x35.tvf_3_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x35.tvf_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'SWA' ,'Corridor1' from ("informix".swa_energy_tef x34 join "informix".swa_energy_tvf x35 on (EXTEND (x34.swa_energy_tef_localcol ,year to second) = EXTEND (x35.swa_energy_tvf_localcol ,year to second) ) )
union select x36.stc_energy_tvf_localcol ,'NA' ,'NA' ,'NA' ,'NA' ,'NA' ,'NA' ,'NA' ,'NA' ,TO_CHAR (round(x36.tvf_1_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x36.tvf_2_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x36.tvf_3_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x36.tvf_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'STC' ,'Corridor1' from "informix".stc_energy_tvf x36
union select x37.str_energy_tvf_localcol ,'NA' ,'NA' ,'NA' ,'NA' ,'NA' ,'NA' ,'NA' ,'NA' ,TO_CHAR (round(x37.tvf_1_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x37.tvf_2_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x37.tvf_3_fan_vibration_mm_per_s , 1 ) ),'NA' ,TO_CHAR (round(x37.tvf_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'STR' ,'Corridor1' from "informix".str_energy_tvf x37
union select x38.sma_energy_tef_localcol ,TO_CHAR (round(x38.tef_1_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x38.tef_2_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x38.tef_3_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x38.tef_4_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'NA' ,TO_CHAR (round(x39.tvf_1_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x39.tvf_1a_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x39.tvf_2_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x39.tvf_2a_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x39.tvf_3_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x39.tvf_3a_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x39.tvf_4_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x39.tvf_4a_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'SMA' ,'Corridor1' from ("informix".sma_energy_tef x38 join "informix".sma_energy_tvf x39 on (EXTEND (x38.sma_energy_tef_localcol ,year to second) = EXTEND (x39.sma_energy_tvf_localcol ,year to second) ) )
union select x40.scc_c2_energy_tef_localcol ,'NA' ,'NA' ,'NA' ,'NA' ,TO_CHAR (round(x40.tef_5_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x40.tef_6_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x40.tef_7_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x40.tef_8_fan_vibration_mm_per_s , 1 ) ),'NA' ,'NA' ,'NA' ,'NA' ,'NA' ,'NA' ,'NA' ,'NA' ,TO_CHAR (round(x41.tvf_5_fan_vibration_mm_per_s , 1 ) ),TO_CHAR (round(x41.tvf_6_fan_vibration_mm_per_s , 1 ) ),'SCC_C2' ,'Corridor2' from ("informix".scc_c2_energy_tef x40 join "informix".scc_c2_energy_tvf x41 on (EXTEND (x40.scc_c2_energy_tef_localcol ,year to second) = EXTEND (x41.scc_c2_energy_tvf_localcol ,year to second) ) ); Пожалуйста, помогите мне решить эту проблему.
Комментарии:
1. Также должен быть дополнительный номер ошибки «ISAM». Это может дать некоторое представление. Возможно, вам не хватает места во временных пространствах баз данных или в основной
/tmpфайловой системе (которая может совпадать с корневой файловой системой). Скорее всего, это проблема с дисковым пространством, а не проблема с памятью. Если мы собираемся помочь решить эту проблему, вам потребуется предоставить гораздо больше информации о вашей настройке. Вы хоть представляете, сколько данных вы сортируете?2. Я предполагаю, что «выполнить представление» означает «выполнить запрос с использованием (ссылки) представления». В какой-то момент может потребоваться просмотреть определение представления и запрос, который вы выполняете для представления. Однако в краткосрочной перспективе, вероятно, более уместно взглянуть на ваше дисковое пространство в системе.
3. спасибо за ваш вклад. Я обновил вопрос.
4. Поскольку в представлении используется «объединение», я считаю, что для удаления любых дубликатов требуется своего рода все, что возвращается каждым выбором. Я бы предложил отслеживать пространство, в котором сервер выполняет сортировку, чтобы увидеть, не заканчивается ли у него место. Если сортировка происходит в пространстве, настроенном сервером, это будут фрагменты для пространств баз данных, перечисленных в DBSPACETEMP, из файла $ONCONFIG (поэтому контролируйте свободное пространство с помощью onstat-d во время выполнения запроса). Если не используется пространство, настроенное для базы данных, я полагаю, что оно затем использует пространство файловой системы Windows и по умолчанию C:TEMP.
5. мой файл Informix Tempdbs имеет размер всего 57 МБ. Поэтому я создал отдельное пространство базы данных tempdb объемом 300 МБ и обновил его также в файле ONCONFIG. Теперь я могу выполнить запрос без каких-либо проблем. Спасибо за поддержку.