Here are the responses to all questions raised related to my problem of
FILE SIZE.

Daniel Rail wrote:

> Could you give more details on the system itself? Hard-drive size and
> available disk and/or volume space? CPU? Memory? Swap file/partition
> size? Can you show the header of the database file? What is the
> dialect of the database? Is it possible that it is a disk space issue,
> since the problem is always around the same db file size? And, what is
> the file system used?

I am using a 36 GB SCSI disk with an Adaptec card.

enclosed below is the output of df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda6 494M 156M 312M 34% /
/dev/sda1 99M 15M 79M 16% /boot
/dev/sda5 9.2G 7.1G 1.7G 81% /home ==== This is where my
database is located
none 756M 0 755M 0% /dev/shm
/dev/sda2 22G 4.7G 16G 23% /usr ==== This is where the
backup resides
/dev/sda7 1004M 331M 621M 35% /var

enclosed below is the top d 10 output

12:49pm up 18:42, 3 users, load average: 0.01, 0.07, 0.08
71 processes: 68 sleeping, 2 running, 1 zombie, 0 stopped
CPU states: 0.8% user, 4.0% system, 0.0% nice, 95.1% idle
Mem: 1548164K av, 1231872K used, 316292K free, 0K shrd, 128520K
buff
Swap: 1044216K av, 0K used, 1044216K free 949032K
cached

PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
498 firebird 15 0 104M 104M 2512 S 0.0 6.8 8:44 fbserver
721 root 15 0 4644 4644 1800 S 0.0 0.2 0:00 miniserv.pl
676 xfs 15 0 3100 3100 840 S 0.0 0.2 0:00 xfs
6314 root 15 0 2904 2904 2360 S 0.0 0.1 0:00 sendmail
6301 root 15 0 2848 2848 2048 S 0.0 0.1 0:00 sendmail
6331 root 15 0 2832 2832 2336 S 0.0 0.1 0:00 sendmail
628 root 15 0 2316 2316 2004 S 0.0 0.1 0:00 sendmail
637 smmsp 15 0 2080 2076 1588 S 0.0 0.1 0:00 sendmail
6302 root 15 0 1572 1572 1196 S 0.0 0.1 0:00 fetchmail
685 root 15 0 1500 1500 1332 S 0.0 0.0 0:00 smbd
767 root 15 0 1476 1476 1120 S 0.0 0.0 0:00 bash
29978 root 15 0 1476 1476 1120 S 0.0 0.0 0:00 bash
6500 root 15 0 1476 1476 1124 S 0.0 0.0 0:00 bash
579 root 15 0 1460 1460 1320 S 0.0 0.0 0:00 sshd
689 root 15 0 1376 1376 940 S 0.0 0.0 0:00 nmbd
497 firebird 16 0 1332 1332 1132 S 0.0 0.0 0:00 fbguard
3429 root 15 0 1120 1120 868 S 0.0 0.0 0:10 top

Swap file size allocated is 1 GB however the funny thing is on my RH
Linux 8.0 using Kernel 2.4.18 the swap space is rarely used. I have been
unable to find the reason for this.

The file system used is ext3.

Database dialect is 1

The header file output is as follows:

Database "/home/kms/hr.fdb"

Database header page information:
Flags 0
Checksum 12345
Generation 17986
Page size 8192
ODS version 10.1
Oldest transaction 15
Oldest active 17618
Oldest snapshot 17618
Next transaction 17978
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 19
Shadow count 0
Page buffers 10000
Next header page 0
Database dialect 1
Creation date Sep 23, 2004 21:25:23
Attributes force write

Variable header data:
Sweep interval: 20000
Continuation file: /home/kms/hr2.fdb
Last logical page: 25000
*END*

> Also, you might find some information here:
> http://www.ibphoenix.com/main.nfs?a=ibphoenix&d=kb&q=gds+consistency+check

The site tells me to repair the database but can someone help me with
the exact commands as this is a production database and I am a little
scared of experimenting as I have never repaired a db before.

what method do you use to backup the database?
Alan

Alan I use gbak on the command line of the linux prompt to backup the
database and I ensure that the backup is taken on a seperate partition.

Try to backup and restore the DB.. - Jan

Jan I have done that already twice but the problem seems to persist.
Also the file size is not growing now since yesterday. Even though new
records are being continuously added and data is being altered. The
application architecture guarantees that by the end of the day the db
size will grow atleast by 3-5 MB.

Let me know if anyone needs any more information or anyone can help me here.

Regards,


RP