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.
 

August 22, 2014


Vincent McBurney

IBM Information Server Just Got Cheaper with Unlimited User Entitlements

IBM has removed the requirement for authorized user licenses for Information Server product bundles making significant savings for customers, especially those with enterprise governance and quality programmes.
 

August 21, 2014


Dave Beulke

Three DB2 Performance Areas to Verify When Experiencing DB2 Performance Degradation

When you experience DB2 performance degradation, you’ll discover no one has changed anything (of course), or admits to changing anything. Luckily there are a wide variety of DB2 performance dependencies to check. When DB2 processes are running consistently well, then suddenly the DB2 performance...

(Read more)
 

August 19, 2014


Willie Favero

August 2014 (RSU1407) service package has been tested and is now available

(Posted Tuesday, August 19, 2014) Testing for RSU service package RSU1407 is now complete.  This RSU completes the first quarter of 2014.  This August 2014 2nd Quarter 2014 1st Addendum "Quarterly Report" (67 KB PDF file) contains ALL service through the end of M...

(Read more)

Henrik Loeser

Accessing DB2 from node.js on IBM Bluemix and locally

Some days ago I started experimenting with node.js. Other than JSON and some click functions on webpages I don't have much experience with JavaScript. The reason for this "adventure" is that node.js...

(Read more)

Henrik Loeser

Sample IBM Bluemix Application: Extended IP logging with node.js and DB2

As I wrote in my last blog article I have been playing around with node.js and DB2 on IBM Bluemix. Now I am done with my first server-side JavaScript application which I named...

(Read more)

Ember Crooks

Quick Hit Tips – CPUSPEED, RESTRICTIVE, and DB2_WORKLOAD

Today we are going to talk about some random DB2 features that can’t stand in a blog of their own, but are worth discussing nonetheless. These are tidbits I had discovered during “DB2’s Got...

...

DB2utor

An In-Depth Look at Buffer Pool Monitoring and Tuning

IBM recently released a Redpaper, "IBM DB2 11 for z/OS Buffer Pool Monitoring and Tuning." While this document is intended for DB2 systems administrators, it...
 

August 18, 2014


Triton Consulting

DB2 10 for z/OS withdrawn from marketing – Date Announcement

IBM have announced that DB2 for z/OS will be withdrawn from marketing from 6th July 2015.  This means that DB2 10 along with DB2 10 VUE and the DB2 10 Utility Suite will no longer be available to order.  This … Continue reading →

(Read more)
 

August 17, 2014


Willie Favero

APAR Friday: DSNWMSGS has just been updated again

(Posted August 17, 2014) If you have had the opportunity to do any performance tuning of DB2 for z/OS, you have probably come across any number of IFCID (instrumentation facility component identifier) at some point.  In fact, I did a blog post way back in May 2010 discu...

(Read more)
 

August 16, 2014


ChannelDB2 Videos

DB2 Tips n Tricks Part 41 - How to get Admin Authorities on a Restored Database

How to get Admin Authorities on a Restored Database Solution: db2set DB2_RESTORE_GRANT_ADMIN_AUTHORITIES=ON Restart Instance Restore Database Happy Learning ...
 

August 15, 2014


Susan Visser

What happens when you put DB2 on Power?

When it comes to analytic results, fast can always be faster. Together, DB2 with BLU Acceleration and the new generation of IBM Power Systems are optimized to put data to work – delivering even faster analytic performance.

The new generation of IBM Power Systems, powered by POWER8 processors, is specifically designed for big data with innovation that optimizes analytics performance.  IBM DB2 with BLU Acceleration on new Power Systems offers insights 82x faster at a reduced cost.

 Yes, it is no longer the"wait-for-results-and-get-coffee” analytics.

I’ve pulled together a few of our favourite graphics, papers, and videos to help demonstrate this point:

  • The business value of DB2 BLU on IBM Power Systems is pretty impressive: it provides 82x faster insights!  This infographic will give you a few points to ponder:  http://bit.ly/PowerBLU

 

  • I know you may be skeptical, so take a look what analyst Philip Howard of Bloor Research discovered.  He compares DB2 with BLU Acceleration and Cognos BI running on Power Systems with competitive offerings from Oracle, Microsoft, and SAP:  http://bit.ly/BloorBLU

 

  • SAP OLAP workloads work on many platforms, but why not use the platform that will provide the best performance?  Watch this video that shows how fast SAP OLAP workloads run when paired with IBM DB2 BLU on IBM Power Systems: bit.ly/turbochargeSAP

 

  • The POWER8 processor is designed for big data, and it is capable of running increased concurrent queries in parallel quickly and across multiple cores by utilizing more threads per core. DB2 with BLU Acceleration is a next-generation database technology for in-memory computing. Organizations can analyze data rapidly and efficiently to uncover insights for helping grow revenue, reduce cost, and minimize risk.  Read this article by Robert Friske to help you understand the super powers built into POWER8:   http://bit.ly/db2powerduo

 

  • DB2 on Power Systems offers extreme performance without limits for analytics with BLU Acceleration and provides flexibility and scalability for SAP ERP with PureScale – a complete solution for all SAP users. Given all options available in the market, IDC recommends that SAP users consider adopting IBM DB2 as the data platform for both transactional and analytics applications.  Read the entire report from IDC: http://bit.ly/IBMBLUPower

 

If you like this information, be sure to follow @IBM_DB2 on twitter to get this kind of information as it is published.

 

Susan

Your DB2 Social Butterfly!

 

 

 

 


Craig Mullins

Join the Transaction TweetChat

Today's blog post is an invitation to join me -- and several of my esteemed colleagues -- on Twitter on August 20, 2014 for a TweetChat on transactions. Now that sentence may have caused some of you to have a couple questions. First of all, what is a TweetChat? Well, a TweetChat is a pre-arranged conversation that happens on Twitter. It is arranged by an organizer (for this one, that would...

(Read more)
 

August 14, 2014


DB2 Guys

August Tweetchat – How Important Are Transactions In a Big Data World?

By Susan Visser Join us for the #Transactions Twitterchat on “How important are transactions in a big data world?” Aug 20, from 11:00 am to 12:00 pm ET. Our special guests for this Twitterchat are: Scott Hayes – @srhayes Craig Mullins  @craigmullins Kelly Schlamb  @KSchlamb  You can follow along—and join the discussion using the hashtag […]

Susan Visser

How important are transactions in a big data world?

Join us for the #Transactions Twitterchat on “How important are transactions in a big data world?” Aug 20, from 11:00 am to 12:00 pm ET.

Our special guests for this Twitterchat are:

  • Scott Hayes - @srhayes
  • Craig Mullins  @craigmullins
  • Kelly Schlamb  @KSchlamb

 

You can follow along—and join the discussion using the hashtag #Transactions.   We look forward to your thoughts and comments on #Transactons twitterchat hosted by @IBM_DB2 (Susan Visser).

 

How do you join in?

If you use a Twitter client like Tweetdeck or HootSuite, create a search column for the term #Transactions. Then as participants tweet with the #Transactions hashtag, those tweets will appear in your column.

 

How do you participate?

Review the discussion questions so you can prepare your thoughts and answers. When the question is posed, begin your response with A1: for question 1 and A2: for question 2, and so on. This makes it easier to follow the conversation throughout the chat. No answer is wrong!

 

Discussion Questions

  • Q1: How do you define “transaction”? Online purchase, sensor reading, CRM/ERP update, log entry, web click, social post?
  • Q2: Who is impacted, and how, when transaction systems go down or perform poorly?
  • Q3: How should Service Level Agreements address transaction system availability and performance?
  • Q4: What are the most important database capabilities for high availability and consistent performance?
  • Q5: When you need to make changes for performance or growth, how does the database scale? Do applications need to change?
  • Q6: How many DBAs does it take to …keep a database up and running smoothly? …respond to problems?
  • Q7: How can you minimize planned downtime for backups, maintenance, upgrades?
  • Q8: If an unplanned outage or failure happens, what is an acceptable recovery time?

 

 

Reading List

More about our panelists

Craig Mullins

Craig is president & principal consultant of Mullins Consulting, Inc., a principal with SoftwareOnZ and the publisher/editor of The Database Site, His working experience spans multiple industries.   He’s written multiple books and blogs at: http://datatechnologytoday.wordpress.com/

Scott Hayes

Scott Hayes is President & CEO of Database-Brothers Inc (DBI), a company intensely focused on IBM DB2 UDB LUW and Oracle database solutions. Scott is an IBM DB2 GOLD Consultant and has received a number of DB2 Certifications.  Scott hosts The DB2Night Show series of webinars.  Check the website http://www.dbisoftware.com/db2nightshow/ where you can found hundreds of hours of free DB2 education.

Kelly Schlamb

Kelly works in the IBM Software Group, Information Management as an Executive IT Specialist in WW IM Technical Sales.  His specialties are DB2 pureScale & PureData System for Transactions.  Kelly has written several blog entries on the IBM DB2 Blog site.

 

Thanks to Larry Heathcote, Ember Crooks, Sally Hartnell, Kelly Schlamb, and Scott Hayes for helping me put this together!

 

Susan


Dave Beulke

Five Areas to Verify to Stay Safe in Your Cloud

There are a number of considerations for every company as they begin to conquer their new cloud projects, including several technology challenges such as data security, data placement segregation, and data access coordination to name a few. There are several other areas that can bring the business...

(Read more)
 

August 13, 2014


ChannelDB2 Videos

Deploying and running SQL script


Thumbnail

In this tutorial, you will see how to deploy and run multiple artifacts such as SQL scripts against multiple databases using IBM Data Studio.

Henrik Loeser

Using some Workload Management for free in non-Advanced Editions of DB2

One of the new features of DB2 10.5 is BLU Acceleration. In introduces a couple of default Workload Management objects that are intended to control heavy queries running against column-organized...

(Read more)
 

August 12, 2014


Ember Crooks

DB2 Error Logging

(Edited 8/12/2014 to add links to the old tutorials from IBM) There are a number of ways to cover error logging. I have covered some specific elements in previous posts, so I’m going for a more...

...

DB2utor

IBM Knowledge Center a DB2 for z/OS Resource

As I've often noted, I prefer storing DB2 for z/OS manuals in PDF format. Even though keeping them updated is a challenge, I believe that...

Triton Consulting

What are the top five reasons for choosing remote database support?

#1 Cost No prizes for guessing that cost is a major factor for many organisations that choose remote database support. However, it’s not as clear-cut as you may think. When we looked at this issue more closely we discovered that … Continue reading →

(Read more)
 

August 08, 2014


Henrik Loeser

Manage a DB2 database on IBM Bluemix

I recently showed you how to set up a Python-based application that makes use of the SQL DB service (a.k.a. DB2) on IBM Bluemix. Today I give you a quick introduction into what you can do with the...

(Read more)
 

August 07, 2014


Ember Crooks

Bad Message Queue Handler. Sit. Stay.

There’s an error message that appears in my db2 diagnostic logs rather frequently. It looks like this: 2014-07-30-13.34.58.446316+000 E1638372A476 LEVEL: Error (OS) PID : 32374944 TID : 1 PROC...

...

IBM Press Room

CSC and IBM Expanding Alliance to Speed Clients’ Adoption of Hybrid Cloud, Mobile and Big Data

Leading technology companies CSC and IBM today announced they are building on their existing alliance with new ways to help global customers accelerate their transition to the cloud.
E-mail this page Save to del.icio.us Digg this
 

August 05, 2014


Willie Favero

DB2 10 for z/OS Out-of-Service Date Announced

(Posted Monday, August 5, 2014) On September 30, 2017, that?s in just 3 years, 1 month, and 25 days from today (05AUG2014), DB2 10 for z/OS (5605-DB2) will go out of service.   That may seem like a long ways off, but it isn?t.  It?s only lust under 38 months.  W...

(Read more)

DB2utor

A Newbie Perspective on DB2

In her recent post on IDUG's DB2 Beginner's blog, Lauren Turner compares learning database basics with the challenge of picking up a foreign language. I...

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