Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

RBDCPCLR - Delete Change Pointers

Former Member

‎2010 Jun 03 2:04 PM

3,088

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.

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.

Reply
2 REPLIES 2
Read only

Former Member

‎2010 Jun 03 2:08 PM

0 Likes
1,097

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

Read only

Former Member

‎2010 Jun 18 2:14 PM

0 Likes
1,097

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