If you’re mourning the loss of “RESET MONITOR ALL”, there are a number of ways you can address that. Ideally, you’d use this approach: http://www.ibm.com/developerworks/data/library/techarticle/dm-1009db2monitoring1/, but there are some arguments for using MONREPORT over that in some ways. One argument is that MONREPORT is built-in and you don’t have to add objects to make it work.… Read the restContinue reading »
This blog entry may be a little on the basic side, but some of my most basic entries are some of my most popular ones.
DB2 has a number of special characters, for which there are rules of use. Both the single quotation mark and the double quotation marks are special characters.… Read the restContinue reading »
As with the other entries in my DB2 Basics series, this entry does not cover everything about triggers. Instead, I’m covering the basics and a few important points.
DB2 triggers are sometimes over-used and over-complicated. Basically, triggers are actions(SQL) that take place when a triggering action occurs.… Read the restContinue reading »
This is clearly a broad topic, and this post is intended to serve as an introduction.
The first step in accessing a db2 database is Authentication. Authentication is what tells DB2 that you are who you say you are. Simply put, DB2 does not do authentication.… Read the restContinue reading »
Don’t call them indices in the United States – most American DBAs agree that they are ‘indexes’, though either plural form is grammatically acceptable in American English. Indexes are arguably one of the most important aspects of database design. They’re also something that we can pretty easily change and add to over time.… Read the restContinue reading »