Informix

nested-group-icon.png

DB2

Expand all | Collapse all

'myimport -C'

  • 1.  'myimport -C'

    Posted Mon November 23, 2020 07:02 PM
    Greetings,

    I apologize for being such a Neanderthal, but might anyone offer a fuller (than the "usage" output from 'myimport') explanation of what the "-C" option does?  In my (alleged) mind, it looks like it might be similar to the "-i" option.  But, that doesn't make sense, since "-i" already exists.

    I am currently re-evaluating Art's utilities, which looked very promising in the past, but we had some esoteric issues that were problematic, but now are probably fixed.

    Thank you for any comments.

    Regards,

    David Grove

    ------------------------------
    David Grove
    ------------------------------


  • 2.  RE: 'myimport -C'

    Posted Mon November 23, 2020 08:00 PM
    P.S.  Will be using external tables (-E), which makes "-C" required.  Last time I was working with myimport, that option (-C) didn't exist.  [And, we were using -E.]

    ------------------------------
    David Grove
    ------------------------------



  • 3.  RE: 'myimport -C'

    Posted Mon November 23, 2020 08:02 PM
    David:

    OK, so, if you do an external table export, the target storage directory path is embedded in the SQL scripts that create the external tables for unload and also the scripts that myimport will have to ue to reimport the data files. If you will be loading the data from a path that is different from the path used to unload, then myimport's -C option lets you provide a replacement path that will be used to rewrite those scripts with the correct path.

    Art

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


    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.








  • 4.  RE: 'myimport -C'

    Posted Mon November 23, 2020 08:04 PM
    Also, I made it a separate option rather than just substitute the -i path so that the data files could be moved to a different directory from the scripts in case of storage issues.

    Art

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


    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.








  • 5.  RE: 'myimport -C'

    Posted Mon November 23, 2020 08:07 PM

    Ahhh.  Now it makes sense.

    Thank you, Art.

    DG



    ------------------------------
    David Grove
    ------------------------------



  • 6.  RE: 'myimport -C'

    Posted Mon November 23, 2020 08:10 PM
    B^)  When in doubt or confused, just remember that everything in my utilities packages came from a real need, either mine or some other user.

    Tight storage on the target machine is all too common when the hardware folks don't bother talking to the DBAs before ordering systems.

    Art

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


    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.










  • 7.  RE: 'myimport -C'

    Posted Mon November 23, 2020 08:17 PM

    That makes complete sense, and my experience tells me your use case is exactly correct.

     

    DG