Matt Huras - Chief Architect, DB2 for Linux, Unix and Windows has shared this great article discussing some of the high-value, core advances in security, availability and performance with the recently announced DB2 11.1 for Linux, UNIX and Windows.
This article is Part 1 of a 2-part Blog series. The article discusses the following
Added by Sajan K on April 28, 2016 at 4:00am — No Comments
In order to analize system performance I tried to discover how time is spent within my database system.
According to the documentation, TOTAL_RQST_TIME=TOTAL_WAIT_TIME + TOTAL_*_PROC_TIME.
By querying the service class table function (MON_GET_SERVICE_CLASS) I'm disappointed by the fact that there is a big difference between total_rqst_time and the sum of all other values.
It seems that with "normal" DML statements these two values are quite…Continue
Added by Alessandro Oppici on April 24, 2016 at 2:58am — No Comments
Lots of new content is available on www.ibmbluhub.com, a site that is focused on BLU Acceleration in-memory computing for fast reporting and analytics from the transaction environment or a warehouse environment. Here is a summary of some content you may want to check out:
Added by Cindy Russell on September 26, 2014 at 9:41am — No Comments
IBM InfoSphere Optim Workload Replay can significantly improve your database testing experience and help you successfully manage change in your database environments, whether you are adopting BLU Acceleration, upgrading DB2 versions, or making the move to DB2.
Using InfoSphere Workload Replay, you can capture production workloads and use them to build realistic testing environments. This helps assess a wide range of database changes before production deployment and without…Continue
Added by Cindy Russell on January 9, 2014 at 3:36pm — No Comments
Big Data applications demand a lot of skills to execute well -- from knowledge of Hadoop to skills to work extensively with your business counterparts.
At this year's IOD conference, we have designed a set of tutorials that will let you build this range of skills. For example, join Dr Vladimir Bacvanski for a 9AM - 4PM tutorial on Hadoop. He will cover all of the relevant technologies to Hadoop but from the standpoint of a data base administrator or data management…Continue
Added by Cindy Russell on September 9, 2013 at 12:27pm — No Comments
This web site links you to announcements and also some livestreaming video from across the brands at the conference.
And, IBM PureData Systems have been keynoted at the conference! If you cannot attend IOD, then kick start your learning on PureData Systems with the DB2 Tech Talk this Wednesday Oct 24th. We will also cover other hot news from IBM and…Continue
Added by Cindy Russell on October 22, 2012 at 1:28pm — No Comments
IBM Data Management Magazine covers DB2 10 and InfoSphere Warehouse 10 Releases
As promised this new format is more flexible, enabling us to respond to exciting news like the DB2 10 and InfoSphere Warehouse 10 product announcements. Check out…
Added by Cindy Russell on March 23, 2012 at 10:30am — No Comments
This month, IBM released an update to the Q Replication Dashboard. The most significant enhancement is the addition of a simplified user interface that's designed for web browsers in small touch-screen devices. I've tried it on both an iPhone 4S running iOS 5.0.1 and a Google…Continue
Added by david t on December 26, 2011 at 9:00pm — No Comments
I regularly see people ask how to access data on UNIX or Windows from apps on IBM's z/OS (mainframe) operating system. However, I haven't been able to find anything that discusses the options. Therefore, I'm using this post to provide the basics about one solution - using IBM's InfoSphere Federation Server as an interface.
This solution is for people running DB2 on z/OS. It's probably best discussed with a simple example and a picture. So, my example is - let's say you…Continue
Added by david t on December 20, 2011 at 8:14pm — No Comments
In IBM Mexico we are looking for an DB2 Database Administrator. The person in this position will have two to three years of experience and strong technical experience. Please find the full job description for this position on our website: http://www.ibm.com/mx/employment/ Job Code ITD-0409585
Added by Jose Luis on December 15, 2011 at 11:34am — No Comments
I am sure you all know that you can configure db2 admin server and health monitor to send emails, but how do you send email from within
db2 luw itself. Much like SQLMAIL feature in our friend SQL Server , DB2 now have a mail feature. Starting from DB2 V9.7, there is an additional database configuration called SMTP_SERVER and built in stored procedure …
Added by Raju Pillai on November 15, 2011 at 8:07am — No Comments
Testing DB2 OLEDB Provider using Microsoft Excel
It is well known that from DB2 control center, one can test connectivity using configuration assistant for various providers like OLEDB , CLI , JDBC , ADO…Continue
Added by Prashant N Kulkarni on October 20, 2011 at 1:39am — No Comments
Last week, smarterquestions.org had a very good post comparing two new database offerings for SMB - the IBM Smart Analytics System 5710 and the Oracle Database Appliance (ODA). Naturally, the first thing I looked for was anything comparing options for…Continue
DB2 LUW partitioned databases haven't been called DPF, the Database Partitioning Feature, since 2007. However, a lot of people still use the term. That's not a bad thing, but they tend to search…Continue
Added by david t on August 29, 2011 at 2:06pm — No Comments
I get a lot of questions about what's included in DB2 Advance ESE where data federation (virtualization) and replication technologies are concerned. Some of them are simple licensing questions about what you get for no extra charge. However, many more are about basic functionality. developerWorks helps out in both cases. For the questions about function, there's…Continue
If you are updating DB2 Express C on Linux to newly released 9.7.4 version, follow my instructions in older blog post.
If you are using db2 text search, it will fail after update with error message:
CIE00340 Cannot start executable program "/bin/sh".
You need to update db2 text search instance as well by running:
configTool upgradeInstance -configPath…Continue
Added by Radim Kolar on June 27, 2011 at 7:07am — No Comments
Greetings to everyone!
This is my first blog here at Channel DB2! And its nice to be here! I would like to start my blog with a review of a great book I read recently , "The Data Warehouse Mentor" by Robert Laberge. I found it very infromative and it filled all…Continue
Added by JB Chakrapani on June 21, 2011 at 10:27am — No Comments
Ahem. Your attention please, for a moment, if you’re interested in DB2 DBA Certifications as a z/OS DBA. I’m posting this to talk specifically about the DB2 9 Fundamentals exam.
Added by Phil Sevetson on June 16, 2011 at 2:13pm — No Comments
IBM has a new availability solution, GDPS active-active continuous availability (GDPS/A-A), that offers an unlimited distance between data centers, cross-site workload monitoring, automated workload balancing, and recovery time objectives measured in seconds. I have a few highlights here. Full details can be found in…Continue
Added by david t on May 24, 2011 at 6:00pm — No Comments