Reversion 11.70 to 11.50

Posted in 2013

Summary

Frank was reverting IDS 11.70.FC7 to 11.50.FC8 on RHEL5, and the revertibility check listed ~100 tables with outstanding in-place ALTERs that had to be cleared with dummy updates (UPDATE tab SET col = col WHERE 1=1). He asked how to identify which specific columns needed updating. Art Kagel and Alexandre Marini answered that only the table list matters, not particular columns: updating any single column to itself rewrites all rows on each page to the current schema version. Art added that, for speed, choose a column that is not indexed (and not part of the primary key) so index pages don't have to be updated. Frank thanked them; no further issues reported.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: Migration, Import/Export & Data Conversion, Platform-Specific Issues, Versions, Editions & End-of-Life

FRANK — Tue, 19 Nov 2013 16:31:51 — source: IIUG Forums & Mailing Lists

Hi, Folks, I am reverting IDS11.70 FC7 back to 11.50FC8. Linux redhat 5 Lot of outstanding in-place Alters need be handled first( see below) Some tables have many columns , not sure which columns need dummy- update. Any idea to have a fast script/SQL to find these outstanding columns? Thanks, Frank Database noaa is not revertible ... Checking database noaa_ansi for revertibility ... Database noaa_ansi is revertible ... The following tables have issues that are blocking reversion. Tables with In-Place Alter. Perform UPDATE {table-name} SET {colname} = {colname} WHERE 1=1; Refer to the section on dummy updates in the Migration guide for more details. noaa:"informix".xref_ds_np_doc - oustanding In-Place-Alter noaa:"informix".xref_ds_np_pkg - oustanding In-Place-Alter noaa:"informix".xref_dtvers - oustanding In-Place-Alter noaa:"informix".xref_np_auxanc - oustanding In-Place-Alter noaa:"informix".aip_info - oustanding In-Place-Alter noaa:"informix".orbits - oustanding In-Place-Alter noaa:"informix".ds_variablearea - oustanding In-Place-Alter noaa:"informix".gvar_details - oustanding In-Place-Alter noaa:"informix".nes_transactions - oustanding In-Place-Alter noaa:"informix".aip_inv_modis - oustanding In-Place-Alter noaa:"informix".aip_inv_modis_io - oustanding In-Place-Alter noaa:"informix".aip_inv_orbits - oustanding In-Place-Alter noaa:"informix".aip_file_info - oustanding In-Place-Alter noaa:"informix".xref_aip_inv_modis - oustanding In-Place-Alter noaa:"informix".xref_ds_orbital - oustanding In-Place-Alter noaa:"informix".rsat_source_chksum - oustanding In-Place-Alter noaa:"informix".file_inv_chksum - oustanding In-Place-Alter noaa:"informix".aip_inv_iasi1c - oustanding In-Place-Alter noaa:"informix".xref_aip_iasi1c - oustanding In-Place-Alter noaa:"informix".aip_inv_iasi3x3 - oustanding In-Place-Alter noaa:"informix".xref_aip_iasi3x3 - oustanding In-Place-Alter noaa:"informix".xref_ds_fixed_area - oustanding In-Place-Alter noaa:"informix".aip_inv_gen - oustanding In-Place-Alter noaa:"informix".xref_aip_gen - oustanding In-Place-Alter noaa:"informix".xref_ds_head - oustanding In-Place-Alter noaa:"informix".desc_msgs - oustanding In-Place-Alter noaa:"informix".ing_act_summ_refs - oustanding In-Place-Alter noaa:"informix".bad_file_rcpt_info - oustanding In-Place-Alter noaa:"informix".bad_dataset_info - oustanding In-Place-Alter noaa:"informix".bad_file_info - oustanding In-Place-Alter noaa:"informix".order - oustanding In-Place-Alter noaa:"informix".ord_channel_res - oustanding In-Place-Alter noaa:"informix".ord_comments - oustanding In-Place-Alter noaa:"informix".ds_np_gran_nv - oustanding In-Place-Alter noaa:"informix".reconcile_data - oustanding In-Place-Alter noaa:"informix".xref_aip_track - oustanding In-Place-Alter noaa:"informix".xref_ds_track - oustanding In-Place-Alter noaa:"informix".ds_np_doc - oustanding In-Place-Alter noaa:"informix".ds_np_agg - oustanding In-Place-Alter noaa:"informix".aip_inv_pkg_np - oustanding In-Place-Alter noaa:"informix".sub_manifest - oustanding In-Place-Alter noaa:"informix".vis_files_np - oustanding In-Place-Alter noaa:"informix".ds_np_fxd_tile - oustanding In-Place-Alter noaa:"informix".ds_np_fxd_tile_nv - oustanding In-Place-Alter noaa:"informix".ds_quality_fxd_np - oustanding In-Place-Alter noaa:"informix".ds_jg - oustanding In-Place-Alter noaa:"informix".ds_jg_auxanc - oustanding In-Place-Alter noaa:"informix".ds_quality_jg - oustanding In-Place-Alter noaa:"informix".ds_chksum_jg - oustanding In-Place-Alter noaa:"informix".file_inv_chksum_jg - oustanding In-Place-Alter noaa:"informix".ds_fxd_nr - oustanding In-Place-Alter noaa:"informix".ds_quality_nr - oustanding In-Place-Alter noaa:"informix".ds_chksum_nr - oustanding In-Place-Alter noaa:"informix".m2m_id_map - oustanding In-Place-Alter noaa:"informix".cman_act_deliv - oustanding In-Place-Alter noaa:"informix".cman_act_temp - oustanding In-Place-Alter noaa:"informix".cman_cat_deliv - oustanding In-Place-Alter noaa:"informix".dataset_info - oustanding In-Place-Alter noaa:"informix".ds_np_gran - oustanding In-Place-Alter noaa:"informix".ds_tar_contents - oustanding In-Place-Alter noaa:"informix".file_change_notice - oustanding In-Place-Alter noaa:"informix".file_locator - oustanding In-Place-Alter noaa:"informix".file_met - oustanding In-Place-Alter noaa:"informix".file_set - oustanding In-Place-Alter noaa:"informix".inv_ingest_log - oustanding In-Place-Alter noaa:"informix".lin_dip - oustanding In-Place-Alter noaa:"informix".lin_status - oustanding In-Place-Alter noaa:"informix".lin_source - oustanding In-Place-Alter noaa:"informix".lin_trans - oustanding In-Place-Alter noaa:"informix".line_item - oustanding In-Place-Alter noaa:"informix".ord_email - oustanding In-Place-Alter noaa:"informix".order_xrefs - oustanding In-Place-Alter noaa:"informix".retransmit_info - oustanding In-Place-Alter noaa:"informix".recall_que - oustanding In-Place-Alter noaa:"informix".retransmit_req - oustanding In-Place-Alter noaa:"informix".rmt_path_update - oustanding In-Place-Alter noaa:"informix".xref_aip_pkg_np - oustanding In-Place-Alter noaa:"informix".xref_ds_np_datprod - oustanding In-Place-Alter noaa:"informix".arch_recall_reqs - oustanding In-Place-Alter noaa:"informix".file_receipt_info - oustanding In-Place-Alter noaa:"informix".inv_source - oustanding In-Place-Alter noaa:"informix".rmt_activity_status - oustanding In-Place-Alter noaa:"informix".activity_status - oustanding In-Place-Alter noaa:"informix".oc_details - oustanding In-Place-Alter noaa:"informix".ds_orbital - oustanding In-Place-Alter noaa:"informix".vis_files - oustanding In-Place-Alter noaa:"informix".stat_correct - oustanding In-Place-Alter noaa:"informix".survey_resp - oustanding In-Place-Alter noaa:"informix".ds_np_orbits - oustanding In-Place-Alter noaa:"informix".ds_np_auxanc - oustanding In-Place-Alter noaa:"informix".ds_chksum_np - oustanding In-Place-Alter noaa:"informix".ds_quality_np - oustanding In-Place-Alter noaa:"informix".file_inv_chksum_np - oustanding In-Place-Alter noaa:"informix".ds_track - oustanding In-Place-Alter noaa:"informix".ds_cycle_pass - oustanding In-Place-Alter noaa:"informix".aip_cycle_pass - oustanding In-Place-Alter noaa:"informix".ds_np_pkg - oustanding In-Place-Alter noaa:"informix".order_spec - oustanding In-Place-Alter

↪ replying to FRANK

Art Kagel — Tue, 19 Nov 2013 16:36:24 — source: IIUG Forums & Mailing Lists

You don't need to know which columns need updating, just which tables. Any dummy update of any column in the table will cause all of the rows on a page to be rewritten using the newest version of the schema. So, just pick any column that isn't a primary key column and update it to itself. Art Art S. Kagel, Principal Consultant Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Nov 19, 2013 at 11:31 AM, FRANK <yunyaoqu@gmail.com> wrote: > Hi, Folks, > > I am reverting IDS11.70 FC7 back to 11.50FC8. Linux redhat 5 > > Lot of outstanding in-place Alters need be handled first( see below) > > Some tables have many columns , not sure which columns need dummy- update. > > Any idea to have a fast script/SQL to find these outstanding columns? > > Thanks, > Frank > > Database noaa is not revertible ... > Checking database noaa_ansi for revertibility ... > Database noaa_ansi is revertible ... > The following tables have issues that are blocking reversion. > Tables with In-Place Alter. Perform > > UPDATE {table-name} SET {colname} = {colname} WHERE 1=1; > Refer to the section on dummy updates in the Migration guide for more > details. > noaa:"informix".xref_ds_np_doc - oustanding In-Place-Alter > noaa:"informix".xref_ds_np_pkg - oustanding In-Place-Alter > noaa:"informix".xref_dtvers - oustanding In-Place-Alter > noaa:"informix".xref_np_auxanc - oustanding In-Place-Alter > noaa:"informix".aip_info - oustanding In-Place-Alter > noaa:"informix".orbits - oustanding In-Place-Alter > noaa:"informix".ds_variablearea - oustanding In-Place-Alter > noaa:"informix".gvar_details - oustanding In-Place-Alter > noaa:"informix".nes_transactions - oustanding In-Place-Alter > noaa:"informix".aip_inv_modis - oustanding In-Place-Alter > noaa:"informix".aip_inv_modis_io - oustanding In-Place-Alter > noaa:"informix".aip_inv_orbits - oustanding In-Place-Alter > noaa:"informix".aip_file_info - oustanding In-Place-Alter > noaa:"informix".xref_aip_inv_modis - oustanding In-Place-Alter > noaa:"informix".xref_ds_orbital - oustanding In-Place-Alter > noaa:"informix".rsat_source_chksum - oustanding In-Place-Alter > noaa:"informix".file_inv_chksum - oustanding In-Place-Alter > noaa:"informix".aip_inv_iasi1c - oustanding In-Place-Alter > noaa:"informix".xref_aip_iasi1c - oustanding In-Place-Alter > noaa:"informix".aip_inv_iasi3x3 - oustanding In-Place-Alter > noaa:"informix".xref_aip_iasi3x3 - oustanding In-Place-Alter > noaa:"informix".xref_ds_fixed_area - oustanding In-Place-Alter > noaa:"informix".aip_inv_gen - oustanding In-Place-Alter > noaa:"informix".xref_aip_gen - oustanding In-Place-Alter > noaa:"informix".xref_ds_head - oustanding In-Place-Alter > noaa:"informix".desc_msgs - oustanding In-Place-Alter > noaa:"informix".ing_act_summ_refs - oustanding In-Place-Alter > noaa:"informix".bad_file_rcpt_info - oustanding In-Place-Alter > noaa:"informix".bad_dataset_info - oustanding In-Place-Alter > noaa:"informix".bad_file_info - oustanding In-Place-Alter > noaa:"informix".order - oustanding In-Place-Alter > noaa:"informix".ord_channel_res - oustanding In-Place-Alter > noaa:"informix".ord_comments - oustanding In-Place-Alter > noaa:"informix".ds_np_gran_nv - oustanding In-Place-Alter > noaa:"informix".reconcile_data - oustanding In-Place-Alter > noaa:"informix".xref_aip_track - oustanding In-Place-Alter > noaa:"informix".xref_ds_track - oustanding In-Place-Alter > noaa:"informix".ds_np_doc - oustanding In-Place-Alter > noaa:"informix".ds_np_agg - oustanding In-Place-Alter > noaa:"informix".aip_inv_pkg_np - oustanding In-Place-Alter > noaa:"informix".sub_manifest - oustanding In-Place-Alter > noaa:"informix".vis_files_np - oustanding In-Place-Alter > noaa:"informix".ds_np_fxd_tile - oustanding In-Place-Alter > noaa:"informix".ds_np_fxd_tile_nv - oustanding In-Place-Alter > noaa:"informix".ds_quality_fxd_np - oustanding In-Place-Alter > noaa:"informix".ds_jg - oustanding In-Place-Alter > noaa:"informix".ds_jg_auxanc - oustanding In-Place-Alter > noaa:"informix".ds_quality_jg - oustanding In-Place-Alter > noaa:"informix".ds_chksum_jg - oustanding In-Place-Alter > noaa:"informix".file_inv_chksum_jg - oustanding In-Place-Alter > noaa:"informix".ds_fxd_nr - oustanding In-Place-Alter > noaa:"informix".ds_quality_nr - oustanding In-Place-Alter > noaa:"informix".ds_chksum_nr - oustanding In-Place-Alter > noaa:"informix".m2m_id_map - oustanding In-Place-Alter > noaa:"informix".cman_act_deliv - oustanding In-Place-Alter > noaa:"informix".cman_act_temp - oustanding In-Place-Alter > noaa:"informix".cman_cat_deliv - oustanding In-Place-Alter > noaa:"informix".dataset_info - oustanding In-Place-Alter > noaa:"informix".ds_np_gran - oustanding In-Place-Alter > noaa:"informix".ds_tar_contents - oustanding In-Place-Alter > noaa:"informix".file_change_notice - oustanding In-Place-Alter > noaa:"informix".file_locator - oustanding In-Place-Alter > noaa:"informix".file_met - oustanding In-Place-Alter > noaa:"informix".file_set - oustanding In-Place-Alter > noaa:"informix".inv_ingest_log - oustanding In-Place-Alter > noaa:"informix".lin_dip - oustanding In-Place-Alter > noaa:"informix".lin_status - oustanding In-Place-Alter > noaa:"informix".lin_source - oustanding In-Place-Alter > noaa:"informix".lin_trans - oustanding In-Place-Alter > noaa:"informix".line_item - oustanding In-Place-Alter > noaa:"informix".ord_email - oustanding In-Place-Alter > noaa:"informix".order_xrefs - oustanding In-Place-Alter > noaa:"informix".retransmit_info - oustanding In-Place-Alter > noaa:"informix".recall_que - oustanding In-Place-Alter > noaa:"informix".retransmit_req - oustanding In-Place-Alter > noaa:"informix".rmt_path_update - oustanding In-Place-Alter > noaa:"informix".xref_aip_pkg_np - oustanding In-Place-Alter > noaa:"informix".xref_ds_np_datprod - oustanding In-Place-Alter > noaa:"informix".arch_recall_reqs - oustanding In-Place-Alter > noaa:"informix".file_receipt_info - oustanding In-Place-Alter > noaa:"informix".inv_source - oustanding In-Place-Alter > noaa:"informix".rmt_

↪ replying to FRANK

Art Kagel — Tue, 19 Nov 2013 16:37:40 — source: IIUG Forums & Mailing Lists

Oh, for performance reasons, best to do the dummy update on a column that is not indexed at all so that index nodes do not need to be updated. Art Art S. Kagel, Principal Consultant Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Nov 19, 2013 at 11:35 AM, Art Kagel <art.kagel@gmail.com> wrote: > You don't need to know which columns need updating, just which tables. > Any dummy update of any column in the table will cause all of the rows on > a page to be rewritten using the newest version of the schema. So, just > pick any column that isn't a primary key column and update it to itself. > > Art > > > Art S. Kagel, Principal Consultant > > Advanced DataTools (www.advancedatatools.com) > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on my employer, Advanced DataTools, the IIUG, nor any > other organization with which I am associated either explicitly, > implicitly, or by inference. Neither do those opinions reflect those of > other individuals affiliated with any entity with which I am affiliated nor > those of the entities themselves. > > > On Tue, Nov 19, 2013 at 11:31 AM, FRANK <yunyaoqu@gmail.com> wrote: > >> Hi, Folks, >> >> I am reverting IDS11.70 FC7 back to 11.50FC8. Linux redhat 5 >> >> Lot of outstanding in-place Alters need be handled first( see below) >> >> Some tables have many columns , not sure which columns need dummy- update. >> >> Any idea to have a fast script/SQL to find these outstanding columns? >> >> Thanks, >> Frank >> >> Database noaa is not revertible ... >> Checking database noaa_ansi for revertibility ... >> Database noaa_ansi is revertible ... >> The following tables have issues that are blocking reversion. >> Tables with In-Place Alter. Perform >> >> UPDATE {table-name} SET {colname} = {colname} WHERE 1=1; >> Refer to the section on dummy updates in the Migration guide for more >> details. >> noaa:"informix".xref_ds_np_doc - oustanding In-Place-Alter >> noaa:"informix".xref_ds_np_pkg - oustanding In-Place-Alter >> noaa:"informix".xref_dtvers - oustanding In-Place-Alter >> noaa:"informix".xref_np_auxanc - oustanding In-Place-Alter >> noaa:"informix".aip_info - oustanding In-Place-Alter >> noaa:"informix".orbits - oustanding In-Place-Alter >> noaa:"informix".ds_variablearea - oustanding In-Place-Alter >> noaa:"informix".gvar_details - oustanding In-Place-Alter >> noaa:"informix".nes_transactions - oustanding In-Place-Alter >> noaa:"informix".aip_inv_modis - oustanding In-Place-Alter >> noaa:"informix".aip_inv_modis_io - oustanding In-Place-Alter >> noaa:"informix".aip_inv_orbits - oustanding In-Place-Alter >> noaa:"informix".aip_file_info - oustanding In-Place-Alter >> noaa:"informix".xref_aip_inv_modis - oustanding In-Place-Alter >> noaa:"informix".xref_ds_orbital - oustanding In-Place-Alter >> noaa:"informix".rsat_source_chksum - oustanding In-Place-Alter >> noaa:"informix".file_inv_chksum - oustanding In-Place-Alter >> noaa:"informix".aip_inv_iasi1c - oustanding In-Place-Alter >> noaa:"informix".xref_aip_iasi1c - oustanding In-Place-Alter >> noaa:"informix".aip_inv_iasi3x3 - oustanding In-Place-Alter >> noaa:"informix".xref_aip_iasi3x3 - oustanding In-Place-Alter >> noaa:"informix".xref_ds_fixed_area - oustanding In-Place-Alter >> noaa:"informix".aip_inv_gen - oustanding In-Place-Alter >> noaa:"informix".xref_aip_gen - oustanding In-Place-Alter >> noaa:"informix".xref_ds_head - oustanding In-Place-Alter >> noaa:"informix".desc_msgs - oustanding In-Place-Alter >> noaa:"informix".ing_act_summ_refs - oustanding In-Place-Alter >> noaa:"informix".bad_file_rcpt_info - oustanding In-Place-Alter >> noaa:"informix".bad_dataset_info - oustanding In-Place-Alter >> noaa:"informix".bad_file_info - oustanding In-Place-Alter >> noaa:"informix".order - oustanding In-Place-Alter >> noaa:"informix".ord_channel_res - oustanding In-Place-Alter >> noaa:"informix".ord_comments - oustanding In-Place-Alter >> noaa:"informix".ds_np_gran_nv - oustanding In-Place-Alter >> noaa:"informix".reconcile_data - oustanding In-Place-Alter >> noaa:"informix".xref_aip_track - oustanding In-Place-Alter >> noaa:"informix".xref_ds_track - oustanding In-Place-Alter >> noaa:"informix".ds_np_doc - oustanding In-Place-Alter >> noaa:"informix".ds_np_agg - oustanding In-Place-Alter >> noaa:"informix".aip_inv_pkg_np - oustanding In-Place-Alter >> noaa:"informix".sub_manifest - oustanding In-Place-Alter >> noaa:"informix".vis_files_np - oustanding In-Place-Alter >> noaa:"informix".ds_np_fxd_tile - oustanding In-Place-Alter >> noaa:"informix".ds_np_fxd_tile_nv - oustanding In-Place-Alter >> noaa:"informix".ds_quality_fxd_np - oustanding In-Place-Alter >> noaa:"informix".ds_jg - oustanding In-Place-Alter >> noaa:"informix".ds_jg_auxanc - oustanding In-Place-Alter >> noaa:"informix".ds_quality_jg - oustanding In-Place-Alter >> noaa:"informix".ds_chksum_jg - oustanding In-Place-Alter >> noaa:"informix".file_inv_chksum_jg - oustanding In-Place-Alter >> noaa:"informix".ds_fxd_nr - oustanding In-Place-Alter >> noaa:"informix".ds_quality_nr - oustanding In-Place-Alter >> noaa:"informix".ds_chksum_nr - oustanding In-Place-Alter >> noaa:"informix".m2m_id_map - oustanding In-Place-Alter >> noaa:"informix".cman_act_deliv - oustanding In-Place-Alter >> noaa:"informix".cman_act_temp - oustanding In-Place-Alter >> noaa:"informix".cman_cat_deliv - oustanding In-Place-Alter >> noaa:"informix".dataset_info - oustanding In-Place-Alter >> noaa:"informix".ds_np_gran - oustanding In-Place-Alter >> noaa:"informix".ds_tar_contents - oustanding In-Place-Alter >> noaa:"informix".file_change_notice - oustanding In-Place-Alter >> noaa:"informix".file_locator - oustanding In-Place-Alter >> noaa:"informix".file_met - oustanding In-Place-Alter >> noaa:"informix".file_set - oustanding In-Place-Alter >> noaa:"informix".inv_ingest_log - oustanding In-Place-Alter >> noaa:"informix".lin_dip - oustanding In-Place-Alter >> noaa:"informix".lin_status - oustanding In-Place-Alter >> noaa:"informix".lin_source - oustanding In-Place-Alter >> noaa:"informix"

↪ replying to FRANK

Alexandre Marini — Tue, 19 Nov 2013 16:40:46 — source: IIUG Forums & Mailing Lists

Hello. When the engine mention "in-place-alters", it means there are different data page versions, for each table mentioned. You must do exactly what it says, for each of the tables on the list. You don´t have to run an update in all/some specific columns. Just take one field from the primary key, for example, and update 1=1 will do the trick for you. Hope it helps. Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional Informix Senior DBA - Orizon Brasil BRIUG website administrator Informix independent consultant > To: ids@iiug.org > From: yunyaoqu@gmail.com > Subject: Reversion 11.70 to 11.50 [31970] > Date: Tue, 19 Nov 2013 11:31:52 -0500 > > Hi, Folks, > > I am reverting IDS11.70 FC7 back to 11.50FC8. Linux redhat 5 > > Lot of outstanding in-place Alters need be handled first( see below) > > Some tables have many columns , not sure which columns need dummy- update. > > Any idea to have a fast script/SQL to find these outstanding columns? > > Thanks, > Frank > > Database noaa is not revertible ... > Checking database noaa_ansi for revertibility ... > Database noaa_ansi is revertible ... > The following tables have issues that are blocking reversion. > Tables with In-Place Alter. Perform > > UPDATE {table-name} SET {colname} = {colname} WHERE 1=1; > Refer to the section on dummy updates in the Migration guide for more > details. > noaa:"informix".xref_ds_np_doc - oustanding In-Place-Alter > noaa:"informix".xref_ds_np_pkg - oustanding In-Place-Alter > noaa:"informix".xref_dtvers - oustanding In-Place-Alter > noaa:"informix".xref_np_auxanc - oustanding In-Place-Alter > noaa:"informix".aip_info - oustanding In-Place-Alter > noaa:"informix".orbits - oustanding In-Place-Alter > noaa:"informix".ds_variablearea - oustanding In-Place-Alter > noaa:"informix".gvar_details - oustanding In-Place-Alter > noaa:"informix".nes_transactions - oustanding In-Place-Alter > noaa:"informix".aip_inv_modis - oustanding In-Place-Alter > noaa:"informix".aip_inv_modis_io - oustanding In-Place-Alter > noaa:"informix".aip_inv_orbits - oustanding In-Place-Alter > noaa:"informix".aip_file_info - oustanding In-Place-Alter > noaa:"informix".xref_aip_inv_modis - oustanding In-Place-Alter > noaa:"informix".xref_ds_orbital - oustanding In-Place-Alter > noaa:"informix".rsat_source_chksum - oustanding In-Place-Alter > noaa:"informix".file_inv_chksum - oustanding In-Place-Alter > noaa:"informix".aip_inv_iasi1c - oustanding In-Place-Alter > noaa:"informix".xref_aip_iasi1c - oustanding In-Place-Alter > noaa:"informix".aip_inv_iasi3x3 - oustanding In-Place-Alter > noaa:"informix".xref_aip_iasi3x3 - oustanding In-Place-Alter > noaa:"informix".xref_ds_fixed_area - oustanding In-Place-Alter > noaa:"informix".aip_inv_gen - oustanding In-Place-Alter > noaa:"informix".xref_aip_gen - oustanding In-Place-Alter > noaa:"informix".xref_ds_head - oustanding In-Place-Alter > noaa:"informix".desc_msgs - oustanding In-Place-Alter > noaa:"informix".ing_act_summ_refs - oustanding In-Place-Alter > noaa:"informix".bad_file_rcpt_info - oustanding In-Place-Alter > noaa:"informix".bad_dataset_info - oustanding In-Place-Alter > noaa:"informix".bad_file_info - oustanding In-Place-Alter > noaa:"informix".order - oustanding In-Place-Alter > noaa:"informix".ord_channel_res - oustanding In-Place-Alter > noaa:"informix".ord_comments - oustanding In-Place-Alter > noaa:"informix".ds_np_gran_nv - oustanding In-Place-Alter > noaa:"informix".reconcile_data - oustanding In-Place-Alter > noaa:"informix".xref_aip_track - oustanding In-Place-Alter > noaa:"informix".xref_ds_track - oustanding In-Place-Alter > noaa:"informix".ds_np_doc - oustanding In-Place-Alter > noaa:"informix".ds_np_agg - oustanding In-Place-Alter > noaa:"informix".aip_inv_pkg_np - oustanding In-Place-Alter > noaa:"informix".sub_manifest - oustanding In-Place-Alter > noaa:"informix".vis_files_np - oustanding In-Place-Alter > noaa:"informix".ds_np_fxd_tile - oustanding In-Place-Alter > noaa:"informix".ds_np_fxd_tile_nv - oustanding In-Place-Alter > noaa:"informix".ds_quality_fxd_np - oustanding In-Place-Alter > noaa:"informix".ds_jg - oustanding In-Place-Alter > noaa:"informix".ds_jg_auxanc - oustanding In-Place-Alter > noaa:"informix".ds_quality_jg - oustanding In-Place-Alter > noaa:"informix".ds_chksum_jg - oustanding In-Place-Alter > noaa:"informix".file_inv_chksum_jg - oustanding In-Place-Alter > noaa:"informix".ds_fxd_nr - oustanding In-Place-Alter > noaa:"informix".ds_quality_nr - oustanding In-Place-Alter > noaa:"informix".ds_chksum_nr - oustanding In-Place-Alter > noaa:"informix".m2m_id_map - oustanding In-Place-Alter > noaa:"informix".cman_act_deliv - oustanding In-Place-Alter > noaa:"informix".cman_act_temp - oustanding In-Place-Alter > noaa:"informix".cman_cat_deliv - oustanding In-Place-Alter > noaa:"informix".dataset_info - oustanding In-Place-Alter > noaa:"informix".ds_np_gran - oustanding In-Place-Alter > noaa:"informix".ds_tar_contents - oustanding In-Place-Alter > noaa:"informix".file_change_notice - oustanding In-Place-Alter > noaa:"informix".file_locator - oustanding In-Place-Alter > noaa:"informix".file_met - oustanding In-Place-Alter > noaa:"informix".file_set - oustanding In-Place-Alter > noaa:"informix".inv_ingest_log - oustanding In-Place-Alter > noaa:"informix".lin_dip - oustanding In-Place-Alter > noaa:"informix".lin_status - oustanding In-Place-Alter > noaa:"informix".lin_source - oustanding In-Place-Alter > noaa:"informix".lin_trans - oustanding In-Place-Alter > noaa:"informix".line_item - oustanding In-Place-Alter > noaa:"informix".ord_email - oustanding In-Place-Alter > noaa:"informix".order_xrefs - oustanding In-Place-Alter > noaa:"informix".retransmit_info - oustanding In-Place-Alter > noaa:"informix".recall_que - oustanding In-Place-Alter > noaa:"informix".retransmit_req - oustanding In-Place-Alter > noaa:"informix".rmt_path_update - oustanding In-Place-Alter > noaa:"informix".xref_aip_pkg_np - oustanding In-Place-Alter > noaa:"informix".xref_ds_np_datprod - oustanding In-Place-Alter > noaa:"informix".arch_recall_reqs - oustanding In-Place-Alter > noaa:"informix".file_receipt_info - oustanding In-Place-Alter > noaa:"informix".inv_source - oustanding In-Place-Alter > noaa:"informix".rmt_activity_status - oustanding In-Plac

↪ replying to Art Kagel

FRANK — Tue, 19 Nov 2013 22:37:44 — source: IIUG Forums & Mailing Lists

Thank you Art and Alex ! Frank On Tue, Nov 19, 2013 at 11:37 AM, Art Kagel <art.kagel@gmail.com> wrote: > Oh, for performance reasons, best to do the dummy update on a column that > is not indexed at all so that index nodes do not need to be updated. > > Art > > Art S. Kagel, Principal Consultant > > Advanced DataTools (www.advancedatatools.com) > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on my employer, Advanced DataTools, the IIUG, nor any > other organization with which I am associated either explicitly, > implicitly, or by inference. Neither do those opinions reflect those of > other individuals affiliated with any entity with which I am affiliated nor > those of the entities themselves. > > On Tue, Nov 19, 2013 at 11:35 AM, Art Kagel <art.kagel@gmail.com> wrote: > > > You don't need to know which columns need updating, just which tables. > > Any dummy update of any column in the table will cause all of the rows on > > a page to be rewritten using the newest version of the schema. So, just > > pick any column that isn't a primary key column and update it to itself. > > > > Art > > > > > > Art S. Kagel, Principal Consultant > > > > Advanced DataTools (www.advancedatatools.com) > > Blog: http://informix-myview.blogspot.com/ > > > > Disclaimer: Please keep in mind that my own opinions are my own opinions > > and do not reflect on my employer, Advanced DataTools, the IIUG, nor any > > other organization with which I am associated either explicitly, > > implicitly, or by inference. Neither do those opinions reflect those of > > other individuals affiliated with any entity with which I am affiliated > nor > > those of the entities themselves. > > > > > > On Tue, Nov 19, 2013 at 11:31 AM, FRANK <yunyaoqu@gmail.com> wrote: > > > >> Hi, Folks, > >> > >> I am reverting IDS11.70 FC7 back to 11.50FC8. Linux redhat 5 > >> > >> Lot of outstanding in-place Alters need be handled first( see below) > >> > >> Some tables have many columns , not sure which columns need dummy- > update. > >> > >> Any idea to have a fast script/SQL to find these outstanding columns? > >> > >> Thanks, > >> Frank > >> > >> Database noaa is not revertible ... > >> Checking database noaa_ansi for revertibility ... > >> Database noaa_ansi is revertible ... > >> The following tables have issues that are blocking reversion. > >> Tables with In-Place Alter. Perform > >> > >> UPDATE {table-name} SET {colname} = {colname} WHERE 1=1; > >> Refer to the section on dummy updates in the Migration guide for more > >> details. > >> noaa:"informix".xref_ds_np_doc - oustanding In-Place-Alter > >> noaa:"informix".xref_ds_np_pkg - oustanding In-Place-Alter > >> noaa:"informix".xref_dtvers - oustanding In-Place-Alter > >> noaa:"informix".xref_np_auxanc - oustanding In-Place-Alter > >> noaa:"informix".aip_info - oustanding In-Place-Alter > >> noaa:"informix".orbits - oustanding In-Place-Alter > >> noaa:"informix".ds_variablearea - oustanding In-Place-Alter > >> noaa:"informix".gvar_details - oustanding In-Place-Alter > >> noaa:"informix".nes_transactions - oustanding In-Place-Alter > >> noaa:"informix".aip_inv_modis - oustanding In-Place-Alter > >> noaa:"informix".aip_inv_modis_io - oustanding In-Place-Alter > >> noaa:"informix".aip_inv_orbits - oustanding In-Place-Alter > >> noaa:"informix".aip_file_info - oustanding In-Place-Alter > >> noaa:"informix".xref_aip_inv_modis - oustanding In-Place-Alter > >> noaa:"informix".xref_ds_orbital - oustanding In-Place-Alter > >> noaa:"informix".rsat_source_chksum - oustanding In-Place-Alter > >> noaa:"informix".file_inv_chksum - oustanding In-Place-Alter > >> noaa:"informix".aip_inv_iasi1c - oustanding In-Place-Alter > >> noaa:"informix".xref_aip_iasi1c - oustanding In-Place-Alter > >> noaa:"informix".aip_inv_iasi3x3 - oustanding In-Place-Alter > >> noaa:"informix".xref_aip_iasi3x3 - oustanding In-Place-Alter > >> noaa:"informix".xref_ds_fixed_area - oustanding In-Place-Alter > >> noaa:"informix".aip_inv_gen - oustanding In-Place-Alter > >> noaa:"informix".xref_aip_gen - oustanding In-Place-Alter > >> noaa:"informix".xref_ds_head - oustanding In-Place-Alter > >> noaa:"informix".desc_msgs - oustanding In-Place-Alter > >> noaa:"informix".ing_act_summ_refs - oustanding In-Place-Alter > >> noaa:"informix".bad_file_rcpt_info - oustanding In-Place-Alter > >> noaa:"informix".bad_dataset_info - oustanding In-Place-Alter > >> noaa:"informix".bad_file_info - oustanding In-Place-Alter > >> noaa:"informix".order - oustanding In-Place-Alter > >> noaa:"informix".ord_channel_res - oustanding In-Place-Alter > >> noaa:"informix".ord_comments - oustanding In-Place-Alter > >> noaa:"informix".ds_np_gran_nv - oustanding In-Place-Alter > >> noaa:"informix".reconcile_data - oustanding In-Place-Alter > >> noaa:"informix".xref_aip_track - oustanding In-Place-Alter > >> noaa:"informix".xref_ds_track - oustanding In-Place-Alter > >> noaa:"informix".ds_np_doc - oustanding In-Place-Alter > >> noaa:"informix".ds_np_agg - oustanding In-Place-Alter > >> noaa:"informix".aip_inv_pkg_np - oustanding In-Place-Alter > >> noaa:"informix".sub_manifest - oustanding In-Place-Alter > >> noaa:"informix".vis_files_np - oustanding In-Place-Alter > >> noaa:"informix".ds_np_fxd_tile - oustanding In-Place-Alter > >> noaa:"informix".ds_np_fxd_tile_nv - oustanding In-Place-Alter > >> noaa:"informix".ds_quality_fxd_np - oustanding In-Place-Alter > >> noaa:"informix".ds_jg - oustanding In-Place-Alter > >> noaa:"informix".ds_jg_auxanc - oustanding In-Place-Alter > >> noaa:"informix".ds_quality_jg - oustanding In-Place-Alter > >> noaa:"informix".ds_chksum_jg - oustanding In-Place-Alter > >> noaa:"informix".file_inv_chksum_jg - oustanding In-Place-Alter > >> noaa:"informix".ds_fxd_nr - oustanding In-Place-Alter > >> noaa:"informix".ds_quality_nr - oustanding In-Place-Alter > >> noaa:"informix".ds_chksum_nr - oustanding In-Place-Alter > >> noaa:"informix".m2m_id_map - oustanding In-Place-Alter > >> noaa:"informix".cman_act_deliv - oustanding In-Place-Alter > >> noaa:"informix".cman_act_temp - oustanding In-Place-Alter > >> noaa:"informix".cman_cat_deliv - oustanding In-Place-Alter > >> noaa:"informix".dataset_info - oustanding In-Place-Alter > >> noaa:"informix".ds_np_gran - oustanding In-Place-Alter > >> noaa:"informix".ds_tar_contents - oustanding In-Place-Alter > >> noaa:"informix".file_change_notice - oustanding In-Place-Alter > >> noaa:"informix".file_locator - oustanding In-Place-Alter > >> noaa:"informix".file_met - oustanding In-Place-Alter > >>

↪ replying to FRANK

Deillon Samuel — Tue, 19 Nov 2013 23:08:20 — source: IIUG Forums & Mailing Lists

Hi, Just à curiosity question, what is the reversion reason. We have many performance and stability problems with 11.7 and we work hard to change code and params ... We actualy have many open pmrs. The status is not too bad now. The reversion is an open issue but what to after that for the next upgrade... Regards, Sam > Le 19 nov. 2013 à 17:38, "FRANK" <yunyaoqu@gmail.com> a écrit : > > Thank you Art and Alex ! Frank > >> On Tue, Nov 19, 2013 at 11:37 AM, Art Kagel <art.kagel@gmail.com> wrote: >> >> Oh, for performance reasons, best to do the dummy update on a column that >> is not indexed at all so that index nodes do not need to be updated. >> >> Art >> >> Art S. Kagel, Principal Consultant >> >> Advanced DataTools (www.advancedatatools.com) >> Blog: http://informix-myview.blogspot.com/ >> >> Disclaimer: Please keep in mind that my own opinions are my own opinions >> and do not reflect on my employer, Advanced DataTools, the IIUG, nor any >> other organization with which I am associated either explicitly, >> implicitly, or by inference. Neither do those opinions reflect those of >> other individuals affiliated with any entity with which I am affiliated nor >> those of the entities themselves. >> >>> On Tue, Nov 19, 2013 at 11:35 AM, Art Kagel <art.kagel@gmail.com> wrote: >>> >>> You don't need to know which columns need updating, just which tables. >>> Any dummy update of any column in the table will cause all of the rows on >>> a page to be rewritten using the newest version of the schema. So, just >>> pick any column that isn't a primary key column and update it to itself. >>> >>> Art >>> >>> >>> Art S. Kagel, Principal Consultant >>> >>> Advanced DataTools (www.advancedatatools.com) >>> Blog: http://informix-myview.blogspot.com/ >>> >>> Disclaimer: Please keep in mind that my own opinions are my own opinions >>> and do not reflect on my employer, Advanced DataTools, the IIUG, nor any >>> other organization with which I am associated either explicitly, >>> implicitly, or by inference. Neither do those opinions reflect those of >>> other individuals affiliated with any entity with which I am affiliated >> nor >>> those of the entities themselves. >>> >>> >>>> On Tue, Nov 19, 2013 at 11:31 AM, FRANK <yunyaoqu@gmail.com> wrote: >>>> >>>> Hi, Folks, >>>> >>>> I am reverting IDS11.70 FC7 back to 11.50FC8. Linux redhat 5 >>>> >>>> Lot of outstanding in-place Alters need be handled first( see below) >>>> >>>> Some tables have many columns , not sure which columns need dummy- >> update. >>>> >>>> Any idea to have a fast script/SQL to find these outstanding columns? >>>> >>>> Thanks, >>>> Frank >>>> >>>> Database noaa is not revertible ... >>>> Checking database noaa_ansi for revertibility ... >>>> Database noaa_ansi is revertible ... >>>> The following tables have issues that are blocking reversion. >>>> Tables with In-Place Alter. Perform >>>> >>>> UPDATE {table-name} SET {colname} = {colname} WHERE 1=1; >>>> Refer to the section on dummy updates in the Migration guide for more >>>> details. >>>> noaa:"informix".xref_ds_np_doc - oustanding In-Place-Alter >>>> noaa:"informix".xref_ds_np_pkg - oustanding In-Place-Alter >>>> noaa:"informix".xref_dtvers - oustanding In-Place-Alter >>>> noaa:"informix".xref_np_auxanc - oustanding In-Place-Alter >>>> noaa:"informix".aip_info - oustanding In-Place-Alter >>>> noaa:"informix".orbits - oustanding In-Place-Alter >>>> noaa:"informix".ds_variablearea - oustanding In-Place-Alter >>>> noaa:"informix".gvar_details - oustanding In-Place-Alter >>>> noaa:"informix".nes_transactions - oustanding In-Place-Alter >>>> noaa:"informix".aip_inv_modis - oustanding In-Place-Alter >>>> noaa:"informix".aip_inv_modis_io - oustanding In-Place-Alter >>>> noaa:"informix".aip_inv_orbits - oustanding In-Place-Alter >>>> noaa:"informix".aip_file_info - oustanding In-Place-Alter >>>> noaa:"informix".xref_aip_inv_modis - oustanding In-Place-Alter >>>> noaa:"informix".xref_ds_orbital - oustanding In-Place-Alter >>>> noaa:"informix".rsat_source_chksum - oustanding In-Place-Alter >>>> noaa:"informix".file_inv_chksum - oustanding In-Place-Alter >>>> noaa:"informix".aip_inv_iasi1c - oustanding In-Place-Alter >>>> noaa:"informix".xref_aip_iasi1c - oustanding In-Place-Alter >>>> noaa:"informix".aip_inv_iasi3x3 - oustanding In-Place-Alter >>>> noaa:"informix".xref_aip_iasi3x3 - oustanding In-Place-Alter >>>> noaa:"informix".xref_ds_fixed_area - oustanding In-Place-Alter >>>> noaa:"informix".aip_inv_gen - oustanding In-Place-Alter >>>> noaa:"informix".xref_aip_gen - oustanding In-Place-Alter >>>> noaa:"informix".xref_ds_head - oustanding In-Place-Alter >>>> noaa:"informix".desc_msgs - oustanding In-Place-Alter >>>> noaa:"informix".ing_act_summ_refs - oustanding In-Place-Alter >>>> noaa:"informix".bad_file_rcpt_info - oustanding In-Place-Alter >>>> noaa:"informix".bad_dataset_info - oustanding In-Place-Alter >>>> noaa:"informix".bad_file_info - oustanding In-Place-Alter >>>> noaa:"informix".order - oustanding In-Place-Alter >>>> noaa:"informix".ord_channel_res - oustanding In-Place-Alter >>>> noaa:"informix".ord_comments - oustanding In-Place-Alter >>>> noaa:"informix".ds_np_gran_nv - oustanding In-Place-Alter >>>> noaa:"informix".reconcile_data - oustanding In-Place-Alter >>>> noaa:"informix".xref_aip_track - oustanding In-Place-Alter >>>> noaa:"informix".xref_ds_track - oustanding In-Place-Alter >>>> noaa:"informix".ds_np_doc - oustanding In-Place-Alter >>>> noaa:"informix".ds_np_agg - oustanding In-Place-Alter >>>> noaa:"informix".aip_inv_pkg_np - oustanding In-Place-Alter >>>> noaa:"informix".sub_manifest - oustanding In-Place-Alter >>>> noaa:"informix".vis_files_np - oustanding In-Place-Alter >>>> noaa:"informix".ds_np_fxd_tile - oustanding In-Place-Alter >>>> noaa:"informix".ds_np_fxd_tile_nv - oustanding In-Place-Alter >>>> noaa:"informix".ds_quality_fxd_np - oustanding In-Place-Alter >>>> noaa:"informix".ds_jg - oustanding In-Place-Alter >>>> noaa:"informix".ds_jg_auxanc - oustanding In-Place-Alter >>>> noaa:"informix".ds_quality_jg - oustanding In-Place-Alter >>>> noaa:"informix".ds_chksum_jg - oustanding In-Place-Alter >>>> noaa:"informix".file_inv_chksum_jg - oustanding In-Place-Alter >>>> noaa:"informix".ds_fxd_nr - oustanding In-Place-Alter >>>> noaa:"informix".ds_quality_nr - oustanding In-Place-Alter >>>> noaa:"informix".ds_chksum_nr - oustanding In-Place-Alter >>>> noaa:"informix".m2m_id_map - oustanding In-Place-Alter >>>> noaa:"informix".cman_act_deliv - oustanding In-Place-Alter >>>> noaa:"informix".cman_act_temp - oustanding In-Place-Alter >>>> noaa:"informix".cman_c

↪ replying to Deillon Samuel

FRANK — Wed, 20 Nov 2013 20:10:10 — source: IIUG Forums & Mailing Lists

Sam, Honestly, reversion is not a pleasant work for us. But 11.70 ER does not work well for us, we have no other options at this moment. Wish 12.xx ER will work for us next. On Tue, Nov 19, 2013 at 6:08 PM, Deillon Samuel <deillon@ofac.ch> wrote: > Hi, > > Just à curiosity question, what is the reversion reason. > We have many performance and stability problems with 11.7 and we work hard > to > change code and params ... We actualy have many open pmrs. > The status is not too bad now. > > The reversion is an open issue but what to after that for the next > upgrade... > > Regards, > > Sam > > > Le 19 nov. 2013 à 17:38, "FRANK" <yunyaoqu@gmail.com> a écrit : > > > > Thank you Art and Alex ! Frank > > > >> On Tue, Nov 19, 2013 at 11:37 AM, Art Kagel <art.kagel@gmail.com> > wrote: > >> > >> Oh, for performance reasons, best to do the dummy update on a column > that > >> is not indexed at all so that index nodes do not need to be updated. > >> > >> Art > >> > >> Art S. Kagel, Principal Consultant > >> > >> Advanced DataTools (www.advancedatatools.com) > >> Blog: http://informix-myview.blogspot.com/ > >> > >> Disclaimer: Please keep in mind that my own opinions are my own opinions > >> and do not reflect on my employer, Advanced DataTools, the IIUG, nor any > >> other organization with which I am associated either explicitly, > >> implicitly, or by inference. Neither do those opinions reflect those of > >> other individuals affiliated with any entity with which I am affiliated > nor > >> those of the entities themselves. > >> > >>> On Tue, Nov 19, 2013 at 11:35 AM, Art Kagel <art.kagel@gmail.com> > wrote: > >>> > >>> You don't need to know which columns need updating, just which tables. > >>> Any dummy update of any column in the table will cause all of the rows > on > >>> a page to be rewritten using the newest version of the schema. So, just > >>> pick any column that isn't a primary key column and update it to > itself. > >>> > >>> Art > >>> > >>> > >>> Art S. Kagel, Principal Consultant > >>> > >>> Advanced DataTools (www.advancedatatools.com) > >>> Blog: http://informix-myview.blogspot.com/ > >>> > >>> Disclaimer: Please keep in mind that my own opinions are my own > opinions > >>> and do not reflect on my employer, Advanced DataTools, the IIUG, nor > any > >>> other organization with which I am associated either explicitly, > >>> implicitly, or by inference. Neither do those opinions reflect those of > >>> other individuals affiliated with any entity with which I am affiliated > >> nor > >>> those of the entities themselves. > >>> > >>> > >>>> On Tue, Nov 19, 2013 at 11:31 AM, FRANK <yunyaoqu@gmail.com> wrote: > >>>> > >>>> Hi, Folks, > >>>> > >>>> I am reverting IDS11.70 FC7 back to 11.50FC8. Linux redhat 5 > >>>> > >>>> Lot of outstanding in-place Alters need be handled first( see below) > >>>> > >>>> Some tables have many columns , not sure which columns need dummy- > >> update. > >>>> > >>>> Any idea to have a fast script/SQL to find these outstanding columns? > >>>> > >>>> Thanks, > >>>> Frank > >>>> > >>>> Database noaa is not revertible ... > >>>> Checking database noaa_ansi for revertibility ... > >>>> Database noaa_ansi is revertible ... > >>>> The following tables have issues that are blocking reversion. > >>>> Tables with In-Place Alter. Perform > >>>> > >>>> UPDATE {table-name} SET {colname} = {colname} WHERE 1=1; > >>>> Refer to the section on dummy updates in the Migration guide for more > >>>> details. > >>>> noaa:"informix".xref_ds_np_doc - oustanding In-Place-Alter > >>>> noaa:"informix".xref_ds_np_pkg - oustanding In-Place-Alter > >>>> noaa:"informix".xref_dtvers - oustanding In-Place-Alter > >>>> noaa:"informix".xref_np_auxanc - oustanding In-Place-Alter > >>>> noaa:"informix".aip_info - oustanding In-Place-Alter > >>>> noaa:"informix".orbits - oustanding In-Place-Alter > >>>> noaa:"informix".ds_variablearea - oustanding In-Place-Alter > >>>> noaa:"informix".gvar_details - oustanding In-Place-Alter > >>>> noaa:"informix".nes_transactions - oustanding In-Place-Alter > >>>> noaa:"informix".aip_inv_modis - oustanding In-Place-Alter > >>>> noaa:"informix".aip_inv_modis_io - oustanding In-Place-Alter > >>>> noaa:"informix".aip_inv_orbits - oustanding In-Place-Alter > >>>> noaa:"informix".aip_file_info - oustanding In-Place-Alter > >>>> noaa:"informix".xref_aip_inv_modis - oustanding In-Place-Alter > >>>> noaa:"informix".xref_ds_orbital - oustanding In-Place-Alter > >>>> noaa:"informix".rsat_source_chksum - oustanding In-Place-Alter > >>>> noaa:"informix".file_inv_chksum - oustanding In-Place-Alter > >>>> noaa:"informix".aip_inv_iasi1c - oustanding In-Place-Alter > >>>> noaa:"informix".xref_aip_iasi1c - oustanding In-Place-Alter > >>>> noaa:"informix".aip_inv_iasi3x3 - oustanding In-Place-Alter > >>>> noaa:"informix".xref_aip_iasi3x3 - oustanding In-Place-Alter > >>>> noaa:"informix".xref_ds_fixed_area - oustanding In-Place-Alter > >>>> noaa:"informix".aip_inv_gen - oustanding In-Place-Alter > >>>> noaa:"informix".xref_aip_gen - oustanding In-Place-Alter > >>>> noaa:"informix".xref_ds_head - oustanding In-Place-Alter > >>>> noaa:"informix".desc_msgs - oustanding In-Place-Alter > >>>> noaa:"informix".ing_act_summ_refs - oustanding In-Place-Alter > >>>> noaa:"informix".bad_file_rcpt_info - oustanding In-Place-Alter > >>>> noaa:"informix".bad_dataset_info - oustanding In-Place-Alter > >>>> noaa:"informix".bad_file_info - oustanding In-Place-Alter > >>>> noaa:"informix".order - oustanding In-Place-Alter > >>>> noaa:"informix".ord_channel_res - oustanding In-Place-Alter > >>>> noaa:"informix".ord_comments - oustanding In-Place-Alter > >>>> noaa:"informix".ds_np_gran_nv - oustanding In-Place-Alter > >>>> noaa:"informix".reconcile_data - oustanding In-Place-Alter > >>>> noaa:"informix".xref_aip_track - oustanding In-Place-Alter > >>>> noaa:"informix".xref_ds_track - oustanding In-Place-Alter > >>>> noaa:"informix".ds_np_doc - oustanding In-Place-Alter > >>>> noaa:"informix".ds_np_agg - oustanding In-Place-Alter > >>>> noaa:"informix".aip_inv_pkg_np - oustanding In-Place-Alter > >>>> noaa:"informix".sub_manifest - oustanding In-Place-Alter > >>>> noaa:"informix".vis_files_np - oustanding In-Place-Alter > >>>> noaa:"informix".ds_np_fxd_tile - oustanding In-Place-Alter > >>>> noaa:"informix".ds_np_fxd_tile_nv - oustanding In-Place-Alter > >>>> noaa:"informix".ds_quality_fxd_np - oustanding In-Place-Alter > >>>> noaa:"informix".ds_jg - oustanding In-Place-Alter > >>>> noaa:"informix".ds_jg_auxanc - oustanding In-Place-Alter > >>>> noaa:"informix".ds_quality_jg - oustanding In-Place-Alter > >>>> noaa:"informix".ds_chksum_jg -