Articles & Content

Planet DB2

planetDB2 is an aggregator of blogs about the IBM DB2 database server

Note: The content of this blog is the opinion and thoughts of the blogger and does not necessarily represent the opinions of IDUG.

 

 
How IBM Watson made a delicious BBQ Sauce
Scale out your existing MySQL landscape with ScalebaseIn a nut shell, scalebase is to mysql what greenplum db is to postgresql, it makes it possible to create an MPP database based on mysql. You can use it to scale out your existing "mysql applications"... ...
filter — Selective AggregatesThe filter clause extends aggregate functions (sum, avg, count, ...) by an additional where clause. The result of the aggregate is built from only the rows that satisfy the additional where... ...
DB2 for z/OS: When Did You Last Check Your Checkpoint Frequency?I have written in this blog a few entries about various DB2 for z/OS ZPARM parameters, including a post on DSMAX and another on EDM_SKELETON_POOL. Time for another such entry, this time focused on... ...
DB2 Direct: A new way of consuming your Databaseby Phillip Downey, WW program Director, IBM Analytics Platform Hybrid Cloud Strategy In DB2 11.1, we introduced two new and easy to consume DB2 Direct editions: DB2 Direct Advanced and DB2 Direct... ...
Using Trusted Context on a Local ConnectionBack in August 2011, I wrote about the use of roles and trusted context in auditing DBA activity. Just recently two separate customers have asked me about how and when to use this. Given that --... ...
This Week in Data Science (May 24, 2016)Here's this week's news in Data Science and Big Data. Don't forget to subscribe if you find this useful! Interesting Data Science Articles and News Building The Big Data Platform for Your Smart City... ...
How to put TSAMP into maintenance modeA common problem for managing TSMAMP DB2 high availability is how to deal with non DB2 maintenance. An example is OS patching. Let's say there is a 2 node clustering architecture set up. The OS... ...
The DB2Night Show #Z70: Advanced and Complex SQL RefresherPresented by: Sheryl LarsenSr. DB2 Product -- Specialist, BMC Software "The DB2Night Show z70: Advanced and Complex SQL Refresher" Replays available in WMV and M4V formats!98% of our... ...
Learn from Everyone’s Sessions at IDUGAnother IDUG conference is coming up, and the agenda of presentations looks great. The IDUG conference planning Committee always does a great job, and the agenda shows many extra educational... ...