Kbase 11849: An alternative way to speed up data dump and load on VMS
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
An alternative way to speed up data dump and load on VMS
This Technical Support Knowledgebase Entry gives an alternative method of
dumping and reloading data on VMS, with a full development license.
This has been tested against the demo database using the standard dump and
reload within the data dictionary, and has proved to be quicker.
The amount of space allocated within dump1.p will need to be modified
dependant on the size of the files within the database. You will also have
to create an empty file before hand to use on the copy command.
/*dump1.p*/
DEFINE NEW SHARED VARIABLE a-space AS CHARACTER.
FOR EACH _file WHERE NOT _file-name BEGINS "_":
a-space = _file-name.
a-space = a-space + ".d".
VMS SILENT copy/allocat=15 empty.txt VALUE(a-space).
END.
FOR EACH _file WHERE NOT _file-name BEGINS "_":
a-space = _file-name.
RUN dump2.p _file-name.
END.
/*dump2.p*/
DEFINE SHARED VARIABLE a-space AS CHARACTER.
a-space = a-space + ".d".
OUTPUT TO VALUE(a-space) APPEND.
FOR EACH {1}:
EXPORT {1}.
END.
OUTPUT CLOSE.
This will give you the following files at operating system level:
$ dir/siz=all *.d
agedar.d 2/15
customer.d 14/15
item.d 10/15
monthly.d 2/15
order-line.d 3/15
order.d 6/15
salesrep.d 1/15
shipping.d 5/15
state.d 3/15
syscontrol.d 1/15
Progress Software Technical Support Note # 11849