Kbase P106967: How to perform a selective binary dump
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
How to perform a selective binary dump
GOAL:
Can a selective binary dump be performed?
GOAL:
Can we dump only a subset of data from a very large table?
GOAL:
Is there any option in proutil to selectively dump portions of a table?
FACT(s) (Environment):
Progress 9.1D
FIX:
If you need to dump only a subset of data from a very large table, you could use the selectively binary-dump part of the table using a specific criterion.
Starting with 9.1D, a new option, called DUMPSPECIFIED, was introduced in the proutil binary dump utility, which allows the DBA to selectively dump portions of a table based on a column?s value.
This new functionality facilitates archiving large amounts of data:
proutil sports -C dumpspecified "customer.cust-num" LT 50
proutil sports -C dumpspecified "order.orderdate" GE 02-11-1998