(Ember Crooks) I call my post-conference blog posts brain dumps because that is largely what they are – information formatted in a way my brain understands but not necessarily as thoroughly organized and researched as you might be used to seeing from me.
Tag: IBM
DB2 11 for z/OS Application Developer – Part 3
(Emil Kotrc) The third episode of our series deals with distributed access to DB2 for z/OS. In this blog post, I would like to change the format a little bit. Instead of providing full links in the text, I will switch to standard hyperlinks in order to make the blog more readable.
5 Important Ideas from IBM Insight Conference
(Dave Beulke) The IBM Insight conference was last week and on the long flight home I was thinking how this year’s conference was different from previous years’ events. Here are my five big takeaways from this year’s conference.
Reduce Risk and Improve Security on IBM Mainframes: Volume 3 Mainframe Subsystem and Application Security
(Axel Buecker, Marcela Kanke, Mohit Mohanan, Vinicius Oliveira, Vinodkumar Ramalingam, David Rowley, Botrous Thalouth and Jan Thielmann) This IBM Redbooks publication documents the strength and value of the IBM security strategy with IBM z Systems hardware and software. In an age of increasing secur
The DBA’s Big Data Holiday Wish List — #1: Scaling Up and Out
(Lockwood Lyon) Like management information systems, enterprise resource planning and relational database, big data is now a standard part of information technology architecture for most large organizations. Common applications include storage and analysis of customer data, web interactions, machine
More DB2 Family Security Best Practices Part 7: Preventing SQL Injection
(Dave Beulke) The next part (Part 7) of this DB2 Family Security Best Practices blog talks about preventing SQL injection in all your different applications. SQL injection is the ability of a hacker to provide extra SQL input into any of your interfaces or web sites and access data they want instead
Using Stored Procedures to Lock Application Objects
(John Maenpaa) We live in a massively multithreaded world. Lots of actions are occurring around us. We are jumping from one task to another. Every now and then, we have to slow down and stop what we are doing to let another task make its way in the stream of activities. That task isn’t necessarily o
Tuning Big Data Applications — Additional Tuning Options
(Lockwood Lyon) Big data stored in DB2 tables may require the DBA to reduce or minimize the number of indexes on the data. While it is typical to add multiple indexes to a table to improve query performance, for very large tables the indexes will be large as well.
IBM Insight 2015 Wrap-Up
(Craig S. Mullins) Last week I attended the IBM Insight conference and blogged about the first few days of the conference here at http://db2portal.blogspot.com/2015/10/an-update-from-ibm-insight-2015.html… and I promised to blog about the remainder of the conference, so here is a synopsis of the hig
DB2 Administrative SQL Cookbook: Column Selectivity by Table (BLU)
(Ember Crooks) This statement reports how selective at the column level queries are that run against a specific table. This does not look at overall selectivity or row selectivity. It will only work in DB2 10.5. BLU performs best when not all columns are referenced by queries.