My understanding (definitely subject to correction as needed) is that the B1 file grows as needed when large numbers of transactions are processed. Then as they are committed and removed form the B1 the file size remains at the same size. It does not "give back" the disk space. OK, here is my sketchy part...when the DB is shutdown and restarted it recreates the B1 empty and smaller. There is also a routine to truncate the B1 file and remove the before images which also reduces it. But in normal operations a shutdown/restart should be enough...I think.
The size of the B1 file depends a lot on the number of transactions occuring at once before they are committed. I had an issue awhile back where a job closing process running over a weekend expanded the B1 to almost 3GB - twice the size of the DB and it consumed all the free disk space. I had to truncate the B1 and delete it before restarting the DB - and fortunately had no corruption. As a hunch I would guess our 65MB B1 is at the moment only 10% or so used so we would have to have a burst of transactions to force it to grow again.
In John's case of a backup suddenly growing the B1 might have been more full and this extra got backed up. I believe only the transactions in the B1 get backed up and not all the empty space so once they are committedd the backup should shrink back - but the file itself would remain bloated. If they don't then it sounds like something is hung and even if it doe snot reduce the files size a DB shutdown/restart could free the stuck B1 entries.
Not to say this B1 thing really is the cause of the backup issue...it could still be log files or something else. Before doing anything other than a shutdown/restart (like attempting the B1 truncate) it might be wise to talk to support first.
-Todd C.
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Jasper Recto
Sent: Friday, January 06, 2006 7:19 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Whats going on?
After reading the last serveral messages I checked the size of our files.
-b1 558MB
-d1 984MB
Why is my ratio so large? I believe the last time I restarted the database was 2 weeks ago.
Thanks,
Jasper
-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Thursday, January 05, 2006 6:17 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Whats going on?
I think the 500MB in your B1 is the culprit. It should usually be a lot smaller than that. Our ratio is 1.4GB to 65MB and Vantage has been running for at least 3-4 months without a restart.
If there is a better approach than a shutdown/restart to commit those transactions and free the before images perhaps someone else can advise.
-Todd C.
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of John Mansfield
Sent: Thursday, January 05, 2006 5:03 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Whats going on?
Hi Todd,
I checked the b1 and d1 file sizes.
- b1 .5 gig
- d1 2.3 gig
I will watch these files.
Thanks,
John Mansfield
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
SPONSORED LINKS
Manufacturing < http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> &k=Manufacturing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software Membership < http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> &k=Membership+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> database software Database < http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> &k=Database+mortgage+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage software
Pda < http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> &k=Pda+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database software Database < http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> &k=Database+management+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> management software Database < http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw> &k=Database+marketing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw> marketing software
_____
YAHOO! GROUPS LINKS
* Visit your group " vantage < http://groups.yahoo.com/group/vantage> " on the web.
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service < http://docs.yahoo.com/info/terms/> .
_____
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
_____
YAHOO! GROUPS LINKS
* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .
_____
[Non-text portions of this message have been removed]
The size of the B1 file depends a lot on the number of transactions occuring at once before they are committed. I had an issue awhile back where a job closing process running over a weekend expanded the B1 to almost 3GB - twice the size of the DB and it consumed all the free disk space. I had to truncate the B1 and delete it before restarting the DB - and fortunately had no corruption. As a hunch I would guess our 65MB B1 is at the moment only 10% or so used so we would have to have a burst of transactions to force it to grow again.
In John's case of a backup suddenly growing the B1 might have been more full and this extra got backed up. I believe only the transactions in the B1 get backed up and not all the empty space so once they are committedd the backup should shrink back - but the file itself would remain bloated. If they don't then it sounds like something is hung and even if it doe snot reduce the files size a DB shutdown/restart could free the stuck B1 entries.
Not to say this B1 thing really is the cause of the backup issue...it could still be log files or something else. Before doing anything other than a shutdown/restart (like attempting the B1 truncate) it might be wise to talk to support first.
-Todd C.
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Jasper Recto
Sent: Friday, January 06, 2006 7:19 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Whats going on?
After reading the last serveral messages I checked the size of our files.
-b1 558MB
-d1 984MB
Why is my ratio so large? I believe the last time I restarted the database was 2 weeks ago.
Thanks,
Jasper
-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Thursday, January 05, 2006 6:17 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Whats going on?
I think the 500MB in your B1 is the culprit. It should usually be a lot smaller than that. Our ratio is 1.4GB to 65MB and Vantage has been running for at least 3-4 months without a restart.
If there is a better approach than a shutdown/restart to commit those transactions and free the before images perhaps someone else can advise.
-Todd C.
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of John Mansfield
Sent: Thursday, January 05, 2006 5:03 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Whats going on?
Hi Todd,
I checked the b1 and d1 file sizes.
- b1 .5 gig
- d1 2.3 gig
I will watch these files.
Thanks,
John Mansfield
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
SPONSORED LINKS
Manufacturing < http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> &k=Manufacturing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software Membership < http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> &k=Membership+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> database software Database < http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> &k=Database+mortgage+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage software
Pda < http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> &k=Pda+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database software Database < http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> &k=Database+management+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> management software Database < http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw> &k=Database+marketing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw> marketing software
_____
YAHOO! GROUPS LINKS
* Visit your group " vantage < http://groups.yahoo.com/group/vantage> " on the web.
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service < http://docs.yahoo.com/info/terms/> .
_____
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
_____
YAHOO! GROUPS LINKS
* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .
_____
[Non-text portions of this message have been removed]