Chris Hughes
ProgressTalk.com Sponsor
Hi
First time in 3 years I've hit this particular problem with our app....
Say you have a really large database 100GB+, and an audit table of 30GB+.
The software upgrade requires a DF to be loaded against that DB (mostly new tables, but some addtional fields and indexes).
This takes 7 hours+ and generates a BI file in excess of 70GB.
I've tried this multiple times
1) Ran out of disk space on first couple of attempts
2) Tried starting the DB with -i and -r (still writes to BI files though)
I can see there is a new field being added to the audit table in the DF.
So just wondering if there is a proserv parameter I've overlooked that could help or perhaps a better approach?
Just glad I'm not dealing with TB dbs yet
Thanks
Chris
First time in 3 years I've hit this particular problem with our app....
Say you have a really large database 100GB+, and an audit table of 30GB+.
The software upgrade requires a DF to be loaded against that DB (mostly new tables, but some addtional fields and indexes).
This takes 7 hours+ and generates a BI file in excess of 70GB.
I've tried this multiple times
1) Ran out of disk space on first couple of attempts
2) Tried starting the DB with -i and -r (still writes to BI files though)
I can see there is a new field being added to the audit table in the DF.
So just wondering if there is a proserv parameter I've overlooked that could help or perhaps a better approach?
Just glad I'm not dealing with TB dbs yet
Thanks
Chris