We help IT Professionals succeed at work.
Get Started

Informix 9.4TC on Windows, physlog and logspace at 99% full, how ti clear or increase

ksquyres
ksquyres asked
on
714 Views
Last Modified: 2012-08-14
I have a Windows server 2003 with an IBM Informix Dynamic Server 9.40.TC7. New to the site but the situation is starting last week it will run for a while then odbc connections hang. A restart will usually bring it up for a while. It is running Misys software. Through their utilities I found that the physlog and logspace for the Informix instance are both 99% full. Suspect it's the problem. I know MS SQL but little about Informix. My understanding is that these are transaction logs and I would assume they would stay mostly clear. There are 10 users, moderate activity at most in a medical office. Off at night and weekends, but logs never change. I have been able to enable backups, that script uses ontape. and I now have access to command lines like onstat. It confirms physlog size 56320 free 72, and logspace size 153600 and free 547. How do I clear? Extend? I only need to buy about 6 weeks of use as a migration is underway.
Comment
Watch Question
Commented:
This problem has been solved!
Unlock 1 Answer and 9 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE