Comparing config.dat on blueback and sockeye

From PTAGISWiki

Jump to: navigation, search
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
Personal tools