decor
 

planetDB2 logo

  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.
 

July 25, 2014


Henrik Loeser

The Hunt for the Chocolate Thief (Part 2) - Putting IBM Bluemix, Cloudant, and a Raspberry Pi to good use

I am still on the hunt for the mean chocolate thief, kind of. In the first part I covered the side of the Raspberry Pi and uploading data to Cloudant. I showed how to set up an infrared motion sensor...

(Read more)

Henrik Loeser

Catching the mean chocolate thief with Raspberry Pi, Bluemix, and Cloudant

I always try to have some chocolate in my office, kind of as mood enhancer. But how to be sure that nobody else is going to plunder and pilfer my hidden treasures? So it was great that last week at...

(Read more)
 

July 24, 2014


Dave Beulke

Apple and IBM Partnership to Leverage BLUMix Synergies

The recent partnership between IBM and Apple combines the expertise of the enterprise and user-friendly mobile application devices. The partnership takes advantage of the expertise of both companies along with leveraging the new IBM BLUMix Cloud infrastructure, the various software platforms and...

(Read more)
 

July 23, 2014


ChannelDB2 Videos

DB2 Tech Talk: Use DB2 with BLU Acceleration for SAP

Learn from the expert how to use BLU Accleration in-memory computing for fast analytics and reporting on SAP data. This simple, agile solution helps preserve your hardware investment.

Henrik Loeser

Watch this! Move your DB2 monitoring to the in-memory interface (WLM monitoring)

Since its first days as a database management system, DB2 has been been changed. It has been extended by new features to serve customer requirements and has been adapted to the state of the art in...

(Read more)
 

July 22, 2014


Leons Petrazickis

How to run and install IPMIView on Mac

Softlayer cloud uses IPMIView for direct console access to bare metal hardware. SuperMicro makes a Mac version of IPMIView available for download. Bizarrely, SuperMicro doesn’t appear to have...

(Read more)

Adam Gartenberg

Your Participation is Needed: 6th Annual Analytics Survey

IBM's Institute for Business Value is currently collecting responses for the 6th annual IBV Analytics survey, and needs your participation. The survey, the largest of its kind in the industry, will...

(Read more)

Ember Crooks

DB2 Basics: Storage Groups

What is a Storage Group? A storage group is a layer of abstraction between the data in your database and disk. It is only used with Automatic Storage Tablespaces (AST). It allows us to group...

...

DB2utor

Finding the Cause of a Deadlock or Timeout

Pinpointing the cause of an application failure is one of the more challenging aspects of a developer's job. Locking problems can be greatly reduced by...
 

July 21, 2014


DB2Night Show News

Top DB2Night Show DB2 LUW Replay Downloads of Season #5

The DB2Night Show™ is pleased to announce our most popular DB2 for LUW shows of Season #5 running September 2013 through June 2014. While you are enjoying the summer of 2014, why not expand...

...

DB2Night Show News

Top DB2Night Show DB2 z/OS Replay Downloads of Season #5

The DB2Night Show™ is pleased to announce our most popular DB2 for z/OS shows for Season #5 running September 2013 through June 2014. According to replay downloads as of 18 July 2014, here's...

...
 

July 18, 2014


Data and Technology

Take a Big Data and Cloud Computing Quiz

Are you concerned about new technology and industry hype rendering your experience obsolete? Are memes like Big Data and Cloud Computing confusing to you… or are you comfortable that you know...

(Read more)
 

July 17, 2014


Craig Mullins

DB2 Health Checks - Part 1

Left to their own devices, DB2 databases and applications will accumulate problems over time. Things that used to work, stop working. This can happen for various reasons including the addition of more data, a reduction in some aspect of business data, different types of data, more users, changes in busy periods, business shifts, software changes, hardware changes… you get the idea. And there is...

(Read more)

Willie Favero

Back to Buffer Pool Basics Octology

I?m not sure if Octology is word or not... I can?t find it on Dictionary.com although it does show up in Wiktionary.org.   I?m using it anyway to describe my Back to Buffer Pool Basics Series of 8 posts.   From this post, you can ...

(Read more)

Willie Favero

Back to Buffer Pool Basics: Part 5A - Fixed Thresholds

Let?s start today?s post with a short discussion about what a buffer pool is.   I know most of you all know this stuff already, so this explanation will be short and just enough to get us all on the same page.   Thresholds are usu...

(Read more)

Willie Favero

Back to Buffer Pool Basics: Part 5C - DWQT and VDWQT

(Posted Thursday, July 17, 2014) Just as a review: Before we jump into discussing the last two variable buffer pool thresholds, the defaults for the previously discussed fixed buffer pool thresholds are: immediate write threshold (IWTH) - 97.5%, data management threshold (DMTH) - 95%, and...

(Read more)

Ember Crooks

Quick Tip: Simple Errors on Database Connection

There are a couple of errors that you can get on database connection that simply mean you typed something wrong, but I figure there are people who will search on these errors, so I thought I would...

...

Willie Favero

Back to Buffer Pool Basics: Part 5B - VPSEQT and VPPSEQT

(Posted Thursday, July 17, 2014) Just as a review: Before we jump into discussing the different variable buffer pool thresholds, the defaults for the fixed buffer pool thresholds are: immediate write threshold (IWTH) - 97.5%, data management threshold (DMTH) - 95%, and prefetch threshold (SPTH) -...

(Read more)
 

July 16, 2014


Susan Visser

Learn about Big Data - 4 select cities in China

In the world of big data, Hadoop is not the answer to every question. While the promise of big data is clear, selecting the right architecture and technologies to invest in is becoming a game-changer for a growing number of organisations.  So how do you get ahead? Join IBM technical experts to learn how to maximize your IT opportunities using no nonsense presentations, live demonstrations and real-world performance comparisons.
During this half-day agenda, you will learn how to make the right decisions for your current and future architecture:

•Recognize the core technology innovations and landscape for big data that matter
•Compare IBM DB2 10.5 with BLU Acceleration with other in-memory, columnar database technologies such as SAP HANA
•Optimize the use of predictive analytics and business intelligence pervasively in your architecture
•Understand how to make wise open source investments in Hadoop for your enterprise
•Compare the capabilities and performance of analytical appliances
•Create a strategy to protect and secure your big data

So join us and learn how IBM can help your company make the right technology decisions today and in planning for what is next.

There are three options for registering:

call the hotline  010 -68,200,063
send a fax to      010 -68,207,655
send an email to:  IBMEvent05@dimei.cn

 

For the invitation in Chinese, see these links:

 

Thanks to Steven Rubin for providing me with this information.

 

Susan


Robert Catterall

DB2 for z/OS Buffer Pool Enlargement is NOT Just an Elapsed Time Thing

A couple of weeks ago, I got a question from a mainframe DB2 DBA about the impact of DB2 buffer pool enlargement on application and system performance. This individual had requested an increase in the size of a buffer pool on his system, and the system administration team had agreed to implement the change; however, one of the system administrators told the DBA that while the larger buffer pool would improve elapsed times for application processes accessing objects assigned to the pool, no CPU...

(Read more)
 

July 15, 2014


Willie Favero

Happy 8th Anniversary to my DB2 Blog

(Posted Tuesday, July 15, 2014) Today?s post will be short, sweet, and a little bit of bragging with some self promoting.  You see, this Friday, July 18, will be my blog?s 8 year anniversary.   My first post was on July 18, 2005. Yup, I have been writing this blog ...

(Read more)

Ember Crooks

STMM Analysis Tool

I mostly like and use DB2′s Self Tuning Memory Memory Manager (STMM) for my OLTP databases where I have only one DB2 Instance/Database on a database server. I do have some areas that I do not...

...

DB2utor

Using the New Compatibility Mode

In May when I posted a summary of new DB2 11 features, I mentioned that the latest release allows applications with SQL or XML to...
 

July 14, 2014


Frank Fillmore

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

From November 9 – 14 I will be visiting one of the most charming cities on the planet when I attend the International DB2 Users Group (IDUG) conference in Prague, CZ.  I will present “IBM...

(Read more)

Antonio Cangiano

Learn to Secure Apps in Vancouver, and Calgary SMAC Meetup

Lately I have been travelling a fair bit throughout Western Canada for various IBM events. Two such events are planned for the second half of July, so I thought I’d share them here. Vancouver...

...
 

July 13, 2014


ChannelDB2 Videos

DB2 Tips n Tricks Part 38 - Limitation on Monitor Metrics by Dynamic SQL Snapshot


Thumbnail

How Dynamic SQL Snapshot is Technically Correct but Functionally Incorrect Solution: Dynamic SQL Snapshot aggregates monitor metrics based on Statement Text....
 

July 12, 2014


Willie Favero

APAR Friday: Accelerator, SQLCODE, SYSTS_UPDATE SP, and PKGREL_COMMIT

(Posted Saturday, July 12, 2014) The first three APARs all have something to do with the DB2 Analytics Accelerator for z/OS. Even though the Accelerator is a for-cost option, it?s still pretty cool and gaining more and more popularity. After all, who doesn?t want to run queries that normally run...

(Read more)

Willie Favero

Please take this survey... This one is important to all of us!

(Posted Saturday, July 12, 2014) There?s a group of folks at IBM?s Silicon Valley Lab, you know the people who are responsible for creating all that terrific DB2 for z/OS documentation that allows us to our daily jobs so much better and easier, who have put together a survey to dete...

(Read more)
 

July 10, 2014


Dave Beulke

Another 5 More DB2 SQL Performance Tips

As I talked about last week, good DB2 SQL performance is vital for efficient processing. I also talked previously about DB2 SQL performance here, here, and here describing the many attributes that can impact and improve DB2 SQL performance. Fortunately all of these blogs combined . . . →...

(Read more)

Dave Beulke

5 More DB2 SQL Performance Tips

Writing good DB2 SQL is always difficult because it is dependent on the database table design and the various table indexes available coming together with the purpose of the processing module, There are many DB2 SQL performance tips to remember and several are documented in my DB2 SQL performance...

(Read more)
 

July 08, 2014

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.
 

Search

Bloggers

decor