(Joe Pluta) OK, “exciting” may be stretching it just a little, but “helpful” and “appreciated” definitely come to mind when looking at some of the new features in the editor.
Tag: IBM
Guru: Dealing With Non-Normalized Data
(Jon Paris) From time to time, many of us have to find solutions for handling our old non-normalized tables in an efficient manner. It would be nice to have the luxury of redesigning and normalizing these databases, but real life is not like that.
Simple, Highly Scalable and Distributed Query Processing with IBM Queryplex
(Robert Neugebauer) Data is the cornerstone of business and it exists everywhere. You can find it in databases and big data clusters, in branch offices or manufacturing devices, in ATMs, in cars, trucks and in sensors.
Db2 12 for z/OS Tools Compatibility
(Troy L Coleman) Before migrating from Db2 11 to Db2 12 for, you must verify that all IBM Db2 tools are supported.
Consolidation Planning Workbook Practical Migration from x86 to IBM LinuxOne
(Lydia Parziale) IBM LinuxONE is a portfolio of hardware, software, and solutions for an enterprise-grade Linux environment. It is designed to run more transactions faster and with more security and reliability specifically for the open community. It fully embraces open source-based technology.
Db2 for z/OS Buffer Pools – Time to Give AUTOSIZE(YES) a Try?
(Robert Catterall) Db2 9 for z/OS became generally available back in 2007. In the years since, most of the features introduced with Db2 9 have been broadly put to use. An interesting exception is the auto-sizing of buffer pools, implemented via the AUTOSIZE(YES) option of the -ALTER BUFFERPOOL comma
Scripting with Selenium
(Andrew Chan) IBM Website Monitoring is a comprehensive solution for website probing and alerting. This software-as-a-service (SaaS) offering consists of:
Db2: CTE and CONNECT BY – two kinds of recursion
(Henrik Loeser) Recently, I gave a talk on SQL Recursion. One of the cool features in Db2 that I (re-)discovered for that presentation is that there are two different forms of syntax for recursive queries. One is the Common Table Expression (CTE), another the CONNECT BY syntax.
Managing data migration with your storage solution
Simon Lightstone, lead offering manager for DB2 on Cloud and Hosted, explains IBM’s position on hybrid data management storage, including how to manage the important issue of data migration.
SQL Injection Still Causing Trouble
(Craig S. Mullins) An on-going and important aspect of managing database security is designing your applications to avoid SQL injection attacks. SQL injection is a form of web hacking whereby SQL statements are specified in the fields of a web form to cause a poorly designed web application to dump