(Javier Estrada Benavides) For many years we have known that executing BIND over packages and plans sets up the required structures inside the Db2 catalog and directory.
Tag: IBM
Db2’s Alternate Page Cleaning
(Ember Crooks) The first professional technical presentation I ever gave was on March 31, 2003. I had been a DBA for just less than 2 years. It was at an event called “SDC West Geek Fest”.
Common Database Design Errors
(Craig S. Mullins) Before we begin today’s blog post, wherein I explain some of the more common mistakes that rookies and non-database folks make (heck, even some database folks make mistakes), I first want to unequivocally state that your organization should have a data architecture team that is re
Is your data ready for AI? Part 1
(Rafi Ezry and Bruce Tyler) Artificial intelligence is a major driver of value for the enterprise. According to a recent AI study from IBM, 82 percent of organizations are now at least considering AI adoption, and the number of companies that are beyond the AI implementation stage is 33 percent high
DB2 TSAMP Clustering – Resource marked as OFFLINE
(Jack Vamvas) Question: I’ve installed the latest security vulnerability patching for jdk on DB2 TASMP clustering – and while running some tests i.e fail over and fail back , I’m getting a Resource Marked as offline.
Advanced Query Tuning with IBM Data Studio
(Tony Andrews) Do you make any New Year’s resolutions? In case you don’t have any Db2 related, we have a suggestion for you. What if you start the New Year with improving the performance of your SQL queries?
IBM Spectrum Scale and IBM StoredIQ: Identifying and securing your business data to support regulatory requirements
(Sandeep R Patil, Sasikanth Eda, Atul V Gore and Nils Haustein) Having the appropriate storage for hosting business critical data and the proper analytic software for deep inspection of that data is becoming necessary to get deeper insights into the data so that users can categorize which data quali
A Case Study: Measuring the Impact of Db2 for z/OS Buffer Pool Changes
(Robert Catterall) Not long ago, a Db2 for z/OS administrator contacted me with a request. His team had made some changes to the buffer pool configuration in their production Db2 environment (the overall size of the buffer pool configuration was increased to reduce read I/O activity, and greater use
A Look at Watson Knowledge Catalog
(David Shirey) This month, I want to look at Watson Knowledge Catalog. I tend to think of it as Watson Studio’s big brother, but I’m not sure if that’s actually true. You decide when we get to the end of this. I trust your judgment.
Guru: Arranging Query Logic in DB2 for i Routines
(Michael Sansoterra) Hey, Mike: We use a stored procedure to return the result set to Java and display the results to a screen. I would like to make this stored procedure put the result set into a temporary table and then do some processing on the temporary table. Is this possible and if so how c