×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Informix Online 5 freezes several times a week

Informix Online 5 freezes several times a week

Informix Online 5 freezes several times a week

(OP)
Hi,

Several times Informix 5.10.UC1 freezes. When running tbstat -uk I see in the header "CHKPNT REQ". Nothing some to help (tbstat -c e.q). The only solution is to stop the database and start up Informix again.

Can somebody give me some tips? The database is running in a production environment on a virtual (VMWare) server.

Greetings,
Marco
The Netherlands

** Here some parameters **

# Root Dbspace Configuration

ROOTNAME        rootdbs         # Root dbspace name
ROOTPATH        /dev/rinformix0 # Path for device containing root dbspace
ROOTOFFSET      0               # Offset of root dbspace into device (Kbytes)
ROOTSIZE        2000000         # 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         rootdbs         # Name of dbspace that contains physical log
PHYSFILE        2000            # Physical log file size (Kbytes)

# Logical Log Configuration

LOGFILES        55              # Number of logical log files
LOGSIZE         1000            # Size of each logical log file (Kbytes)
# Shared Memory Parameters

RESIDENT        1               # Forced residency flag (Yes = 1, No = 0)
USERS           150             # Maximum number of concurrent user processes
TRANSACTIONS    150             # Maximum number of concurrent transactions
LOCKS           10000           # Maximum number of locks
BUFFERS         1000            # Maximum number of shared memory buffers
TBLSPACES       2300            # Maximum number of active tblspaces
CHUNKS          8               # Maximum number of chunks
DBSPACES        8               # Maximum number of dbspaces and blobspaces
PHYSBUFF        32              # Size of physical log buffers (Kbytes)
LOGBUFF         32              # Size of logical log buffers (Kbytes)
LOGSMAX         61              # Maximum number of logical log files
CLEANERS        1               # Number of page-cleaner processes
SHMBASE         0x0               # Shared memory base address
CKPTINTVL       300             # Checkpoint interval (in seconds)
LRUS            8               # Number of LRU queues
LRU_MAX_DIRTY   60              # LRU modified begin-cleaning limit (percent)
LRU_MIN_DIRTY   50              # LRU modified end-cleaning limit (percent)
LTXHWM          50              # Long TX high-water mark (percent)
LTXEHWM         60              # Long TX exclusive high-water mark (percent)

RE: Informix Online 5 freezes several times a week

Have a look here:
http://my.safaribooksonline.com/book/databases/informix/0130796239/understanding-the-online-utilities/124

Quote:

(CKPT REQ) Some process has requested a checkpoint, and the engine is trying to initiate the checkpoint. This flag is often seen if the database is hung waiting for a checkpoint.
and here:
http://www.prstech.com/resources/src/informix_faq/ifaq06.htm#6.23

Hope This Helps, PH.
FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ181-2886: How can I maximize my chances of getting an answer?

RE: Informix Online 5 freezes several times a week

(OP)
Hi PHV,

Thanks for your tips. Last month I tried a lot, but nothings works.

CLEANERS: from 1 to 6
LOCKS: from 10.000 to 80.000
BUFFERS: from 1000 to 5.000
LRU_MAX_DIRTY: from 60 to 40
LRU_MIN_DIRTY: from 50 to 30

Database is still freezing, sometimes 10 times a day. Do you haven additional hints or tips?

Thanks,
Marco

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close