RE: Informix DB Reorganisation
Posted in 1997
Topics: Storage & Space Management, Connectivity: ODBC / JDBC / .NET, Server Administration, Migration, Import/Export & Data Conversion
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_01BCF374.0D281DA0
Content-Type: text/plain
IMHO, dbexport / dbimport works the best. You *can* export to tape, but
I would use disk, if you have enough file space.
Pointers:
-- make sure your ulimit is set high enough to handle your big-table
data files;
-- be aware that dbexport requires a DB *exclusive* lock (there can be
no other users in the DB);
-- after the dbexport, but before the dbimport, you may want to edit
the <databasename>.sql file,
changing first/next extent sizes;
-- depending on your system, this *may* take quite a while; you may
want to do a test
unload/load of some of your larger tables to get an idea of the time
required
HTH
=============================
Paul Mosser, Open Systems DBA
Wells Fargo Bank
Tempe, Arizona, USA
mosserp@wellsfargo.com
> ----------
> From: Information Systems[SMTP:mscinfosys@peg.apc.org]
> Reply To: Information Systems
> Sent: Monday, November 10, 1997 7:39 PM
> To: informix-list@rmy.emory.edu
> Subject: Informix DB Reorganisation
>
> We are running Informix 5 on DGUX 4.11. What is the best way to
> perform a
> database reorganisation or defragmentation?
>
> Regards,
>
> Darren Fuller.
>
>
------ =_NextPart_000_01BCF374.0D281DA0
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64
eJ8+IisXAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQSAAQAfAAAAUkU6IEluZm9ybWl4IERCIFJlb3JnYW5pc2F0aW9u
AMgKAQmAAQAhAAAANjZCQTYwMTk5MjVGRDExMUFCM0IwMDAwODM3NjEyQkEA8gYBIIADAA4AAADN
BwsAEQAQAA8AKgABADoBAQWAAwAOAAAAzQcLABEAEAATABMAAQAnAQENgAQAAgAAAAIAAgABA5AG
ALwHAAAdAAAAAwAuAAAAAABAADkAcPjXOq/zvAEeAHAAAQAAABsAAABJbmZvcm1peCBEQiBSZW9y
Z2FuaXNhdGlvbgAAAgFxAAEAAAAbAAAAAbzzqaSuV6R3b1+MEdGTdgAA+EWyCgAAybGRAAIBCRAB
AAAAeAQAAHQEAAACCAAATFpGdY2GtP8DAAoAcmNwZzEyNf4yAP8CBgKkA+QF6wKDAFATA1QCAGNo
CsBzZXT+MgYABsMCgw5QA9UHEwKDxjMDxQIAcHJxEuAQv6xmNBT8FEg1E819CoDbCM8J2TsaXw4w
NQKACoFLDnELYG4OEDAzFOBooQWwemRvYwAAKhJV9iACkR5gbB6VCvsW8gwBAmMAQCBJTUhPLEAg
ZGJleHAaASCuLyGRB3Ah43cFsGsEIBB0aGUgIbBzdC5EIFkIYCAqYwBwKhIgIcV0byMwYXBlKSGA
YnUFQEki0XVsuGQgdRKwIZAEAGshgNkGkCB5I/ESgHYjYAnwYQhgZ2ggZgMQI2BzMQqwY2UuCoUK
hVBvJQuAdASQczoKhSAt9C0gAMBrKEEIcCNgJxH3BcAmAAdwaQVABAAoUBLAPSdAaSfhJ6Uk8RKA
bmRnKDErgyJgZy0BkSgxZGZhAZAoA3M7KjkhsCD8YXcKwCNgI0AvECGYGmA4cXVpGmAEIC8wREL7
JBAhwGMKQACQJ3AkYBnw8GNrICgjQStRJDEwUvknsCBvM9ImMh7BC4AjM/UygCkvqmEBgDUBI0Ih
pv8lZCGwAhAwwzdyInQhgCcS/QDAeSLQAHAk0wmALBEjQpI8LwJiYRKwbmEHgPA+LnNxAyAoEiGA
KjZvPUEScR1gC4BnKAESoHT8L24hwAVAPpEJ8AVAAJD+ei+MDnAlQC3APeICICt05HN5I6BlbSGA
I0AsQf4qOgEkYAGQKwEx8SngMlH2dyywKDA7Ob8eEDJRKeATI6A86XVuGfBhZC/3RkI0wCbwcwNw
I2BG4SuD+Qtgcmc3Ii6yIyElAEgQewVAA5FpDnAvMEbhI0J0iwdxMcZkKMxIVEgKj8MLkRTiMTcg
PU2/TnntKTZhJgAF0G8EEASQIYC+T0BxEvFBkgQgMoBBTAXQV2VsbAQgRkfxJQDqQgBwa0wFVEGw
JUIHEcp6AiBhIYBVU1G2BGBRUGJwQHdSQmZSoi49BaBtTA8gbFarK+AxOIIwAtFpLTE0NA6wfwzQ
WgMLWVmAVsADYCngY38FQCqwXCZWp1rbDDBbpka9A2E6XS5bpgyCITBuOJEPAMBKIEDxURVbU01U
dFA6UWBjC4ACEEFxQEklQGcuJTBjLgWwZ1ZdXM9d3VJAYGw6IFT+b18PYB9hLWPvXd0GYAIwP2Zv
Z3tQQC3AOhAhgE5vHydwBtA1AR2AIYAxOTmhTZA3OjM5KZBNaX8fXd1mT2ddYqJhIGl4Lcsr4COg
QGEgeS5BsAWwGXShZHVvr2qOdWJq/1vhcc9nf3PiMnJl4GOhAHDPBABhQyjMWQYzNlqnE7K/INNa
oVu1UjAwgCtRckYgFwMAPfF5pzVA4kRHVcBYIDQuMTEjwFIgfzECLEEjRjoxOiAk8SVAcv9oYjCA
VqU7ZjHBeoo0wINxcQ6AcmFnB4ACMGFDP08ozGXgeqALIHMsKMxEtwrAGmADoEYmACgwcii9X3wv
IHdbplalGYEAjRAeADFAAQAAABAAAABNT1NTRVJQNDM5OTFEQTcAAwAaQAAAAAAeADBAAQAAABAA
AABNT1NTRVJQNDM5OTFEQTcAAwAZQAAAAAADADYAAAAAAB4AQhABAAAAGQAAADw2NDhnbTkkMzY5
QHBlZy5hcGMub3JnPgAAAAADACYAAAAAAAIB+T8BAAAAZwAAAAAAAADcp0DIwEIQGrS5CAArL+GC
AQAAAAYAAAAvTz1XRUxMUyBGQVJHTyAmIENPLi9PVT1XRkIxL0NOPU5PTi1FWENIQU5HRSBSRUNJ
UElFTlRTL0NOPU1PU1NFUlA0Mzk5MURBNwAAHgD4PwEAAAANAAAATW9zc2VyLCBQYXVsAAAAAB4A
OEABAAAAEAAAAE1PU1NFUlA0Mzk5MURBNwACAfs/AQAAAGcAAAAAAAAA3KdAyMBCEBq0uQgAKy/h
ggEAAAAGAAAAL089V0VMTFMgRkFSR08gJiBDTy4vT1U9V0ZCMS9DTj1OT04tRVhDSEFOR0UgUkVD
SVBJRU5UUy9DTj1NT1NTRVJQNDM5OTFEQTcAAB4A+j8BAAAADQAAAE1vc3NlciwgUGF1bAAAAAAe
ADlAAQAAABAAAABNT1NTRVJQNDM5OTFEQTcAQAAHMLC8csus87wBQAAIMErPbLmu87wBHgA9AAEA
AAAFAAAAUkU6IAAAAAAeAB0OAQAAABsAAABJbmZvcm1peCBEQiBSZW9yZ2FuaXNhdGlvbgAACwAp
AAAAAAALACMAAAAAAAMABhC7toncAwAHEH0DAAADABAQAAAAAAMAERADAAAAHgAIEAEAAABlAAAA
SU1ITyxEQkVYUE9SVC9EQklNUE9SVFdPUktTVEhFQkVTVFlPVSpDQU4qRVhQT1JUVE9UQVBFLEJV
VElXT1VMRFVTRURJU0ssSUZZT1VIQVZFRU5PVUdIRklMRVNQQUNFUE9JTgAAAABGMQ==
------ =_NextPart_000_01BCF374.0D281DA0--