Apply is not running SQL statements

This is a discussion on Apply is not running SQL statements within the db2-udb forums in Other Databases category; Hello. I have an odd problem here. I have two databases which are pulling data from a single source database. All are on AIX 5.3.0.0. The source database is running 64-bit DB2 v8.1 FP11, as is one of the target databases. The other target Database (that I'm having problems on) is running 64-bit DB2 v8.1 FP12. Here's the problem... Tagged onto one subscription set, I have two SQL statements to prune the APPLYTRACE and APPLYTRAIL tables. Nothing out of the ordinary, just deleting using a calculated timestamp as the cutoff. The ...

Go Back   Database Forum > Other Databases > db2-udb

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 09-24-2007, 02:23 PM
Default Apply is not running SQL statements

Hello.

I have an odd problem here. I have two databases which are pulling data from a single source database. All are on AIX 5.3.0.0. The source database is running 64-bit DB2 v8.1 FP11, as is one of the target databases. The other target Database (that I'm having problems on) is running 64-bit DB2 v8.1 FP12. Here's the problem...

Tagged onto one subscription set, I have two SQL statements to prune the APPLYTRACE and APPLYTRAIL tables. Nothing out of the ordinary, just deleting using a calculated timestamp as the cutoff. The set has the same SQL on both target databases and it runs fine on one -- but not the other. The set is completing just fine, no errors there. Nothing in the diag log either.

When I check the SQL within Replication Center, I can execute it using the [Run] button on the SQL Assist panel, but it appears not run when the set does. I went through the exercise of removing the statements and adding the back again. I even added the SQL to another set, but still no luck. I am somewhat stumped. The only thing I can think of is that perhaps the FP12 is not committing?

Any thoughts? Advice?

Thanks,
- Bill -
Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 05:50 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Integrated by bbpixel2009 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.