| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
|
| 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 - |
![]() |
| Thread Tools | |
| Display Modes | |