SFMDB is consuming more disk space.

[karthikbalu]

Guys,

Would like to know is there a way we can rotate the below contents which is using by sfm?

#du -sk *
8 PG_VERSION
5498288 base

#cd base

#ll
total 112
drwx------ 2 sfmdb users 8192 Jun 8 2010 1
drwx------ 3 sfmdb users 8192 Oct 29 09:18 168172
drwx------ 2 sfmdb users 8192 Oct 29 09:15 168492
drwx------ 2 sfmdb users 8192 Jun 12 12:59 168812
drwx------ 2 sfmdb users 8192 Jun 8 2010 168813
drwx------ 2 sfmdb users 8192 Jun 8 2010 17141
drwx------ 3 sfmdb users 8192 Nov 4 01:05 174733

Under this directory there are plenty of files which almost all in data format.  I wonder what these data really contains...Can someone help me understand about these files  and the possible way to get rid to get back the space??

[Dennis Handly]

What is the path to the directory?  What HP-UX version?

[karthikbalu]

Path =  /var/opt/sfmdb/pgsql/base  & OS version is HPUX B.11.23.

[Duncan Edmonstone]

Anything written to /var/opt/sfmdb/pgsql /sfmdb.log   ?

There are some articles in the knowledge base that indicate if sfmdb doesn't start correctly it can grow fast...