Informix

 View Only
Expand all | Collapse all

onpladm help please!

  • 1.  onpladm help please!

    Posted Fri December 27, 2019 06:59 AM
    Hi,

    I have read about some advantages on use onpladm for backups. I don't find any examples, can someone give me some help how to backup one entire database with it.

    Thanks,

    SP

    ------------------------------
    Sergio Peres
    AIRC
    Coimbra
    ------------------------------


  • 2.  RE: onpladm help please!

    Posted Fri December 27, 2019 02:10 PM
    Sérgio,

    onpladm is an utility to create jobs for HPL (High Performance Load). This works on a table level and not on a database level. Besides that, HPL is somehow deprecated as you can have similar functionality (and performance) with external tables.

    I believe that Art's tools (myexport?) allow you to export a database using external tables... may be worth checking...

    Regards.

    ------------------------------
    FERNANDO NUNES
    ------------------------------



  • 3.  RE: onpladm help please!

    Posted Fri December 27, 2019 02:30 PM
    I agree with Fernando. Onpladm and so the HPLoader is the wrong tool to do text level archiving of databases. You could, as Fernando suggests, use my dbexport/dbimport replacement tool package, myexport, which uses external tables, but honestly I don't know why you would not just use ontape/onbar?

    The real problem with using HPLoader, dbexport, or myexport is that these are table by table exports which means that if the database is being actively used the export files will not be internally consistent across related tables. You may export a parent table just before a new row is inserted then export the child table that has new rows referencing the new parent row that will not be in the output. Similarly for deleted parents if the child table is exported first. Myexport has a feature to prevent the latter scenario, but you cannot avoid both and so the first scenario is all too real. It can even happen using myexports parallel export mode. Though that can minimize the possibilities, if your database has many tables, your system will not be able to handle exporting say 15000 tables in parallel, so this may not be a viable option.

    So, I implore you, please post the problem you are trying to solve, not the solution you can't get to work!

    ------------------------------
    Art Kagel
    ------------------------------



  • 4.  RE: onpladm help please!

    Posted Fri December 27, 2019 08:46 PM
    Thanks for your replies Fernando and Art, 
    The problem, I am trying to solve is to find a way to clone my database to another with minimal downtime.

    SP

    ------------------------------
    Sergio Peres
    AIRC
    Coimbra
    ------------------------------



  • 5.  RE: onpladm help please!

    Posted Fri December 27, 2019 10:06 PM
    Cdr migrate server

    Paul Watson
    Oninit LLC
    +1-913-387-7529
    www.oninit.com
    Oninit®️ is a registered trademark of Oninit LLC





  • 6.  RE: onpladm help please!

    Posted Sat December 28, 2019 06:29 PM
    Thanks Paul,

    I have listened some information about CDR command and it seems very useful, besides the information on documentation as it have lots of options, there are more practical examples? 

    Regards,

    SP

    ------------------------------
    Sergio Peres
    AIRC
    Coimbra
    ------------------------------



  • 7.  RE: onpladm help please!

    Posted Sat December 28, 2019 06:52 PM
    Nagarugi did a good presentation on this as the SLUG conference earlier in the year - should be on www.iiug.org

    I use cdr migrate in preference to ifxclone - just find it easier

    Cheers 
    Paul

    Paul Watson
    Oninit LLC
    +1-913-387-7529
    www.oninit.com
    Oninit®️ is a registered trademark of Oninit LLC





  • 8.  RE: onpladm help please!

    Posted Sun December 29, 2019 10:26 AM

    Thanks,

    I will take a look and do some tests over it.

    Best regards,

    SP



    ------------------------------
    Sergio Peres
    AIRC
    Coimbra
    ------------------------------



  • 9.  RE: onpladm help please!

    Posted Sat December 28, 2019 06:39 PM
    Use ifxclone!

    Art





  • 10.  RE: onpladm help please!

    Posted Sun December 29, 2019 10:30 AM
    Thanks Art,

    I did some testing to install RSS and HDR servers but got strange results so I continued to use the old methods ...

    Regards,

    SP

    ------------------------------
    Sergio Peres
    AIRC
    Coimbra
    ------------------------------



  • 11.  RE: onpladm help please!

    Posted Mon December 30, 2019 09:42 AM
    agreed

    ------------------------------
    anas khan
    ------------------------------



  • 12.  RE: onpladm help please!

    Posted Mon April 11, 2022 10:00 AM
    Hello

    is HPL deprecated ? do you have the reference please ? is the info on IBM site ?

    thanks

    ------------------------------
    John Smith
    ------------------------------



  • 13.  RE: onpladm help please!

    Posted Mon April 11, 2022 10:16 AM
    John:

    HPL is not deprecated. It is just used less frequently because external tables are simpler to use and perform a little faster on some data sets, a bit slower on others. It's just much easier to set up an external table export/import than an HPL job.

    Art

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



  • 14.  RE: onpladm help please!

    Posted Mon April 11, 2022 01:39 PM
    onpladm is still around.  While I do prefer external tables because of ease of use, HPL still has a place for fast unloads or loads.

    Documentation is on the IBM website.  

    Just search for informix and High-Performance Loader User's Guide...that will get you there.

    High-Performance Loader User's Guide - IBM Documentation

    ------------------------------
    Mike Walker
    xDB Systems, Inc
    www.xdbsystems.com
    ------------------------------