 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. |
|
Automated Storage management |
|
JimWankowski
|
Tuesday, July 29, 2008 12:30 PM
|
|
|
Continuing on with my discussions on autonomic computing in DB2 is the concept of self managing space. Proper space allocations are another critical factor when it comes to optimizing the performance of your database. Inadequate space allocations can result in application ...
|
 |
|
Comments (0)
|
Read More...
|
|
|
|
DB2 Autonomics |
|
JimWankowski
|
Monday, June 02, 2008 8:16 AM
|
|
|
|
Obtaining optimal performance from your DB2 LUW applications requires that you not only ensure your SQL is written efficiently and is properly tuned, but one must be sure that the DB2 instance itself is properly tuned. Too many people make the mistake of focusing all their efforts on tuning SQL and do not take a look at the big picture. Think of your DB2 installation as an ecosystem, where memory, phys ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
Custom Data Reporting with Toad for DB2 |
|
JimWankowski
|
Tuesday, December 18, 2007 10:57 AM
|
|
|
|
One of the nicer features within Toad® for DB2 is the wide array of reporting capabilities. There is a constant requirement for managerial level reports that need to be run on a regular basis. Many of these reports are generating using reporting tools like QMF, Crystal Reporting, etc. Toad’s data reporting facility p ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
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...
|
|
|
|
|
|
|
|
|
|
|