Amit:
You may be able to use either my dbcopy or demove utility, both included in my utils2_ak package, to copy the data using smaller transactions!
You can download the latest release of utils2_ak from my web site at
www.askdbmgt.com/my-utilities------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com------------------------------
Original Message:
Sent: Fri March 12, 2021 12:47 AM
From: AMIT PATEL
Subject: calculation of Required logical log
Hello All,
We need to the data purging for table which is having huge data. We are renaming table with other table and then Re-creatingthe original table and from backup table again inserting data based on condition like "INSERT INTO cs_pmpt_regn SELECT * from cs_pmpt_regn_backup where date > '01-01-2019 10:20:30'
and could insert millions of records.
So How can calculate the estimation for how many logical log may required for transaction?
I have attached the word file with table rows, extent size and used extent size and number of logical log.
Kindly help to share the logical log estimation calculation.
Thanks
Amit Patel
------------------------------
AMIT PATEL
------------------------------
#Informix