Dump and load

Yahoo Archive
1
Has anyone performed a dump and load to their Vantage database recently? We
are planning on doing this over the holidays in an attempt to improve our
Vantage performance. We ran the TABANYLYS command to gather statistics and
it showed many of our tables with a scatter index of greater than the 2
recommended (many of the bigger table had 6-8 for the scatter index) so we
think it should help with performance. We have been on Vantage for about 3.5
years and our multi-extent database is has 15 .d files at 204,800 kb with
matching .b files which in total would be over 6 GB. Does anyone have any
tips or recommendations? The only instructions I have come from the Progress
Database Guide and Reference.

Tim Goertz
IS Manager
Bermo Inc.



[Non-text portions of this message have been removed]
2
Tim,
I'm planning on doing a dump and load over the holidays also. 6 GB wow!
It's good to know that Vantage works with that big of a database. The last
time I talked to support they were going to send me a dump and load kit. I
just put a request in to remind them.

-----Original Message-----
From: tim.goertz@... [mailto:tim.goertz@...]
Sent: Monday, December 17, 2001 2:13 PM
To: vantage@yahoogroups.com
Subject: [Vantage] dump and load


Has anyone performed a dump and load to their Vantage database recently? We
are planning on doing this over the holidays in an attempt to improve our
Vantage performance. We ran the TABANYLYS command to gather statistics and
it showed many of our tables with a scatter index of greater than the 2
recommended (many of the bigger table had 6-8 for the scatter index) so we
think it should help with performance. We have been on Vantage for about 3.5
years and our multi-extent database is has 15 .d files at 204,800 kb with
matching .b files which in total would be over 6 GB. Does anyone have any
tips or recommendations? The only instructions I have come from the Progress
Database Guide and Reference.

Tim Goertz
IS Manager
Bermo Inc.



[Non-text portions of this message have been removed]



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=215002.1711356.3237013.1261774/D=egroupweb/S=17050071
83:HM/A=847665/R=0/*http://ads.x10.com/?bHlhaG9vbW9uc3RlcjcuZGF0=1008619703%
3eM=215002.1711356.3237013.1261774/D=egroupweb/S=1705007183:HM/A=847665/R=1>


<http://us.adserver.yahoo.com/l?M=215002.1711356.3237013.1261774/D=egroupmai
l/S=1705007183:HM/A=847665/rand=342200930>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
3
I did a dump & load this summer. Support sent me a "Kit" for my version. I
was able to practice on my test server and I'm glad I did. I had a little
trouble. Your disk space is going critical with a 6GB database. You need
enough room for at least 3 full copies of the database and run to run. What
version are you guys dumping and loading?
Nancy Dunn
Winco Industries


-----Original Message-----
From: Ed Zywiec [mailto:ed.zywiec@...]
Sent: Monday, December 17, 2001 3:37 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] dump and load


Tim,
I'm planning on doing a dump and load over the holidays also. 6 GB wow!
It's good to know that Vantage works with that big of a database. The last
time I talked to support they were going to send me a dump and load kit. I
just put a request in to remind them.

-----Original Message-----
From: tim.goertz@... [mailto:tim.goertz@...]
Sent: Monday, December 17, 2001 2:13 PM
To: vantage@yahoogroups.com
Subject: [Vantage] dump and load


Has anyone performed a dump and load to their Vantage database recently? We
are planning on doing this over the holidays in an attempt to improve our
Vantage performance. We ran the TABANYLYS command to gather statistics and
it showed many of our tables with a scatter index of greater than the 2
recommended (many of the bigger table had 6-8 for the scatter index) so we
think it should help with performance. We have been on Vantage for about 3.5
years and our multi-extent database is has 15 .d files at 204,800 kb with
matching .b files which in total would be over 6 GB. Does anyone have any
tips or recommendations? The only instructions I have come from the Progress
Database Guide and Reference.

Tim Goertz
IS Manager
Bermo Inc.



[Non-text portions of this message have been removed]



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=215002.1711356.3237013.1261774/D=egroupweb/S=17050071
83:HM/A=847665/R=0/*http://ads.x10.com/?bHlhaG9vbW9uc3RlcjcuZGF0=1008619703%
3eM=215002.1711356.3237013.1261774/D=egroupweb/S=1705007183:HM/A=847665/R=1>


<http://us.adserver.yahoo.com/l?M=215002.1711356.3237013.1261774/D=egroupmai
l/S=1705007183:HM/A=847665/rand=342200930>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
4
5.0 What's a little trouble?

-----Original Message-----
From: Dunn, Nancy [mailto:ndunn@...]
Sent: Monday, December 17, 2001 3:26 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] dump and load


I did a dump & load this summer. Support sent me a "Kit" for my version. I
was able to practice on my test server and I'm glad I did. I had a little
trouble. Your disk space is going critical with a 6GB database. You need
enough room for at least 3 full copies of the database and run to run. What
version are you guys dumping and loading?
Nancy Dunn
Winco Industries


-----Original Message-----
From: Ed Zywiec [mailto:ed.zywiec@...]
Sent: Monday, December 17, 2001 3:37 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] dump and load


Tim,
I'm planning on doing a dump and load over the holidays also. 6 GB wow!
It's good to know that Vantage works with that big of a database. The last
time I talked to support they were going to send me a dump and load kit. I
just put a request in to remind them.

-----Original Message-----
From: tim.goertz@... [mailto:tim.goertz@...]
Sent: Monday, December 17, 2001 2:13 PM
To: vantage@yahoogroups.com
Subject: [Vantage] dump and load


Has anyone performed a dump and load to their Vantage database recently? We
are planning on doing this over the holidays in an attempt to improve our
Vantage performance. We ran the TABANYLYS command to gather statistics and
it showed many of our tables with a scatter index of greater than the 2
recommended (many of the bigger table had 6-8 for the scatter index) so we
think it should help with performance. We have been on Vantage for about 3.5
years and our multi-extent database is has 15 .d files at 204,800 kb with
matching .b files which in total would be over 6 GB. Does anyone have any
tips or recommendations? The only instructions I have come from the Progress
Database Guide and Reference.

Tim Goertz
IS Manager
Bermo Inc.



[Non-text portions of this message have been removed]



Yahoo! Groups Sponsor

ADVERTISEMENT

<
http://rd.yahoo.com/M=215002.1711356.3237013.1261774/D=egroupweb/S=17050071
<http://rd.yahoo.com/M=215002.1711356.3237013.1261774/D=egroupweb/S=17050071
>
83:HM/A=847665/R=0/*
http://ads.x10.com/?bHlhaG9vbW9uc3RlcjcuZGF0=1008619703%
<http://ads.x10.com/?bHlhaG9vbW9uc3RlcjcuZGF0=1008619703%>
3eM=215002.1711356.3237013.1261774/D=egroupweb/S=1705007183:HM/A=847665/R=1>


<
http://us.adserver.yahoo.com/l?M=215002.1711356.3237013.1261774/D=egroupmai
<http://us.adserver.yahoo.com/l?M=215002.1711356.3237013.1261774/D=egroupmai
>
l/S=1705007183:HM/A=847665/rand=342200930>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
< http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.> >
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
< http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
< http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links> >

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
< http://docs.yahoo.com/info/terms/ <http://docs.yahoo.com/info/terms/> > .




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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=215002.1711356.3237013.1261774/D=egroupweb/S=17050071
83:HM/A=847665/R=0/*http://ads.x10.com/?bHlhaG9vbW9uc3RlcjcuZGF0=1008624380%
3eM=215002.1711356.3237013.1261774/D=egroupweb/S=1705007183:HM/A=847665/R=1>


<http://us.adserver.yahoo.com/l?M=215002.1711356.3237013.1261774/D=egroupmai
l/S=1705007183:HM/A=847665/rand=484857728>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
5
When doing a dump and load in version 4, I got an error - 1532. It's
something support knew about and had a work around. Ask them about any know
errors before starting. It might keep you from having to start all over
again. Especially if support isn't in.
The other things I ran into: I didn't get the DB structure the way I wanted
it the first time. I was going from a single volumn to a multiple volumn and
didn't get the size I wanted, the first time. I appended the multiple
volumns instead of creating a whole new structure (vantage.st).
I also tried the directions "if you don't have enough room on your C:\" for
the dump & load. I couldn't get it to work. Luckly I had plenty of room, I
just didn't want to crowd the operating system if I didn't have to.
Hope this helps.
Nancy

-----Original Message-----
From: Ed Zywiec [mailto:ed.zywiec@...]
Sent: Monday, December 17, 2001 4:18 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] dump and load


5.0 What's a little trouble?

-----Original Message-----
From: Dunn, Nancy [mailto:ndunn@...]
Sent: Monday, December 17, 2001 3:26 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] dump and load


I did a dump & load this summer. Support sent me a "Kit" for my version. I
was able to practice on my test server and I'm glad I did. I had a little
trouble. Your disk space is going critical with a 6GB database. You need
enough room for at least 3 full copies of the database and run to run. What
version are you guys dumping and loading?
Nancy Dunn
Winco Industries
6
Ed
We did a dump & load process recently....
Shut down Vantage,
Backup complete Vantage database & Directory structure
Run Dump & Load utility process
Verify Database works.

For our (almost) 1 Gig database, this process took 4 hours. Bet on at least
doubling that for your database.

Regards,
David Sloan
IT Manager
Entech Integrated Technologies

----- Original Message -----
From: "Ed Zywiec" <ed.zywiec@...>
To: <vantage@yahoogroups.com>
Sent: Tuesday, December 18, 2001 7:06 AM
Subject: RE: [Vantage] dump and load


> Tim,
> I'm planning on doing a dump and load over the holidays also. 6 GB wow!
> It's good to know that Vantage works with that big of a database. The
last
> time I talked to support they were going to send me a dump and load kit.
I
> just put a request in to remind them.
>
> -----Original Message-----
> From: tim.goertz@... [mailto:tim.goertz@...]
> Sent: Monday, December 17, 2001 2:13 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] dump and load
>
>
> Has anyone performed a dump and load to their Vantage database recently?
We
> are planning on doing this over the holidays in an attempt to improve our
> Vantage performance. We ran the TABANYLYS command to gather statistics and
> it showed many of our tables with a scatter index of greater than the 2
> recommended (many of the bigger table had 6-8 for the scatter index) so we
> think it should help with performance. We have been on Vantage for about
3.5
> years and our multi-extent database is has 15 .d files at 204,800 kb with
> matching .b files which in total would be over 6 GB. Does anyone have any
> tips or recommendations? The only instructions I have come from the
Progress
> Database Guide and Reference.
>
> Tim Goertz
> IS Manager
> Bermo Inc.
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
>
>
<http://rd.yahoo.com/M=215002.1711356.3237013.1261774/D=egroupweb/S=17050071
>
83:HM/A=847665/R=0/*http://ads.x10.com/?bHlhaG9vbW9uc3RlcjcuZGF0=1008619703%
>
3eM=215002.1711356.3237013.1261774/D=egroupweb/S=1705007183:HM/A=847665/R=1>
>
>
>
<http://us.adserver.yahoo.com/l?M=215002.1711356.3237013.1261774/D=egroupmai
> l/S=1705007183:HM/A=847665/rand=342200930>
>
> 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/.
> <http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> <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
> <http://groups.yahoo.com/group/vantage/links>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/> .
>
>
>
>
> 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
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>