dbTalk Databases Forums  

Syschk Message - What Does It Mean and What Should Be Done About It

comp.databases.pick comp.databases.pick


Discuss Syschk Message - What Does It Mean and What Should Be Done About It in the comp.databases.pick forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
ddspell-m3
 
Posts: n/a

Default Syschk Message - What Does It Mean and What Should Be Done About It - 06-27-2006 , 11:52 AM







syschk: Overflow usage (93.8%) exceeds 90%

I've resized just about all the files on the system, so what am I
missing here. I take this message to mean that the overflow space is
almost used up. Okay, so what should be done to remedy this?


Thanks,
Danny
Dallas, TX


Reply With Quote
  #2  
Old   
Kevin Powick
 
Posts: n/a

Default Re: Syschk Message - What Does It Mean and What Should Be Done About It - 06-27-2006 , 12:39 PM






ddspell-m3 wrote:

Quote:
syschk: Overflow usage (93.8%) exceeds 90%

Okay, so what should be done to remedy this?
You could start by providing some information like:

database product, Version, operating system, etc.

--
Kevin Powick


Reply With Quote
  #3  
Old   
ddspell-m3
 
Posts: n/a

Default Re: Syschk Message - What Does It Mean and What Should Be Done About It - 06-27-2006 , 01:00 PM



Kevin Powick wrote:
Quote:
ddspell-m3 wrote:

syschk: Overflow usage (93.8%) exceeds 90%

Okay, so what should be done to remedy this?

You could start by providing some information like:

database product, Version, operating system, etc.

--
Kevin Powick
Running on D3 7.2.1 Linux from Raining Data on Red Hat 7.1 (Seawolf).
ABS patch level is 7.2.1.A96.


Thanks,
Danny



Reply With Quote
  #4  
Old   
AT
 
Posts: n/a

Default Re: Syschk Message - What Does It Mean and What Should Be Done About It - 06-27-2006 , 01:23 PM



Granted, I am not certain this applies to linux but it may well work.
For D3 on AIX, this is symptomatic of the /var/adm/wtmp file being too
large. Perform the following as root:

cd /var/adm
rm wtmp
touch wtmp

As I said, that works in AIX...not sure about linux.

BTW, hi Danny. I'm not sure you would remember me, but we have an
acquaintance in common in the person of Gil Garcia. I worked with him
briefly in Dallas but I'm now in Wichita, Kansas.

-Bruce Holt


ddspell-m3 wrote:
Quote:
Kevin Powick wrote:
ddspell-m3 wrote:

syschk: Overflow usage (93.8%) exceeds 90%

Okay, so what should be done to remedy this?

You could start by providing some information like:

database product, Version, operating system, etc.

--
Kevin Powick

Running on D3 7.2.1 Linux from Raining Data on Red Hat 7.1 (Seawolf).
ABS patch level is 7.2.1.A96.


Thanks,
Danny


Reply With Quote
  #5  
Old   
AT
 
Posts: n/a

Default Re: Syschk Message - What Does It Mean and What Should Be Done About It - 06-27-2006 , 01:27 PM




ddspell-m3 wrote:
Quote:
syschk: Overflow usage (93.8%) exceeds 90%

I've resized just about all the files on the system, so what am I
missing here. I take this message to mean that the overflow space is
almost used up. Okay, so what should be done to remedy this?
This is a d3 message that indicates that your virtual storage space is
almost full.

If it has been a long time since your last save/restore, doing one
might help recover some lost space. Otherwise, you need to delete some
data or increase the amount of space allocated to d3 data files.
Depending on your hardware configuration, adding space might require
hardware additions/changes.

Resizing files often results in better performance, but more space
used, so this does not help.

Quote:
Thanks,
Danny
Dallas, TX


Reply With Quote
  #6  
Old   
ddspell-m3
 
Posts: n/a

Default Re: Syschk Message - What Does It Mean and What Should Be Done About It - 06-27-2006 , 02:02 PM




mvdbman (AT) yahoo (DOT) com wrote:
Quote:
Granted, I am not certain this applies to linux but it may well work.
For D3 on AIX, this is symptomatic of the /var/adm/wtmp file being too
large. Perform the following as root:

cd /var/adm
rm wtmp
touch wtmp

As I said, that works in AIX...not sure about linux.

BTW, hi Danny. I'm not sure you would remember me, but we have an
acquaintance in common in the person of Gil Garcia. I worked with him
briefly in Dallas but I'm now in Wichita, Kansas.

-Bruce Holt

Hey Bruce,


I remember the name. Can't remember when. Reply to my personal email
and we can catch up.


Regards,
Danny



Reply With Quote
  #7  
Old   
ddspell-m3
 
Posts: n/a

Default Re: Syschk Message - What Does It Mean and What Should Be Done About It - 06-27-2006 , 03:43 PM




mvdbman (AT) yahoo (DOT) com wrote:
Quote:
Granted, I am not certain this applies to linux but it may well work.
For D3 on AIX, this is symptomatic of the /var/adm/wtmp file being too
large. Perform the following as root:

cd /var/adm
rm wtmp
touch wtmp

As I said, that works in AIX...not sure about linux.

BTW, hi Danny. I'm not sure you would remember me, but we have an
acquaintance in common in the person of Gil Garcia. I worked with him
briefly in Dallas but I'm now in Wichita, Kansas.

-Bruce Holt
Well, there's a var directory in the OS, but there isn't any adm
sub-directory.



Reply With Quote
  #8  
Old   
Frank Winans
 
Posts: n/a

Default Re: Syschk Message - What Does It Mean and What Should Be Done About It - 07-14-2006 , 02:44 PM



"ddspell-m3" wrote
Quote:
syschk: Overflow usage (93.8%) exceeds 90%

I've resized just about all the files on the system, so what am I
missing here. I take this message to mean that the overflow space is
almost used up. Okay, so what should be done to remedy this?


Thanks,
Danny
Dallas, TX
The command FREE will verify that your d3 disk space allocation is
near full. The line of stars "*" are sort of like a gas guage on your car,
more stars mean a fuller 'tank' of unused disk space.

Your file resizing will take effect when you next reload your system;
the file-resize verb just makes notes on how to size the files later on,
it doesn't instantly change the space used on disk of each file.
Wrongly-sized files are not the first thing I'd suspect in an over-full
system. Typically they're sized too small, which hurts performance,
instead of too large. If you've done a save lately and let it collect
file statistics, then LIST-FILE-STATS DET-SUPP will show
which accounts are the biggest disk hogs. Omit the DET-SUPP to
see what files are the biggest hogs, but expect dozens or hundreds
of pages of output if you show all accounts w/o DET-SUPP.

One thing that tends to eat up disk space is held print jobs. On all
but the oldest d3 releases, you can treat 'peqs' as a magic disk file,
doing commands like LIST PEQS TOTAL SIZE {result is in bytes,
so drop the last 6 digits for 'megs' of use.}

Enlarging the allocated space can be as easy as editing the file
/usr/lib/pick/pick0 and taking d3 down briefly. Older versions had
a limit of 2.1 gigs for each DISK line.




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.