Motivation A major DB2 partner acquired a subsidiary a while back which sells an application that needs to me enabled from Oracle to DB2. The team is making good progress, but recently ran into a snag. There was a difference between Oracle and DB2 which caused DB2 to raise a run time error. With deeply nested routines which are being driven by an application homing in on the root cause was not trivial. Tracing This is a prime example for tracing. Given a tracing facility the team could have attached to the application, traced the failing...
[More]
Tags:
application
db2trc
tracing
sql
profile
trace
routine
procedure
sql_trace
profiling
dbms_monitor
trigger
X
Interesting SQL solutions for DB2 LUW as well as hints on how to move Oracle applications to DB2
