If there’s one thing that people ask me it’s “How can I use Toad for Data Analysts to automatically update my Excel report?” I’ll show you how you can get your Excel reports to update from the databas...
We were in a situation very recently to run SQL Tuning Advisor against a bunch of SQL statements that appeared in the AWR’s ADDM recommendations report. The initial effort to launch SQL Tuning Advisor...
Think of why you run the DB2 for z/OS REORG utility, and a number of reasons are likely to come quickly to mind: to restore row order per a table's clustering key; to reestablish free space (for inser...
