The BLU Acceleration technology is coming out and the new DB2 Version 10.5 Kepler performance improvements are game changing and dramatic especially for Big Data. I blogged about these features in a more detailed entry (IBM BLU Acceleration – Best Yet for Big Data!). The Columnar data store, 10x compression, in-memory processing, Single . . . → Read More: Big Data: BLU Acceleration DB2 Version 10.5 Kepler Considerations
|
|
||
|
Recently I discussed DB2 SQL tips that have provided application performance for decades with my clients’ SQL developers. These DB2 SQL tips provide developers with performance guidelines that can help their application designs and SQL coding get the best performance the first time. Since clients have many different DB2 SQL tips, I’ve listed below 10 . . . → Read More: DB2 SQL Tips: 10 Performance Guidelines Hardware continues to get faster, cheaper, and with more capacity. Now UNIX and even Windows systems are trying to handle billions of rows or terabytes of data. Database performance tuning is vital, but continues to get destroyed through wretched designs, poor application practices and maintenance malpractice which dramatically impacts overall database performance. Unfortunately, throwing more . . . → Read More: Database Performance Tuning Is Only Getting More Important DB2 Clean up – Close Out the PastAs I said last week, within every DB2 LUW or DB2 z/OS systems there are things that always need to be cleaned up. This week we look into the DB2 Plan and Package settings. These settings can . . . → Read More: DB2 Performance Maintenance – Get All the Cache DB2 Clean up – Close Out the PastAs I said last week, within every DB2 LUW or DB2 z/OS systems there are things that always need to be cleaned up. This week it’s recommended that you look into your various program’s plan and package . . . → Read More: DB2 Performance Maintenance – Trust But Verify DB2 Clean Up – Close Out the PastWithin every DB2 LUW or DB2 z/OS systems there are things that always need to be cleaned up. Test systems with unused databases, production jobs that need their schedule tweaked, reorgs for tables or indexes that need . . . → Read More: DB2 Performance Maintenance – Start Off the New Year Right! Row and Column Access ControlsAs I have talked about in previous weeks, another reason to request additional DBA resources are all the security configuration and settings involved with DB2 10 row and column access security. The setup, configuration and monitoring of these row and . . . → Read More: DB2 Security: Row and Column Access Controls Security Audits Coming Your WayIs performance the number one issue for the DBA and the application teams or is security and governance? I guess it depends on your industry and point of view. With the latest WikiLeaks scandal, the new BASEL III requirements, HIPAA . . . → Read More: DB2 Audit Security Policies DB2 10 SECADM helps DB2 auditsIn addition to the introduction of ROLES, encryption and masking of data, DB2 10 takes a giant step forward with security and DB2 audits with the new SECADM authority. This new SECADM authority is finally acknowledging the huge amount . . . → Read More: DB2 10 Security, the SECADM Opportunity DB2 10 Encryption and MaskingIn addition to the introduction of ROLES with DB2 10 there are also a number of other security improvements that are also introduced with the new release. The first ones that are going to be a big hit with everyone . . . → Read More: DB2 10 Security Encryption Improvements |
 
  |
|
|
Copyright © 2013 Dave Beulke - All Rights Reserved | Privacy Policy | Refund Policy |
||
