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.

 

January 13, 2017


Frank Fillmore

It was 30 years ago today… The Fillmore Group “Founder’s Day” @ffillmorejr @KimMayTFG #IBMAnalytics #IBMz

On Tuesday, January 13, 1987 I sat in the kitchen of my 11 foot wide rowhouse in the Highlandtown section of Baltimore and typed out on a manual typewriter the Articles of Incorporation for The...

(Read more)

DB2Night Replays

The DB2Night Show #188: DB2 LUW Predictive Index Impact Analysis

@srhayes :: @db2performance Special Guest: Scott Hayes, DBI Software Sage DB2 LUW Performance Advice Predictive Index Impact Analysis - Know Before you Create! 100% of our audience learned something! Sage Advice Part 3 - Predictive Index Impact Analysis - Know Before you Create - extends the performance tuning journey that began with Parts 1 and 2. Don't worry if you missed Parts 1 and 2 because they are briefly reviewed during this...

(Read more)
 

January 11, 2017

 

January 10, 2017


Henrik Loeser

DB2 Quiz for the Resource-Minded & IDUG EMEA 2017

Did you know...? I hope you had a good start into 2017. I am already up and running and accomplished some important tasks. I submitted my presentation proposals for the IDUG DB2 Tech Conference 2017...

(Read more)
Big Data University

This Week in Data Science (January 10, 2017)

Hello all! My name is Janice Darling and I will be taking over this column from Cora.
Here is a roundup of the news this week in Data Science and Big Data. IBM Watson Power7

Don’t forget to subscribe to keep up-to-date with developments in Big Data and Data Science!

Interesting Data Science Articles and News

Cool Data Science Videos

The post This Week in Data Science (January 10, 2017) appeared first on Big Data University.


DB2utor

DB2 for z/OS Native RESTful Services in DB2 11 & 12

I’ve previously written about RESTful services, noting how these services will enable data and applications running on DB2 for z/OS to become a strategic component of your enterprise API strategy.
 

January 09, 2017


Craig Mullins

The Tao of DB2 - Part 15: Putting it all together!

We rejoin our soon-to-be-retiring DBA and the intern who is tasked with replacing him as the old DBA continues to teach the young intern about Tao and DB2. "Soon, I will be retiring, and all of this will be yours," said the expert DBA. "Are you ready?" "I am trying my best," said the intern. "Do you have any more advice for me before you go?" "Ahhh... you are wise to ask. Let me again reach...

(Read more)
 

January 06, 2017


DB2 Guys

Network with peers at the Informix Users Group Conference 2017

by Rajesh Govindan, Portfolio Marketing Manager – Informix When we asked David Link from Nebraska what he liked most about the Informix Users Group Conference in 2016, he told us that networking was high on his list. “I had an excellent time,” he said, “The content was great, the people were great, the […]
Jack Vamvas

Methods to find TSAMP error details and return codes

Question: How can I find details about TSAMP (Tivoli System Automation for Multiplatforms) failover details? I discovered that a failover occurred and need, what sources will give me details?

I have a TSA single storage solution in place

Answer: There are multiple methods to extract details about a failover details. If you troubleshooting , it may be necessary to correlate details from different sources.

These sources of information are a good starting point for diagnostics.

/var/ct/IBM.RecoveryRM.log

Linux error logs on /var/logs/messages

          tail -f /var/log/messages

Db2diag log files

Instance_name.nfy file

 

Read More on TSAMP

TSAMP Cheat Sheet for DBA managing DB2 clustering (DBA DB2)

How to customise TSAMP start and stop scripts to make monitoring ...

How to put TSAMP into maintenance mode (DBA DB2)

 

 

 

January 03, 2017


Kim May

IBM DB2 Analytics Accelerator (IDAA) *Free* Hands-On Training Class

DB2 Gold Consultant and IBM Champion Frank C. Fillmore, Jr. will deliver a *free*, hands-on IDAA training class in Baltimore on Monday and Tuesday, February 27th and 28th.  IBM System z customers...

(Read more)

DB2utor

Comparing DB2 12 Function Levels M100 and M500

I was recently reading the DB2 12 for z/OS What’s New guide. It's interesting comparing the features available in the initial Function Level M100 with what you can get when you activate Function Level M500.
 

January 02, 2017

Jack Vamvas

Database Self-Tuning

To get my head back into gear and focused for the New Year , I want to outline some notes on the topic of Database Self Tuning. Database Tuning is all about ensuring service level agreements being met . Database tuning is essential as data sets get bigger with increasing a larger set of access paths to the data.

Following on from my blog post – The future of the SQL Server Performance Tuning Expert , I’ve compiled some notes on Database Self Tuning

Focus is on two aspects

1) What is the current state of Database Self Tuning?

2) How to achieve full automation in the future.

Database Tuning Definition – The sum of all activites completed to make the Database respond within satisfactory levels

Database Tuning focuses on:

1) Throughput

2) Response Time

3) Resource Usage

Example, set some constraint e.g memory (Resource Usage) and improve response time (throughput)

What Database Server components can be tuned?

An example Performance Stack.

CPU Cores

Windows\Linux OS

Database Server

Cache

FC HBA

Fibre Channel Switch

Storage Controller

Storage Controller Cache

Disk

LUN

Database Tuning requires in depth expertise on:

1) Application

2) OS

3) Hardware

4) RDBMS

 

Basic principles of Database Tuning  (Shasha)

1) Think globally, fix locally – Track down bottlecnck and resolve

2) Partitioning breaks bottlecnecks – if step 1 doesn’t fix problem , divide the load over more resources or spread the load over time

3) Try to keep things up and running , avoid restarts

4) Render onto server , what is due onto server. Keep the balance between application and DBMS

Read more on the five basic principles Five Basic Principles according to Shasha

Database Tuning – continuous

1) Identify existing Problem

2) Monitor and define cause (root) of problem

3) Apply changes to problem

4) Problem Solved

5) Repeat

 

Database Tuner needs to manage trade-offs – between benefits and cost.

Hardware Tuning – Kill it with Iron – ROI

 

Read More

Performance Tuning series – Performance Stack

RAID levels overview

SQL Server – tempdb and solid state drives

Database Tuning for complex sql queries (DBA DB2)

 

 


Data and Technology

A Good Start for Your SQL Library

Every professional programmer (and DBA) should have a library of books on SQL fundamentals. There are many SQL titles to choose from, and a lot of them are very good. But you can’t buy them all...

(Read more)
 

December 30, 2016

 

December 27, 2016

Big Data University

This Week in Data Science (December 27, 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

The post This Week in Data Science (December 27, 2016) appeared first on Big Data University.

 

December 22, 2016


Craig Mullins

Happy Holidays 2016

It is that time of year again. When we all take some time to pause and spend time with our family, friends and loved ones. We take time off of work to celebrate and reflect on the past year... and to welcome the new year. No matter what holiday tradition you celebrate, I wish you an enjoyable holiday season. Happy holidays, that is! And we'll meet back here again in January 2017 to talk more...

(Read more)
 

December 21, 2016


Dave Beulke

Black Friday Lessons

In the last blog (found here), I talked about the first five of the top 10 ways that can help make your systems bulletproof for holiday processing for reliability, availability, and scalability demands. This week I continue with reliability, availability, and scalability topics from my technology...

(Read more)
Big Data University

This Week in Data Science (December 20, 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

The post This Week in Data Science (December 20, 2016) appeared first on Big Data University.

 

December 20, 2016


DB2utor

Deprecated Functions: A Primer

When IBM decides to remove a function from DB2 for z/OS (or any DB2 offering), it's generally publicized in in the DB2 for z/OS announcement letter. See the DB2 12 for z/OS announcement letter, for instance.
 

December 16, 2016


Henrik Loeser

New Mod Pack and Fix Pack for DB2 V11 available now

New DB2 Fix Pack and Mod Pack available Over the past years I blogged about new fixpacks and features in DB2. This is the first time I have to mention "Mod Packs" because for DB2 V11 a new Mod Pack...

(Read more)

DB2 Guys

Will you join me at the Informix Users Group Conference 2017?

by Rajesh Govindan, Portfolio Marketing Manager – Informix Are you interested in improving your Informix skills, learning about new features, and networking with others who have encountered –and resolved –the same challenges that you face? Do you want to become professionally certified on Informix or other IBM Analytics products? Would you like to […]
 

December 15, 2016


Craig Mullins

The Tao of DB2 - Part 14: A Short Lesson on Wisdom

After a long day of dealing with problems the DBA and his intern were readying themselves to head home for the evening. The mentor glanced over at his trainee and saw that something was troubling him. "You seem to be troubled," noted the DBA. “I guess so," replied the intern. "We did a lot today, but a lot of our time was consumed answering what seemed to be the same, or at least similar,...

(Read more)
 

December 14, 2016

Big Data University

This Week in Data Science (December 13, 2016)

Here’s this week’s news in Data Science and Big Data. 5g

Don’t forget to subscribe if you find this useful!

Interesting Data Science Articles and News

Upcoming Data Science Events

  • Predictive Analytics Innovation Summit – The Predictive Analytics Innovation Summit, on February 22-23, provides a platform for industry leaders to deliver case studies, expertise and share unique insight into the rapidly emerging movement: the power to forecast the future with today’s data.

The post This Week in Data Science (December 13, 2016) appeared first on Big Data University.

 

December 13, 2016


DB2utor

Monitoring Index Cleanup Threads

I was recently asked about activating a trace that sends information about DB2 11 index cleanup threads to the IBM System Management Facility (SMF).
 

December 12, 2016


Henrik Loeser

SQL Magic in Notebooks in the IBM Data Science Experience

New Notebook in IBM Data Science Experience At the recent IDUG DB2 Tech Conference in Brussels I gave a talk on using Jupyter Notebooks with IBM DB2 or dashDB. For the presentation I used a local...

(Read more)

Scott Hayes

IBM DB2 and SAP - A marriage made in heaven? Or Not?

The following article on DB2 and SAP is contributed by Martin Hubel. IBM is providing DB2 SAP Road Show Briefings THIS WEEK in select cities. Scott Hayes offers his own commentary on DB2 and SAP. Martin Hubel is an IBM DB2 GOLD Consultant and IBM Champion. He is also one of the world's leading top independent DB2 Consultants with respect to DB2 performance. We hope you find his article thought provoking and helpful.

(Read more)
 

December 10, 2016

 

December 09, 2016


Data and Technology

A Useful Guide to Data Fundamentals from Fabian Pascal

Today’s blog post is a quick review of Fabian Pascal’s latest book The DBDEBUNK Guide to Misconceptions and Data Fundamentals. Those of you who know Pascal will know what to expect...

(Read more)

DB2Night Replays

The DB2Night Show #187: FREE Resources to help you succeed with DB2 LUW V11

Follow @upintheairyyz Special Guest: George Baklarz, Program Director, IBM Canada New & Updated FREE Resources to help you succeed with DB2 LUW V11.1 Again, 100% of our audience learned something! When you listen to our replay, take note of the millions of miles that George has flown around the world. While he's on the airplanes, he writes books and develops really cool tools to help learn about DB2. During this show, you'll learn about...

(Read more)

DB2 Guys

Simply Powerful and Flexible – IBM Informix on Cloud

by Pradeep Muthalpuredathe To make sense of the avalanche of data generated today, you will need to put the data to work. The more you do it, the better the outcome. But the cost of storing and managing the data on premise grows very fast along with growing infrastructure and operational cost. Add […]
 

December 07, 2016

Big Data University

New York Data Science Bootcamp And Validated Badges

This post is about our New York Data Science Bootcamp. Interested? Find data science bootcamps in your city.

The Data Science Bootcamp journey for Big Data University started in China back in September. At the time, we were in Bejing for the CDA (Certified Data Analyst) Summit, which had an attendance of more than 3,000 data analysts, data scientists, data engineers, students, and professors. After that, we held a Data Science Bootcamp in Mexico which was a 4-day affair with an attendance of 80 participants in the city of Guadalajara.

New York Data Science BootcampMore recently, IBM’s Big Data University held a four and a half day beginner friendly, hands-on data science bootcamp in New York City. It took place from Tuesday, November 29th to Saturday, December 3rd at the Zicklin School of Business, Baruch College, CUNY.

BDU’s Chief Data Scientist Saeed Aghabozorgi, PhD delivered the Data Science bootcamp with the aid of two fellow BDU data scientists: Candi Halbert and Hima Vasudevan. 45 participants from the corporate and academic world took part in the bootcamp.

We are very grateful for the help and support from Maithily Erande (Lecturer, Marketing Analytics Dept. of Marketing & International Business) in arranging this New York data science bootcamp. (Maithily is an Analytics Expert and a Product Manager/ Vice President for Product Engineering with several Fortune 100 clients including Apple, Microsoft, Dun & Bradstreet, JP Morgan Chase, Cisco, and Sesame Street.)

Introducing Validated Badges

Saeed at the New York Data Science BootcampAt this bootcamp, Saeed gave an overview of data science, Big Data University, an introduction to the R language, data analysis, data visualization, machine learning and working with big data with SparkR. There was also a capstone project which gave participants a hands-on experience on a real-world data science project. For this project, participants used the Data Scientist Workbench, a virtual lab environment which allowed them to perform lab exercises directly from their browsers.

For the first time ever, participants who passed the exam were eligible not only for a certificate but for a Validated Badge as well. This badge is reserved for Big Data University students who pass the test for a course in person (so that we can guarantee that they were the ones who took the exam). These badges, like our regular badges, can be shared with others using social media, on your resume, etc.

We, at BDU, are greatly enjoying these bootcamps. The feedback received so far has been equally enthusiastic. If you are interested in attending future Data Science Bootcamps worldwide, please refer to our Data Science Bootcamps link. We hope to see you there!

The post New York Data Science Bootcamp And Validated Badges appeared first on Big Data University.

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