TIP: Click on subject to list as thread! ANSI
echo: os2prog
to: Christopher Bockner
from: John Poltorak
date: 1995-03-16 23:17:32
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™.