If you work on the mainframe using z/OS and haven't heard of RESTful APIs, you need to wake up and smell the coffee. Seriously, even though RESTful APIs are still a fairly new thing, they're already essential. If you don't know about them, ask the people on the distributed side of your business -- who I can assure you already rely upon them -- to help bring you up to speed.
Posted: July 12, 2016 |
Recently I’ve fielded a number of questions about the best use of DB2 Connect. Specifically, customers want to know if they should continue to use the DB2 Connect gateway or move applications toward a direct connection using the DB2 Connect client with IBM DB2 data server drivers.
Posted: July 05, 2016 |
During May's IDUG NA conference, I attended a session by IBM's John Campbell. A question came up on how to size and configure local and group bufferpools. John mentioned that a presentation he'd given on this in 2013 is available as a webcast.
Posted: June 28, 2016 |
Since joining IBM last year I've been spending more time speaking to user groups. This got me thinking about a post I wrote back in December 2012 on the professional benefits of public speaking. While I'd love for you to read the whole thing, I'll sum it up in four words: You can do this.
Posted: June 21, 2016 |
Last year I noted that IBM was accelerating development of the DB2 Analytics Accelerator. With new maintenance releases coming out about every 3-6 months, it's a challenge to keep up with all the changes. That's why I was excited to discover the IBM developerWorks Community for DB2 Analytics Accelerator.
Posted: June 14, 2016 |
Each new DB2 release brings enhancements to the SQL optimizer, which is designed to speed response times by improving the access path used to return qualified data to the application. However, these improvements can only be realized by first REBINDing the program package.
Posted: June 07, 2016 |
Recently I was sitting in on a customer review and the topic of maximum number of open data sets came up. In DB2 11, the maximum number of open datasets is increased from 10,000 to 200,000.
Posted: May 31, 2016 |
Back in August 2011, I wrote about the use of roles and trusted context in auditing DBA activity. Just recently two separate customers have asked me about how and when to use this. Given that -- not to mention the increased attention on enterprise security, the growing demand for remote access through mobile devices, and the ongoing need to audit all management activities -- this topic is well worth revisiting.
Posted: May 24, 2016 |
Back in 2011, I wrote a series of posts about the evolution of optimization hints and the new DB2 10 statement-level optimization hints.
Now with DB2 11, the statement-level optimization hint can override the selectivity of predicates for matching statements. This is needed because DB2 cannot estimate filter factors for certain types of predicates. It must rely on inaccurate estimates or even default filter factors to select access paths for statements that use such predicates.
Posted: May 17, 2016 |
I recently worked with a customer who hadn't been using the PARALLEL parameter for REORG TABLESPACE. They'd set the LISTDEF parameter at the database level, which qualifies a large number of table spaces with hundreds of partitions per table space. Because the customer lacked the disk space to process hundreds of partitions simultaneously, they set the REORG_LIST_PROCESSING system parameter to SERIAL, which defaults the value of PARALLEL to (NO).
Posted: May 10, 2016 |