| TIP: Click on subject to list as thread! | ANSI |
| echo: | |
|---|---|
| to: | |
| from: | |
| date: | |
| subject: | SQL & DB2/2 questions |
Saturday March 11 1995, Christopher Bockner writes to John Poltorak: CB> Copying a Database..? How..? Do you want to run the database on the same CB> copy of the DBM, or on another copy of it. If you run it on the same copy CB> of the DBM, I think you have to rename it. Anyway, in order to do any of CB> this, you need torename it, back it up, restore the name of the original CB> database, and then restore the the backed up copy of the database. I CB> haven't tried this sort of stuff, so there may be an easier way, but this CB> is all I can think of. Someone was wanting a way of running a long report against a production database without impacting normal database users. I suggested copying the database and running a separate low-priority job aginst this copy of the original, but when I thought about it, I couldn't work out how to achieve what I had suggested. I suppose, if I can't copy the database onto a different drive, I could copy it to a different machine, along with DBM and run it there... John --- GoldED/2 2.50.Beta4+* Origin: (2:250/313) SEEN-BY: 105/42 620/243 624/50 711/401 409 410 413 430 807 808 809 934 955 SEEN-BY: 712/407 515 628 704 713/888 800/1 7877/2809 @PATH: 250/313 440/4 141/209 270/101 105/103 42 712/515 711/808 809 934 |
|
| SOURCE: echomail via fidonet.ozzmosis.com | |
Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.