IDS Forum

Re: Faster Dbimport

Posted By: Art Kagel
Date: Monday, 29 December 2014, at 10:07 p.m.

In Response To: Re: Faster Dbimport (GUSTAVO ECHENIQUE)

OK, so, if I remember correctly, you are using Informix v7.31, so some of
the more advanced features of myexport/myimport will not work. You will
not be able to use the -O (dependency ordering) or -E (export/import using
external tables) option or -A for myimport (use the HP Loader via the IBM
onpladm utility) for high speed exports and imports. These options depend
on Informix engine features that you just do not have in 7.31.

For faster exports you can use the -H D or -H E option to import and -D,
-C, or -S to export faster using Ravi Khrishna's myonpload utility (which
you can download from the IIUG Software Repository) to manage the HP Loader
and you can use -P parallel export/import to take advantage of all of the
CPU cycles and IO bandwidth available.

So, using these features, I would:

myexport mydatabase -C -o /path/for/.exp/directory -p -m -v

and

myimport mydatabase -H D -m -p -d default_dbspace

As far as how myimport connects to the database, it is just a shell
script. Connections to the database depend on which tools it is using to
accomplish the pieces of what it does. It uses some of the following
depending on options:

- myschema - an ESQL/C utility from my utils2_ak package which uses a

native Informix SQLI connection

- sqlunload - an ESQL/C utility from Jonathan Leffler's sqlcmd package

which uses a native Informix SQLI connection

- dbaccess - Informix native utility which also uses SQLI connections

- myonpload - an ESQL/C utility from Ravi Khrishna's myonpload

package which uses a native Informix SQLI connection

- HPLoader - Native Informix high speed load/unload utility. It uses

a low level library interface directly into the database

- sqlunload - an ESQL/C utility from Jonathan Leffler's sqlcmd

package which uses a native Informix SQLI connection

- sqlreload - an ESQL/C utility from Jonathan Leffler's sqlcmd

package which uses a native Informix SQLI connection

You should compile the utils2_ak, myonpload, and sqlcmd packages using the
latest Informix CSDK (v4.10.xC4) rather than your current v2.xx release of
the CSDK because it has been a long time (12 years) since that CSDK version
and v7.31 of the server engine were desupported and some code that is not
compatible with those older CSDK release may have slipped into the code.
For my packages, I do try to keep things backwards compatible, but I cannot
guarantee that the new code will compile with the older compilers.
Jonathan, I know, does not like to continue to support very old CSDK
releases, so his code may be ever more trouble. Myonpload is an old
package and has not been modified for a while, so it should be OK with old
or new CSDK versions.

Art

Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com

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

Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.

On Mon, Dec 29, 2014 at 7:40 PM, GUSTAVO ECHENIQUE <
gustavo.echenique@cemdo.com.ar> wrote:

> Art Hello again!
> You do not know how much I appreciate your kindness forever to answer all
> questions.
> The problem occurred because dbimport constraint of a table did not record
> any
> record. Moreover, much that basis was not affected by any ALTER ago. So I
> miss
> most.
> The example that I asked you was on using your scripts (myexport), since
> dbexport and dbimport the use for a long time (I have exported and imported
> about 500 times the database production, but I never felt that not recorded
> records in a table).
>
> I also need to know if the server connection is made via ODBC or JDBC.
>
> I send a heartfelt hug, and again thank you very much.
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--047d7b34318a9db555050b664915

Messages In This Thread

• Faster Dbimport
  GUSTAVO ECHENIQUE -- Wednesday, 24 December 2014, at 7:15 a.m.
  • Re: Faster Dbimport
    Art Kagel -- Wednesday, 24 December 2014, at 7:43 a.m.
    • Re: Faster Dbimport
      GUSTAVO ECHENIQUE -- Wednesday, 24 December 2014, at 8:15 a.m.
      • Re: Faster Dbimport
        Art Kagel -- Wednesday, 24 December 2014, at 9:52 a.m.
        • Re: Faster Dbimport
          GUSTAVO ECHENIQUE -- Wednesday, 24 December 2014, at 10:16 a.m.
          • Re: Faster Dbimport
            Art Kagel -- Wednesday, 24 December 2014, at 10:33 a.m.
            • Re: Faster Dbimport
              GUSTAVO ECHENIQUE -- Monday, 29 December 2014, at 4:28 p.m.
              • Re: Faster Dbimport
                Art Kagel -- Monday, 29 December 2014, at 6:15 p.m.
                • Re: Faster Dbimport
                  GUSTAVO ECHENIQUE -- Monday, 29 December 2014, at 7:40 p.m.
                  • Re: Faster Dbimport
                    Art Kagel -- Monday, 29 December 2014, at 10:07 p.m.
                    • Re: Faster Dbimport
                      GUSTAVO ECHENIQUE -- Wednesday, 31 December 2014, at 11:21 a.m.
                      • Re: Faster Dbimport
                        Art Kagel -- Wednesday, 7 January 2015, at 1:51 p.m.
  • Re: Faster Dbimport
    Ignacio Bisso -- Wednesday, 24 December 2014, at 8:17 a.m.
    • Re: Faster Dbimport
      GUSTAVO ECHENIQUE -- Wednesday, 24 December 2014, at 8:35 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.