RE: checkpoint problem

Duplicate problem?? Have you got KAIO turned on? How many dbspaces/chunks/disks have you got? Are your chunks cooked or raw? onstat -d Keith -> -----Original Message----- -> From: mchivaviro@okzim.co.zw [mailto:mchivaviro@okzim.co.zw] -> Sent: Tuesday, June 20, 2006 7:58 AM -> To: informix-list@iiug.org -> Subject: checkpoint problem -> -> -> -> I am runnind IDS 7.31 on HPUX 11 and my check points a -> taking too long. -> What do I need to change. -> -> 12:03:10 Checkpoint Completed: duration was 21 seconds. -> 12:09:48 Checkpoint Completed: duration was 34 seconds. -> 12:16:27 Checkpoint Completed: duration was 36 seconds. -> 12:23:07 Checkpoint Completed: duration was 37 seconds. -> 12:29:39 Checkpoint Completed: duration was 28 seconds. -> 12:32:24 Logical Log 159104 Complete. -> 12:32:28 Logical Log 159104 - Backup Started -> 12:32:31 Logical Log 159104 - Backup Completed -> 12:36:10 Checkpoint Completed: duration was 27 seconds. -> 12:42:58 Checkpoint Completed: duration was 44 seconds. -> 12:42:59 Logical Log 159105 Complete. -> 12:43:01 Logical Log 159105 - Backup Started -> 12:43:05 Logical Log 159105 - Backup Completed -> 12:49:42 Checkpoint Completed: duration was 40 seconds. -> 12:52:55 Logical Log 159106 Complete. -> 12:52:55 Logical Log 159106 - Backup Started -> 12:52:58 Logical Log 159106 - Backup Completed -> -> CONFIG FILE -> DEADLOCK_TIMEOUT 60 # Max time to wait of lock in -> distributed env. -> RESIDENT 0 # Forced residency flag (Yes = 1, No = -> 0) -> -> MULTIPROCESSOR 1 # 0 for single-processor, 1 for -> multi-processor -> NUMCPUVPS 2 # Number of user (cpu) vps -> SINGLE_CPU_VP 0 # If non-zero, limit number -> of cpu vps -> to one -> -> NOAGE 1 # Process aging -> AFF_SPROC 0 # Affinity start processor -> AFF_NPROCS 0 # Affinity number of processors -> -> # Shared Memory Parameters -> -> LOCKS 500000 # Maximum number of locks -> BUFFERS 200000 # Maximum number of shared buffers -> NUMAIOVPS 8 # Number of IO vps -> PHYSBUFF 128 # Physical log buffer size (Kbytes) -> LOGBUFF 128 # Logical log buffer size (Kbytes) -> LOGSMAX 100 # Maximum number of logical log files -> CLEANERS 127 # Number of buffer cleaner processes -> SHMBASE 0x0 # Shared memory base address -> SHMVIRTSIZE 300000 # initial virtual shared -> memory segment -> size -> SHMADD 40000 # Size of new shared memory segments -> (Kbytes) -> SHMTOTAL 0 # Total shared memory (Kbytes). -> 0=>unlimited -> CKPTINTVL 360 # Check point interval (in sec) -> LRUS 127 # Number of LRU queues -> LRU_MAX_DIRTY 1 # LRU percent dirty begin cleaning -> limit -> LRU_MIN_DIRTY 0 # LRU percent dirty end -> cleaning limit -> LTXHWM 50 # Long transaction high water mark -> percentage -> LTXEHWM 60 # Long transaction high water mark -> (exclusive) -> TXTIMEOUT 0x12c # Transaction timeout (in sec) -> STACKSIZE 64 # Stack size (Kbytes) -> -> # System Page Size -> # BUFFSIZE - Dynamic Server no longer supports this configuration -> parameter. -> # To determine the page size used by Dynamic -> Server on your -> platform -> # see the last line of output from the command, -> 'onstat -b'. -> -> -> # Recovery Variables -> # OFF_RECVRY_THREADS: -> # Number of parallel worker threads during fast recovery or -> an offline -> restore. -> # ON_RECVRY_THREADS: -> # Number of parallel worker threads during an online restore. -> -> OFF_RECVRY_THREADS 10 # Default number of offline worker -> threads -> ON_RECVRY_THREADS 1 # Default number of online worker -> threads -> -> # Data Replication Variables -> # DRAUTO: 0 manual, 1 retain type, 2 reverse type -> DRAUTO 0 # DR automatic switchover -> DRINTERVAL 30 # DR max time between DR -> buffer flushes -> (in sec) -> DRTIMEOUT 30 # DR network timeout (in sec) -> DRLOSTFOUND /u/informix/etc/dr.lostfound # DR lost+found -> file path -> -> # CDR Variables -> CDR_LOGBUFFERS 2048 # size of log reading buffer pool -> (Kbytes) -> CDR_EVALTHREADS 1,2 # evaluator threads -> (per-cpu-vp,additional) -> CDR_DSLOCKWAIT 5 # DS lockwait timeout (seconds) -> CDR_QUEUEMEM 4096 # Maximum amount of memory -> for any CDR -> queue (Kbytes) -> CDR_LOGDELTA 30 # % of log space allowed in queue -> memory -> CDR_NUMCONNECT 400 # Expected connections per server -> CDR_NIFRETRY 300 # Connection retry (seconds) -> CDR_NIFCOMPRESS 0 # Link level compression (-1 never, 0 -> none, 9 max) -> -> # Backup/Restore variables -> BAR_ACT_LOG /tmp/bar_act.log -> BAR_MAX_BACKUP 0 -> BAR_RETRY 1 -> BAR_NB_XPORT_COUNT 10 -> BAR_XFER_BUF_SIZE 31 -> -> # Informix Storage Manager variables -> ISM_DATA_POOL ISMData # If the data pool name is -> changed, be -> sure to -> # update -> $INFORMIXDIR/bin/onbar. Change to -> # ism_catalog -create_bootstrap -> -pool <new name> -> ISM_LOG_POOL ISMLogs -> -> # Read Ahead Variables -> RA_PAGES # Number of pages to attempt to read -> ahead -> RA_THRESHOLD # Number of pages left before next -> group -> -> # DBSPACETEMP: -> # Dynamic Server equivalent of DBTEMP for SE. This is the list of -> dbspaces -> # that the Dynamic Server SQL Engine will use to create temp tables -> etc. -> # If specified it must be a colon separated list of dbspaces -> that exist -> # when the Dynamic Server system is brought online. If not -> specified, -> or if -> # all dbspaces specified are invalid, various ad hoc queries will -> create -> # temporary files in /tmp instead. -> -> DBSPACETEMP tempdbs # Default temp dbspaces -> -> # DUMP*: -> # The following parameters control the type of diagnostics -> information -> which -> # is preserved when an unanticipated error condition (assertion -> failure) occurs -> # during Dynamic Server operations. -> # For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No. -> -> DUMPDIR /tmp # Preserve diagnostics in this -> directory -> DUMPSHMEM 0 # Dump a copy of shared memory -> DUMPGCORE 0 # Dump a core image using 'gcore' -> DUMPCORE 0 # Dump a core image (Warning:this -> aborts Dynamic Server) -> DUMPCNT 1 # Number of shared memory or gcore -> dumps for -> # a single user's session@@