RE: Rebuild Access Paths

[Chris Bipes <chris.bipes@xxxxxxxxxxxxxxx>]

Have you looked at EDTRBDAP, (edit rebuild access paths)?  It may do what
you want.

Christopher K. Bipes    mailto:ChrisB@Cross-Check.com
Sr. Programmer/Analyst  mailto:Chris_Bipes@Yahoo.com
CrossCheck, Inc.        http://www.cross-check.com
6119 State Farm Drive   Phone: 707 586-0551 x 1102
Rohnert Park CA  94928  Fax: 707 586-1884

If consistency is the hobgoblin of little minds, only geniuses work here.
Karen Herbelin - Readers Digest 3/2000

-----Original Message-----
From: Mike Naughton [mailto:mnaughton@juddwire.com]
Sent: Tuesday, September 12, 2000 6:39 AM
To: midrange-l@midrange.com
Subject: ReBuild Access Paths


Hi everyone,

Is there a way to tell the system to rebuild access paths? We have a test
library, which contains copies of production data files (physicals and
logicals). Periodically, we like to refresh the data from the production
system, and the fastest way seems to be to use our backup tape to restore
the prodution library into the test library. However, when we back up, we
don't save access paths, so the restore doesn't put them into the test
library. I know after the restore is done I can run programs to open the
files and rebuild the paths that way, but is there a way to rebuild all
the paths without having to go through this?

TIA for any suggestions,


Mike Naughton
Senior Programmer/Analyst
Judd Wire, Inc.
124 Turnpike Road
Turners Falls, MA  01376
413-863-4357 x444
mnaughton@juddwire.com
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---