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.

 

September 30, 2014


Robert Catterall

DB2 for z/OS: DDF, Stored Procedures, and SET CURRENT PACKAGESET

Recently, I was talking with people from a company's IT department about modernizing their mainframe application architecture.Among other things, we discussed increasing the company's use of stored procedures for DB2 for z/OS data access. That prompted some questions around the use of the DB2 SQL statement SET CURRENT PACKAGESET in stored procedures called by DRDA requesters (these being calls that would get to DB2 via the distributed data facility, or DDF). Why did this issue come up? Because...

(Read more)

Ember Crooks

A Better Understanding of TSA Resources and States

It is very possible to support DB2′s HADR using TSA to automate failover without understanding many of the TSA components and details, and even the TSA commands. I’ve posted several blog...

...
 

September 29, 2014


DB2 Guys

What is DB2ssh?

By Mihai Iacob DB2 Security Development The IBM DB2 pureScale Feature provides high levels of distributed availability, scalability and transparency to the application, but why do I need to enable password-less SSH for the root user in my DB2 pureScale cluster? Well you don’t any longer and this site  explains how to use db2ssh to […]

Frank Fillmore

“The Top Three Reasons #DB2 is Best!” Webinar Materials

Many thanks to my colleague, Kim May, and IBMer Bill Kincaid for an excellent presentation on DB2 for LUW feature/functionality and pricing advantages over competing offerings.  And thank you to the...

(Read more)
 

September 28, 2014


Robert Catterall

DB2 for z/OS: Avoiding zIIP Engine Contention Issues

In an entry posted a few months ago to this blog, I touched on several matters pertaining to mainframe zIIP engines and the use of these processors by DB2 for z/OS. Based on recent experience, I feel that it's important to further highlight a particular zIIP-related issue: zIIP engine contention. Through this post, I want to explain what zIIP contention is, why you want to avoid it, how you can spot it, and what you can do about it. As, probably, most mainframers know by now, zIIPs (System z...

(Read more)
 

September 27, 2014


ChannelDB2 Videos

DB2 Tips n Tricks Part 43 - CURRENT_USER special register is not always current user


Thumbnail

How the CURRENT_USER special register is not always displaying current user Solution: Use SESSION_USER OR USER special register to display executor or invoke...
 

September 26, 2014


DB2Night Replays

The DB2Night Show #139: DB2 LUW db2batch command Tips and Advice

@pault99 Special Guest: Paul Turpin, Sr. DBA, BB&T Bank Advanced "db2batch" command Tips and Techniques 98% of our audience learned something! During today's show, Paul shared his excellent IDUG presentation in which he details his experiences, tips, and advice for using the IBM DB2 LUW "db2batch" command. There are many options to consider. By using the right options, you can Run and Explain your SQL, limit outputs, and choose various...

(Read more)

DB2 Guys

Exclusive Opportunity to Influence IBM Product Usability: Looking for Participants for Usability Test Sessions – Data Warehousing and Analytics

By Arno C. Huang, CPE Designer, IBM Information Management Design The IBM Design Team is seeking people with a variety of database, data warehousing and analytics backgrounds to participate in usability test sessions. We are currently looking for people who work in one of the following roles: DBA, Architect, Data Scientist, Business Analyst or Developer. […]
Cindy Russell

What's new on the BLU Acceleration hub?

Lots of new content is available on www.ibmbluhub.com, a site that is focused on BLU Acceleration in-memory computing for fast reporting and analytics from the transaction environment or a warehouse environment.  Here is a summary of some content you may want to check out:

  • What's new for BLU Acceleration in DB2 10.5 "Cancun Release", especially BLU Shadow Tables that let you perform operational reporting in the moment within the transaction environment goo.gl/tCRb6C

  • Client case study for Balluff GmbH, a german sensor manufacturer who is getting more performance from their SAP BW warehouse using BLU Acceleration and which demonstrates the "load and go" capabilities of BLU Acceleration.  goo.gl/0plm8t

  • Many blogs that are from our experts on this new release, including Sam Lightstone, Amit Patel, Nancy Hensley, and IBM Champion Iqbal Goralwalla goo.gl/ZgArii
  • A short, information packed interview with Nancy Hensley from TDWI San Diego.  She overviews DB2 with BLU Acceleration at the latest release level, and summarizes Watson news as well. goo.gl/rzGWue
  • For those in the Asia Pacific region in particular, IBM and ERP solution provides Yonyou have announced a strategic collaboration that will bring BLU Acceleration together with the Yonyou NC software. goo.gl/o9cQ5l

  • How can you try the new capabilities? The "Get BLU" section connects you to the DB2 free trial, as well as Analytics Warehouse (based on BLU Acceleration) that is available through the hot new Bluemix platform for assembling cloud-based apps based on a series of plug-in components.  So you can easily add analytics and reporting to the apps you assemble with this platform. goo.gl/doQaLZ

Check it all out, recommend to your colleagues and share on social media! 

The main page is www.ibmbluhub.com .

 

September 25, 2014


ChannelDB2 Videos

The Top Three Reasons DB2 is Best 2014 09 25


Thumbnail

Every organization – current DB2 users and others – is under fire to deliver a flexible, reliable database solution to support business requirements. In sixt...

Dave Beulke

Four Questions Millennials Don’t Want to Answer

When I work with millennials these days in all different management and programming duties, the experience is always very interesting. Each millennial has a very different point of view of IT and data processing. Even within the Big 4 consulting firms’ new hires, the college experience, IT degrees,...

(Read more)
 

September 24, 2014


Willie Favero

Are you ready for Insight 2014? It's almost here...

(Posted Wednesday, September 24, 2014) So, what do you have planned for the week of October 26, 2014?  What ever it is, I hope it also includes being at the Mandalay Bay in Las Vegas, NV for the Insight 2014 (formally know as IOD or Information on Demand Conference (formally know as ...

(Read more)

DB2 Guys

Nothing Endures But Change – Face it With Confidence.

By Radha Gowda Product Marketing Manager, DB2 and related offerings When faced with change, do you share Dilbert’s frustration (take a look at this Dilbert comic and you’ll see what we mean)?  Wait… don’t be fecklessly hopeless yet!  We understand that keeping up with competition and customer expectations in this constantly changing global economy requires […]

Dave Beulke

DB2 10.5 “Cancun Release” Additional Monitoring Capabilities

DB2 10.5 “Cancun Release” was recently released as DB2 LUW Version 10.5 Fix Pak 4. As I wrote about last week, IBM has put a number of impressive features in this new update. Within DB2 10.5 “Cancun Release” Fix Pak 4 there are several new and interesting monitoring elements. These new monitoring...

(Read more)
 

September 23, 2014


Ember Crooks

Tracking Table Activity using Triggers

There are a number of situations in which a DBA may need to deterimine when data in a table is being inserted or changed. The most obvious tool for tracking this may be using the db2 auditing...

...

Triton Consulting

The Top Five Reasons for Choosing Remote Database Support – Cover

#2 Cover In our first blog in this series we looked at how cost is a common factor in bringing in external expertise to assist with database support.  The second reason which we have found to be very common amongst … Continue reading →

(Read more)
 

September 22, 2014


Data and Technology

Managing Application Performance… from a database perspective.

Applications that access databases are only as good as the performance they achieve. And every user wants their software to run as fast as possible. As such, performance tuning and management is one...

(Read more)

Henrik Loeser

Enforce backup encryption with encrlib and encropts

What may sound like sore throat, "encrlib/encropts", in reality is a really useful combination of new configuration parameters for DB2 in the Cancun release. They allow the security administrator...

(Read more)

Craig Mullins

Rules for an Effective DB2 Monitoring Strategy

DB2, and relational databases in general, have a reputation of being (relatively) easy for users to understand; users specify what data to retrieve, not how to retrieve it. The layer of complexity removed for the users, however, had to be relegated elsewhere: to the code of DB2. And that means you sometimes have to dig into technical details of the DB2 optimizer or other arcane details to uncover...

(Read more)
 

September 19, 2014


DB2Night Replays

The DB2Night Show z50: DB2 Buffer Pool Tuning � Get the greatest benefits

Presented by: Joel Goldstein Responsive Systems Company "The DB2Night Show z50: DB2 Buffer Pool Tuning � Get the greatest benefits" Replays available in WMV and M4V formats! 100% of our studio audience learned something! Joel provided an in-depth look at buffer pool tuning with many real world examples. Learn from the master; watch the replay...

(Read more)

Adam Gartenberg

Last Day! Insight (IOD) 2014 Early Bird Registration

Don't forget that early bird registration for Insight 2014 (formerly IOD) ends today. You can register here. ...

(Read more)

Willie Favero

How to stay busy and maintain your skill set

(Posted Wednesday, September 3, 2014) I have found that over the years, some of the best ways for me to keep up with what?s going on in the wonderful world of DB2 for z/OS is teaching DB2 for z/OS (something I stopped doing many years ago when I returned to IBM), presenting at conference...

(Read more)
 

September 18, 2014


Ember Crooks

DB2 Quick Tip: Checking Connection State

Sometimes the connection state is unclear. The following can all make it fuzzy wether or not you have a valid connection: A db2 error or warning related to your connection A system error related to...

...
 

September 17, 2014


Craig Mullins

Plan to Attend IBM Insight 2014

The IBM Insight conference is just around the corner and if you care about DB2, Big Data, Analytics, data warehousing, or really, anything at all about enterprise data, then Las Vegas is the place to be the week of October 26 thru 30, 2014. But what is IBM Insight? Well, you may remember it as the IBM Information on Demand conference, or IOD for short, Yes, IBM has renamed the...

(Read more)
 

September 16, 2014


Adam Gartenberg

Introducing Watson Analytics: Analytics for Everyone

When you've got a new solution being compared to the transformational power of the spreadsheet and the iPhone, you just might be on to something. At its heart, Watson Analytics is designed to let...

(Read more)

Ember Crooks

Example of A Clustering Low-Cardinality Index Helping Query Performance

The request from the developers was something along the lines of “Help, Ember, this query needs to perform better”. Sometimes the query I’m working on is not one that shows up as a...

...

DB2utor

Bind Option Conflicts

Last week I discussed dirty reads and how isolation level (UR) is used to read uncommitted data. In the course of my research for that...

Triton Consulting

Addressing IT skills shortages within Local Authorities

Many local authorities are facing very difficult spending decisions and are dealing with running an IT service which is chronically understaffed in order to meet spending requirements. From working directly with public sector organisations we know how difficult this can … Continue reading...

(Read more)
 

September 15, 2014


Dave Beulke

6 Reason Why DB2 10.5″ Cancun Release” Is So Important

The new DB2 10.5 “Cancun Release” was recently released as DB2 LUW Version 10.5 Fix Pak 4. IBM has done a lot of work and put a number of impressive features in this DB2 LUW Fix Pak 4. All these new DB2 10.5 “Cancun Release” features remove any doubts or restrictions about going to the . . ....

(Read more)

DB2 Guys

Rapid Insight With Results: Harnessing Analytics in the Cloud

By Basiruddin Syed DB2 Social Marketing Manager “It’s Now or Never” is a popular song recorded by Elvis Presley and the lyrics of this song seem to appeal to us now more than ever. Every day we are making decisions in our lives, both personal and financial. We are often seen contemplating which holidays to book, […]

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