Informix

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
------------------------------

#Informix

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
------------------------------

Original Message:
Sent: Fri December 27, 2019 06:59 AM
From: Sergio Peres
Subject: onpladm help please!

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
------------------------------

#Informix

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
------------------------------

Original Message:
Sent: Fri December 27, 2019 02:09 PM
From: FERNANDO NUNES
Subject: onpladm help please!

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

Original Message:
Sent: Fri December 27, 2019 06:59 AM
From: Sergio Peres
Subject: onpladm help please!

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
------------------------------

#Informix

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
------------------------------

Original Message:
Sent: Fri December 27, 2019 02:30 PM
From: Art Kagel
Subject: onpladm help please!

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

Original Message:
Sent: Fri December 27, 2019 02:09 PM
From: FERNANDO NUNES
Subject: onpladm help please!

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

Original Message:
Sent: Fri December 27, 2019 06:59 AM
From: Sergio Peres
Subject: onpladm help please!

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
------------------------------

#Informix

Original Message------

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
------------------------------

#Informix

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
------------------------------

Original Message:
Sent: Fri December 27, 2019 10:06 PM
From: Paul Watson
Subject: onpladm help please!

Cdr migrate server

Paul Watson

Oninit LLC

+1-913-387-7529

www.oninit.com

Oninit®️ is a registered trademark of Oninit LLC

Original Message------

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
------------------------------

#Informix

Original Message------

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
------------------------------

#Informix

Thanks,

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

Best regards,

SP

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

Original Message:
Sent: Sat December 28, 2019 06:51 PM
From: Paul Watson
Subject: onpladm help please!

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

Original Message------

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
------------------------------

#Informix

Original Message------

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
------------------------------

#Informix

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
------------------------------

Original Message:
Sent: Sat December 28, 2019 06:38 PM
From: Art Kagel
Subject: onpladm help please!

Use ifxclone!

Art

Original Message------

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
------------------------------

#Informix

agreed

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

Original Message:
Sent: Fri December 27, 2019 02:30 PM
From: Art Kagel
Subject: onpladm help please!

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

Original Message:
Sent: Fri December 27, 2019 02:09 PM
From: FERNANDO NUNES
Subject: onpladm help please!

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

Original Message:
Sent: Fri December 27, 2019 06:59 AM
From: Sergio Peres
Subject: onpladm help please!

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
------------------------------

#Informix

Hello

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

thanks

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

Original Message:
Sent: Fri December 27, 2019 02:09 PM
From: Fernando Nunes
Subject: onpladm help please!

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

Original Message:
Sent: Fri December 27, 2019 06:59 AM
From: Sergio Peres
Subject: onpladm help please!

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
------------------------------

#Informix

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
------------------------------

Original Message:
Sent: Mon April 11, 2022 09:59 AM
From: John Smith
Subject: onpladm help please!

Hello

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

thanks

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

Original Message:
Sent: Fri December 27, 2019 02:09 PM
From: Fernando Nunes
Subject: onpladm help please!

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

Original Message:
Sent: Fri December 27, 2019 06:59 AM
From: Sergio Peres
Subject: onpladm help please!

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
------------------------------

#Informix

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
------------------------------

Original Message:
Sent: Mon April 11, 2022 09:59 AM
From: John Smith
Subject: onpladm help please!

Hello

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

thanks

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

Original Message:
Sent: Fri December 27, 2019 02:09 PM
From: Fernando Nunes
Subject: onpladm help please!

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

Original Message:
Sent: Fri December 27, 2019 06:59 AM
From: Sergio Peres
Subject: onpladm help please!

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
------------------------------

#Informix