cancel
Showing results forΒ 
Search instead forΒ 
Did you mean:Β 

BMR database is huge comparatively

symsonu
Level 6

Hello,

 

I am facing space crunch in root filesystem.

and I can see that most of the space is used by BMR DB in data and staging folder.

 

/usr/openv/db/data
# ls -lh
total 4965898
-rw-------   1 root     root        4.6M Dec 19 10:54 BMRDB.db
-rw-------   1 root     root        4.0K Dec 19 10:54 BMRDB.log
-rw-------   1 root     root        2.0G Dec 17 16:34 BMR_DATA.db
-rw-------   1 root     root         25M Dec 14  2013 BMR_INDEX.db
-rw-------   1 root     root         25M Sep 11  2013 DARS_DATA.db
-rw-------   1 root     root         25M Sep 11  2013 DARS_INDEX.db
-rw-------   1 root     root         25M Dec 19 03:14 DBM_DATA.db
-rw-------   1 root     root         25M Dec 19 03:14 DBM_INDEX.db
-rw-------   1 root     root        132M Dec 17 15:34 EMM_DATA.db
-rw-------   1 root     root         25M Dec 16 17:01 EMM_INDEX.db
-rw-------   1 root     root         25M Dec 17 15:14 JOBD_DATA.db
-rw-------   1 root     root        2.3M Dec 19 10:54 NBAZDB.db
-rw-------   1 root     bin         2.3M Sep 16  2012 NBAZDB.db.template
-rw-------   1 root     root        4.0K Dec 19 10:54 NBAZDB.log
-rw-------   1 root     root        3.4M Dec 19 10:54 NBDB.db
-rw-------   1 root     root        4.0K Dec 19 10:54 NBDB.log
-rw-------   1 root     root         25M Sep 11  2013 SEARCH_DATA.db
-rw-------   1 root     root         25M Sep 11  2013 SEARCH_INDEX.db
-rw-------   1 root     root         627 Dec 15 00:02 vxdbms.conf
-rw-------   1 root     root           0 Sep 11  2013 vxdbms_conf.lock
# cd ../staging
# ls -lh
total 4960790
-r--------   1 root     root        4.6M Dec 15 00:09 BMRDB.db
-r--------   1 root     root        2.0G Dec 15 00:02 BMR_DATA.db
-r--------   1 root     root         25M Dec 15 00:02 BMR_INDEX.db
-r--------   1 root     root         25M Dec 15 00:02 DARS_DATA.db
-r--------   1 root     root         25M Dec 15 00:02 DARS_INDEX.db
-r--------   1 root     root         25M Dec 15 00:02 DBM_DATA.db
-r--------   1 root     root         25M Dec 15 00:02 DBM_INDEX.db
-r--------   1 root     root        132M Dec 15 00:09 EMM_DATA.db
-r--------   1 root     root         25M Dec 15 00:02 EMM_INDEX.db
-r--------   1 root     root         25M Dec 15 00:09 JOBD_DATA.db
-r--------   1 root     root        2.3M Dec 15 00:09 NBAZDB.db
-r--------   1 root     root        3.3M Dec 15 00:09 NBDB.db
-r--------   1 root     root         25M Dec 15 00:02 SEARCH_DATA.db
-r--------   1 root     root         25M Dec 15 00:02 SEARCH_INDEX.db
-rw-------   1 root     root         117 Dec 15 00:02 databases.conf
-rw-------   1 root     root         185 Dec 15 00:02 server.conf
-rw-------   1 root     root         627 Dec 15 00:02 vxdbms.conf

 

 

How can I reduce these or take care of to release space?

 

Regards

Sumit

 

1 ACCEPTED SOLUTION

Accepted Solutions
3 REPLIES 3

Pangal
Level 5

It doesnt fix my issue...the bmr is over 5Gb which is simply far too large for what it contains.

The script just says the db instance is clean and then exits.

Ive seen this before...theres another issue at play here Im sure.

Marianne
Level 6
Partner    VIP    Accredited Certified
This particular post has been solved.
Please start a new discussion for your issue.