How to carry over execution history when moving to a new system?

[Yuan Chieh Ying]

We are trying to move from an Oracle system to Postgresql and we recently ran the UNLOAD utility with the -btransportall flag. We expected that the execution history would be included in the unloaded data, but when we used the LOAD utility to load in the .txt file in the target client no execution history was present. Is there a parameter we are missing in using the UNLOAD utility or are we supposed to use the CLIENT COPY utility instead in order for us to preserve execution history?

[Peter Grundler]

Hi,

DB.Unload in transport mode is used to transport (all) objects but no stats, reports, messages etc.

You can use DB.ClientCopy (possible to select which information will be copied) or DB.Unload -BNORMAL (exports the entire database content).

regards,
Peter

------------------------------
Automic Certified Professional/Expert & Broadcom Knight

For AUTOMIC trainings please check https://www.qskills.de/qs/workshops/automic/
------------------------------

[Yuan Chieh Ying]

Thank you, we will try the client copy.