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.

 

March 27, 2015


DB2Night Replays

The DB2Night Show #154: DB2's GOT TALENT - Grand Finale!

DB2's GOT TALENT 2015GRAND FINALE! Top 5 Finalists Compete for YOUR Votes!Great DB2 LUW presentations! 100% of our studio audience learned something! Today's presentations included topics on tuning production DB2 LUW Databases (Challenges and Solutions), Getting Connections to DB2 databases in restricted intranets (tunneling in secure environments), Pursuit of Happiness- Achieving Performance beyond SLAs, and "db2pd" - more than just problem...

(Read more)
 

March 26, 2015


Data and Technology

Everyone in IT Should Serve A Mainframe Tour of Duty

Today’s post is an update on a post I first wrote 10 years ago on my DB2portal blog. The general idea is that everybody in IT would be well-served by learning about mainframes and their robust...

(Read more)
 

March 25, 2015


Scott Hayes

Press Release: PrimeSource Building Products runs SAP on DB2 LUW 4X Faster

DBI Software's pureFeat™ Tools for DB2® Empower PrimeSource Building Products SAP® Database to Run Four Times Faster---In Less than 24 Hours Thanks to DBI Software, PrimeSource Building Products foregoes hundreds of thousands of dollars in CPUs, memory, and licenses while ADDING its Canadian data and users to its SAP DB2 database Austin, TX USA (March 26, 2015): Dallas-based PrimeSource Building Products, one of the largest ...

(Read more)

Peggy Zagelow

Sample files for text analytics tutorial

We are often asked where to find the sample files for our text analytics tutorial.   It's a small set of IBM quarterly reports.  I've uploaded them here , just click on that to download them.  Happy coding!! 

(Read more)
 

March 24, 2015


Craig Mullins

Time to Start Your IDUG in Philadelphia Planning

Spring is in the air... well, at least it is South of the Mason-Dixon line... and that means it is time to plan your trip to this year's IDUG North American DB2 Tech Conference. Anybody who has ever attended an IDUG conference knows about all of the good things you can expect to encounter, experience and learn at the event. That includes technical session on all of the latest and greatest DB2...

(Read more)

Ember Crooks

Giving Automatic Maintenance a Fair Try

I’m a control freak. I think that control freaks tend to make good DBAs as long as they don’t take it too far. My position for years has been that I would rather control my runstats,...

...
 

March 23, 2015


DB2Night Show News

27 MAR 2015 10am CDT: DB2's GOT TALENT Grand Finale - What will you learn?

The international Olympics of DB2 continue Friday 27 MAR 2015 10am CDT with our Top 5 Finalist Contestants competing for YOUR votes! Have you registered yet? Here's what you will learn...

...
 

March 21, 2015


Robert Catterall

DB2 for z/OS: Non-Disruptively Altering a Native SQL Procedure

Not long ago, I was contacted by a DB2 for z/OS DBA who wanted to run a situation by me. On one of his organizations' mainframe DB2 systems -- a system with very high transaction volumes and very stringent application availability requirements -- there was a native SQL procedure for which the ASUTIME specification had to be changed. The DBA wanted to see if I could help him to find a non-disruptive way to effect this stored procedure modification. [Background: a native SQL procedure is a DB2...

(Read more)
 

March 20, 2015


DB2Night Replays

The DB2Night Show #153: DB2's GOT TALENT - Finals Round 3 - Top 6 Compete!

DB2's GOT TALENT 2015Finals Round #3 Top 6 Finalists Compete for YOUR Votes!Great DB2 LUW presentations! 100% of our studio audience learned something! Today's presentations included topics on IBM DB2 LUW Oracle Compatibility, scheduling db2top via crontab, monitoring enhancements for BLU columnar tables, lessons learned on defining disk storage, where to get, and how to install, free drivers for DB2 10.5 Express-C, and how to connect Java...

(Read more)

Data Studio Team

Make The Most of Your Investment: Introducing IBM Data Server Manager

In today's economy doing more with less is imperative.  You want to get the most out of your DB2 investment because your enterprise depends on it.  IBM Data Server Manager is a simple, scalable and smart solution to administer, monitor, manage and optimize performance for DB2 for Linux, UNIX and Windows databases across the enterprise.  Let's take a look at the different facets of where IBM Data Server Manager can empower you to do more.
 
Let's start with performance.  Think about all those many times where you were responsible for diagnosing and troubleshooting a performance problem.  There are many factors that you need to consider in order to find out the root cause of performance problems like CPU time, constrained network, data skew, poor statistics and many more.. Solving database performance problems in a multi-tiered environment can be very daunting to say the least.  It's good to know that IBM Data Server Manager is there to help by providing access to real time and historical performance data, capability to identify potential data access bottlenecks, comparing SQL performance over time, and even get alerted of emergent issues using proactive alerts.  
 
Let's now look at query tuning.  Use the query tuning capabilities and let all the built in advisors and statistics make recommendations on how to fix poorly performing queries.  Don't know where you can take advantage of BLU Acceleraiton yet?  With IBM Data Server Manager you can get recommendations on what tables will get the most benefit if you convert to BLU...This means you can spend less time wondering where BLU would be of value and more time implementing the next generation of in memory computing for DB2.  
 
Having troubles identifying all the different clients that are connecting to your database server?  Let IBM Data Server Manager help you control what those clients are doing and even take an inventory of different connection properties from one central location so that you can control how they should be set.  You can also control memory management and let the tool advise you on where to take advantage of adaptive compression in DB2 10.5.  
 
From a database administration capability IBM Data Server Manager is there to help the novice user run various utilities against DB2 like setting up BLU tables, but it also helps the non-DBA user to do things like edit and run SQL statements with help using content assist.  Other areas of interest for the DBA are catalog navigation, object management, privilege management, maintenance and availability management.  
 
Think about all of these capabilities contained in one product.  IBM Data Server Manager provides a simple quick and easy install and simplified user experience with an integrated web console.  Look at real time and historical metrics that can scale to 100's of databases in your enterprise.  Use the smart alerts in IBM Data Server Manager to optimize query performance and give guided problem diagnosis and workflow analysis from investigation to action. 
 
In order to be the most efficient out there you want to stay ahead of your competition by being more lean and fit.  DB2 database software already leads the way in terms of performance, scale and reliability.  Let IBM Data Server Manager help you make the most out of your database investment allowing you to increase SLA attainment, reduce IT costs and align with business priorities.
 

DB2 Guys

Top ten reasons to love IBM Data Server Manager

By Radha Gowda DB2 and PureData Sales Enablement & Product Marketing Manager Today many in-house or multi-vendor data management tools lack end-to-end visibility, usability and scalability. Database administrators often struggle to keep workflows and analytics operating at optimum efficiency and are unable to provide the continuous availability needed for ever-increasing transaction volumes. By effectively integrating […]
 

March 19, 2015


Data and Technology

Avoiding Deadly DBA Habits

Every now and then I’ll write a short blog post to promote an article that I think is worth reading. This is one of those posts… Today’s article worth reading is titled The Seven...

(Read more)

Ember Crooks

How to Connect to a Local DB2 Database Without Specifying a Password in PowerShell

One of the awesome things about running scripts locally on a DB2 server is that if they’re run as a privileged user, you do not have to specify the password. This makes for easier scripting...

...
 

March 18, 2015


Dave Beulke

DB2 SQL Security Audits

With the all the hacking stories getting a lot of news coverage, security of your DB2 system is paramount. Doing a DB2 SQL security audit periodically or before your DB2 migration has been a standard security best practice of many for countless years and many DB2 Version upgrades. These DB2 SQL...

(Read more)
 

March 17, 2015


DB2Night Show News

20 MAR 2015 10am CDT: DB2's GOT TALENT Finals Round 3- What will you learn?

The international Olympics of DB2 continue Friday 20 MAR 2015 10am CDT with our Top 6 Finalist Contestants competing for YOUR votes! Have you registered yet? Here's what you will learn...

...

Ember Crooks

DB2 Workload Manager (WLM) as a Monitoring Solution– How to Set up WLM (Part 2 of 3)

This is part two 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...

...
 

March 16, 2015


Craig Mullins

SQL Performance Basics: Part 2, Rely on Indexes

Perhaps the single most important aspect of SQL tuning is indexing. All developers should know all of the indexes that exist on any table upon which they write SQL statements. When an index exists on a column (or columns), DB2 can use the index to reduce I/O instead of scanning the entire table to satisfy a predicate.  For critical queries, where no useful indexes exists, it usually...

(Read more)

IBM Press Room

IBM Helps Angola Develop Smarter Healthcare and Education Capabilities

A team of IBM specialists has presented recommendations to Angolan authorities on a range of issues aimed at supporting Angola’s drive for economic and social transformation. These include academic training, technical skills development, and healthcare management strategies.
E-mail this page Save to del.icio.us Digg this
 

March 13, 2015


DB2Night Replays

The DB2Night Show #152: DB2's GOT TALENT - Finals Round 2 - Top 8 Compete!

DB2's GOT TALENT 2015Finals Round #2 Top 8 Finalists Compete for YOUR Votes!Great DB2 LUW & z/OS presentations! 100% of our studio audience learned something! Today's presentations were GREAT and included topics on MON_GET_DATABASE, Configuring UOW Event Monitor, IBM Performance Analysis Suite, Connecting DB2 LUW to Microsoft Access, SQL Injection and Exception Handling via Stored Procedures, taming a mismatched DB2 z/OS catalog, and...

(Read more)
 

March 12, 2015


Triton Consulting

IDUG EMEA 2015 – Call for Presentations

We are delighted to let you know that IDUG is now accepting presentation abstracts for the IDUG DB2 Tech Conference which will take place in Dublin from 15-20th November. Being an IDUG presenter is a great opportunity to share your … Continue reading →

(Read more)

Ember Crooks

DB2 Administrative SQL Cookbook: Finding When Statistics Were Last Collected for a List of Tables

While using SQL to look at statistics overall is often useful, sometimes we need to look at or report on only a specific subset of tables. Purpose To report the time of last statistics collection...

...
 

March 11, 2015


DB2Night Show News

13 MAR 2015 10am CDT: DB2's GOT TALENT Finals Round 2- What will you learn?

The international Olympics of DB2 continue Friday 13 MAR 2015 10am CDT with our Top 8 Finalist Contestants competing for YOUR votes! Have you registered yet? Here's what you will learn...

...
 

March 10, 2015


Craig Mullins

SQL Performance Basics: Ask For Only What You Need

As you write SQL statements to access DB2 data, there are certain very simple, yet important rules to follow to encourage efficient SQL. Of course, SQL performance is a complex topic and to understand every nuance of how SQL performs can take a lifetime to master. That being said, adhering to the following simple rules puts you on the right track to achieving high-performing DB2 applications. The...

(Read more)

Ember Crooks

Playing With CLPPLUS

I’ve played with the clpplus at least once before, but have generally thought of it as a tool created to satisfy those coming from Oracle and looking for Oracle-like features. One of the...

...
 

March 06, 2015


DB2Night Replays

The DB2Night Show #151: DB2's GOT TALENT - Finals Round 1 - Top 9 Compete!

DB2's GOT TALENT 2015Finals Round #1 Top 9 Finalists Compete for YOUR Votes!Great DB2 LUW & z/OS presentations! 100% of our studio audience learned something! Today's presentations were GREAT and included topics on package cache analysis, trying IBMBLU acceleration, battles with DB2 LUW license administration, DB2 10.5 BLU Data Skipping, DB2 z/OS SQL tuning via temp tables, DB2 z/OS Stored Procedure Analysis, a DB2 LUW Range Partitioning...

(Read more)

Willie Favero

March 2015 (RSU1502) service package has been tested and is now available

(Posted Friday March 6, 2015) Testing for RSU service package RSU1502 is now complete. This March 4, 2015 4th Quarter "2nd Addendum Quarterly Report" (65 KB PDF file) is based on the 4th quarter 2014 service ( RSU1412) and contains ALL service through the end of September 2014 not already...

(Read more)
 

March 05, 2015


Ember Crooks

Adding a GENERATED ALWAYS Column to a Table

GENERATED ALWAYS can be a blessing or a curse. I’m not talking about identity columns here, but about creating a column that is actually a duplicate of some part of the data to boost...

...

Triton Consulting

Top 10 DB2 Support Nightmares and How to Avoid Them #8

Number 8 in our Top 10 DB2 Support Nightmares series. This month we take a look at what happens when organisations are not able to keep up to date with the latest DB2 technology.  Top 10 DB2 Support Nightmares #8 … Continue reading →

(Read more)
 

March 04, 2015


DB2Night Show News

6 MAR 2015 10am CST: DB2's GOT TALENT Finals Round 1 - What will you learn?

The international Olympics of DB2 continue Friday 6 MAR 2015 10am CST with our Top 9 Finalist Contestants competing for YOUR votes! Have you registered yet? Here's what you will learn...

...
 

March 03, 2015


Ember Crooks

Keeping EXPLAIN under control

Have you ever looked at a list of tables in your database, only to see the set of EXPLAIN tables present in two, five or even 10 different developers’ schemas? I don’t know about you, but...

...
 

March 02, 2015


Data and Technology

Inside the Data Reading Room – Spring Break 2015 Edition

Welcome to another installment of Inside the Data Reading Room, a regular feature of this blog where I take a look at some of the recently published database- and data-related books. In today’s post...

(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