DBTABLOG - Taking forever to export

[Former Member]

Hello,

I am currently exporting the database using SAP distribution monitor. This is on AIX, DB2 and ECC 6.0 and will be performing Unicode conversion during the import. However, table DBTABLOG is taking forever to export. This table has around 25 Mi records and 4.8 GB SIZE. I have even splitted the table into 2, but the export rate is very very bad comparing to other big tables and etc. export rate is like 3.33 MB/Min and which is taking around 13 hours to complete, does anyone has any idea why this is taking longer to export? Please advice.

Thanks in advance.

Kumar

[Former Member]

Hi,

Check SAP Note 579980 - Table logs: Performance during access to DBTABLOG

Thanks

Sunny

[Former Member]

Hi Sunny, Thanks for your quick reply.

I am not sure how this note would be helpful during the Manual database export using distribution monitoru2026since they are talking about change log analysis and it is strictly at the SAP Application level, for uses who wants to pull/analysis table logging.

Kumar

[Former Member]

Hi,

Check SAP Note 579980 - Table logs: Performance during access to DBTABLOG

Thanks

Sunny