Re: PAGE CLEANERS
Posted in 1998
I am including tbconfig, so you can take a look at it. Any suggestion will be
appreciated.
# Root Dbspace Configuration
ROOTNAME onlinedbs_tsg #Root dbspace nameROOTPATH /dev/onlinedbs_tsg #Path for device containing root dbspace
ROOTOFFSET 512 #Offset of root dbspace in device (Kbytes)
ROOTSIZE 187904 # Size of root dbspace (Kbytes)
# Disk Mirroring Configuration
MIRROR 0 # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH # Path for device containing root dbspace mirror
MIRROROFFSET 0 # Offset into mirror device (Kbytes)
# Physical Log Configuration
#PHYSDBS # Name of dbspace that contains physical log
#PHYSFILE 5120 # Physical log file size (Kbytes)
# Logical Log Configuration
#LOGFILES 3 # Number of logical log files
#LOGSIZE 2560 # Size of each logical log file (Kbytes)
# Message Files
MSGPATH /usr/informix/tsg.log # OnLine message log pathname
CONSOLE /dev/tty1 # System console message pathname
# Archive Tape Device
TAPEDEV /dev/rmt0 # Archive tape device pathname
TAPEBLK 1024 # Archive tape block size (Kbytes)
TAPESIZE 524288000 # Max amount of data to put on tape (Kbytes)
# Logical Log Backup Tape Device
LTAPEDEV /copias/backup/logs.tsg # Logical log tape device pathname
LTAPEBLK 1024 # Logical log tape block size
(Kbytes)
LTAPESIZE 524288000 # Max amount of data to put on log tape
(Kbytes)
# Identification Parameters
SERVERNUM 1 # Unique id associated with this OnLineinstance
DBSERVERNAME tsg # Unique name of this OnLine instance
# Shared Memory Parameters
RESIDENT 0 # Forced residency flag (Yes = 1, No = 0)USERS 200 # Maximum number of concurrent user processes
TRANSACTIONS 320 # Maximum number of concurrent transactions
LOCKS 50000 # Maximum number of locks
BUFFERS 1500 # Maximum number of shared memory buffersTBLSPACES 3000 # Maximum number of active tblspaces
CHUNKS 20 # Maximum number of chunks
DBSPACES 15 # Maximum number of dbspaces and blobspaces
PHYSBUFF 32 # Size of physical log buffers (Kbytes)
LOGBUFF 32 # Size of logical log buffers (Kbytes)LOGSMAX 40 # Maximum number of logical log files
CLEANERS 4 # Number of page-cleaner processes
SHMBASE 0x30000000 # Shared memory base address
CKPTINTVL 300 # Checkpoint interval (in seconds)
LRUS 8 # Number of LRU queues
LRU_MAX_DIRTY 30 # LRU modified begin-cleaning limit (percent)
LRU_MIN_DIRTY 20 # LRU modified end-cleaning limit (percent)
LTXHWM 50 # Long TX high-water mark (percent)
LTXEHWM 60 # Long TX exclusive high-water mark (percent)
# Machine- and Product-Specific Parameters
DYNSHMSZ 200 # Dynamic shared memory size (Kbytes)
GTRID_CMP_SZ 16 # Number of bytes to use in GTRID comparision
DEADLOCK_TIMEOUT 60 # Max time to wait for lock in distributed env.
TXTIMEOUT 300 # Transaction timeout for I-STAR (in seconds)SPINCNT 0 # No. of times process tries for latch
STAGEBLOB # Reserved for INFORMIX-OnLine/Optical
# System Page Size
BUFFSIZE 4096 # Page size (do not change!)
PHYSDBS phydbs_tsg # Name of dbspace that contains physical log
PHYSFILE 16020 # Physical log file size (Kbytes)
LOGFILES 10 # Number of logical log files
LOGSIZE 5120 # Size of each logical log file (Kbytes)
Thanks,
Julia
David Williams wrote:
> In article <3520E280.E03605CD@interbook.net>, Julia Barbeito Rodr'guez
> <sessolucions@interbook.net> writes
> >*HELLO,
> >*
> >*I HAVE A PROBLEM. I AM USING V 5.10 AND I HAVE A PROBLEM WITH PAGE
> >CLEANERS.
> >*AT SOME UNDETERMIDED MOMENT 2 OF MY 4 PAGE CLEANERS GO ON ERROR.
> >*AND THE DATABASE GOES NUTS, IT WON'T ALLOW ME TO TAKE IT OFFLINE, AND
> >*I HAVE TO REBBOT THE MACHINE.
> >*IF SOMEONE MAY HAVE HAD THIS PROBLEM, PLEASE HELP ME.
>
> Check $INFORMIXDIR/etc/$TBCONFIG
>
> in this file the MSGPATH parameter will point to a file
>
> what does that fiel (online.log) say?
>
> --
> David Williams
>
> Maintainer of the Informix FAQ
> Primary site (Beta Version) http://www.smooth1.demon.co.uk
> Official site http://www.iiug.org/techinfo/faq/faq_top.html
>
> I see you standin', Standin' on your own, It's such a lonely place for you, For
> you to be If you need a shoulder, Or if you need a friend, I'll be here
> standing, Until the bitter end...
> So don't chastise me Or think I, I mean you harm...
> All I ever wanted Was for you To know that I care