(Paul C. Zikopoulos) The Toad product from Quest Software is a well-known database tool that helps to improve the productivity of application developers and database administrators (DBAs) working with some of the world’s most popular relational databases. In September 2005, Quest Software made some

(Jacques Roy) A date is a complex piece of information. It represents a specific day of the year. You can group dates together by day of the week, month, quarter, and so on. The grouping allows you to compare results for specific periods from year to year.

(Paul C. Zikopoulos) The Toad product from Quest Software is a well-known database tool that helps to improve the productivity of application developers and database administrators (DBAs) working with some of the world’s most popular relational databases. In September 2005, Quest Software made some

(Willie Favero) must be missing English class because this entry had me searching for a dictionary to look up the definition of my title word. The current web version of the Merriam-Webster’s dictionary defines coexistence as: 1) to exist together or at the same time 2) to live in peace with each

(Guy Davis) Get help developing your database-driven unit-testing skills. Without isolation and automation, database-driven unit tests can become a maintenance nightmare of sporadic failures and bad test data. The open source Apache Derby database is ideal for completely automating and isolating uni

(Serge Rielau) When porting or migrating an application from Oracle to DB2 UDB for Linux, UNIX, and Windows, recursive queries present a significant obstacle. A developer who understands and uses Oracle-style recursion often does not naturally understand DB2 recursion and the same is true the other

(Willie Favero) Migration to compatibility mode is complete, or almost complete. The next big question that comes up is “How Long?” How long is long enough for you to stay in compatibility mode? You will not want to hear the answer. It depends!!! It depends on how you move new releases of software i

(Linfeng Yu) Most WebSphere Application Server (WAS) for z/OS customers use DB2 for z/OS as the backend or data store. DB2 for z/OS is a high-performance DBMS, with a strong reputation for handling high-volume data access transactions. Picking the right WAS for z/OS and DB2 Subsystem connectivity ar

(Joyce Coleman and Ronen Grosman) Learn about server-assisted client redirect (SACR) and how it can be used to build applications that are highly scalable across DB2 servers and WebSphere Application Server clients. Learn, also, which applications will benefit most from SACR, how to partition data a

(Chris Eaton) This is going to be my last posting on monitoring your database with SQL scripts. And I’ll end it off with a big bang (or at least the biggest SQL statement I’ve written in quite some time). I’m sure most of you have a bag of scripts that you run from time to time to check the status […]