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 29, 2014


Robert Catterall

Isolating DB2 for z/OS Accounting Data at the WebSphere Application Level

Back in the 1990s, almost all of the DB2 for z/OS-accessing transactional applications I encountered were of the CICS variety. Often, a given DB2 subsystem served as the database manager for multiple CICS-based applications. In such cases, isolation of DB2 accounting information (i.e., database activity figures obtained from DB2 accounting trace records) at the application level was not difficult. DB2 accounting trace records contain multiple identifier fields, and several of these are suitable...

(Read more)

Willie Favero

DB2 11 for z/OS Performance Topics is completed and available

(Posted Tuesday, July 29, 2014) Good news from the IBM Redbook website. The DB2 11 Performance Topics Redbook has been posted in its final status; it is no longer a Draft. All of the comments made about it since becoming a draft have accumulated and editing has been completed. It is now ready...

(Read more)

Ember Crooks

DB2 Basics: Aliases

My blog entries covering the DB2 Basics continue to be my most popular blog entries. This is probably because they appeal to a wider audience – even non-DBAs are interested in them and I...

...

DB2utor

Identifying Locked DB2 Resources

Last week I explained how to find the cause of a deadlock or timeout. This week, I'll show you how to identify the name and...

Triton Consulting

Top 10 DB2 Support Nightmares & How to Avoid Them #4

Here is part four in our top ten DB2 support nightmares series. Here we look at DBA performance! Top 10 DB2 Support Nightmares #4 – Download if you dare! from Laura Hood

(Read more)
 

July 28, 2014


Henrik Loeser

Why we need and have workload management

Wikipedia While working in your office a rare visitor from another location stops by. Time for a break to connect on the latest gossip, but not too long. On the way back to your office your boss...

(Read more)

Henrik Loeser

What's Going On? - DB2 Workload Management: Identification of Activities

In an earlier blog post I had written about why Workload Management is needed. It's not just something for the database system or on the operating system level, it is really useful and done in "real...

(Read more)

Henrik Loeser

Quiz? State of Affairs...!

This is not really a quiz (if you followed by advice to try out IBM Bluemix), but merely shows the state of affairs: Current State What does it say to the trained eyes? Where was screenshot...

(Read more)
 

July 25, 2014


Craig Mullins

Happy DBA Day!

Hey everybody, time to celebrate... today, July 25, 2014 is SysAdmin day! For the past 15 years, the last Friday in June has been set aside to recognize the hard work done by System Administrators. This is known as System Administrator Appreciation Day.  As a DBA, I have regularly co-opted the day to include DBAs because, after all, we are a special type of system administrator -- the...

(Read more)

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)

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