topic Re: DBTABLOG - Taking forever to export in Application Development and Automation Discussions

DBTABLOG - Taking forever to export

Former Member — Wed, 14 Jul 2010 06:15:27 GMT

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

Re: DBTABLOG - Taking forever to export

Former Member — Wed, 14 Jul 2010 07:35:55 GMT

Hi,

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

Thanks

Sunny

Re: DBTABLOG - Taking forever to export

Former Member — Wed, 14 Jul 2010 07:39:05 GMT

Hi,

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

Thanks

Sunny

Re: DBTABLOG - Taking forever to export

Former Member — Wed, 14 Jul 2010 15:09:59 GMT

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