From PTAGISWiki
9c9
< ii.*.image_size.iimerge: 11929784
---
> ii.*.image_size.iimerge: 11876112
304,307c304,307
< ii..cbf.syscheck_mode: OFF
< ii..config.cluster.numa: OFF
< ii..config.cluster_mode: OFF
< ii..config.dbms.ii910su9us5123: complete
---
> ii..cbf.syscheck_mode: OFF
> ii..config.cluster.numa: OFF
> ii..config.cluster_mode: OFF
> ii..config.dbms.ii910su9us5123: complete
309,313c309,313
< ii..config.gcd.ii910su9us5123: complete
< ii..config.net.ii910su9us5123: complete
< ii..createdb.delim_id_case: lower
< ii..createdb.real_user_case: lower
< ii..createdb.reg_id_case: lower
---
> ii..config.gcd.ii910su9us5123: complete
> ii..config.net.ii910su9us5123: complete
> ii..createdb.delim_id_case: lower
> ii..createdb.real_user_case: lower
> ii..createdb.reg_id_case: lower
315c315
< ii..dbms.*.active_limit: 64
---
> ii..dbms.*.active_limit: 64
317,372c317,372
< ii..dbms.*.async_io: OFF
< ii..dbms.*.blob_etab_page_size: 2048
< ii..dbms.*.blob_etab_structure: BTREE
< ii..dbms.*.cache_lock: OFF
< ii..dbms.*.cache_name: cach_def
< ii..dbms.*.cache_sharing: ON
< ii..dbms.*.class_node_affinity: OFF
< ii..dbms.*.connect_limit: 64
< ii..dbms.*.cpu_statistics: OFF
< ii..dbms.*.cursor_default_open: UPDATE
< ii..dbms.*.cursor_limit: 16
< ii..dbms.*.cursor_update_mode: DEFERRED
< ii..dbms.*.database_limit: 65
< ii..dbms.*.database_list:
< ii..dbms.*.date_type_alias: ingresdate
< ii..dbms.*.default_journaling: ON
< ii..dbms.*.default_page_size: 2048
< ii..dbms.*.define_address: OFF
< ii..dbms.*.di_zero_bufsize: 1048576
< ii..dbms.*.direct_io: OFF
< ii..dbms.*.dmcm: OFF
< ii..dbms.*.dmf_db_cache_size: 40
< ii..dbms.*.dmf_int_sort_size: 524288
< ii..dbms.*.dmf_tbl_cache_size: 40
< ii..dbms.*.dmf_tcb_limit: 5000
< ii..dbms.*.event_limit: 80
< ii..dbms.*.event_priority: 8
< ii..dbms.*.fast_commit: ON
< ii..dbms.*.fd_affinity: THREAD
< ii..dbms.*.gather_write: ON
< ii..dbms.*.gc_interval: 20
< ii..dbms.*.gc_num_ticks: 5
< ii..dbms.*.gc_threshold: 1
< ii..dbms.*.hex_session_ids: OFF
< ii..dbms.*.image_name: iidbms
< ii..dbms.*.log_esc_lpr_sc: OFF
< ii..dbms.*.log_esc_lpr_ut: OFF
< ii..dbms.*.log_esc_lpt_sc: OFF
< ii..dbms.*.log_esc_lpt_ut: OFF
< ii..dbms.*.log_readnolock: OFF
< ii..dbms.*.log_writer: 2
< ii..dbms.*.max_tuple_length: 2008
< ii..dbms.*.name_service: ON
< ii..dbms.*.opf_active_limit: 13
< ii..dbms.*.opf_hash_join: ON
< ii..dbms.*.opf_joinop_timeout: 0
< ii..dbms.*.opf_maxmemf: 50
< ii..dbms.*.opf_memory: 13893632
< ii..dbms.*.opf_old_cnf: OFF
< ii..dbms.*.opf_old_idxorder: OFF
< ii..dbms.*.opf_old_jcard: OFF
< ii..dbms.*.opf_old_subsel: OFF
< ii..dbms.*.opf_one_rel_opt: OFF
< ii..dbms.*.opf_pq_dop: 8
< ii..dbms.*.opf_pq_threshold: 1000
< ii..dbms.*.opf_sort_factor: 100
---
> ii..dbms.*.async_io: OFF
> ii..dbms.*.blob_etab_page_size: 2048
> ii..dbms.*.blob_etab_structure: BTREE
> ii..dbms.*.cache_lock: OFF
> ii..dbms.*.cache_name: cach_def
> ii..dbms.*.cache_sharing: ON
> ii..dbms.*.class_node_affinity: OFF
> ii..dbms.*.connect_limit: 64
> ii..dbms.*.cpu_statistics: OFF
> ii..dbms.*.cursor_default_open: UPDATE
> ii..dbms.*.cursor_limit: 16
> ii..dbms.*.cursor_update_mode: DEFERRED
> ii..dbms.*.database_limit: 65
> ii..dbms.*.database_list:
> ii..dbms.*.date_type_alias: ingresdate
> ii..dbms.*.default_journaling: ON
> ii..dbms.*.default_page_size: 8192
> ii..dbms.*.define_address: OFF
> ii..dbms.*.di_zero_bufsize: 1048576
> ii..dbms.*.direct_io: OFF
> ii..dbms.*.dmcm: OFF
> ii..dbms.*.dmf_db_cache_size: 40
> ii..dbms.*.dmf_int_sort_size: 524288
> ii..dbms.*.dmf_tbl_cache_size: 40
> ii..dbms.*.dmf_tcb_limit: 5000
> ii..dbms.*.event_limit: 80
> ii..dbms.*.event_priority: 8
> ii..dbms.*.fast_commit: ON
> ii..dbms.*.fd_affinity: THREAD
> ii..dbms.*.gather_write: ON
> ii..dbms.*.gc_interval: 20
> ii..dbms.*.gc_num_ticks: 5
> ii..dbms.*.gc_threshold: 1
> ii..dbms.*.hex_session_ids: OFF
> ii..dbms.*.image_name: iidbms
> ii..dbms.*.log_esc_lpr_sc: OFF
> ii..dbms.*.log_esc_lpr_ut: OFF
> ii..dbms.*.log_esc_lpt_sc: OFF
> ii..dbms.*.log_esc_lpt_ut: OFF
> ii..dbms.*.log_readnolock: OFF
> ii..dbms.*.log_writer: 4
> ii..dbms.*.max_tuple_length: 2008
> ii..dbms.*.name_service: ON
> ii..dbms.*.opf_active_limit: 13
> ii..dbms.*.opf_hash_join: ON
> ii..dbms.*.opf_joinop_timeout: 0
> ii..dbms.*.opf_maxmemf: 50
> ii..dbms.*.opf_memory: 13893632
> ii..dbms.*.opf_old_cnf: OFF
> ii..dbms.*.opf_old_idxorder: OFF
> ii..dbms.*.opf_old_jcard: OFF
> ii..dbms.*.opf_old_subsel: OFF
> ii..dbms.*.opf_one_rel_opt: OFF
> ii..dbms.*.opf_pq_dop: 8
> ii..dbms.*.opf_pq_threshold: 1000
> ii..dbms.*.opf_sort_factor: 100
375,412c375,412
< ii..dbms.*.opf_timeout_abort: 0
< ii..dbms.*.opf_timeout_factor: 10
< ii..dbms.*.pindex_bsize: 5000
< ii..dbms.*.pindex_nbuffers: 3
< ii..dbms.*.psf_maxmemf: 50
< ii..dbms.*.psf_memory: 7471104
< ii..dbms.*.psf_vch_prec: OFF
< ii..dbms.*.psort_bsize: 1000
< ii..dbms.*.psort_nthreads: 2
< ii..dbms.*.psort_rows: 10000
< ii..dbms.*.qef_dsh_memory: 16384000
< ii..dbms.*.qef_hash_mem: 20971520
< ii..dbms.*.qef_max_mem_sleep: 30
< ii..dbms.*.qef_sort_mem: 1048576
< ii..dbms.*.qef_sorthash_memory: 211812352
< ii..dbms.*.qflatten_aggregate: ON
< ii..dbms.*.qflatten_singleton: ON
< ii..dbms.*.qsf_guideline: medium
< ii..dbms.*.qsf_memory: 26214400
< ii..dbms.*.quantum_size: 1000
< ii..dbms.*.query_flattening: ON
< ii..dbms.*.rdf_col_defaults: 50
< ii..dbms.*.rdf_max_tbls: 400
< ii..dbms.*.rdf_memory: 11489280
< ii..dbms.*.rdf_tbl_synonyms: 50
< ii..dbms.*.rep_dq_lockmode: page
< ii..dbms.*.rep_dt_maxlocks: 0
< ii..dbms.*.rep_iq_lockmode: user
< ii..dbms.*.rep_qman_threads: 1
< ii..dbms.*.rep_sa_lockmode: user
< ii..dbms.*.rep_txq_size: 50
< ii..dbms.*.result_structure: heap
< ii..dbms.*.rule_del_prefetch: ON
< ii..dbms.*.rule_depth: 20
< ii..dbms.*.rule_upd_prefetch: ON
< ii..dbms.*.scf_rows: 20
< ii..dbms.*.server_class: INGRES
< ii..dbms.*.session_accounting: OFF
---
> ii..dbms.*.opf_timeout_abort: 0
> ii..dbms.*.opf_timeout_factor: 10
> ii..dbms.*.pindex_bsize: 5000
> ii..dbms.*.pindex_nbuffers: 3
> ii..dbms.*.psf_maxmemf: 50
> ii..dbms.*.psf_memory: 7471104
> ii..dbms.*.psf_vch_prec: OFF
> ii..dbms.*.psort_bsize: 1000
> ii..dbms.*.psort_nthreads: 2
> ii..dbms.*.psort_rows: 10000
> ii..dbms.*.qef_dsh_memory: 16384000
> ii..dbms.*.qef_hash_mem: 20971520
> ii..dbms.*.qef_max_mem_sleep: 30
> ii..dbms.*.qef_sort_mem: 1048576
> ii..dbms.*.qef_sorthash_memory: 211812352
> ii..dbms.*.qflatten_aggregate: ON
> ii..dbms.*.qflatten_singleton: ON
> ii..dbms.*.qsf_guideline: medium
> ii..dbms.*.qsf_memory: 26214400
> ii..dbms.*.quantum_size: 1000
> ii..dbms.*.query_flattening: ON
> ii..dbms.*.rdf_col_defaults: 50
> ii..dbms.*.rdf_max_tbls: 400
> ii..dbms.*.rdf_memory: 11489280
> ii..dbms.*.rdf_tbl_synonyms: 50
> ii..dbms.*.rep_dq_lockmode: page
> ii..dbms.*.rep_dt_maxlocks: 0
> ii..dbms.*.rep_iq_lockmode: user
> ii..dbms.*.rep_qman_threads: 1
> ii..dbms.*.rep_sa_lockmode: user
> ii..dbms.*.rep_txq_size: 50
> ii..dbms.*.result_structure: heap
> ii..dbms.*.rule_del_prefetch: ON
> ii..dbms.*.rule_depth: 20
> ii..dbms.*.rule_upd_prefetch: ON
> ii..dbms.*.scf_rows: 20
> ii..dbms.*.server_class: INGRES
> ii..dbms.*.session_accounting: OFF
414,872c414,428
< ii..dbms.*.size_io_buf: 32768
< ii..dbms.*.sole_server: OFF
< ii..dbms.*.stack_caching: OFF
< ii..dbms.*.stack_size: 262144
< ii..dbms.*.system_isolation: serializable
< ii..dbms.*.system_lock_level: default
< ii..dbms.*.system_maxlocks: 50
< ii..dbms.*.system_readlock: shared
< ii..dbms.*.system_timeout: 0
< ii..dbms.*.ulm_chunk_size: 524288
< ii..dbms.*.unix_priority: 0
< ii..dbms.*.vch_compression: ON
< ii..dbms.connect_max: 64
< ii..dbms.connect_sum: 448
< ii..dbms.file_limit: 78
< ii..dbms.master_db.active_limit: 64
< ii..dbms.master_db.ambig_replace_64compat: OFF
< ii..dbms.master_db.async_io: OFF
< ii..dbms.master_db.blob_etab_page_size: 2048
< ii..dbms.master_db.blob_etab_structure: BTREE
< ii..dbms.master_db.cache_lock: OFF
< ii..dbms.master_db.cache_name: cach_def
< ii..dbms.master_db.cache_sharing: ON
< ii..dbms.master_db.class_node_affinity: OFF
< ii..dbms.master_db.connect_limit: 64
< ii..dbms.master_db.cpu_statistics: OFF
< ii..dbms.master_db.cursor_default_open: UPDATE
< ii..dbms.master_db.cursor_limit: 16
< ii..dbms.master_db.cursor_update_mode: DEFERRED
< ii..dbms.master_db.database_limit: 65
< ii..dbms.master_db.database_list: 'iidbdb imadb'
< ii..dbms.master_db.date_type_alias: ingresdate
< ii..dbms.master_db.default_journaling: ON
< ii..dbms.master_db.default_page_size: 2048
< ii..dbms.master_db.define_address: OFF
< ii..dbms.master_db.di_zero_bufsize: 1048576
< ii..dbms.master_db.direct_io: OFF
< ii..dbms.master_db.dmcm: OFF
< ii..dbms.master_db.dmf_db_cache_size: 40
< ii..dbms.master_db.dmf_int_sort_size: 524288
< ii..dbms.master_db.dmf_tbl_cache_size: 40
< ii..dbms.master_db.dmf_tcb_limit: 5000
< ii..dbms.master_db.event_limit: 80
< ii..dbms.master_db.event_priority: 8
< ii..dbms.master_db.fast_commit: ON
< ii..dbms.master_db.fd_affinity: THREAD
< ii..dbms.master_db.gather_write: ON
< ii..dbms.master_db.gc_interval: 20
< ii..dbms.master_db.gc_num_ticks: 5
< ii..dbms.master_db.gc_threshold: 1
< ii..dbms.master_db.hex_session_ids: OFF
< ii..dbms.master_db.image_name: iidbms
< ii..dbms.master_db.log_esc_lpr_sc: OFF
< ii..dbms.master_db.log_esc_lpr_ut: OFF
< ii..dbms.master_db.log_esc_lpt_sc: OFF
< ii..dbms.master_db.log_esc_lpt_ut: OFF
< ii..dbms.master_db.log_readnolock: OFF
< ii..dbms.master_db.log_writer: 4
< ii..dbms.master_db.max_tuple_length: 2008
< ii..dbms.master_db.name_service: ON
< ii..dbms.master_db.opf_active_limit: 13
< ii..dbms.master_db.opf_hash_join: ON
< ii..dbms.master_db.opf_joinop_timeout: 0
< ii..dbms.master_db.opf_maxmemf: 50
< ii..dbms.master_db.opf_memory: 13893632
< ii..dbms.master_db.opf_old_cnf: OFF
< ii..dbms.master_db.opf_old_idxorder: OFF
< ii..dbms.master_db.opf_old_jcard: OFF
< ii..dbms.master_db.opf_old_subsel: OFF
< ii..dbms.master_db.opf_one_rel_opt: OFF
< ii..dbms.master_db.opf_pq_dop: 8
< ii..dbms.master_db.opf_pq_threshold: 1000
< ii..dbms.master_db.opf_sort_factor: 100
< ii..dbms.master_db.opf_stats_nostats_factor: 1
< ii..dbms.master_db.opf_stats_nostats_max: OFF
< ii..dbms.master_db.opf_timeout_abort: 0
< ii..dbms.master_db.opf_timeout_factor: 10
< ii..dbms.master_db.pindex_bsize: 5000
< ii..dbms.master_db.pindex_nbuffers: 3
< ii..dbms.master_db.psf_maxmemf: 50
< ii..dbms.master_db.psf_memory: 7471104
< ii..dbms.master_db.psf_vch_prec: OFF
< ii..dbms.master_db.psort_bsize: 1000
< ii..dbms.master_db.psort_nthreads: 2
< ii..dbms.master_db.psort_rows: 10000
< ii..dbms.master_db.qef_dsh_memory: 16384000
< ii..dbms.master_db.qef_hash_mem: 20971520
< ii..dbms.master_db.qef_max_mem_sleep: 30
< ii..dbms.master_db.qef_sort_mem: 1048576
< ii..dbms.master_db.qef_sorthash_memory: 211812352
< ii..dbms.master_db.qflatten_aggregate: ON
< ii..dbms.master_db.qflatten_singleton: ON
< ii..dbms.master_db.qsf_guideline: medium
< ii..dbms.master_db.qsf_memory: 26214400
< ii..dbms.master_db.quantum_size: 1000
< ii..dbms.master_db.query_flattening: ON
< ii..dbms.master_db.rdf_col_defaults: 50
< ii..dbms.master_db.rdf_max_tbls: 400
< ii..dbms.master_db.rdf_memory: 11489280
< ii..dbms.master_db.rdf_tbl_synonyms: 50
< ii..dbms.master_db.rep_dq_lockmode: page
< ii..dbms.master_db.rep_dt_maxlocks: 0
< ii..dbms.master_db.rep_iq_lockmode: user
< ii..dbms.master_db.rep_qman_threads: 1
< ii..dbms.master_db.rep_sa_lockmode: user
< ii..dbms.master_db.rep_txq_size: 50
< ii..dbms.master_db.result_structure: heap
< ii..dbms.master_db.rule_del_prefetch: ON
< ii..dbms.master_db.rule_depth: 20
< ii..dbms.master_db.rule_upd_prefetch: ON
< ii..dbms.master_db.scf_rows: 20
< ii..dbms.master_db.server_class: INGRES
< ii..dbms.master_db.session_accounting: OFF
< ii..dbms.master_db.session_check_interval: 30
< ii..dbms.master_db.size_io_buf: 32768
< ii..dbms.master_db.sole_server: OFF
< ii..dbms.master_db.stack_caching: OFF
< ii..dbms.master_db.stack_size: 262144
< ii..dbms.master_db.system_isolation: serializable
< ii..dbms.master_db.system_lock_level: default
< ii..dbms.master_db.system_maxlocks: 50
< ii..dbms.master_db.system_readlock: shared
< ii..dbms.master_db.system_timeout: 0
< ii..dbms.master_db.ulm_chunk_size: 524288
< ii..dbms.master_db.unix_priority: 0
< ii..dbms.master_db.vch_compression: ON
< ii..dbms.meta_design.active_limit: 64
< ii..dbms.meta_design.ambig_replace_64compat: OFF
< ii..dbms.meta_design.async_io: OFF
< ii..dbms.meta_design.blob_etab_page_size: 2048
< ii..dbms.meta_design.blob_etab_structure: BTREE
< ii..dbms.meta_design.cache_lock: OFF
< ii..dbms.meta_design.cache_name: cach_def
< ii..dbms.meta_design.cache_sharing: ON
< ii..dbms.meta_design.class_node_affinity: OFF
< ii..dbms.meta_design.connect_limit: 64
< ii..dbms.meta_design.cpu_statistics: OFF
< ii..dbms.meta_design.cursor_default_open: UPDATE
< ii..dbms.meta_design.cursor_limit: 16
< ii..dbms.meta_design.cursor_update_mode: DEFERRED
< ii..dbms.meta_design.database_limit: 65
< ii..dbms.meta_design.database_list: 'demodb catest g2_ptagis3 meta design'
< ii..dbms.meta_design.date_type_alias: ingresdate
< ii..dbms.meta_design.default_journaling: ON
< ii..dbms.meta_design.default_page_size: 4096
< ii..dbms.meta_design.define_address: OFF
< ii..dbms.meta_design.di_zero_bufsize: 1048576
< ii..dbms.meta_design.direct_io: OFF
< ii..dbms.meta_design.dmcm: OFF
< ii..dbms.meta_design.dmf_db_cache_size: 40
< ii..dbms.meta_design.dmf_int_sort_size: 524288
< ii..dbms.meta_design.dmf_tbl_cache_size: 40
< ii..dbms.meta_design.dmf_tcb_limit: 5000
< ii..dbms.meta_design.event_limit: 80
< ii..dbms.meta_design.event_priority: 8
< ii..dbms.meta_design.fast_commit: ON
< ii..dbms.meta_design.fd_affinity: THREAD
< ii..dbms.meta_design.gather_write: ON
< ii..dbms.meta_design.gc_interval: 20
< ii..dbms.meta_design.gc_num_ticks: 5
< ii..dbms.meta_design.gc_threshold: 1
< ii..dbms.meta_design.hex_session_ids: OFF
< ii..dbms.meta_design.image_name: iidbms
< ii..dbms.meta_design.log_esc_lpr_sc: OFF
< ii..dbms.meta_design.log_esc_lpr_ut: OFF
< ii..dbms.meta_design.log_esc_lpt_sc: OFF
< ii..dbms.meta_design.log_esc_lpt_ut: OFF
< ii..dbms.meta_design.log_readnolock: OFF
< ii..dbms.meta_design.log_writer: 4
< ii..dbms.meta_design.max_tuple_length: 8084
< ii..dbms.meta_design.name_service: ON
< ii..dbms.meta_design.opf_active_limit: 13
< ii..dbms.meta_design.opf_hash_join: ON
< ii..dbms.meta_design.opf_joinop_timeout: 0
< ii..dbms.meta_design.opf_maxmemf: 50
< ii..dbms.meta_design.opf_memory: 13893632
< ii..dbms.meta_design.opf_old_cnf: OFF
< ii..dbms.meta_design.opf_old_idxorder: OFF
< ii..dbms.meta_design.opf_old_jcard: OFF
< ii..dbms.meta_design.opf_old_subsel: OFF
< ii..dbms.meta_design.opf_one_rel_opt: OFF
< ii..dbms.meta_design.opf_pq_dop: 8
< ii..dbms.meta_design.opf_pq_threshold: 1000
< ii..dbms.meta_design.opf_sort_factor: 100
< ii..dbms.meta_design.opf_stats_nostats_factor: 1
< ii..dbms.meta_design.opf_stats_nostats_max: OFF
< ii..dbms.meta_design.opf_timeout_abort: 0
< ii..dbms.meta_design.opf_timeout_factor: 10
< ii..dbms.meta_design.pindex_bsize: 5000
< ii..dbms.meta_design.pindex_nbuffers: 3
< ii..dbms.meta_design.psf_maxmemf: 50
< ii..dbms.meta_design.psf_memory: 7471104
< ii..dbms.meta_design.psf_vch_prec: OFF
< ii..dbms.meta_design.psort_bsize: 1000
< ii..dbms.meta_design.psort_nthreads: 2
< ii..dbms.meta_design.psort_rows: 10000
< ii..dbms.meta_design.qef_dsh_memory: 16384000
< ii..dbms.meta_design.qef_hash_mem: 20971520
< ii..dbms.meta_design.qef_max_mem_sleep: 30
< ii..dbms.meta_design.qef_sort_mem: 1048576
< ii..dbms.meta_design.qef_sorthash_memory: 211812352
< ii..dbms.meta_design.qflatten_aggregate: ON
< ii..dbms.meta_design.qflatten_singleton: ON
< ii..dbms.meta_design.qsf_guideline: medium
< ii..dbms.meta_design.qsf_memory: 26214400
< ii..dbms.meta_design.quantum_size: 1000
< ii..dbms.meta_design.query_flattening: ON
< ii..dbms.meta_design.rdf_col_defaults: 50
< ii..dbms.meta_design.rdf_max_tbls: 400
< ii..dbms.meta_design.rdf_memory: 11489280
< ii..dbms.meta_design.rdf_tbl_synonyms: 50
< ii..dbms.meta_design.rep_dq_lockmode: page
< ii..dbms.meta_design.rep_dt_maxlocks: 0
< ii..dbms.meta_design.rep_iq_lockmode: user
< ii..dbms.meta_design.rep_qman_threads: 1
< ii..dbms.meta_design.rep_sa_lockmode: user
< ii..dbms.meta_design.rep_txq_size: 50
< ii..dbms.meta_design.result_structure: heap
< ii..dbms.meta_design.rule_del_prefetch: ON
< ii..dbms.meta_design.rule_depth: 20
< ii..dbms.meta_design.rule_upd_prefetch: ON
< ii..dbms.meta_design.scf_rows: 20
< ii..dbms.meta_design.server_class: INGRES
< ii..dbms.meta_design.session_accounting: OFF
< ii..dbms.meta_design.session_check_interval: 30
< ii..dbms.meta_design.size_io_buf: 32768
< ii..dbms.meta_design.sole_server: OFF
< ii..dbms.meta_design.stack_caching: OFF
< ii..dbms.meta_design.stack_size: 262144
< ii..dbms.meta_design.system_isolation: serializable
< ii..dbms.meta_design.system_lock_level: default
< ii..dbms.meta_design.system_maxlocks: 50
< ii..dbms.meta_design.system_readlock: shared
< ii..dbms.meta_design.system_timeout: 0
< ii..dbms.meta_design.ulm_chunk_size: 524288
< ii..dbms.meta_design.unix_priority: 0
< ii..dbms.meta_design.vch_compression: ON
< ii..dbms.p3_dev_loader.active_limit: 64
< ii..dbms.p3_dev_loader.ambig_replace_64compat: OFF
< ii..dbms.p3_dev_loader.async_io: OFF
< ii..dbms.p3_dev_loader.blob_etab_page_size: 2048
< ii..dbms.p3_dev_loader.blob_etab_structure: BTREE
< ii..dbms.p3_dev_loader.cache_lock: OFF
< ii..dbms.p3_dev_loader.cache_name: cach_def
< ii..dbms.p3_dev_loader.cache_sharing: ON
< ii..dbms.p3_dev_loader.class_node_affinity: OFF
< ii..dbms.p3_dev_loader.connect_limit: 64
< ii..dbms.p3_dev_loader.cpu_statistics: OFF
< ii..dbms.p3_dev_loader.cursor_default_open: UPDATE
< ii..dbms.p3_dev_loader.cursor_limit: 16
< ii..dbms.p3_dev_loader.cursor_update_mode: DEFERRED
< ii..dbms.p3_dev_loader.database_limit: 65
< ii..dbms.p3_dev_loader.database_list: p3_dev
< ii..dbms.p3_dev_loader.date_type_alias: ingresdate
< ii..dbms.p3_dev_loader.default_journaling: ON
< ii..dbms.p3_dev_loader.default_page_size: 2048
< ii..dbms.p3_dev_loader.define_address: OFF
< ii..dbms.p3_dev_loader.di_zero_bufsize: 1048576
< ii..dbms.p3_dev_loader.direct_io: OFF
< ii..dbms.p3_dev_loader.dmcm: OFF
< ii..dbms.p3_dev_loader.dmf_db_cache_size: 40
< ii..dbms.p3_dev_loader.dmf_int_sort_size: 524288
< ii..dbms.p3_dev_loader.dmf_tbl_cache_size: 40
< ii..dbms.p3_dev_loader.dmf_tcb_limit: 5000
< ii..dbms.p3_dev_loader.event_limit: 80
< ii..dbms.p3_dev_loader.event_priority: 8
< ii..dbms.p3_dev_loader.fast_commit: ON
< ii..dbms.p3_dev_loader.fd_affinity: THREAD
< ii..dbms.p3_dev_loader.gather_write: ON
< ii..dbms.p3_dev_loader.gc_interval: 20
< ii..dbms.p3_dev_loader.gc_num_ticks: 5
< ii..dbms.p3_dev_loader.gc_threshold: 1
< ii..dbms.p3_dev_loader.hex_session_ids: OFF
< ii..dbms.p3_dev_loader.image_name: iidbms
< ii..dbms.p3_dev_loader.log_esc_lpr_sc: OFF
< ii..dbms.p3_dev_loader.log_esc_lpr_ut: OFF
< ii..dbms.p3_dev_loader.log_esc_lpt_sc: OFF
< ii..dbms.p3_dev_loader.log_esc_lpt_ut: OFF
< ii..dbms.p3_dev_loader.log_readnolock: OFF
< ii..dbms.p3_dev_loader.log_writer: 6
< ii..dbms.p3_dev_loader.max_tuple_length: 2008
< ii..dbms.p3_dev_loader.name_service: ON
< ii..dbms.p3_dev_loader.opf_active_limit: 13
< ii..dbms.p3_dev_loader.opf_hash_join: ON
< ii..dbms.p3_dev_loader.opf_joinop_timeout: 0
< ii..dbms.p3_dev_loader.opf_maxmemf: 50
< ii..dbms.p3_dev_loader.opf_memory: 13893632
< ii..dbms.p3_dev_loader.opf_old_cnf: OFF
< ii..dbms.p3_dev_loader.opf_old_idxorder: OFF
< ii..dbms.p3_dev_loader.opf_old_jcard: OFF
< ii..dbms.p3_dev_loader.opf_old_subsel: OFF
< ii..dbms.p3_dev_loader.opf_one_rel_opt: OFF
< ii..dbms.p3_dev_loader.opf_pq_dop: 8
< ii..dbms.p3_dev_loader.opf_pq_threshold: 1000
< ii..dbms.p3_dev_loader.opf_sort_factor: 100
< ii..dbms.p3_dev_loader.opf_stats_nostats_factor: 1
< ii..dbms.p3_dev_loader.opf_stats_nostats_max: OFF
< ii..dbms.p3_dev_loader.opf_timeout_abort: 0
< ii..dbms.p3_dev_loader.opf_timeout_factor: 10
< ii..dbms.p3_dev_loader.pindex_bsize: 5000
< ii..dbms.p3_dev_loader.pindex_nbuffers: 3
< ii..dbms.p3_dev_loader.psf_maxmemf: 50
< ii..dbms.p3_dev_loader.psf_memory: 7471104
< ii..dbms.p3_dev_loader.psf_vch_prec: OFF
< ii..dbms.p3_dev_loader.psort_bsize: 1000
< ii..dbms.p3_dev_loader.psort_nthreads: 2
< ii..dbms.p3_dev_loader.psort_rows: 10000
< ii..dbms.p3_dev_loader.qef_dsh_memory: 16384000
< ii..dbms.p3_dev_loader.qef_hash_mem: 20971520
< ii..dbms.p3_dev_loader.qef_max_mem_sleep: 30
< ii..dbms.p3_dev_loader.qef_sort_mem: 1408576
< ii..dbms.p3_dev_loader.qef_sorthash_memory: 234852352
< ii..dbms.p3_dev_loader.qflatten_aggregate: ON
< ii..dbms.p3_dev_loader.qflatten_singleton: ON
< ii..dbms.p3_dev_loader.qsf_guideline: medium
< ii..dbms.p3_dev_loader.qsf_memory: 26214400
< ii..dbms.p3_dev_loader.quantum_size: 1000
< ii..dbms.p3_dev_loader.query_flattening: ON
< ii..dbms.p3_dev_loader.rdf_col_defaults: 50
< ii..dbms.p3_dev_loader.rdf_max_tbls: 400
< ii..dbms.p3_dev_loader.rdf_memory: 11489280
< ii..dbms.p3_dev_loader.rdf_tbl_synonyms: 50
< ii..dbms.p3_dev_loader.rep_dq_lockmode: page
< ii..dbms.p3_dev_loader.rep_dt_maxlocks: 0
< ii..dbms.p3_dev_loader.rep_iq_lockmode: user
< ii..dbms.p3_dev_loader.rep_qman_threads: 1
< ii..dbms.p3_dev_loader.rep_sa_lockmode: user
< ii..dbms.p3_dev_loader.rep_txq_size: 50
< ii..dbms.p3_dev_loader.result_structure: heap
< ii..dbms.p3_dev_loader.rule_del_prefetch: ON
< ii..dbms.p3_dev_loader.rule_depth: 20
< ii..dbms.p3_dev_loader.rule_upd_prefetch: ON
< ii..dbms.p3_dev_loader.scf_rows: 20
< ii..dbms.p3_dev_loader.server_class: LOADER
< ii..dbms.p3_dev_loader.session_accounting: OFF
< ii..dbms.p3_dev_loader.session_check_interval: 30
< ii..dbms.p3_dev_loader.size_io_buf: 32768
< ii..dbms.p3_dev_loader.sole_server: OFF
< ii..dbms.p3_dev_loader.stack_caching: OFF
< ii..dbms.p3_dev_loader.stack_size: 262144
< ii..dbms.p3_dev_loader.system_isolation: serializable
< ii..dbms.p3_dev_loader.system_lock_level: default
< ii..dbms.p3_dev_loader.system_maxlocks: 50
< ii..dbms.p3_dev_loader.system_readlock: shared
< ii..dbms.p3_dev_loader.system_timeout: 0
< ii..dbms.p3_dev_loader.ulm_chunk_size: 524288
< ii..dbms.p3_dev_loader.unix_priority: 0
< ii..dbms.p3_dev_loader.vch_compression: ON
< ii..dbms.p3_dev_user.active_limit: 64
< ii..dbms.p3_dev_user.ambig_replace_64compat: OFF
< ii..dbms.p3_dev_user.async_io: OFF
< ii..dbms.p3_dev_user.blob_etab_page_size: 2048
< ii..dbms.p3_dev_user.blob_etab_structure: BTREE
< ii..dbms.p3_dev_user.cache_lock: OFF
< ii..dbms.p3_dev_user.cache_name: cach_def
< ii..dbms.p3_dev_user.cache_sharing: ON
< ii..dbms.p3_dev_user.class_node_affinity: OFF
< ii..dbms.p3_dev_user.connect_limit: 64
< ii..dbms.p3_dev_user.cpu_statistics: OFF
< ii..dbms.p3_dev_user.cursor_default_open: UPDATE
< ii..dbms.p3_dev_user.cursor_limit: 16
< ii..dbms.p3_dev_user.cursor_update_mode: DEFERRED
< ii..dbms.p3_dev_user.database_limit: 65
< ii..dbms.p3_dev_user.database_list: p3_dev
< ii..dbms.p3_dev_user.date_type_alias: ingresdate
< ii..dbms.p3_dev_user.default_journaling: ON
< ii..dbms.p3_dev_user.default_page_size: 4096
< ii..dbms.p3_dev_user.define_address: OFF
< ii..dbms.p3_dev_user.di_zero_bufsize: 1048576
< ii..dbms.p3_dev_user.direct_io: OFF
< ii..dbms.p3_dev_user.dmcm: OFF
< ii..dbms.p3_dev_user.dmf_db_cache_size: 40
< ii..dbms.p3_dev_user.dmf_int_sort_size: 524288
< ii..dbms.p3_dev_user.dmf_tbl_cache_size: 40
< ii..dbms.p3_dev_user.dmf_tcb_limit: 5000
< ii..dbms.p3_dev_user.event_limit: 80
< ii..dbms.p3_dev_user.event_priority: 8
< ii..dbms.p3_dev_user.fast_commit: ON
< ii..dbms.p3_dev_user.fd_affinity: THREAD
< ii..dbms.p3_dev_user.gather_write: ON
< ii..dbms.p3_dev_user.gc_interval: 20
< ii..dbms.p3_dev_user.gc_num_ticks: 5
< ii..dbms.p3_dev_user.gc_threshold: 1
< ii..dbms.p3_dev_user.hex_session_ids: OFF
< ii..dbms.p3_dev_user.image_name: iidbms
< ii..dbms.p3_dev_user.log_esc_lpr_sc: OFF
< ii..dbms.p3_dev_user.log_esc_lpr_ut: OFF
< ii..dbms.p3_dev_user.log_esc_lpt_sc: OFF
< ii..dbms.p3_dev_user.log_esc_lpt_ut: OFF
< ii..dbms.p3_dev_user.log_readnolock: OFF
< ii..dbms.p3_dev_user.log_writer: 6
< ii..dbms.p3_dev_user.max_tuple_length: 2008
< ii..dbms.p3_dev_user.name_service: ON
< ii..dbms.p3_dev_user.opf_active_limit: 32
< ii..dbms.p3_dev_user.opf_hash_join: ON
< ii..dbms.p3_dev_user.opf_joinop_timeout: 0
< ii..dbms.p3_dev_user.opf_maxmemf: 50
< ii..dbms.p3_dev_user.opf_memory: 48000000
< ii..dbms.p3_dev_user.opf_old_cnf: OFF
< ii..dbms.p3_dev_user.opf_old_idxorder: OFF
< ii..dbms.p3_dev_user.opf_old_jcard: OFF
< ii..dbms.p3_dev_user.opf_old_subsel: OFF
< ii..dbms.p3_dev_user.opf_one_rel_opt: OFF
< ii..dbms.p3_dev_user.opf_pq_dop: 8
< ii..dbms.p3_dev_user.opf_pq_threshold: 1000
< ii..dbms.p3_dev_user.opf_sort_factor: 100
< ii..dbms.p3_dev_user.opf_stats_nostats_factor: 1
< ii..dbms.p3_dev_user.opf_stats_nostats_max: OFF
< ii..dbms.p3_dev_user.opf_timeout_abort: 0
< ii..dbms.p3_dev_user.opf_timeout_factor: 10
< ii..dbms.p3_dev_user.pindex_bsize: 5000
< ii..dbms.p3_dev_user.pindex_nbuffers: 3
< ii..dbms.p3_dev_user.psf_maxmemf: 50
< ii..dbms.p3_dev_user.psf_memory: 7471104
< ii..dbms.p3_dev_user.psf_vch_prec: OFF
< ii..dbms.p3_dev_user.psort_bsize: 1000
< ii..dbms.p3_dev_user.psort_nthreads: 2
< ii..dbms.p3_dev_user.psort_rows: 10000
< ii..dbms.p3_dev_user.qef_dsh_memory: 16384000
< ii..dbms.p3_dev_user.qef_hash_mem: 20971520
< ii..dbms.p3_dev_user.qef_max_mem_sleep: 30
< ii..dbms.p3_dev_user.qef_sort_mem: 20000000
< ii..dbms.p3_dev_user.qef_sorthash_memory: 1424703488
< ii..dbms.p3_dev_user.qflatten_aggregate: ON
< ii..dbms.p3_dev_user.qflatten_singleton: ON
< ii..dbms.p3_dev_user.qsf_guideline: medium
< ii..dbms.p3_dev_user.qsf_memory: 26214400
< ii..dbms.p3_dev_user.quantum_size: 1000
< ii..dbms.p3_dev_user.query_flattening: ON
< ii..dbms.p3_dev_user.rdf_col_defaults: 50
< ii..dbms.p3_dev_user.rdf_max_tbls: 400
< ii..dbms.p3_dev_user.rdf_memory: 11489280
< ii..dbms.p3_dev_user.rdf_tbl_synonyms: 50
< ii..dbms.p3_dev_user.rep_dq_lockmode: page
< ii..dbms.p3_dev_user.rep_dt_maxlocks: 0
< ii..dbms.p3_dev_user.rep_iq_lockmode: user
< ii..dbms.p3_dev_user.rep_qman_threads: 1
< ii..dbms.p3_dev_user.rep_sa_lockmode: user
< ii..dbms.p3_dev_user.rep_txq_size: 50
< ii..dbms.p3_dev_user.result_structure: heap
< ii..dbms.p3_dev_user.rule_del_prefetch: ON
< ii..dbms.p3_dev_user.rule_depth: 20
< ii..dbms.p3_dev_user.rule_upd_prefetch: ON
< ii..dbms.p3_dev_user.scf_rows: 20
< ii..dbms.p3_dev_user.server_class: INGRES
< ii..dbms.p3_dev_user.session_accounting: OFF
< ii..dbms.p3_dev_user.session_check_interval: 30
< ii..dbms.p3_dev_user.size_io_buf: 32768
< ii..dbms.p3_dev_user.sole_server: OFF
< ii..dbms.p3_dev_user.stack_caching: OFF
< ii..dbms.p3_dev_user.stack_size: 262144
< ii..dbms.p3_dev_user.system_isolation: serializable
< ii..dbms.p3_dev_user.system_lock_level: default
< ii..dbms.p3_dev_user.system_maxlocks: 500
< ii..dbms.p3_dev_user.system_readlock: nolock
< ii..dbms.p3_dev_user.system_timeout: 0
< ii..dbms.p3_dev_user.ulm_chunk_size: 524288
< ii..dbms.p3_dev_user.unix_priority: 0
< ii..dbms.p3_dev_user.vch_compression: ON
---
> ii..dbms.*.size_io_buf: 32768
> ii..dbms.*.sole_server: OFF
> ii..dbms.*.stack_caching: OFF
> ii..dbms.*.stack_size: 262144
> ii..dbms.*.system_isolation: serializable
> ii..dbms.*.system_lock_level: default
> ii..dbms.*.system_maxlocks: 50
> ii..dbms.*.system_readlock: shared
> ii..dbms.*.system_timeout: 0
> ii..dbms.*.ulm_chunk_size: 524288
> ii..dbms.*.unix_priority: 0
> ii..dbms.*.vch_compression: ON
> ii..dbms.connect_max: 64
> ii..dbms.connect_sum: 192
> ii..dbms.file_limit: 78
890,891c446,447
< ii..dbms.ptagis3_loader.default_journaling: OFF
< ii..dbms.ptagis3_loader.default_page_size: 4096
---
> ii..dbms.ptagis3_loader.default_journaling: ON
> ii..dbms.ptagis3_loader.default_page_size: 8192
895c451
< ii..dbms.ptagis3_loader.dmcm: OFF
---
> ii..dbms.ptagis3_loader.dmcm: OFF
900c456
< ii..dbms.ptagis3_loader.event_limit: 80
---
> ii..dbms.ptagis3_loader.event_limit: 160
915c471
< ii..dbms.ptagis3_loader.log_writer: 6
---
> ii..dbms.ptagis3_loader.log_writer: 10
918,919c474,475
< ii..dbms.ptagis3_loader.opf_active_limit: 4
< ii..dbms.ptagis3_loader.opf_hash_join: ON
---
> ii..dbms.ptagis3_loader.opf_active_limit: 32
> ii..dbms.ptagis3_loader.opf_hash_join: OFF
922c478
< ii..dbms.ptagis3_loader.opf_memory: 480000000
---
> ii..dbms.ptagis3_loader.opf_memory: 48000000
938c494
< ii..dbms.ptagis3_loader.psf_memory: 212992000
---
> ii..dbms.ptagis3_loader.psf_memory: 7471104
943c499
< ii..dbms.ptagis3_loader.qef_dsh_memory: 768432000
---
> ii..dbms.ptagis3_loader.qef_dsh_memory: 16384000
975c531
< ii..dbms.ptagis3_loader.stack_size: 262144
---
> ii..dbms.ptagis3_loader.stack_size: 1048576
978,979c534,535
< ii..dbms.ptagis3_loader.system_maxlocks: 50
< ii..dbms.ptagis3_loader.system_readlock: shared
---
> ii..dbms.ptagis3_loader.system_maxlocks: 500
> ii..dbms.ptagis3_loader.system_readlock: nolock
986c542
< ii..dbms.ptagis3_user.async_io: OFF
---
> ii..dbms.ptagis3_user.async_io: OFF
999c555
< ii..dbms.ptagis3_user.database_list: ptagis3
---
> ii..dbms.ptagis3_user.database_list:
1001,1002c557,558
< ii..dbms.ptagis3_user.default_journaling: OFF
< ii..dbms.ptagis3_user.default_page_size: 4096
---
> ii..dbms.ptagis3_user.default_journaling: ON
> ii..dbms.ptagis3_user.default_page_size: 8192
1006c562
< ii..dbms.ptagis3_user.dmcm: OFF
---
> ii..dbms.ptagis3_user.dmcm: OFF
1027c583
< ii..dbms.ptagis3_user.max_tuple_length: 3988
---
> ii..dbms.ptagis3_user.max_tuple_length: 2008
1029,1030c585,586
< ii..dbms.ptagis3_user.opf_active_limit: 13
< ii..dbms.ptagis3_user.opf_hash_join: ON
---
> ii..dbms.ptagis3_user.opf_active_limit: 32
> ii..dbms.ptagis3_user.opf_hash_join: OFF
1033c589
< ii..dbms.ptagis3_user.opf_memory: 24000000
---
> ii..dbms.ptagis3_user.opf_memory: 48000000
1049c605
< ii..dbms.ptagis3_user.psf_memory: 212992000
---
> ii..dbms.ptagis3_user.psf_memory: 7471104
1054c610
< ii..dbms.ptagis3_user.qef_dsh_memory: 768432000
---
> ii..dbms.ptagis3_user.qef_dsh_memory: 16384000
1079c635
< ii..dbms.ptagis3_user.scf_rows: 20
---
> ii..dbms.ptagis3_user.scf_rows: 20
1086c642
< ii..dbms.ptagis3_user.stack_size: 512000
---
> ii..dbms.ptagis3_user.stack_size: 1048576
1089,1090c645,646
< ii..dbms.ptagis3_user.system_maxlocks: 50
< ii..dbms.ptagis3_user.system_readlock: shared
---
> ii..dbms.ptagis3_user.system_maxlocks: 500
> ii..dbms.ptagis3_user.system_readlock: nolock
1103,1106c659,662
< ii..dbms.shared.cach_def.config.dmf_connect: 448
< ii..dbms.shared.cach_def.dmf_cache_size: 10000
< ii..dbms.shared.cach_def.dmf_free_limit: 312
< ii..dbms.shared.cach_def.dmf_group_count: 1500
---
> ii..dbms.shared.cach_def.config.dmf_connect: 0
> ii..dbms.shared.cach_def.dmf_cache_size: 20000
> ii..dbms.shared.cach_def.dmf_free_limit: 625
> ii..dbms.shared.cach_def.dmf_group_count: 1000
1108,1111c664,667
< ii..dbms.shared.cach_def.dmf_memory: 45056000
< ii..dbms.shared.cach_def.dmf_modify_limit: 7500
< ii..dbms.shared.cach_def.dmf_wb_end: 3000
< ii..dbms.shared.cach_def.dmf_wb_start: 5000
---
> ii..dbms.shared.cach_def.dmf_memory: 57344000
> ii..dbms.shared.cach_def.dmf_modify_limit: 15000
> ii..dbms.shared.cach_def.dmf_wb_end: 500
> ii..dbms.shared.cach_def.dmf_wb_start: 1000
1136,1138c692,694
< ii..dbms.shared.cach_def.p4k.dmf_cache_size: 7500
< ii..dbms.shared.cach_def.p4k.dmf_free_limit: 234
< ii..dbms.shared.cach_def.p4k.dmf_group_count: 900
---
> ii..dbms.shared.cach_def.p4k.dmf_cache_size: 10000
> ii..dbms.shared.cach_def.p4k.dmf_free_limit: 312
> ii..dbms.shared.cach_def.p4k.dmf_group_count: 500
1140,1141c696,697
< ii..dbms.shared.cach_def.p4k.dmf_memory: 60211200
< ii..dbms.shared.cach_def.p4k.dmf_modify_limit: 5625
---
> ii..dbms.shared.cach_def.p4k.dmf_memory: 57344000
> ii..dbms.shared.cach_def.p4k.dmf_modify_limit: 7500
1143,1144c699,700
< ii..dbms.shared.cach_def.p4k.dmf_wb_end: 2250
< ii..dbms.shared.cach_def.p4k.dmf_wb_start: 3750
---
> ii..dbms.shared.cach_def.p4k.dmf_wb_end: 500
> ii..dbms.shared.cach_def.p4k.dmf_wb_start: 1000
1158,1160c714,716
< ii..dbms.shared.cach_def.p8k.dmf_cache_size: 2000
< ii..dbms.shared.cach_def.p8k.dmf_free_limit: 62
< ii..dbms.shared.cach_def.p8k.dmf_group_count: 250
---
> ii..dbms.shared.cach_def.p8k.dmf_cache_size: 20000
> ii..dbms.shared.cach_def.p8k.dmf_free_limit: 625
> ii..dbms.shared.cach_def.p8k.dmf_group_count: 500
1162,1163c718,719
< ii..dbms.shared.cach_def.p8k.dmf_memory: 32768000
< ii..dbms.shared.cach_def.p8k.dmf_modify_limit: 1500
---
> ii..dbms.shared.cach_def.p8k.dmf_memory: 196608000
> ii..dbms.shared.cach_def.p8k.dmf_modify_limit: 15000
1165c721
< ii..dbms.shared.cach_def.p8k.dmf_wb_end: 600
---
> ii..dbms.shared.cach_def.p8k.dmf_wb_end: 500
1169,1225c725,781
< ii..gcb.file_limit: 0
< ii..gcc.*.async.port:
< ii..gcc.*.async.status: OFF
< ii..gcc.*.decnet.port: II_GCCUI
< ii..gcc.*.decnet.status: OFF
< ii..gcc.*.error_level: 4
< ii..gcc.*.ib_encrypt_mech: *
< ii..gcc.*.ib_encrypt_mode: optional
< ii..gcc.*.inbound_limit: 64
< ii..gcc.*.iso_oslan.port: OSLAN_UI
< ii..gcc.*.iso_oslan.status: OFF
< ii..gcc.*.iso_x25.port: X25_UI
< ii..gcc.*.iso_x25.status: OFF
< ii..gcc.*.log_level: 4
< ii..gcc.*.mechanisms:
< ii..gcc.*.message_concat: true
< ii..gcc.*.ob_encrypt_mech: *
< ii..gcc.*.ob_encrypt_mode: optional
< ii..gcc.*.outbound_limit: 64
< ii..gcc.*.registry_type: default
< ii..gcc.*.sna_lu62.poll: 4000
< ii..gcc.*.sna_lu62.port: <none>
< ii..gcc.*.sna_lu62.status: OFF
< ii..gcc.*.sockets.port: UI
< ii..gcc.*.sockets.status: OFF
< ii..gcc.*.spx.port: UI
< ii..gcc.*.spx.status: OFF
< ii..gcc.*.tcp_ip.port: UI
< ii..gcc.*.tcp_ip.status: ON
< ii..gcc.*.tcp_wol.port: UI
< ii..gcc.*.tcp_wol.status: OFF
< ii..gcc.connect_max: 1
< ii..gcc.file_limit: 15
< ii..gcd.*.async.port:
< ii..gcd.*.async.status: OFF
< ii..gcd.*.client_max: -1
< ii..gcd.*.client_timeout: 0
< ii..gcd.*.connect_pool_expire: 0
< ii..gcd.*.connect_pool_size: -1
< ii..gcd.*.connect_pool_status: optional
< ii..gcd.*.decnet.port: II_GCDUI7
< ii..gcd.*.decnet.status: OFF
< ii..gcd.*.iso_oslan.port: OSLAN_UI7
< ii..gcd.*.iso_oslan.status: OFF
< ii..gcd.*.iso_x25.port: X25_UI7
< ii..gcd.*.iso_x25.status: OFF
< ii..gcd.*.sna_lu62.port: <none>
< ii..gcd.*.sna_lu62.status: OFF
< ii..gcd.*.sockets.port: UI7
< ii..gcd.*.sockets.status: OFF
< ii..gcd.*.spx.port: UI7
< ii..gcd.*.spx.status: OFF
< ii..gcd.*.tcp_ip.port: UI7
< ii..gcd.*.tcp_ip.status: ON
< ii..gcd.*.tcp_wol.port: UI7
< ii..gcd.*.tcp_wol.status: OFF
< ii..gcf.mech.ingres.enabled: true
---
> ii..gcb.file_limit: 0
> ii..gcc.*.async.port:
> ii..gcc.*.async.status: OFF
> ii..gcc.*.decnet.port: II_GCCUI
> ii..gcc.*.decnet.status: OFF
> ii..gcc.*.error_level: 4
> ii..gcc.*.ib_encrypt_mech: *
> ii..gcc.*.ib_encrypt_mode: optional
> ii..gcc.*.inbound_limit: 64
> ii..gcc.*.iso_oslan.port: OSLAN_UI
> ii..gcc.*.iso_oslan.status: OFF
> ii..gcc.*.iso_x25.port: X25_UI
> ii..gcc.*.iso_x25.status: OFF
> ii..gcc.*.log_level: 4
> ii..gcc.*.mechanisms:
> ii..gcc.*.message_concat: true
> ii..gcc.*.ob_encrypt_mech: *
> ii..gcc.*.ob_encrypt_mode: optional
> ii..gcc.*.outbound_limit: 64
> ii..gcc.*.registry_type: default
> ii..gcc.*.sna_lu62.poll: 4000
> ii..gcc.*.sna_lu62.port: <none>
> ii..gcc.*.sna_lu62.status: OFF
> ii..gcc.*.sockets.port: UI
> ii..gcc.*.sockets.status: OFF
> ii..gcc.*.spx.port: UI
> ii..gcc.*.spx.status: OFF
> ii..gcc.*.tcp_ip.port: UI
> ii..gcc.*.tcp_ip.status: ON
> ii..gcc.*.tcp_wol.port: UI
> ii..gcc.*.tcp_wol.status: OFF
> ii..gcc.connect_max: 1
> ii..gcc.file_limit: 15
> ii..gcd.*.async.port:
> ii..gcd.*.async.status: OFF
> ii..gcd.*.client_max: -1
> ii..gcd.*.client_timeout: 0
> ii..gcd.*.connect_pool_expire: 0
> ii..gcd.*.connect_pool_size: -1
> ii..gcd.*.connect_pool_status: optional
> ii..gcd.*.decnet.port: II_GCDUI7
> ii..gcd.*.decnet.status: OFF
> ii..gcd.*.iso_oslan.port: OSLAN_UI7
> ii..gcd.*.iso_oslan.status: OFF
> ii..gcd.*.iso_x25.port: X25_UI7
> ii..gcd.*.iso_x25.status: OFF
> ii..gcd.*.sna_lu62.port: <none>
> ii..gcd.*.sna_lu62.status: OFF
> ii..gcd.*.sockets.port: UI7
> ii..gcd.*.sockets.status: OFF
> ii..gcd.*.spx.port: UI7
> ii..gcd.*.spx.status: OFF
> ii..gcd.*.tcp_ip.port: UI7
> ii..gcd.*.tcp_ip.status: ON
> ii..gcd.*.tcp_wol.port: UI7
> ii..gcd.*.tcp_wol.status: OFF
> ii..gcf.mech.ingres.enabled: true
1228,1264c784,816
< ii..gcf.mech.null.enabled: false
< ii..gcf.mech.system.enabled: true
< ii..gcf.mechanism_location: /usr/ing2006r2/ingUI/ingres/lib
< ii..gcf.mechanisms:
< ii..gcf.password_mechanism: default
< ii..gcf.remote_auth_error: ignore
< ii..gcf.remote_mechanism: none
< ii..gcf.restrict_pwd_auth: false
< ii..gcf.restrict_rem_auth: false
< ii..gcf.restrict_srv_auth: true
< ii..gcf.restrict_usr_auth: false
< ii..gcf.security_mechanism: ingres
< ii..gcf.server_mechanism: default
< ii..gcf.user_mechanism: default
< ii..gcn.check_interval: 300
< ii..gcn.check_timeout: 20
< ii..gcn.check_type: connect,install,class
< ii..gcn.compress_point: 50
< ii..gcn.default_server_class: INGRES
< ii..gcn.expire_interval: 300
< ii..gcn.local_vnode:
< ii..gcn.mechanisms:
< ii..gcn.registry_type: none
< ii..gcn.remote_mechanism: none
< ii..gcn.remote_vnode:
< ii..gcn.session_limit: 16
< ii..gcn.ticket_cache_size: 10
< ii..gcn.ticket_expire: 1800
< ii..gcn.timeout: 60
< ii..ingstart.*.dbms: 0
< ii..ingstart.*.gcc: 1
< ii..ingstart.*.gcd: 1
< ii..ingstart.*.rmcmd: 1
< ii..ingstart.master_db.dbms: 1
< ii..ingstart.meta_design.dbms: 1
< ii..ingstart.p3_dev_loader.dbms: 1
< ii..ingstart.p3_dev_user.dbms: 1
---
> ii..gcf.mech.null.enabled: false
> ii..gcf.mech.system.enabled: true
> ii..gcf.mechanism_location: /usr/ing2006r2/ingUI/ingres/lib
> ii..gcf.mechanisms:
> ii..gcf.password_mechanism: default
> ii..gcf.remote_auth_error: ignore
> ii..gcf.remote_mechanism: none
> ii..gcf.restrict_pwd_auth: false
> ii..gcf.restrict_rem_auth: false
> ii..gcf.restrict_srv_auth: true
> ii..gcf.restrict_usr_auth: false
> ii..gcf.security_mechanism: ingres
> ii..gcf.server_mechanism: default
> ii..gcf.user_mechanism: default
> ii..gcn.check_interval: 300
> ii..gcn.check_timeout: 20
> ii..gcn.check_type: connect,install,class
> ii..gcn.compress_point: 50
> ii..gcn.default_server_class: INGRES
> ii..gcn.expire_interval: 300
> ii..gcn.local_vnode:
> ii..gcn.mechanisms:
> ii..gcn.registry_type: none
> ii..gcn.remote_mechanism: none
> ii..gcn.remote_vnode:
> ii..gcn.session_limit: 16
> ii..gcn.ticket_cache_size: 10
> ii..gcn.ticket_expire: 1800
> ii..gcn.timeout: 60
> ii..ingstart.*.dbms: 0
> ii..ingstart.*.gcc: 2
> ii..ingstart.*.gcd: 1
> ii..ingstart.*.rmcmd: 1
1266,1343c818,895
< ii..ingstart.ptagis3_user.dbms: 1
< ii..ingstart.syscheck_mode: OFF
< ii..odbc.cli_module_name: libiiodbc.1.so
< ii..odbc.module_name: libiiodbcdriver.1.so
< ii..odbc.trace_module_name: libiiodbctrace.1.so
< ii..prefs.cbf_syscheck: OFF
< ii..prefs.ingstart_syscheck: OFF
< ii..prefs.ingstop: none
< ii..privileges.user.carters: SERVER_CONTROL,NET_ADMIN,MONITOR,TRUSTED
< ii..privileges.user.davem: SERVER_CONTROL,NET_ADMIN,MONITOR,TRUSTED
< ii..privileges.user.ingres: SERVER_CONTROL,NET_ADMIN,MONITOR,TRUSTED
< ii..privileges.user.pittag: SERVER_CONTROL,NET_ADMIN,MONITOR,TRUSTED
< ii..privileges.user.ptagdev: SERVER_CONTROL,NET_ADMIN,MONITOR,TRUSTED
< ii..privileges.user.rday: SERVER_CONTROL,NET_ADMIN,MONITOR,TRUSTED
< ii..privileges.user.root: SERVER_CONTROL,NET_ADMIN,MONITOR,TRUSTED
< ii..rcp.config.logwriter_sum: 38
< ii..rcp.dmf_cache_size: 1000
< ii..rcp.dmf_cache_size16k: 200
< ii..rcp.dmf_cache_size32k: 0
< ii..rcp.dmf_cache_size4k: 200
< ii..rcp.dmf_cache_size64k: 0
< ii..rcp.dmf_cache_size8k: 200
< ii..rcp.file.kbytes: 409600
< ii..rcp.lock.hash_size: 23399
< ii..rcp.lock.list_limit: 2270
< ii..rcp.lock.lock_limit: 117000
< ii..rcp.lock.per_tx_limit: 750
< ii..rcp.lock.resource_hash: 23399
< ii..rcp.lock.resource_limit: 117000
< ii..rcp.log.archiver_interval: 1
< ii..rcp.log.archiver_refresh: 10
< ii..rcp.log.block_size: 4
< ii..rcp.log.buffer_count: 35
< ii..rcp.log.cp_interval: 10
< ii..rcp.log.cp_interval_mb: 40
< ii..rcp.log.database_limit: 200
< ii..rcp.log.dual_log_name: dual_log
< ii..rcp.log.force_abort_limit: 72
< ii..rcp.log.full_limit: 90
< ii..rcp.log.lgk_memory_lock: OFF
< ii..rcp.log.log_file_1: /usr/ckp/ingUI
< ii..rcp.log.log_file_name: ingres_log
< ii..rcp.log.log_file_parts: 1
< ii..rcp.log.optimize_writes: ON
< ii..rcp.log.tx_limit: 2270
< ii..recovery.*.active_limit: 5
< ii..recovery.*.async_io: OFF
< ii..recovery.*.connect_limit: 5
< ii..recovery.*.cp_timer: 0
< ii..recovery.*.database_limit: 200
< ii..recovery.*.di_zero_bufsize: 1048576
< ii..recovery.*.direct_io: OFF
< ii..recovery.*.dmcm: OFF
< ii..recovery.*.event_limit: 0
< ii..recovery.*.gather_write: OFF
< ii..recovery.*.log_writer: 1
< ii..recovery.*.name_service: ON
< ii..recovery.*.stack_size: 131072
< ii..registry.async.port:
< ii..registry.async.status: OFF
< ii..registry.decnet.port:
< ii..registry.decnet.status: OFF
< ii..registry.iso_oslan.port:
< ii..registry.iso_oslan.status: OFF
< ii..registry.iso_x25.port:
< ii..registry.iso_x25.status: OFF
< ii..registry.sna_lu62.port:
< ii..registry.sna_lu62.status: OFF
< ii..registry.sockets.port:
< ii..registry.sockets.status: OFF
< ii..registry.spx.port:
< ii..registry.spx.status: OFF
< ii..registry.tcp_ip.port: 16903
< ii..registry.tcp_ip.status: OFF
< ii..registry.tcp_wol.port:
< ii..registry.tcp_wol.status: OFF
< ii..setup.owner.group: ingres
< ii..setup.owner.user: ingres
---
> ii..ingstart.ptagis3_user.dbms: 1
> ii..ingstart.syscheck_mode: OFF
> ii..odbc.cli_module_name: libiiodbc.1.so
> ii..odbc.module_name: libiiodbcdriver.1.so
> ii..odbc.trace_module_name: libiiodbctrace.1.so
> ii..prefs.cbf_syscheck: OFF
> ii..prefs.ingstart_syscheck: OFF
> ii..prefs.ingstop: none
> ii..privileges.user.carters: SERVER_CONTROL,NET_ADMIN,MONITOR,TRUSTED
> ii..privileges.user.davem: SERVER_CONTROL,NET_ADMIN,MONITOR,TRUSTED
> ii..privileges.user.ingres: SERVER_CONTROL,NET_ADMIN,MONITOR,TRUSTED
> ii..privileges.user.pittag: SERVER_CONTROL,NET_ADMIN,MONITOR,TRUSTED
> ii..privileges.user.ptagdev: SERVER_CONTROL,NET_ADMIN,MONITOR,TRUSTED
> ii..privileges.user.rday: SERVER_CONTROL,NET_ADMIN,MONITOR,TRUSTED
> ii..privileges.user.root: SERVER_CONTROL,NET_ADMIN,MONITOR,TRUSTED
> ii..rcp.config.logwriter_sum: 26
> ii..rcp.dmf_cache_size: 1000
> ii..rcp.dmf_cache_size16k: 200
> ii..rcp.dmf_cache_size32k: 0
> ii..rcp.dmf_cache_size4k: 200
> ii..rcp.dmf_cache_size64k: 0
> ii..rcp.dmf_cache_size8k: 200
> ii..rcp.file.kbytes: 409600
> ii..rcp.lock.hash_size: 26597
> ii..rcp.lock.list_limit: 2120
> ii..rcp.lock.lock_limit: 133000
> ii..rcp.lock.per_tx_limit: 2000
> ii..rcp.lock.resource_hash: 26597
> ii..rcp.lock.resource_limit: 133000
> ii..rcp.log.archiver_interval: 1
> ii..rcp.log.archiver_refresh: 10
> ii..rcp.log.block_size: 8
> ii..rcp.log.buffer_count: 35
> ii..rcp.log.cp_interval: 10
> ii..rcp.log.cp_interval_mb: 40
> ii..rcp.log.database_limit: 192
> ii..rcp.log.dual_log_name: dual_log
> ii..rcp.log.force_abort_limit: 72
> ii..rcp.log.full_limit: 90
> ii..rcp.log.lgk_memory_lock: OFF
> ii..rcp.log.log_file_1: /usr/ckp/ingUI
> ii..rcp.log.log_file_name: ingres_log
> ii..rcp.log.log_file_parts: 1
> ii..rcp.log.optimize_writes: ON
> ii..rcp.log.tx_limit: 2120
> ii..recovery.*.active_limit: 5
> ii..recovery.*.async_io: OFF
> ii..recovery.*.connect_limit: 5
> ii..recovery.*.cp_timer: 0
> ii..recovery.*.database_limit: 192
> ii..recovery.*.di_zero_bufsize: 1048576
> ii..recovery.*.direct_io: OFF
> ii..recovery.*.dmcm: OFF
> ii..recovery.*.event_limit: 0
> ii..recovery.*.gather_write: OFF
> ii..recovery.*.log_writer: 1
> ii..recovery.*.name_service: ON
> ii..recovery.*.stack_size: 131072
> ii..registry.async.port:
> ii..registry.async.status: OFF
> ii..registry.decnet.port:
> ii..registry.decnet.status: OFF
> ii..registry.iso_oslan.port:
> ii..registry.iso_oslan.status: OFF
> ii..registry.iso_x25.port:
> ii..registry.iso_x25.status: OFF
> ii..registry.sna_lu62.port:
> ii..registry.sna_lu62.status: OFF
> ii..registry.sockets.port:
> ii..registry.sockets.status: OFF
> ii..registry.spx.port:
> ii..registry.spx.status: OFF
> ii..registry.tcp_ip.port: 16903
> ii..registry.tcp_ip.status: OFF
> ii..registry.tcp_wol.port:
> ii..registry.tcp_wol.status: OFF
> ii..setup.owner.group: ingres
> ii..setup.owner.user: ingres
1345,1362c897,914
< ii..star.connect_max: 0
< ii..star.file_limit: 0
< ii..syscheck.dbms_segment: 540672
< ii..syscheck.dbms_swap_mem: 2147483647
< ii..syscheck.dmf_seg_num: 1
< ii..syscheck.dmf_segment: 236339200
< ii..syscheck.file_limit: 78
< ii..syscheck.iidbms_swap: 2147483647
< ii..syscheck.iigcb_swap: 0
< ii..syscheck.iigcc_swap: 1365708
< ii..syscheck.iigcd_swap: 2574360
< ii..syscheck.iigcn_swap: 1418740
< ii..syscheck.iistar_swap: 0
< ii..syscheck.rcp_segment: 132562944
< ii..syscheck.segments: 10
< ii..syscheck.semaphore_sets: 8
< ii..syscheck.semaphores: 215
< ii..syscheck.swap_space_kb: 2101919
---
> ii..star.connect_max: 0
> ii..star.file_limit: 0
> ii..syscheck.dbms_segment: 540672
> ii..syscheck.dbms_swap_mem: 1361916928
> ii..syscheck.dmf_seg_num: 1
> ii..syscheck.dmf_segment: 409600000
> ii..syscheck.file_limit: 78
> ii..syscheck.iidbms_swap: 1413517376
> ii..syscheck.iigcb_swap: 0
> ii..syscheck.iigcc_swap: 2731416
> ii..syscheck.iigcd_swap: 2574360
> ii..syscheck.iigcn_swap: 1418740
> ii..syscheck.iistar_swap: 0
> ii..syscheck.rcp_segment: 150142976
> ii..syscheck.segments: 6
> ii..syscheck.semaphore_sets: 4
> ii..syscheck.semaphores: 95
> ii..syscheck.swap_space_kb: 1386489