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.

 

April 24, 2015


Leons Petrazickis

Dockerize all the things

As my team creates new web apps and microservices in Rails, Meteor JS, and other stacks, we dockerize them. Docker is great because it enforces loose coupling, modular design, and process isolation....

(Read more)

DB2Night Replays

The DB2Night Show z57: IDAA - More Than Just Query Acceleration

Presented by: Peter Bendel IBM SVL "The DB2Night Show z57: IBM DB2 Analytics Accelerator for z/OS - More Than Just Query Acceleration" Replays available in WMV and M4V formats! 100% of our studio audience learned something!Peter insight into the many new features of the IBM DB2 Analytics Accelerator. Watch the replay...

(Read more)
 

April 23, 2015


Robert Catterall

A DB2 11 for z/OS Temporal Data Enhancement You Might Have Missed

When DB2 10 for z/OS introduced temporal data functionality about five years ago, one of the first use cases that jumped to mind for many people was data-change auditing: a table could be created with (or an existing table altered to add) the "system time" characteristic, and thereafter one would have, in the history table associated with the base table, a record of row changes resulting from UPDATE and DELETE statements targeting the base table. That's nice, but suppose you want to see more...

(Read more)

DB2Night Show News

It pays to learn DB2 on The DB2Night Show - we just stimulated the economy!

Congratulations again to Joyce Danielle, Stella Keesling, Peter Schuetze, Jeff Agosta, Kapil Mathur, Deborah Gresham, Joshi Jayesh, Michael High, Larry Danley, Divesh Kumar, Louis Brendemuehl, and...

...
 

April 21, 2015


Craig Mullins

SQL Performance Basics: Part 7, Embed the SQL Directly Into Your Programs

You may recall that this is a subject I've written about before, but I think it is important enough to warrant covering briefly in this series on SQL performance basics... and that is, you should avoid black boxes if you want to optimize your applications. So what is a black box? Simply stated, a black box is a database access routine that sits in between your application programs and DB2....

(Read more)

Henrik Loeser

My 10 Minute DB2 App on Bluemix

I needed some fun at the end of the workday today. Why not enhance my own skills, do some "coding", and try out Node-RED on Bluemix again (I performed a "phoney" test in October already). This time,...

(Read more)

Ember Crooks

The Excitement of the IDUG North American Technical Conference – 2015

My favorite week of the year is the IDUG North American Technical Conference. It’s better than Christmas if you ask me. I get to see my DB2 family and learn all kinds of new stuff. I come away...

...
 

April 20, 2015


DB2Night Replays

The DB2Night Show #156: Using and Optimizing DataStage and DB2

@globomike Special Guest: Michael TiefenbacherManager Business Services & Data Management Specialist at ids-System Using and Optimizing DataStage and DB2 100% of our audience learned something! DataStage is a very popular ETL tool that is used with IBM DB2 LUW. Michael offered some very valuable advice on how to maximize performance in DPF and non-DPF environments. Enjoy the replay ...

(Read more)
 

April 16, 2015


Craig Mullins

SQL Performance Basics: Part 6, Code Relationally... or Avoid the Flat-File Mentality

Another pervasive problem permeating the DB2 development community -- and indeed for most relational DBMSes -- is the “flat file” development mentality. What I mean by this is, when a programmer tries to access data in a relational database the same way that he would access data from a flat file.  DB2 is ‘relational’ in nature and, as such, operates on data a set-at-a-time, instead of the...

(Read more)
 

April 15, 2015


Henrik Loeser

German DB2 User Group (DeDUG), 08.05., with/mit Leo Martin (ex-BND)

(in German because of German User Group) Das nächste Treffen der deutschen DB2 User Group (DeDUG) findet am 08. Mai bei IBM in Ehningen  statt. Auf der Agenda stehen neben interessanten DB2-Themen...

(Read more)

ChannelDB2 Videos

DB2 Tips n Tricks Part 58 - How To Find Indexes used by Query without getting Explain Plan


Thumbnail

How To Find Indexes used by Query without getting Explain Plan Solution: Use MON_GET_SECTION_OBJECT Routine No Need of Explain Tables and Format Explain Outp...
 

April 14, 2015


Leons Petrazickis

Unix command of the day: watch

The project I’m working on right now involve not just Dockerized Rails microservices, Meteor JS, and a data set measured in tens of terabytes, but also a big Bash code base. Bash is a language...

(Read more)

ChannelDB2 Videos

Data Server Manager: Beyond real-time DB2 monitoring and administration


Thumbnail

IBM Data Server Manager is a new, integrated tool for managing performance and administering DB2 for Linux, UNIX, and Windows. Unlock the enterprise features by adding a data repository that lets you monitor historical metrics for SQL statements, database access patterns, storage optimization, monitor and manage client applications, and more.

For more information and download:
IBM Data Server Manager Community: https://ibm.biz/dataservermanager

ChannelDB2 Videos

Data Server Manager: Light-weight real time DB2 administration and performance monitoring


Thumbnail

IBM Data Server Manager is a new, integrated tool for managing performance and administering DB2 for Linux, UNIX, and Windows. Explore the lightweight option for real-time monitoring and administration with auto-discovery of databases, at-a-glance health view of all your databases, detailed single database monitoring, and more.

For more information and download:
IBM Data Server Manager Community: https://ibm.biz/dataservermanager

ChannelDB2 Videos

Data Server Manager: Up and running


Thumbnail

IBM Data Server Manager is a new, integrated tool for managing performance and administering DB2 for Linux, UNIX, and Windows. See how you can set up the product in three short steps and start exploring the web console in just a few minutes.

Resources:
Data Server Manager Community: https://ibm.biz/dataservermanager

Ember Crooks

A Few Scripting Basics with DB2 and PowerShell

Not long ago, I posted some of the details of using PowerShell as your command line for DB2 on Windows. I am definitely addicted to PowerShell as my command line when I have to work on Windows...

...
 

April 11, 2015


Craig Mullins

SQL Performance Basics: Part 5, Avoid Sorting

Sorting is a very costly operation that you should strive to avoid if at all possible. Indexes are very useful for this purpose. DB2 can choose to use an available index to satisfy the sorting requirements of an ORDER BY, GROUP BY, or DISTINCT clause. Therefore, it can be beneficial to create indexes that correspond to these clauses for frequently executed SQL statements. For example,...

(Read more)

Data and Technology

A Brief Introduction to Data Normalization

Normalization is a series of steps followed to obtain a database design that allows for efficient access and storage of data in a relational database. These steps reduce data redundancy and the...

(Read more)
 

April 10, 2015


Willie Favero

April 2015 (RSU1503) service package has been tested and is now available

(Posted Friday April 10, 2015) Testing for RSU service package RSU1503 is now complete. This April 3, 2015 1st Quarter "1st Quarter Quarterly Report" (104 KB PDF file) contains ALL service through the end of December 2014 not already marked RSU. This service also includes PE resolution and...

(Read more)

DB2Night Replays

The DB2Night Show #155: All About IDUG & DB2's GOT TALENT 2015 Winners!

All About IDUG PhiladelphiaDB2's GOT TALENT 2015 Winners! IDUG Philadelphia 2015 - Get the Insiders Scoop! 100% of our studio audience learned something! IDUG Volunteers Terry Johnson, Conference Chair, and Steve Rosenberger, Thread Chair, shared with us great information about the upcoming IDUG Conference in Philadelphia! Learn about SIGs, Networking Events, Keynotes, Vendors, Receptions, Hands on Labs, Ed Seminars, and the most robust...

(Read more)
 

April 09, 2015


Willie Favero

IBM has some smart, new television ads

(Posted Thursday April 9, 2015) This week during the television broadcast of the Masters Golf Tournament (Apr 8-12), we will be running a bunch of new ads showing how IBM is helping the world to run smarter. These are some very nicely done ads and are actually fun to watch. Yes, I know I am a...

(Read more)
 

April 08, 2015


DB2Night Show News

10 APR 2015 10am CDT: All About IDUG & DB2's GOT TALENT Winners!

Update! 999 votes cast! Find out who won DB2's GOT TALENT 2015! Get the inside scoop and latest news about IDUG NA Philadelphia May 4-8, plus we'll be announcing our 2015 DB2's GOT TALENT...

...

Dave Beulke

Vital Java DB2 SQL Performance Considerations

Since Java is the new main development language for most companies it is vital that all the programmers know the best DB2 Java performance properties and considerations. During system and application Java performance reviews there are many factors that come up that impact performance. Below are...

(Read more)
 

April 07, 2015


Craig Mullins

SQL Performance Basics: Part 4, The Order of Predicates

Did you know that the order in which you code your predicates can have an impact on query performance? It is usually a minimal impact, but it may buy you a couple of microseconds for a very performance-critical query. In order to use predicate ordering to your advantage however, you  need to be armed with some basic information on how DB2 evaluates predicates as...

(Read more)

ChannelDB2 Videos

DB2 Tips n Tricks Part 57 - How to Catch specific Error Code using db2pdcfg Utility


Thumbnail

How to Catch specific Error Code using db2pdcfg Utility Solution: Use db2pdcfg -catch option and db2cos.sh call out script. Happy Learning & Sharing

Ember Crooks

DB2 Workload Manager (WLM) as a Monitoring Solution– Analyzing WLM Information (Part 3 of 3)

This is part three of a three part series. The full series includes: DB2 Workload Manager (WLM) as a Monitoring Solution – Understanding WLM (Part1 of 3) DB2 Workload Manager (WLM) as a Monitoring...

...
 

April 05, 2015


Willie Favero

Why don't you blog that often anymore?

(Posted Sunday April 5, 2015) "Why don?t you blog that often anymore?" Good question and one that is both difficult and easy to answer. Let me explain. When I first started my blog there were basically two of us; Chris Eaton?s LUW blog and my DB2 for z/OS blog. In fact, it was Chris that first...

(Read more)
 

April 02, 2015


Henrik Loeser

db2audit & syslog: Who Stole my Chocolate Easter Eggs?

Security Audit Easter is coming up, a slow day due to vacation and Spring Break, time to try out some, in advance, of the chocolate Easter eggs. Gosh! They are gone! Who took them? It must have been...

(Read more)
 

April 01, 2015


Craig Mullins

SQL Performance Basics: Part 3, Eliminating Predicates?

It is technically possible to learn how to write SQL statements without having an in-depth knowledge of the data. However, the better you know your data, the better your application performance will be. Let's look at a simple example. By reducing the number of predicates on your SQL statements you may be able to  achieve better performance by: Reducing BIND (and REBIND) time...

(Read more)

Ember Crooks

The Coming pureScale Invasion

I’ve thought for a long time that one of the biggest issues that IBM has faced in getting more traction with pureScale is that it’s only included in the Advanced editions of DB2...

...
 

March 31, 2015


Robert Catterall

The DB2-Managed Data Archiving Feature of DB2 11 for z/OS

Over the past year and a half, I have been talking to lots of people about DB2 11 for z/OS. In the course of these discussions and presentations, I've noticed something interesting pertaining to the DB2-managed data archiving capability delivered with this latest release of the DBMS: a) it is one of the more misunderstood features of DB2 11, and b) when people do understand what DB2-managed archiving is about, it becomes one of the DB2 11 features about which they are most enthusiastic. If you...

(Read more)
 

March 30, 2015

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