topic Re: RBDCPCLR - Delete Change Pointers in Application Development and Automation Discussions

RBDCPCLR - Delete Change Pointers

Former Member — Thu, 03 Jun 2010 13:04:20 GMT

Hi everybody!

Is it possible to speed up Report RBDCPCLR to delete all processed Change pointers ?

Now we habe more than 9,000,000 Change pointers for 1 Messagetype, that we don't need anymore - Report RBDCPCLR is already running as job about a month and have just deleted abot 1,000,000 entries from table BDCPS/BDCP. How can we improve the performance?

Any ideas are welcome

Thanks a lot for your help,

Alexey.

Re: RBDCPCLR - Delete Change Pointers

Former Member — Thu, 03 Jun 2010 13:08:12 GMT

Check some notes:

Note 1014725 - DB2-z/OS: Bad performance in RBDCPCLR

Note 328355 - BD21: Long access times for the BDCPV view

Note 670209 - ALE: Poor performance when deleting change pointers

Note 1008334 - DB2-z/OS: Performance Problems with DB2 V8/V9 REOPT(ONCE)

Reddy

Re: RBDCPCLR - Delete Change Pointers

Former Member — Fri, 18 Jun 2010 13:14:46 GMT

sorry, but these notes cann't be implemented into our system (release 700) cause they are too old/obsolete.