I know that this blog is supposed to be primarily about DB2, but I like to sneak in mainframe-related topics from time to time. And I read a great article today in Computerworld that I want to share with you. The article, titled Confession of a COBOL Programmer, talks up the need for COBOL coders. Just like with other mainframe technologies, as the baby boomers retire there is an insufficient supply of newbies available to step in and continue the care and feeding of the COBOL legacy.I've written briefly about COBOL before, in my Data Management...
Wednesday, 20 February 2008
Tuesday, 5 February 2008
Intelligent Automatic Reoptimization? [DB2 9 for z/OS]
Posted on 09:34 by Unknown
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. Without knowing the actual values of the host variables the optimizer has to make some best guesses as to how best to satisfy the SQL request.Furthermore, we know that we can guide DB2 on how best to approach this situation using the REOPT parameter of the BIND command. Prior to DB2 V9, there were three options for REOPT:REOPT(NONE) – DB2 will not reoptimize SQL at run time.REOPT(ALWAYS) – DB2...
Subscribe to:
Posts (Atom)
