If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Replication : when asn.IBMSNAP_UOW is pruned ?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-23-07, 14:27
rahul_s80 rahul_s80 is offline
Registered User
 
Join Date: Jul 2006
Location: Pune , India
Posts: 433
Exclamation Replication : when asn.IBMSNAP_UOW is pruned ?

i am testing my DB for replication.
Now 1 of the table AA is having large records and
during its delete the corresponding CD table is just getting piled up .
since last 2 hrs the CD table is just increassing .
i have seen its transactions in IBMSNAP_UOW ,
now i want to force the pruning of IBMSNAP_UOW
and CDAA table . how to acheive that?
which parameters should i change so that even a major delete cope up with
replication
__________________
Rahul Singh
Certified DB2 9 DBA / Application Developer
Reply With Quote
  #2 (permalink)  
Old 06-24-07, 02:46
guyprzytula guyprzytula is offline
Registered User
 
Join Date: Jun 2006
Posts: 471
the ibmsnap_capparms table keeps a column prune_interval
this is the interval in seconds between prune cycles
or use asnccmd command to force a prune cycle
__________________
Best Regards, Guy Przytula
DB2 UDB LUW certified V6/7/8
Reply With Quote
  #3 (permalink)  
Old 06-24-07, 06:22
rahul_s80 rahul_s80 is offline
Registered User
 
Join Date: Jul 2006
Location: Pune , India
Posts: 433
Lightbulb

thanks Guy Przytula,

the value of prune_interval is set to 300 sec.
also

C:\Documents and Settings\Administrator>asnccmd CAPTURE_SERVER=PHOENIX PRUNE
2007-06-23-21.15.54.990000 ASN0600I "AsnCcmd" : "" : "Initial" : Program "capcm
d 8.2.5" is starting.
2007-06-23-21.16.03.162000 ASN0506E "AsnCcmd" : "ASN" : "Initial" : The command
was not processed. The "Capture" program is presumed down.

however the service is up and running

Last night the delete utility ended at 10:30 but the replication end at 7:30 am today.

2007-06-23-23.21.12.636000 <pruneUOW> ASN0105I CAPTURE "ASN" : "PruneThread". "27" rows have been pruned from the table "ASN"."IBMSNAP_UOW" at "Sat Jun 23 23:21:12 2007".
2007-06-24-07.38.12.411000 <pruneCDNormal> ASN0105I CAPTURE "ASN" : "PruneThread". "2058668" rows have been pruned from the table "EONE"."CDTPPL_ATNDNCE_DTLS" at "Sun Jun 24 07:38:12 2007".
2007-06-24-07.38.13.974000 <pruneCDNormal> ASN0105I CAPTURE "ASN" : "PruneThread". "11230" rows have been pruned from the table "EONE"."CDTPPL_ATNDNCE_DTLS_HIST" at "Sun Jun 24 07:38:13 2007".
2007-06-24-07.38.14.130000 <pruneCDNormal> ASN0105I CAPTURE "ASN" : "PruneThread". "1280" rows have been pruned from the table "EONE"."CDTPPL_ATNDNCE_MSTR" at "Sun Jun 24 07:38:14 2007".
2007-06-24-07.38.14.630000 <pruneUOW> ASN0105I CAPTURE "ASN" : "PruneThread". "116" rows have been pruned from the table "ASN"."IBMSNAP_UOW" at "Sun Jun 24 07:38:14 2007".
__________________
Rahul Singh
Certified DB2 9 DBA / Application Developer
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On