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 DB2 10 Security ImprovementsDB2 10 for z/OS introduces the ROLES-based security model that was introduced in DB2 9.7 LUW. This security model provides granular data access security providing definitions that can secure data access down to the row and column level. DB2 10 also . . . → Read More: DB2 10 Security Improves Java Performance Every client is different and working in a variety of different environments helps me understand different systems, applications and database design performance aspects and what works and doesn’t work. Over the next few weeks, I’ll be highlighting for you how to improve the performance of a . . . → Read More: DB2 Case Study Introduction |
||
|
Copyright © 2012 Dave Beulke - All Rights Reserved Privacy Policy |
||
