(Harishkumar Baburao Pathangay) How Classic Offline Reorganization consumes more Transactional Log Space Solution:
Tag: IBM
Load Testing Your Big Data Application
(Lockwood Lyon) Many big data applications are designed, built and installed without a formal load test. This is unfortunate, as load testing gives the database administrator quite a lot of valuable information. It may make the difference between poor and acceptable big data performance.
Cost-effective data management with DB2 10.5 and EMC FAST VP, Part 1: The multi-temperature data feature
(Aruna De Silva, Aslam Nomani, Naresh Chainani, Roger E. Sanders and John Adams) You need a cost-effective way to structure your company’s data so that you can instantly access hot data—or data that is accessed frequently—while also storing enormous amounts of cold data—data that is not accessed ver
IBM Bluemix – Specify only Liberty buildpack features you require
(Pas Apicella) I am more often then not using spring boot applications on IBM Bluemix and most of what I need is packaged with the application from JPA or JDBC, drivers, Rest etc. Of course with IBM Bluemix we can specify which build pack we wish to use but by default for java applications LIberty i
DB2 Administrative SQL Cookbook: Finding Unused Indexes
(Ember Crooks) To generate a list of unused or not recently used indexes.
A Lot of Extraneous Data Sets?
(Craig S. Mullins) In a recent blog post here I talked about a quick and dirty method of converting your partitioned table spaces from index-controlled to table=-controlled. If you haven’t read that post, take a moment to click over and read it here: Easily Convert to Table-Controlled Partitioning.
SQL 101: Aggregate Functions: Discovering SQL’s Hidden Gems
(Rafael Victoria-Pereira) How do you calculate a total amount based on detail records in RPG? You probably read each record, add the respective amount to a work variable, and move on to the next record, until the file (or subset of records) ends.
Thoughts on DB2 for z/OS Index Compression
(Robert Catterall) Not long ago, a DB2 for z/OS DBA requested of me some guidance in planning for his organization’s initial use of index compression (a capability introduced with DB2 9 for z/OS). He asked some good questions, and with the thought that my responses might be useful to others in the D
Configuring custom LDAP repositories in Virtual Member Manager
(Mr. Sharath Peddapally) When it comes to working with custom LDAP repositories in Virtual Member Manager (VMM), a part of IBM WebSphere Application Server, you now have greater flexibility. The expanded functions in VMM mean you can configure all V3-compliant LDAP repositories—both default and non-
Data Server Manager Now Supports DB2 for z/OS
(Troy L Coleman) In October I covered the announcement of IBM Data Server Manager. In a sense, I jumped the gun, because the initial release supported only DB2 for LUW.