Specialized IT Services focused on Data Management | Speak with Us 877-634-9222
Tag: Craig Mullins
This post includes a series of 14 links, each one taking you to the TechTarget web site for a different DBMS product overview.
Every now and then I take the opportunity to blog about a question I get through e-mail. This time the question was: When does it make more sense not to build an index for a DB2 table?
When designing DB2 databases a frequently heard request is for a column that contains sequentially generated numbers. For example, each row has a counter associated with it.
DB2 performance is one of those perennial topics that people just can't seem to get enough of. I guess that is because the performance of applications is one of the bigger issues that end users complain about
Want to go over DB2 SQL functions at a basic level? This is a review for those who might not have used them before.
There are two basic mindsets on when to REBIND your DB2 programs. The first -- which I believe is the best approach -- is to REBIND regularly after running RUNSTATS.
Most DBAs have faced the situation where one of their applications requires a four-byte code that is used to identify products, accounts, or some other business object, and all of the codes are numeric and will stay that way.
The performance of dynamic SQL is one of the most widely debated DB2 issues. Some shops try to avoid it, but in this day and age of ERP/CRM systems, Java/JDBC programming, and web applications, all of which heavily rely on dynamic SQL, its use is becoming more ubiquitous.
Most seasoned SQL programmers know that when you use host variables, DB2 may not always come up with the absolutely most optimal access path at bind time.