Ingres Q & A
Fellow Ca-Ingres-users,
There have been a messages (mine included) pertaining to the
inability to keep the dbms server up & running using CA-OPENINGRES 1.1/04
on an Alpha box. There's hope! We have now been running for 10 days
without a crash or hang. Considering that this took so long(since January),
it's a shame, but it has finally happened and that's good news. Here's what
we've done to get it running (this setup is the result of finally getting a
T.S. person who had enough expertise and the desire to check with his co-workers
about parameters to both the System and to INGRES). Please note that there
are still issues unresolved, bugs that need to be corrected, but the
important item is that the server RUNS. I've included the INGRES account
authorization info, followed by the INGRES configuration file(config.dat).
Both have been edited to delete info that is not pertain to the modifications or
info that is private.
So, if you use this data as a guideline, you may get the same results as we
have. A DBMS server that stays up & does(almost) what it was designed to do.
I'll be happy to discuss this with any interested party, just write or call.
John McKenna
Database Administrator
Massachusetts General Hospital
Cardiac Computer Center
Bulfinch-457
Boston, Ma. 02114
Tel: (617)724-8022
Fax: (617)726-5866
Email: mckenna@olorin.mgh.harvard.edu
***** INGRES ACCOUNT AUTHORIZATION *******************************************
No access restrictions
Maxjobs: 0 Fillm: 1000 Bytlm: 700000
Maxacctjobs: 0 Shrfillm: 0 Pbytlm: 0
Maxdetach: 0 BIOlm: 400 JTquota: 40000
Prclm: 0 DIOlm: 200 WSdef: 2000
Prio: 4 ASTlm: 250 WSquo: 4000
Queprio: 0 TQElm: 50 WSextent: 16384
CPU: (none) Enqlm: 2048 Pgflquo: 200000
Authorized Privileges:
ACNT ALLSPOOL ALTPRI AUDIT BUGCHK CMEXEC CMKRNL DETACH
DIAGNOSE DOWNGRADE EXQUOTA GROUP GRPNAM GRPPRV IMPORT LOG_IO
MOUNT NETMBX OPER PFNMAP PHY_IO PRMCEB PRMGBL PRMMBX
PSWAPM READALL SECURITY SETPRV SHARE SHMEM SYSGBL SYSLCK
SYSNAM SYSPRV TMPMBX UPGRADE VOLPRO WORLD
Default Privileges:
ACNT ALLSPOOL ALTPRI AUDIT BUGCHK CMEXEC CMKRNL DETACH
DIAGNOSE DOWNGRADE EXQUOTA GROUP GRPNAM GRPPRV IMPORT LOG_IO
MOUNT NETMBX OPER PFNMAP PHY_IO PRMCEB PRMGBL PRMMBX
PSWAPM READALL SECURITY SETPRV SHARE SHMEM SYSGBL SYSLCK
SYSNAM SYSPRV TMPMBX UPGRADE VOLPRO WORLD
***** CONFIG.DAT *******************************************
ii.*.c2.audit_writer_start: 10
ii.*.c2.force_flush: ON
ii.*.c2.shared_buffer_count: 64
ii.olorin.config.acp_factor: 250
ii.olorin.config.acp_window: 7
ii.olorin.config.channelcnt: 1000
ii.olorin.config.cluster_mode: OFF
ii.olorin.config.dbms.oping1104axpvms01: COMPLETE
ii.olorin.config.ncp_buffer_size: 1504
ii.olorin.config.net.oping1104axpvms01: COMPLETE
ii.olorin.createdb.delim_id_case: lower
ii.olorin.createdb.real_user_case: lower
ii.olorin.createdb.reg_id_case: lower
ii.olorin.dbms.*.*.config.dmf_connect: 32
ii.olorin.dbms.*.active_limit: 32
ii.olorin.dbms.*.cache_lock: OFF
ii.olorin.dbms.*.cache_name: cach_def
ii.olorin.dbms.*.cache_sharing: OFF
ii.olorin.dbms.*.connect_limit: 32
ii.olorin.dbms.*.cpu_statistics: OFF
ii.olorin.dbms.*.cursor_limit: 19
ii.olorin.dbms.*.cursor_update_mode: DEFERRED
ii.olorin.dbms.*.database_limit: 33
ii.olorin.dbms.*.database_list:
ii.olorin.dbms.*.default_journaling: ON
ii.olorin.dbms.*.define_address: OFF
ii.olorin.dbms.*.dmf_db_cache_size: 40
ii.olorin.dbms.*.dmf_tbl_cache_size: 40
ii.olorin.dbms.*.event_limit: 40
ii.olorin.dbms.*.fast_commit: ON
ii.olorin.dbms.*.log_writer: 1
ii.olorin.dbms.*.name_service: ON
ii.olorin.dbms.*.opf_active_limit: 16
ii.olorin.dbms.*.opf_memory: 3200000
ii.olorin.dbms.*.qef_qep_mem: 2539520
ii.olorin.dbms.*.qef_sort_mem: 32768
ii.olorin.dbms.*.qflatten_aggregate: ON
ii.olorin.dbms.*.qflatten_singleton: ON
ii.olorin.dbms.*.qsf_memory: 2660000
ii.olorin.dbms.*.query_flattening: ON
ii.olorin.dbms.*.rdf_max_tbls: 300
ii.olorin.dbms.*.rdf_memory: 11141120
ii.olorin.dbms.*.rdf_tbl_cols: 15
ii.olorin.dbms.*.rdf_tbl_synonyms: 1
ii.olorin.dbms.*.rule_depth: 32
ii.olorin.dbms.*.scf_rows: 20
ii.olorin.dbms.*.sec_label_cache: 100
ii.olorin.dbms.*.server_class: INGRES
ii.olorin.dbms.*.session_accounting: OFF
ii.olorin.dbms.*.session_check_interval: 30
ii.olorin.dbms.*.sole_server: OFF
ii.olorin.dbms.*.stack_size: 262144
ii.olorin.dbms.*.vms_accounting: OFF
ii.olorin.dbms.*.vms_ast_limit: 69
ii.olorin.dbms.*.vms_buffer_limit: 654000
ii.olorin.dbms.*.vms_error: ii_system:[ingres.files]iidbms.error
ii.olorin.dbms.*.vms_extent: 131072
ii.olorin.dbms.*.vms_file_limit: 950
ii.olorin.dbms.*.vms_io_buffered: 69
ii.olorin.dbms.*.vms_io_direct: 36
ii.olorin.dbms.*.vms_maximum_working_set: 2000
ii.olorin.dbms.*.vms_page_file: 45000
ii.olorin.dbms.*.vms_priority: 4
ii.olorin.dbms.*.vms_privileges: (prmmbx,sysprv,world,readall,syslck,share,exquota,sysgbl,shmem)
ii.olorin.dbms.*.vms_queue_limit: 37
ii.olorin.dbms.*.vms_working_set: 1000
ii.olorin.dbms.*.write_behind: 2
ii.olorin.fixed_prefs.iso_entry_sql-92: OFF
ii.olorin.gcc.*.async.port:
ii.olorin.gcc.*.async.status: OFF
ii.olorin.gcc.*.decnet.port: II_GCC0
ii.olorin.gcc.*.decnet.status: ON
ii.olorin.gcc.*.inbound_limit: 64
ii.olorin.gcc.*.iso_oslan.port: OSLAN_AA
ii.olorin.gcc.*.iso_oslan.status: OFF
ii.olorin.gcc.*.iso_x25.port: X25_AA
ii.olorin.gcc.*.iso_x25.status: OFF
ii.olorin.gcc.*.log_level: 4
ii.olorin.gcc.*.outbound_limit: 64
ii.olorin.gcc.*.sna_lu0.port: (none)
ii.olorin.gcc.*.sna_lu62.poll: 4000
ii.olorin.gcc.*.sna_lu62.port: (none)
ii.olorin.gcc.*.sna_lu62.status: OFF
ii.olorin.gcc.*.spx.port: aa
ii.olorin.gcc.*.spx.status: OFF
ii.olorin.gcc.*.tcp_ip.port: II0
ii.olorin.gcc.*.tcp_ip.status: OFF
ii.olorin.gcc.*.tcp_wol.port: II0
ii.olorin.gcc.*.tcp_wol.status: OFF
ii.olorin.gcc.*.vms_accounting: ON
ii.olorin.gcc.*.vms_ast_limit: 916
ii.olorin.gcc.*.vms_buffer_limit: 1253256
ii.olorin.gcc.*.vms_enqueue_limit: 1280
ii.olorin.gcc.*.vms_error: NLA0:
ii.olorin.gcc.*.vms_extent: 4000
ii.olorin.gcc.*.vms_file_limit: 394
ii.olorin.gcc.*.vms_image: ii_system:[ingres.bin]iigcc.exe
ii.olorin.gcc.*.vms_input: NLA0:
ii.olorin.gcc.*.vms_interval:
ii.olorin.gcc.*.vms_io_buffered: 778
ii.olorin.gcc.*.vms_io_direct: 306
ii.olorin.gcc.*.vms_maximum_working_set: 2000
ii.olorin.gcc.*.vms_output: NLA0:
ii.olorin.gcc.*.vms_page_file: 27924
ii.olorin.gcc.*.vms_priority: 4
ii.olorin.gcc.*.vms_privileges: (readall,prmmbx,sysname,cmkrnl,sysprv,share,world,netmbx,tmpmbx,exquota)
ii.olorin.gcc.*.vms_queue_limit: 266
ii.olorin.gcc.*.vms_working_set: 1000
ii.olorin.gcc.config.connect_sum: 128
ii.olorin.gcc.connect_max: 1
ii.olorin.gcn.*.vms_accounting: ON
ii.olorin.gcn.*.vms_ast_limit: 916
ii.olorin.gcn.*.vms_buffer_limit: 689544
ii.olorin.gcn.*.vms_enqueue_limit: 1280
ii.olorin.gcn.*.vms_error: NLA0:
ii.olorin.gcn.*.vms_extent: 16384
ii.olorin.gcn.*.vms_file_limit: 394
ii.olorin.gcn.*.vms_image: ii_system:[ingres.bin]iigcn.exe
ii.olorin.gcn.*.vms_input: NLA0:
ii.olorin.gcn.*.vms_interval:
ii.olorin.gcn.*.vms_io_buffered: 778
ii.olorin.gcn.*.vms_io_direct: 306
ii.olorin.gcn.*.vms_maximum_working_set: 16384
ii.olorin.gcn.*.vms_output: NLA0:
ii.olorin.gcn.*.vms_page_file: 27924
ii.olorin.gcn.*.vms_priority: 4
ii.olorin.gcn.*.vms_privileges: (readall,prmmbx,sysname,cmkrnl,sysprv,share,world,netmbx,tmpmbx,exquota)
ii.olorin.gcn.*.vms_queue_limit: 261
ii.olorin.gcn.*.vms_working_set: 1000
ii.olorin.gcn.check_interval: 300
ii.olorin.gcn.cluster_mode: OFF
ii.olorin.gcn.default_server_class: INGRES
ii.olorin.gcn.local_vnode: OLORIN
ii.olorin.gcn.session_limit: 16
ii.olorin.ingstart.*.begin: @ii_system:[ingres.utility]iishare
ii.olorin.ingstart.*.dbms: 1
ii.olorin.ingstart.*.gcc: 1
ii.olorin.ingstart.cathserver.dbms: 0
ii.olorin.ingstart.echoserver.dbms: 0
ii.olorin.ingstart.nuclabserver.dbms: 0
ii.olorin.ingstart.privileges: OPER,SYSNAM,SYSPRV,WORLD,PRMMBX,SHARE,READALL,SYSLCK,EXQUOTA,SYSGBL,PRMGBL
ii.olorin.ingstart.syscheck_mode: ON
ii.olorin.ingstop.privileges: OPER,SYSNAM,SYSPRV,WORLD,PRMMBX,SHARE,READALL,SYSLCK,EXQUOTA,SYSGBL,PRMGBL
ii.olorin.rcp.file.size: 50331648
ii.olorin.rcp.lock.hash_size: 3769
ii.olorin.rcp.lock.list_limit: 520
ii.olorin.rcp.lock.lock_limit: 18884
ii.olorin.rcp.lock.per_tx_limit: 480
ii.olorin.rcp.lock.resource_hash: 3769
ii.olorin.rcp.lock.resource_limit: 18884
ii.olorin.rcp.log.archiver_interval: 2
ii.olorin.rcp.log.block_size: 8
ii.olorin.rcp.log.buffer_count: 12
ii.olorin.rcp.log.cp_interval: 25
ii.olorin.rcp.log.cp_timer: 0
ii.olorin.rcp.log.database_limit: 42
ii.olorin.rcp.log.force_abort_limit: 72
ii.olorin.rcp.log.full_limit: 90
ii.olorin.rcp.log.lgk_memory_lock: OFF
ii.olorin.rcp.log.tx_limit: 520
ii.olorin.recovery.*.active_limit: 5
ii.olorin.recovery.*.connect_limit: 5
ii.olorin.recovery.*.event_limit: 0
ii.olorin.recovery.*.log_writer: 1
ii.olorin.recovery.*.name_service: ON
ii.olorin.recovery.*.stack_size: 32768
ii.olorin.recovery.*.vms_ast_limit: 20
ii.olorin.recovery.*.vms_buffer_limit: 66384
ii.olorin.recovery.*.vms_error: ii_system:[ingres.files]dmfrcp.error
ii.olorin.recovery.*.vms_extent: 131072
ii.olorin.recovery.*.vms_file_limit: 960
ii.olorin.recovery.*.vms_io_buffered: 20
ii.olorin.recovery.*.vms_io_direct: 20
ii.olorin.recovery.*.vms_page_file: 30600
ii.olorin.recovery.*.vms_priority: 4
ii.olorin.recovery.*.vms_privileges: (prmmbx,sysprv,world,readall,syslck,share,exquota,sysgbl,shmem)
ii.olorin.recovery.*.vms_quantum: ON
ii.olorin.recovery.*.vms_queue_limit: 20
ii.olorin.recovery.*.vms_stack_size: 32768
ii.olorin.star.connect_max: 0
ii.olorin.syscheck.channelcnt: 1078
ii.olorin.syscheck.dmf_seg_num: 0
ii.olorin.syscheck.dmf_segment: 0
ii.olorin.syscheck.gblpages: 9777
ii.olorin.syscheck.rcp_segment: 5005312
ii.olorin.syscheck.virtualpagecnt: 40800
Ingres Q & A
To William's Home Page
© William Yuan 2000
Email William