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 06, 2015


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)
 

July 04, 2015


Willie Favero

IBM webcast on Digital Business

(Posted Saturday, July 4, 2015) The digital age has arrived? Again?. It is far more than anything we?ve ever seen before and makes all other ?digital arrivals? seem pale in comparison. With this arrival corporations could excel or fall into to oblivion depending on how this use and manage the...

(Read more)
 

July 03, 2015


Antonio Cangiano

On Assignment in San Francisco for IBM LEADing to Africa

I’m in San Francisco, but I didn’t bring any flowers for my hair. Chiefly due to the lack of hair. What I brought with me however was a couple of suitcases and a great amount of...

...
 

July 02, 2015


Henrik Loeser

DB2 Battle: Optimization Profile vs. Statement Concentrator (Part 2)

Today I wanted to try out using DB2 optimization profiles for a statement impacted by the statement concentrator. In part 1 I gave the background, showed how I created an optimization profile and...

(Read more)

Henrik Loeser

DB2 Battle: Optimization Profile vs. Statement Concentrator (Part 1)

DB2 explain output Today I wanted to try using a DB2 Optimization Profile for a statement impacted by the DB2 Statement Concentrator. It turned out to be a longer exercise than thought, but also...

(Read more)
 

July 01, 2015


Craig Mullins

Influencing the DB2 Optimizer: Part 1

Today is July 1, 2015 - mid way through the year and the beginning a fresh, new month. With that in mind, I'm kicking off a new series of blog posts here on the various methods of influencing the DB2 Optimizer's access path decisions. The bulk of the material will be excerpted from my book - DB2 Developer's Guide - which just so happens to be on sale for 40% over the 4ht of July holidays at...

(Read more)

Brian Fairchild

Accessing InforCRM control values from Javascript

Often when one needs to access the value set in an HTML control from the client side script it is tempting to reach into the DOM object and retrieve it... READ MORE The post Accessing InforCRM...

...

Ember Crooks

DB2 Basics: Filesystems for DB2 on Unix and Linux Systems

DB2 doesn’t have any defaults for filesystems because that is an OS-level thing. However, there are a few sanity checks and some recommeded separation when installing DB2 on Linux and UNIX...

...

Henrik Loeser

DB2 Battle: Optimization Profile vs. Statement Concentrator (Part 3)

db2expln output - statement concentrator active In February I had fiddled with optimization profiles and REOPT working against the statement concentrator (part 2 is here). Today I wanted to give an...

(Read more)
 

June 30, 2015


Willie Favero

I feel I have to point this out about Partition-by-Growth (PBG) table spaces

(Posted Thursday June 30, 2015) Here?s the situation. You?re running a DB2 COPY utility creating either full or incremental image copy against a partition-by-growth table space. You have specified the keywords SHRLEVEL CHANGE DSNUM ALL.

(Read more)

Brian Fairchild

Before you restore!

There are several times that you may have to restore from a production box to a beta or a QA environment as a different user. In that scenario, the restore... READ MORE The post Before you restore!...

...

Henrik Loeser

DIY: 3D-printing a quadrocopter (or hardware for IoT)

3D-printed quadrocopter/drone Over the weekend I had the opportunity to get deeper into 3D printing. I got invited to Maker World 2015 in Friedrichshafen and to a workshop run by the guys of...

(Read more)
 

June 29, 2015


Willie Favero

These are just so cool: Accelerator-only tables (Recap)

(Posted Thursday June 29, 2015) Over the weekend I published a 4 part series that discussed accelerator-only tables, a new function available to the DB2 Analytics Accelerator that was delivered in the recent release of PTF5. This post is just a recap of the 4 post as links.

(Read more)
 

June 28, 2015


Willie Favero

These are just so cool: Accelerator-only tables (Part 4)

(Posted Thursday June 28, 2015) Today?s post is a bit longer than most that I publish and it's in multiple parts; make sure you catch them all. Considering I spend just about all my time performing performance measurements with the Accelerator, with most of those measurements usually around...

(Read more)

Willie Favero

These are just so cool: Accelerator-only tables (Part 3)

(Posted Thursday June 28, 2015) Today?s post is a bit longer than most that I publish and it's in multiple parts; make sure you catch them all. Considering I spend just about all my time performing performance measurements with the Accelerator, with most of those measurements usually around...

(Read more)
 

June 27, 2015


DB2Night Replays

The DB2Night Show #Z61: DB2 in the Digital Age

Presented by: Sheryl Larsen Sr. DB2 Product – Specialist, BMC Software "The DB2Night Show z61: DB2 in the Digital Age" Replays available in WMV and M4V formats! 90% of our studio audience learned something!Sheryl took a look into the future of technology and DB2's role. Watch the replay...

(Read more)

Willie Favero

These are just so cool: Accelerator-only tables (Part 2)

(Posted Thursday June 27, 2015) Today?s post is a bit longer than most that I publish, more the length of an article. For that reason I have broken it down into 4 parts with each part covering a different aspect of accelerator-only tables; this is Part 2. Since I spend just about all my time...

(Read more)

Willie Favero

These are just so cool: Accelerator-only tables (Part 1)

(Posted Thursday June 27, 2015) Today?s post is a bit longer than most that I publish, more the length of an article. For that reason I have broken it down into 4 parts with each part covering a different aspect of accelerator-only tables; this is Part 1. Since I spend just about all my time...

(Read more)
 

June 26, 2015


Willie Favero

June 20, 2015 DB2 for z/OS Product Publication updates for DB2 11 and DB2 10

(Posted Friday June 26, 2015) June 20, 2015 sees another major update of a large number of the DB2 for z/OS product publication. Updates for DB2 11 and DB2 10 are now available. Things are now back to usual with all supported version having their publications updated at the same time. This is...

(Read more)
 

June 25, 2015


Brian Fairchild

Unspecified Error logging into Infor CRM / SalesLogix

If you’ve worked with Infor CRM / SalesLogix for a while, you’ve probably run into the issue where you enter your username and password (correctly!) and all you get is... READ MORE The...

...
 

June 24, 2015


Data and Technology

A Few Database/DBMS Definitions

Just a quick post today to inform my readers of several technical definitions that I have written for TechTarget’s WhatIs? site. If you are not familiar with that site, click on the link and...

(Read more)

Ember Crooks

Multiple Index Regression Analysis

I actually had a blog entry started on this topic before IDUG. I knew this was possible, but not exactly how to do it. Then I sat in Scott Hayes’ session – D04 – More Sage Advice:...

...
 

June 23, 2015


Brian Fairchild

What are Page Splits?

Are you noticing a drop in performance? Are you seeing a large percentage of index fragmentation? If your data page fill factor value set to a high number, page splits... READ MORE The post What...

...

Brian Fairchild

How to extract data using db2audit

One of our customers recently wanted to extract data using db2audit, but the documentation on this topic is very limited and scarce. Moreover, the commands have changed after V9.7 and... READ...

...
 

June 22, 2015


Craig Mullins

The DBMS Market Circa 2015

Today's blog post is to call attention to a series of articles and product overviews I have been writing for the TechTarget SearchDataManagement portal on Database Management Systems (DBMS). Firstly, I wrote a 7 part series of articles reviewing the DBMS technology circa 2015. This series spans relational, NoSQL and in-memory database technology and here are the links to each of the seven...

(Read more)

Brian Fairchild

Conditional styling of InforCRM grid with onStyleRow

This is a very common request – the customer wants to see some rows highlighted in the data grid based on the data.  For example, they might want to see... READ MORE The post Conditional...

...

Brian Fairchild

Logging into the Infor CRM Mobile Client with an iPhone / iPad

We’re often asked, why can’t I login to the Infor CRM (SalesLogix) mobile client using my iPhone / iPad? Here are some common things to check on your device: 1) Click... READ MORE The...

...
 

June 21, 2015


Frank Fillmore

IBM DB2 Analytics Accelerator v4 PTF 5 Enhancements #IDAA #IBMz

Abstract: An update on the latest IBM DB2 Analytic Accelerator (IDAA) PTF released in May, 2015. This PTF delivers new functionality to extend IDAA utilization for DB2 for z/OS users including:...

(Read more)
 

June 19, 2015


DB2Night Replays

The DB2Night Show #160: Top 10 DB2 LUW Explain Tips with John Hornibrook

Special Guest: John Hornibrook, STSM, IBM Canada Top 10 DB2 LUW Explain Tips 100% of our audience learned something! John Hornibrook is one of the top IBM brains behind DB2's optimizer. In this helpful presentation, John shares some invaluable tips for using and understanding DB2's Explain capabilities. You will learn the best ways to create Explain tables, upgrade them, and empty them, how to see actual cardinality values, how to determine...

(Read more)

Leons Petrazickis

#DUTO2015 conference

I’m at the Data Unconference in Toronto today. Jarred Gaertner just gave a through-provoking keynote on the ethics of big data, and I’m about to dig my hands into some open data sets in...

(Read more)

Robert Catterall

Are You Using DB2 for z/OS Real-Time Statistics? DB2 Is

DB2 for z/OS is making increased use of the information that it keeps in the real-time statistics tables in the DB2 catalog. You should be doing likewise. Read on to learn more. For a long time, the only statistics to be found in DB2 "system" tables were those generated through execution of the RUNSTATS utility. Starting with DB2 Version 7 (around the 2000 time frame), DB2 could automatically and periodically (every 30 minutes, by default) write a variety of statistics about table spaces and...

(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