Do you have a topic that you'd like discussed? We'd love to hear from you. Send us your idea for a blog topic.

 |
 |
|
|
 |
 |
|
Author: |
JimWankowski |
Created: |
Tuesday, August 14, 2007 9:26 AM |
 |
|
Providing Toad “Tips and Tricks” and other useful information for administration and development on DB2 whether you are running on Linux, Unix, Windows, or z/OS. |
|
Multi-Location Script Executions |
|
JimWankowski
|
Wednesday, November 21, 2007 8:24 PM
|
|
|
|
In many cases there is a need to create an object or to execute an SQL statement in multiple locations. The group execute option in TOAD for DB2 allows you to execute a script against multiple environments with one easy step.&nb ...
|
 |
|
Comments (1)
|
Read More...
|
|
|
TheThree Letter Word |
|
JimWankowski
|
Monday, October 29, 2007 2:27 PM
|
|
|
|
I just got back from the IBM IOD conference in Las Vegas; it was a great show. Every year there is usually some buzz about what is “hot” with DB2. This year’s buzz was heard loud and clear – XML was being discus ...
|
 |
|
Comments (0)
|
Read More...
|
|
|
|
Roll with the Changes |
|
JimWankowski
|
Friday, September 28, 2007 3:16 PM
|
|
|
|
One of the questions I get quite a bit from customers is; do we have the ability to compare data and/or have the ability to compare DDL files to what’s currently in the DB2 catalog? As of V3.0 of TOAD for DB2 the ...
|
 |
|
Comments (0)
|
Read More...
|
|
|
The Attack of the Clones! |
|
JimWankowski
|
Monday, September 17, 2007 11:28 AM
|
|
|
|
This week I am going to switch gears over to the big iron and talk about DB2 z/OS. IBM has been making great strides in the area of schema management. As any mainframe DBA knows, the process of having to make a seemingly simple schema change can result in a very complex combination of DDL, Utilities and batch processes. These changes can result in applicati ...
|
 |
|
Comments (0)
|
Read More...
|
|
|
The importance of SQL scalability testing |
|
JimWankowski
|
Thursday, August 30, 2007 1:26 PM
|
|
|
|
As we all know, there are many factors that influence the performance of your application. Proper memory allocations, physical design, how the SQL is written and workload all affect the way your queries perform. One of most overlooked parts of testing an application is testing queries under production workload conditions.< ...
|
 |
|
Comments (2)
|
Read More...
|
|
|
Welcome to the Toad for DB2 blog |
|
JimWankowski
|
Wednesday, August 15, 2007 10:41 AM
|
|
|
|
Welcome to my inaugural blog for Toad® for DB2. Many of you may not be aware that Toad is now a multiplatform solution. I plan to discuss subjects across both DB2 running on the LUW platf ...
|
 |
|
Comments (0)
|
Read More...
|
|
|
 |
 |
|
 |
|
 |
|
|