(Craig. S. Mullins) In this 7th, and final installment of this series on influencing the DB2 optimizer’s access path choices, we will take a look at a couple of additional things to consider as you work toward improving your SQL performance.
Tag: IBM
More DB2 Family Security Best Practices Part 5
(Dave Beulke) The next part of this DB2 Family Security Best Practices blog series talks about developing a unique corporate security. This security is unique within your organization and unique within your applications.
Using DB2’s New Native Encryption Feature
(Ember Crooks) With fixpack 5 of DB2 10.5, IBM introduced Native Encryption for data at rest in DB2. This is a fairly significant new feature for introduction in a fixpack. It does require separate licensing – either the Advanced Edition of ESE or WSE or the separate purchase of the Native Encryptio
IBM CICS Performance Series: Comparing Type 2 and Type 4 JDBC Driver Performance with IBM CICS Transaction Server for z/OS V5.2 Liberty JVM server
(Graham Rawson) This IBM Redpaper publication is a study of the performance of a Java Platform, Enterprise Edition (Java EE) application that is hosted by an IBM CICS Transaction Server for z/OS (CICS) V5.2 Liberty Java virtual machine (JVM) server that connects to an IBM DB2 for z/OS database serve
Load Testing in a Big Data Environment — Load Testing Begins
(Lockwood Lyon) In preparation for the load test, the DBA needs to have several processes ready. Here are the most common.
Using DB2’s New Native Encryption Feature
(Ember Crooks) With fixpack 5 of DB2 10.5, IBM introduced Native Encryption for data at rest in DB2. This is a fairly significant new feature for introduction in a fixpack. It does require separate licensing – either the Advanced Edition of ESE or WSE or the separate purchase of the Native Encryptio
IBM CICS Performance Series: Comparing Type 2 and Type 4 JDBC Driver Performance with IBM CICS Transaction Server for z/OS V5.2 Liberty JVM server
(Graham Rawson) This IBM Redpaper publication is a study of the performance of a Java Platform, Enterprise Edition (Java EE) application that is hosted by an IBM CICS Transaction Server for z/OS (CICS) V5.2 Liberty Java virtual machine (JVM) server that connects to an IBM DB2 for z/OS database serve
Load Testing in a Big Data Environment — Load Testing Begins
(Lockwood Lyon) In preparation for the load test, the DBA needs to have several processes ready. Here are the most common.
DB2 11 for z/OS Extended RBA/LRSN Migration
(David Simpson) Many companies are planning a migration to DB2 11 for z/OS because of the support for expanding the RBA and LRSN. Planning for the expansion is a post-migration task that will require some thought. Let’s take a look at the process.
Optimizing Database Performance, part 5: Database Reorganization
(Craig S. Mullins) Relational technology and SQL make data modification easy. Just issue an INSERT, UPDATE, or DELETE statement with the appropriate WHERE clause and the DBMS takes care of the actual data navigation and modification.
