Moving databases across partitions

[Kogan, Arthur]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_000_01BE6512.13C3FF42
Content-Type: text/plain

Hi Rus,

is your database a single or multiple file? If it is multiple file, the
location of the second file (and so on) is stored within the database.

Another thing is probably a stupid question, but here goes... Are you
accessing (even reading!!!) the database while you are copying? If so, this
corrupts it.

Regards,

Arthur Kogan
Westpac Financial Services
Sydney, Australia

> -----Original Message-----
> From:	Rus [SMTP:russell_garner@aapl.com.au]
> Sent:	Wednesday, 3 March 1999 11:41 AM
> To:	powerh-l@lists.swau.edu
> Subject:	Moving databases across partitions
> 
> 
> I was wondering if anyone could enlighten me as to a problem we are
> copping with moving a database across disk partitions.
> 
> We have a Data General AViiON machine running DG/UX and are running
> PH733d3 with Interbase 3.3D
> 
> We have our Dictionary and Database on the same disk partition. I'll call
> it disk partition 1
> 
> If we restore a database from tape to a directory on disk partition 2
> and change the environment variable in the dictionary to point to the new
> directory then everything is ok.
> 
> However if we leave the variable pointing to disk partition 1 and copy the
> database (using either mv or cp ) from partition 2 onto partition 1 then
> we lock up when trying to access the database.
> 
> If we restore the database onto a different directory on partition 1 and
> then 
> perform the cp or mv to move it to where the dictionary points to, we dont
> have
> any problems whatsoever.
> 
> It only seems to be when we copy across disk partitions.
> 
> Any ideas????
> 
> Russell Garner
> Systems Analyst
> Australian Arrow
> 
> 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> =
> Subscribe: "subscribe powerh-l" in message body to
> majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> This list is closed, thus to post to the list, you must be a subscriber.

------_=_NextPart_000_01BE6512.13C3FF42
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64

eJ8+IiIBAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQSAAQAnAAAAUkU6IE1vdmluZyBkYXRhYmFzZXMgYWNyb3NzIHBh
cnRpdGlvbnMAQQ4BCYABACEAAAAyRkZCRDc0RkVERDBEMjExODg0MDAwMDA4MzY4MzU2NwAMBwEg
gAMADgAAAM8HAwADAAwABgAgAAMAEQEBBYADAA4AAADPBwMAAwAMAAQAFgADAAUBAQ2ABAACAAAA
AgACAAEDkAYAxAoAACsAAAALAAIAAQAAAAMALgAAAAAAQAA5APBUDsYRZb4BHgBwAAEAAAAjAAAA
TW92aW5nIGRhdGFiYXNlcyBhY3Jvc3MgcGFydGl0aW9ucwAAAgFxAAEAAAAbAAAAAb5lDwSKA/IO
IND8EdKeGQAA9rj6EQAAevfQAAIBCRABAAAAxAUAAMAFAAAaCgAATFpGdWYreIQDAAoAcmNwZzEy
NdIyAPszNgHoIAKkA+MJAgBjaArAc2V0MB4gBxMCgwBQEFZwcnHeMhFZDlAD1RFlfQqACMjsIDsJ
bw4wNRV/CmACgNkKgXVjAFALA2MAQQtgIm4OEDAzMwumIEjiaQfwdXMsCqIKhAqAiQQAIHkIYSBk
YQGRYmERECBhIACQGTBswxxABbFtdWx0BSAcwQJmAxBlPyBJZiAOaQVAG1EdKywgdGjrHEAJAGMb
4GkCIBzgHiAnH5IREAWgbmQdoyAokwBwISBzbxzgbikeYuxzdAWwCYAgA/AfkAuAix+DG9YuGppB
bm8fkdsFwCMSZx5iEqBvHBACYEJ5HFJ0dXBpISBxzwpQIoAgIR9wYnUFQCUx6RxAZ28HkC4okBFR
HEBzG4EcUGNjB5AcgiGAZUp2CfAgFuBhZByRIf8qwCIwI2oi4CMgHMEpEygh+QWgcHkckR3zIeAf
chtRdQWhcibQdAQgHkAkK1J8ZWcLERp8BxAfkBuhS25vL7ALkBqjVydBCrBjbCBGC4AAcGMHMQZS
dg8N4AeQGpQGsGRuZXnlH3BBGmB0cgdABzAamr8K9DTQDzEYwQFAJgF0BZBCdBHkMTYgLTfCTy0F
EGcygQMgTSmBYWd+ZTfDGpY21DahCxM21mkwLTE0NAFANNAxOG4wAUAM0DtjYjJgA2E6DQyDYhFA
GlEgW1NNGFRQOi5ABBBlbGyGXy+xNCByQGFhC1CCLgWgbS5hdV0alb88kAZgAjA89zHwNBFzG9Ad
NEEzBdAKwBDQIDE5Q0JwQlAxOjQxEVBNiT/XVG8893BvdwSQ8GgtbEA00CKAKIAD4B0/oC4JgAxw
P+d1YmrzNwE8901vM0AloRvWBCD/ANADYAQRCrEdUCASM4U5z/825DYkDNABwRjBE5ETkgwB/Rqp
SSLgHCAi4CEBBnElov8eIABwG4A0ICyxHTAhIAnw+TTQZ2g28AOgB4AcUAQg7yKQHFEmAhzAbSLg
HEEW4P8alCzBJuAloSLyHRBHhBxg5xvYSJQqgHNrSOkkKzHwLSfwYSoQHFFEG+EgRwcJ8ASQMuFB
VmlpT75OHRAA0CMhHEAuQG4DAMEloURHL1VYTrEhIEcsglilGpRQSDcZcGQ7QeBSo0kCMASQHBMz
LtwzRFWPVpEbkkQN4CASfwrAJnEhEVbiHBMgMSCTYedQMVSMKLBJJz5wLLAHQP8JUBsEBUBUjEJQ
TNseIFFh/xbgIoNTWgNSH4A/IBxAUJP/KoAW4DcQBbAmcCAxYm0OUP8aoyGiENEZMGYxH6EJ8DNA
zQNgbgeAAjAgdgrABzD/UREeMCNFXhhQkURwC4AFQPdQkR+SNCB3GpRmqB+RA6CnKgFegCV3b2sk
K0hEgf9uwU6CUWEcwFaCH5Jqh2xj/yWSUJFibllzLMIfgm1lG+Y2KBpgJZJlIwElQW12+xziDfAg
IjBls2fJIgFsMv9zuW5iGpRxMh/gVLAm0CvR/yohNKAs8lCDKWMjX2OfZKT/Kxt4s2aCASAoEWpR
ZqtzrtduYxqUZiByAhByZeEfof93URzydwBQkVLxavFso3sRv362XhhsY1ByH3BRYWQCIf8alFZy
aHaGoVD0TdEQ4C5w/yhgbsF9PAVAAiAmYREQiXL9UJFiK8IqIVFhdKNUH1UvzyThJnAm8Cpgcz+P
8S7b/z40VyA+szOWIoCJciTwB0D/kkEklTSGA6AHEANgbVUamvw9IJWvlr+Xz5jfmUMzlYdGgATy
jDA6ICJzmsb9RGciawIHgTjSJ7AEcGwTfQDAagWwh6AEYET/GrJV/wCAmslYsJt/nIydv0VORH/f
RYQeYi+wNvBFcHkiwU7xvi2msYvzLqGjgzMhLqTG3RqUVC3So4IeYmMJABEQ/mQfcj2RbDOp4WzF
o4IfcP8pEh0gqeGMMRxhmsaKRhSRAgCukAMA/T9SAwAAHgBCEAEAAAA0AAAAPDMuMC4yLjMyLjE5
OTkwMzAzMTE0MTI0LjAwNzMwMWE4QG1haWwuYWFwbC5jb20uYXU+AAsAAIAIIAYAAAAAAMAAAAAA
AABGAAAAAAOFAAAAAAAAAwAHgAggBgAAAAAAwAAAAAAAAEYAAAAAEIUAAAAAAAADACOACCAGAAAA
AADAAAAAAAAARgAAAABShQAAdBAAAB4AJIAIIAYAAAAAAMAAAAAAAABGAAAAAFSFAAABAAAABQAA
ADguMDIAAAAAAwAPgAggBgAAAAAAwAAAAAAAAEYAAAAAAYUAAAAAAAALACmACCAGAAAAAADAAAAA
AAAARgAAAAAOhQAAAAAAAAMADIAIIAYAAAAAAMAAAAAAAABGAAAAABGFAAAAAAAAAwArgAggBgAA
AAAAwAAAAAAAAEYAAAAAGIUAAAAAAAAeADqACCAGAAAAAADAAAAAAAAARgAAAAA2hQAAAQAAAAEA
AAAAAAAAHgA7gAggBgAAAAAAwAAAAAAAAEYAAAAAN4UAAAEAAAABAAAAAAAAAB4APIAIIAYAAAAA
AMAAAAAAAABGAAAAADiFAAABAAAAAQAAAAAAAAADACYAAAAAAAMANgAAAAAAHgAxQAEAAAAPAAAA
S09HQU5BNERDQjc4MzgAAAMAGkAAAAAAHgAwQAEAAAAPAAAAS09HQU5BNERDQjc4MzgAAAMAGUAA
AAAAAwCAEP////8CAfk/AQAAAGIAAAAAAAAA3KdAyMBCEBq0uQgAKy/hggEAAAAGAAAAL089V0VT
VFBBQy9PVT1XQkMvQ049UkVDSVBJRU5UUy9DTj1NU01BSUwgQUREUkVTU0VTL0NOPUtPR0FOQTRE
Q0I3ODM4AAAAHgD4PwEAAAAOAAAAS29nYW4sIEFydGh1cgAAAB4AOEABAAAADwAAAEtPR0FOQTRE
Q0I3ODM4AAACAfs/AQAAAGIAAAAAAAAA3KdAyMBCEBq0uQgAKy/hggEAAAAGAAAAL089V0VTVFBB
Qy9PVT1XQkMvQ049UkVDSVBJRU5UUy9DTj1NU01BSUwgQUREUkVTU0VTL0NOPUtPR0FOQTREQ0I3
ODM4AAAAHgD6PwEAAAAOAAAAS29nYW4sIEFydGh1cgAAAB4AOUABAAAADwAAAEtPR0FOQTREQ0I3
ODM4AABAAAcwEP967xBlvgFAAAgwQv/DExJlvgEeAD0AAQAAAAUAAABSRTogAAAAAB4AHQ4BAAAA
IwAAAE1vdmluZyBkYXRhYmFzZXMgYWNyb3NzIHBhcnRpdGlvbnMAAAsAKQAAAAAACwAjAAAAAAAD
AAYQ8pGm1wMABxAPBgAAAwAQEAAAAAADABEQAQAAAB4ACBABAAAAZQAAAEhJUlVTLElTWU9VUkRB
VEFCQVNFQVNJTkdMRU9STVVMVElQTEVGSUxFP0lGSVRJU01VTFRJUExFRklMRSxUSEVMT0NBVElP
Tk9GVEhFU0VDT05ERklMRShBTkRTT09OKUlTU1QAAAAAbOE=

------_=_NextPart_000_01BE6512.13C3FF42--
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.