decor
 

planetDB2 logo

Planet DB2 is an aggregator of blogs about the IBM DB2 database server. We combine and republish posts by bloggers around the world. Email us to have your blog included.

 

November 26, 2014


Ember Crooks

Giving Thanks in the DB2 Community

It’s Thanksgiving in the US. This is a time to stop and reflect on what I’m thankful for in my life, and a big part of that is the DB2 community for me. Here’s who and what...

...
 

November 25, 2014


Ember Crooks

Using LISTAGG to Turn Rows of Data into a Comma Separated List

This is a topic I have to look up from time to time, and I always go straight to Serge Rielau’s blog. He has a number of good articles on LISTAGG, the similar XML specific functions, and much...

...

Robert Catterall

DB2 for z/OS: How Low Can Synchronous Read Wait Time Go?

Short answer: lower than I'd previously thought. Short explanation: solid-state drives. OK, backstory: I was recently analyzing some performance information related to a client's production DB2 for z/OS environment. Included in the documentation provided by the client were some Accounting Long reports generated by their DB2 monitor (these reports format data contained in DB2 accounting trace records). As I typically do when reviewing such reports, I checked out the wait time per synchronous...

(Read more)
 

November 24, 2014


Craig Mullins

Peace, Prosperity and Happy Thanksgiving

Just a quick blog post today to wish all of my readers, wherever they live, peace and prosperity during this holiday season. And to my readers in the USA, Happy Thanksgiving. You know what that means, right? Relatives, football, and a lot of food, including turkey! It also means that we are about to "officially" start the holiday shopping season, which begins on Black Friday. Of course, anyone...

(Read more)
 

November 21, 2014


DB2Night Replays

The DB2Night Show z53: Altering objects and the impact it has

Presented by: Klaas Brant IBM Gold Consultant, KBCE "The DB2Night Show z53: Altering objects and the impact it has" Replays available in WMV and M4V formats! 96% of our studio audience learned something! Some alters are a piece of cake and can also reverted. Others are more complex and have a (big) impact. Some are still impossible and require you to drop and recreate the object. Watch the replay...

(Read more)
 

November 20, 2014


Dave Beulke

3 Game-Changing IBM DB2 pureScale Enhancements

Another set of great INSIGHT announcements that were somewhat drowned out by all the Watson hoopla were all the enhancements that are happening with DB2 pureScale. For those unfamiliar with DB2 pureScale, it is the multi-node cluster configuration providing the industry’s best scalability,...

(Read more)

DB2 Guys

Bringing Informix Technology to the World’s Fastest Growing Database Market

By Sajan Kuttappa SWG Informix Social Media Marketing & Communications Manager, IBM If someone wanted more proof that Informix is technologically a step ahead of competitors, IBM provided evidence in China! Even the hardest cynic would find it difficult to rebuff the fact that the adoption of a locally innovated version of the Informix database […]

Henrik Loeser

Useful DB2 administrative functions and views

Did you know that there are about 80 (eight-zero) administrative views in the SYSIBMADM schema in DB2 that are ready for use? I have used several of them and also looked into the documentation, but...

(Read more)

Triton Consulting

Top Five Reasons For Choosing Remote Database Support – Lack of Skills In-House

#4 Lack of skills in-house In the fourth instalment of our “Top Five Reasons for Choosing Remote Database Support” blog series we look at DBA skills. We work with organisations who do not have any DB2 skills in-house and organisations … Continue reading →

(Read more)
 

November 19, 2014


Ember Crooks

DB2 Fine-Grained and Row Access Control (FGAC/RCAC)

DB2 10.1 introduced a new feature commonly called RCAC (Row and Column Access Control) or FGAC(Fine-Grained Access Control). This is a bit less labor intensive to support than LBAC (Label Based...

...
 

November 18, 2014


Frank Fillmore

“IBM Data Retrieval Technologies : RDBMS, BLU, IBM Netezza and Hadoop” #IDUG Presentation

The trip to Prague, CZ last week for the International DB2 Users Group meeting was fabulous.  The city certainly has changed since I’ve been there – all for the better.  It seems more...

(Read more)

Ember Crooks

DB2 Explain Output in Another Format

I’m always keeping an eye on Twitter to catch interesting bits of news, and that includes watching cross platform information. I find it fascinating to compare DB2 to other RDMBSes, and saw a...

...
 

November 17, 2014


Henrik Loeser

A quick look at dashDB and a happy SQuirreL

dashDB slogan on its website This morning I took some time to take a look at dashDB, a new IBM DWaaS (Data Warehouse as a Service) offering. When you go to the dashDB website, you are offered two...

(Read more)
 

November 14, 2014


DB2Night Replays

The DB2Night Show #142: DB2 LUW Sage Performance Advice with Scott Hayes

@srhayes :: @db2performance Special Guest: Scott Hayes, DBI Software Sage DB2 LUW Performance Advice A "New" Way to Analyze Performance 100% of our audience learned something! Based on his IDUG Phoenix Top 10 presentation, Scott presents a new way to think about and analyze DB2 LUW performance. Today's show even includes a 6 minute video clip taken from IDUG in Prague. ATTENDEES will receive all the cool SQL commands electronically! ...

(Read more)

Craig Mullins

Database Basics for Beginners

Every now and then I get e-mail from readers of my blogs asking introductory/beginner questions about databases and DBMS. I cannot take the time to answer all of these e-mails in-depth, so I thought I blog a quick post with some good resources for folks. I think a good place to start is an article I wrote several years ago now titled What is a Database? This article breaks down the benefits...

(Read more)
 

November 13, 2014


Triton Consulting

IDUG EMEA 2014 – Day 4

I’m sat in the departure lounge, steadying my nerves after the taxi ride across town. My driver had that fluid yet aggressive style of driving common to city taxi drivers across the globe, coupled with a fondness for Phil Collins … Continue reading →

(Read more)

Dave Beulke

IBM Big SQL Interface Out-Performs the Others

At the recent Insight and IDUG conferences IBM talked about its many new software products for modern corporation information management. These new products handle the constant flow of inexhaustible big data from new data resources like social data from Facebook, Twitter and other sources; location...

(Read more)
 

November 12, 2014


DB2 Guys

CrowdChat: Join Our Expert Panel And Get To Know dashDB

By Jason Burns ITSO Social Business Manager for DB2 Are you facing challenges with your current data warehousing and analytics architecture? What role do cloud technologies play in your data architecture? Join us November 18th at 2:00 PM ET for an IBM Information Management CrowdChat as we take a deeper look at these questions and […]

Triton Consulting

IDUG EMEA 2014 – Day 3

This is my first attendance at an IDUG Technical conference. I have been reading and hearing a lot about IDUG over the years, but I have never had the opportunity to attend. I did however have some idea on the … Continue reading →

(Read more)

IBM Press Room

Kenya Power Taps IBM Real Time Data Solutions To Improve Business Performance

East Africa's largest power distributor Kenya Power, today announced the selection of IBM for an automated system that will provide a real time status of all business processes. This will enable Kenya Power to implement its strategic expansion plans.
E-mail this page Save to del.icio.us Digg this

Willie Favero

How is DB2 maintenance handled: the Poll

(Wednesday, November 12, 2014) As promised in my RSU blog post a few days ago, here are a couple of questions about have you apply your maintenance to DB2. Your responses could help the entire DB2 community.

(Read more)

Triton Consulting

IDUG EMEA 2014 – Day 2

The sun has been shining and the weather mild so far in Prague for IDUG EMEA 2014. (Who says the British only talk about the weather?) However last time I was in Prague the temperature was -20C and I was … Continue reading →

(Read more)
 

November 11, 2014


Craig Mullins

On Building Appropriate DB2 Indexes

Perhaps the single most important thing that can be done to assure optimal DB2 application performance is creating correct indexes for your tables based on the queries used by your applications. Of course, this is easier said than done. But we can start with some basics. For example, consider the following SQL statement:   SELECT  LASTNAME, SALARY   FROM   ...

(Read more)

Ember Crooks

DB2 Internals: Simple Query Processing

Edited 11/13/2014 to be more specific about coordinator agents. This is the first in a series of blog entries talking about DB2 internals. I have no intimate knowledge from IBM of how DB2 works...

...
 

November 10, 2014


Willie Favero

November 2014 (RSU1410) service package has been tested and is now available

(Posted Monday, November 10, 2014) Testing for RSU service package RSU1410 is now complete. This November 2014 3rd Quarter 2014 "1st Addendum Quarterly Report" (56 KB PDF file) is based on the October 2014 service ( RSU1409) and contains ALL service through the end of September 2014 not already...

(Read more)

Triton Consulting

IDUG EMEA 2014 – Day 1

So, that’s another IDUG EMEA conference opening day in the history books – my 16th since I attended my first conference in Barcelona back in 1997. I actually arrived in Prague yesterday morning after a VERY early flight from the … Continue reading →

(Read more)

DB2 Guys

Learn about DB2 at Kolkata India DB2 user event

There is nothing more exciting than hearing how to revolutionize your business with DB2 for Linux, UNIX and Windows, so here is your chance to unlock the best practices and learn from the experts. I encourage you to weave this event into your busy schedule this week. I promise you won’t be disappointed! Join technical […]

Subscribe by email

 

About

planetDB2 is an aggregator of blogs about the IBM DB2 database server. We combine and republish posts by bloggers around the world. Email us to have your blog included.
 

Bloggers

decor