IDS Forum

Re: dbexport

Posted By: Andreas Legner
Date: Thursday, 13 October 2016, at 4:51 a.m.

In Response To: Re: dbexport (LARRY SORENSEN)

AFAIK, this is available on
- updatable RSS with
- STOP=5FAPPLY on (and LOG=5FSTAGING=5FDIR pointing to a secure directory)
- DBSPACETEMP (onconfig) needs to point to a real temp space

Andreas

From: "LARRY SORENSEN" <LSORENSEN25@msn.com>
To: ids@iiug.org
Date: 12.10.2016 21:57
Subject: Re: dbexport [37970]
Sent by: ids-bounces@iiug.org

I was just re-reading the email chain below, and I wanted to get=20
clarification=20
on something.=20

I saw Paul, below, say that you can run a dbexport from a secondary server =

without breaking replication? Is this true. It would save me a lot of=20
problems.=20

Larry=20

=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=
=5F=5F=5F=5F=5F=5F=5F=20
From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel=20
<art.kagel@gmail.com>=20
Sent: Tuesday, August 9, 2016 2:30 PM=20
To: ids@iiug.org=20
Subject: Re: Ebexport [37562]=20

Larry:=20

You can download myexport from the IIUG Software Repository (=20
www.iiug.org/software<http://www.iiug.org/software>). It is a set of=20
scripts=20
(there is one executable C=20

International Informix Users Group<http://www.iiug.org/software>=20
www.iiug.org=20
About the Software Repository. These pages allow you to access the IIUG=20
Software Repository and other Informix-related archives on the Net. Quick=20
Links:=20

utility in the package that is only needed if you want to use the parallel =

load/unload options). You will also need my utils2=5Fak package. The latest=
=20
version of that can be downloaded from my web site (=20
www.askdbmgt.com/my-utilities.html<
http://www.askdbmgt.com/my-utilities.html>)=20
there is a build instruction document=20

My Utilities - ASK Database=20
Management<http://www.askdbmgt.com/my-utilities.html>=20
www.askdbmgt.com=20
Utils2=5Fak is my primary package of utilities. This is the July 28, 2016=20
release. Included: dbping.ec - Tests connections and reports connection=20
time=20
as well as ...=20

included, but it builds just by unpacking the shell archive and running=20
make on linux (and usually Solaris as well). If you use external table=20
exports and imports (the -E option) that's all you need.=20

To use the default export/import, which is the slowest option, you'll also =

need Jonathan Leffler's sqlcmd package the latest of which is in the IIUG=20
Repository as well.=20

To use the HP Loader options you'll need the myonpload utility from the=20
IIUG Repository.=20

Note that the external table option is the fastest unload/load so you can=20
ignore the HP Loader options.=20

Dbcopy is included in the utils2=5Fak package, so you'll be good once you=20
built that. Note that due to a looong standing bug in the ESQL/C libraries =

you can't use dbcopy on tables with LVARCHAR columns and it doesn't work=20
correctly on tables with more than one dumb blob type column. For those=20
cases you can use the dbmove utility (also in the package).=20

If you have any trouble building or using these, let me know.=20

Art=20

Art S. Kagel, President and Principal Consultant=20
ASK Database Management=20
www.askdbmgt.com<http://www.askdbmgt.com>=20

ASK Database Management - Home<http://www.askdbmgt.com/>=20
www.askdbmgt.com=20
This is the site for Art S. Kagel's consultancy. The soaring majesty and=20
beauty in the image above hides the complex ecology and detail of its=20
existence.=20

Blog: http://informix-myview.blogspot.com/=20

Informix - My view<http://informix-myview.blogspot.com/>=20
informix-myview.blogspot.com=20
A place to share my views and ideas which may be of interest to the=20
Informix=20
user Community.=20

Disclaimer: Please keep in mind that my own opinions are my own opinions=20
and do not reflect on the IIUG, nor any other organization with which I am =

associated either explicitly, implicitly, or by inference. Neither do=20
those opinions reflect those of other individuals affiliated with any=20
entity with which I am affiliated nor those of the entities themselves.=20

On Tue, Aug 9, 2016 at 1:33 PM, LARRY SORENSEN <LSORENSEN25@msn.com>=20
wrote:=20

> Thank you all for your responses.=20
>=20
> Do you have a link to the programs myexport, myimport and dbcopy as well =

as=20
> some instructions on how to set them up and compile them (and what, if=20
> anything special, is needed to install before compiling them)?=20
>=20
> Larry=20
>=20
> =5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=
=5F=5F=5F=5F=5F=5F=5F=5F=20
> From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Paul=20
Watson=20
> <paul@oninit.com>=20
> Sent: Tuesday, August 9, 2016 10:53 AM=20
> To: ids@iiug.org=20
> Subject: RE: Ebexport [37557]=20
>=20
> If you have an older version ( one was 11.10 AFAIK) you can run dbexport =

on=20
> a secondary - was extremely useful=20
>=20
> -----Original Message-----=20
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of=20
Mike=20
> Walker=20
> Sent: Tuesday, August 09, 2016 11:46 AM=20
> To: ids@iiug.org=20
> Subject: RE: Ebexport [37556]=20
>=20
> Yes, dbexport does lock the database in exclusive mode. This helps=20
ensure=20
> data consistency/integrity and that you won't run into problems when=20
> building foreign keys when importing your database later on.=20
>=20
> You can look into Art's myexport/myimport utilities which do not lock=20
the=20
> database.=20
>=20
> Mike Walker=20
> Advanced DataTools Corporation=20
>=20
> -----Original Message-----=20
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of=20
> LARRY=20
> SORENSEN=20
> Sent: Tuesday, August 09, 2016 10:33 AM=20
> To: ids@iiug.org=20
> Subject: Ebexport [37554]=20
>=20
> Does dbexport lock the database while running?=20
>=20
> Larry=20
>=20
> ************************************************************=20
> ****************=20
>=20
> ***=20
> Forum Note: Use "Reply" to post a response in the discussion forum.=20
>=20
> ************************************************************=20
> ****************=20
> ***=20
> Forum Note: Use "Reply" to post a response in the discussion forum.=20
>=20
>=20
> ************************************************************=20
> *******************=20
> Forum Note: Use "Reply" to post a response in the discussion forum.=20
>=20
>=20
> ************************************************************=20
> *******************=20
> Forum Note: Use "Reply" to post a response in the discussion forum.=20
>=20
>=20

--001a1143f0a6907d740539a966e2=20

***************************************************************************=
****=20

Forum Note: Use "Reply" to post a response in the discussion forum.=20

***************************************************************************=
****=20

Forum Note: Use "Reply" to post a response in the discussion forum.=20

Messages In This Thread

• Ebexport
  LARRY SORENSEN -- Tuesday, 9 August 2016, at 12:33 p.m.
  • RE: Ebexport
    Paul Watson -- Tuesday, 9 August 2016, at 12:42 p.m.
  • RE: Ebexport
    Mike Walker -- Tuesday, 9 August 2016, at 12:46 p.m.
    • RE: Ebexport
      Paul Watson -- Tuesday, 9 August 2016, at 12:53 p.m.
      • Re: Ebexport
        LARRY SORENSEN -- Tuesday, 9 August 2016, at 1:33 p.m.
        • Re: Ebexport
          Art Kagel -- Tuesday, 9 August 2016, at 4:30 p.m.
          • Re: Ebexport
            LARRY SORENSEN -- Tuesday, 9 August 2016, at 4:48 p.m.
          • Re: dbexport
            LARRY SORENSEN -- Wednesday, 12 October 2016, at 3:56 p.m.
            • Re: dbexport
              Andreas Legner -- Thursday, 13 October 2016, at 4:51 a.m.
              • Re: dbexport
                Khaled Bentebal -- Thursday, 13 October 2016, at 9:09 a.m.
  • RE: Ebexport
    Knox, Ernest -- Tuesday, 9 August 2016, at 12:57 p.m.
  • Re: Ebexport
    Art Kagel -- Tuesday, 9 August 2016, at 1:11 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.