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.

 

July 28, 2015


Frank Fillmore

IBM Data Retrieval Technologies: #RDBMS, #BLU, #Netezza and #Hadoop

In this session I described and compared the four distinct data retrieval technologies available from IBM. Choices are good to have, but how do you choose which technology to apply to a particular...

(Read more)

Ember Crooks

Calculating PVUs for IBM DB2 on Linux

DBAs do not have to calculate PVUs often. Many times there is a system administrator or someone else who might do this for us. Or if you’re buying everything from IBM, then they’re likely...

...

Willie Favero

A poll about the use of a DB2 CHAR data type

(Posted Tuesday, July 28, 2015) You all have always been very helpful to me in the past when I have been trying to track down information. Well, today I am asking for that assistance once again. I have a polling question about how a certain column type in a DB2 table is being used. I am...

(Read more)
 

July 27, 2015


Data and Technology

Optimizing Database Performance, Part 1: Partitioning and Indexing

Today’s post is the start of a three-part series offering up an overview of the most important components of database performance that must be monitored and managed for any database...

(Read more)
 

July 24, 2015


ChannelDB2 Videos

DB2 Tips n Tricks Part 67 - How to change from BACKUP PENDING to NORMAL State asap


Thumbnail

How to change from BACKUP PENDING to NORMAL State asap Solution: Use Backup dbname online to /dev/null Happy Learning & Sharing
 

July 23, 2015


Philip Nelson

Eclipse Orion : Is This The Future of Development ?

In the last week I've been discovering Eclipse Orion, a browser based development environment. And I've been pleasantly surprised ...
 

July 22, 2015


ChannelDB2 Videos

IBM Data Retrieval Technologies RDBMS, BLU, IBM Netezza and Hadoop 2015 07 21


Thumbnail

IBM offers four distinct data retrieval technologies: the traditional RDBMS, which primarily relies on indexes to speed access; the new BLU Acceleration colu...

Dave Beulke

More DB2 Family Security Best Practices Part 3

As I started Part 3 of this DB2 Family Security Best Practices blog, I was notified that my personal information was hacked again. That is five different times my information has been taken. So I offer this third installment on database security that will hopefully help every company secure their...

(Read more)
 

July 21, 2015


Craig Mullins

Influencing the DB2 Optimizer: Part 4 - OPTIMIZE FOR n ROWS

In the first installments of this series of posts on ways to influence the DB2 optimizer we looked at standard methods like RUNSTATS and SQL tweaking techniques. Today, we will look at yet another method of influencing access path selection: specifying the OPTIMIZE FOR n ROWS for a SELECTstatement.  This clause enables programmers to specify the estimated maximum number of rows that...

(Read more)

Frank Fillmore

IBM Hybrid Transaction/Analytic Processing #HTAP #IDAA #BLU #IBMz Webinar Materials

The concept of Hybrid Transaction/Analytic Processing was coined by Gartner. IBM implements HTAP in two ways: – IBM DB2 Analytics Accelerator (IDAA) for DB2 for z/OS data (using Netezza hardware) –...

(Read more)

Ember Crooks

Analyzing Package Cache Size

Note: updated 7/21 to reflect location of the package cache high water mark in the MON_GET* table functions I have long been a fan of a smaller package cache size, particularly for transaction...

...
 

July 20, 2015


Henrik Loeser

Bluemix: Simple cron-like service for my Python code

Schedule background tasks in Bluemix This morning I had some time to fiddle around with Bluemix and Python. I wanted to test out creating a cron-like service, i.e., something that runs in the...

(Read more)

Brian Fairchild

Profiling Data with SSIS

SQL Server Integration Services offers a useful tool to analyze data before you bring it into your Data Warehouse.  The Profile Task will store the analysis in an XML file,... READ MORE The post...

...
 

July 18, 2015


Willie Favero

Updated DB2 11 & DB2 10 Diagnostics Guide and Reference are now

(Posted Saturday, July 18, 2015) If you have a product license for DB2 11 for z/OS or DB2 10 for z/OS, it?s time to get your updated copy of the Diagnosis Guide and Reference. They have just been updated (July 2015).

(Read more)
 

July 17, 2015


Willie Favero

Happy Anniversary to my DB2 for z/OS blog

(Posted Saturday, July 18, 2015) Happy Anniversary to my DB2 for z/OS blog. You turn 10 years old today. Like being a Father and Grandfather did to me, now my blog is starting to make me feel old. Of course, the cool part about the blog turning 10 years old, it reminds me that this blog...

(Read more)

Henrik Loeser

DB2 Encryption: Some rotation before the weekend

Some bits on encryption... Some while ago I wrote about DB2 encryption and how to rotate the master key. Well, today I rotated the master key again and looked at the metadata before and after the...

(Read more)
 

July 16, 2015


Data and Technology

You Can’t Force Data Quality

How many times have you surfed the Web only to encounter a form that requests a slew of personal information before you are permitted to go any further? You know what I’m talking about. A company...

(Read more)

Craig Mullins

Influencing the DB2 Optimizer: Part 3 - Tweaking SQL Statements

In Part 2 of this series we took a look at standard methods of influencing the DB2 optimizer, essentially boiling down to running RUNSTATS, reorganizing, encouraging parallelism and indexing. But sometimes you may not want to change the DB2 Catalog statistics (or use hints, which we will cover later in this series). In such situations, you might consider tweaking the offending SQL statement....

(Read more)

Brian Fairchild

Managing DB2 Transaction Log Files

Logging method There are two methods of logging that DB2 supports: Circular and Archive. Other RDBMSes have similar modes. Circular The default that DB2 uses if you don’t change anything... ...

...
 

July 15, 2015


Willie Favero

"Moving data off z Systems costs millions" - a Guest Blog Post

(Posted Saturday, July 15, 2015) You?re in for a bit of a treat today along with something a little different. For today?s post, we are going to have a true expert joining us as our ?Guest Blogger?. During a recent presentation, I was made aware of a very well written paper discussing the cost...

(Read more)

Ember Crooks

Architecting High-Availability and Disaster Recovery Solutions with DB2

NOTE: Please do not attempt to architect a high-availability solution without a DB2 expert involved. There are many questions and answers needed beyond those here to make the best decision and ask...

...
 

July 13, 2015


ChannelDB2 Videos

DB2 Tips n Tricks Part 66 - Regular Restore of 32 BIT DB into 64 BIT Instance not possible


Thumbnail

How Regular Restore of 32 BIT DB into 64 BIT Instance is not possible Solution: Use Redirected Restore or specify ON Clause during Restore Happy Learning & S...

Triton Consulting

How to handle the Mainframe skills gap

It has been an interesting 12 months in the Mainframe world. 2014 saw IBM celebrating 50 years of the Mainframe and in January this year the latest incarnation of the Mainframe – the z13 was launched. Propelling Mainframe back into … Continue reading →

(Read more)
 

July 11, 2015


Robert Catterall

How Will You Use DB2 for z/OS Global Variables?

About seven years ago, in an entry posted to the blog I maintained while working as an independent DB2 consultant (prior to rejoining IBM), I wrote of the evolution of DB2 for z/OS SQL from merely a data manipulation language to a programming language. That evolution continues with DB2 Version 11, in part through the introduction in that DB2 release of global variable functionality. If you want to know more about this new application enabling feature of DB2 for z/OS, read on. As SQL (in a DB2...

(Read more)
 

July 08, 2015


ChannelDB2 Videos

DB2 Tips n Tricks Part 65 - How Load Utility uses Huge Transaction Log Space


Thumbnail

How Load Utility consumes Huge Transactional Log Space Solution: LOAD using valid Data Sets without redundant records Increase LOG SECOND DB CFG parameter IM...

Craig Mullins

Influencing the DB2 Optimizer: Part 2 - Standard Methods

Last week, in Part 1 of this series, we introduced the concept and the 5 high-level methods of influencing the DB2 optimizer's access path choices. In today's post, we will tackle the first approach, which is using standard, DB2-based methods. Of all the methods for influencing the DB2 optimizer, standard DB2 methods are the only mandatory ones. Try all the standard methods covered in this...

(Read more)
 

July 07, 2015


Brian Fairchild

Stopping DB2 Processes for a DB2 Fix Pack Upgrade

When upgrading DB2 fix packs, you need to make sure that all DB2 related processes have been shut down clean. In normal circumstances, you would: db2stop (if that does not... READ MORE The post...

...
 

July 06, 2015


Willie Favero

Red Alert: For DB2 V10 and DB2 V11 users (2015.07.06)

(Posted Monday, July 6, 2015) It appears that in rare situations the DB2 log records could be written with invalid control information, not a good thing. A ?Red Alert? was put out today by the Red Alert subscription service for zSeries to warn customers of this serious situation. This is a...

(Read more)

Brian Fairchild

Move data from a custom module when converting a lead in SugarCRM

In SugarCRM a Lead Conversion will not handle data from a custom module. Converting a lead that has data associated to it in a custom module will cause the data... READ MORE The post Move data from...

...

Triton Consulting

Flexible Resourcing

Flexible IT resourcing can mean different things to different people.  It could be that your organisation needs access to extra IT skills quickly or on a short-term basis to plug a gap in the team due to unexpected leave.  Perhaps … Continue reading →

(Read more)
 

July 05, 2015


Willie Favero

DB2 11 for z/OS now has accelerator-only table functionality

() Have you ever noticed that sometimes you make a statement, and no sooner is it made something comes along and negates it? Then you have to write a new blog post explaining why the first thing you said is no longer true. That is exactly what happened to me the last week. Despite my best...

(Read more)

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