|
|
 |
Blogs
Toad and Database Commentaries |
Toad World blogs are a mix of insightful how-tos from Quest experts as well as their commentary on experiences with new database technologies. Have some views of your own to share? Post your comments! Note: Comments are restricted to registered Toad World users.
 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 |
 |
 |
Jim Wankowski is a DB2 technology specialist for Quest Software. Jim has more than 20 years of development and database administration (DBA) experience with DB2 and is well known in the DB2 community. He has written articles for DB2 Magazine as well as z/Journal, and regularly presents at IDUG conferences, regional DB2 user groups and vendor seminars worldwide.
Jim's blog provides “Tips and Tricks” and other useful information for administration and development on DB2 whether you are running on Linux, Unix, Windows, or z/OS.
Recent postings:
|
|
|
Rolling Back Object Changes in Toad for DB2 |
|
JimWankowski
|
Monday, August 03, 2009 11:49 AM
|
|
|
|
Have you ever had a situation where you made a change to a DB2 table structure such as renaming a column, or adding a new column only to discover that your production applications are now crashing because they haven’t been updated to support the new structures? What do you do then? You have to scramble to generate an ALTER script to put the objects back to their original form ...
|
 |
|
|
Read More...
|
|
|
Toad for DB2 V4.5 has arrived! |
|
JimWankowski
|
Wednesday, July 22, 2009 1:24 PM
|
|
|
|
I am very happy to announce that we went GA with Toad for DB2 V4.5 on 7/21. This is by far the biggest, best release of Toad for DB2 to date. With this version we have introduced a full featured database administrator’s tool capable of handling the largest DB2 environments.
Some of the highlights of the 4.5 release are:
&l ...
|
|
|
|
|
Read More...
|
|
|
DB2 2009 |
|
JimWankowski
|
Tuesday, January 06, 2009 8:19 AM
|
|
|
|
Happy new year everybody. I hope everyone had a great holiday season. It’s tough getting your head back in the game after a long holiday, that’s for sure! But there is a lot to look forward to in 2009 with our DB2 products. Toad for DB2 came a long way in 2008. As y ...
|
|
|
|
|
Read More...
|
|
|
Automated Maintenance |
|
JimWankowski
|
Wednesday, September 03, 2008 7:31 AM
|
|
|
Automated maintenance began with DB2 LUW 8.2. At this time the behavior of automated utilities had to be controlled manually either through the Control Center or the automation wizard. Now with DB2 9.5 automation of RUNSTATS and REORG commands can be controlled by an XML document referred to as an “automatic maintenance policy” These policies control which objects are consi ...
|
|
|
|
|
Read More...
|
|
|
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 ...
|
|
|
|
|
Read More...
|
|
|
DB2 LUW Autonomics |
|
JimWankowski
|
Monday, June 30, 2008 6:21 AM
|
|
|
Last week I did an IDUG sponsored webcast on the topic of autonomic computing. I wil be excerpting these features over the next few blogs. If you wish to view a recording of the webcast here is the link: http://www.quest. ...
|
|
|
|
|
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 ...
|
|
|
|
|
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 ...
|
|
|
|
|
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 ...
|
|
|
|
|
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 ...
|
|
|
|
|
Read More...
|
|
|
DB2 Day to Day |
|
JimWankowski
|
Friday, October 12, 2007 11:13 AM
|
|
|
|
Hey DB2’ers,
I had a busy week last week speaking at the Central Canadian DB2 Users Group in Toronto
|
|
|
|
|
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 ...
|
|
|
|
|
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 ...
|
|
|
|
|
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.< ...
|
|
|
|
|
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 ...
|
|
|
|
|
Read More...
|
|
|
|
|
|
|
|
|
|
|