Changing the Hostname for a DB2 Server – An Update

Posted by Frank Fillmore on February 7, 2014 under DB2 for Linux Unix Windows, DB2 Migrations. Tags: , .

Probably my most popular blog post of all time – certainly the one most commented upon – was called Changing the Hostname for a DB2 Server.  If you work in a shop that uses the same image (i.e. a Windows backup, VMWare image, or some other form of snap-shotting a Windows computer) containing DB2 for LUW for multiple implementations you will have run into a problem.  When changing the “Computer name” or hostname, the DB2 instance fails to start with an SQL1042C error.

I won’t repeat the entire blog post here – that’s why I included the link above – but I do need to post an update on the location of the important db2nodes.cfg file.  The db2nodes.cfg file now (in DB2 version 9.7) resides in the instance directory.  On a default Windows DB2 installation, that would be x:\ProgramData\IBM\DB2\DB2COPY1\DB2

Please be sure to follow the rest of the instructions on the original post to clear the SQL1042C error.

Data Interoperability Webinar Thursday, 10/3

Posted by Kim May on September 30, 2013 under DB2 Education, DB2 for Linux Unix Windows, DB2 for z/OS, DB2 Gold Consultants, DB2 Migrations, DB2 Stars, Federation, Frank Fillmore, IBM Champion, Informix, InfoSphere, Optim, Q-Replication, TFG Blog. Tags: , , , .

Data interoperability is the function of moving data where you need it, when you need it. It is the process of copying data, also called replication, or combining data from two unique databases, also called federation.

Over the past ten years IBM has been developing technologies and acquiring companies whose tools support fast, reliable replication and federation.  DB2 Gold Consultant and Champion Frank Fillmore and I will deliver a presentation on IBM’s data interoperability solutions targeted to an audience of current Oracle customers – but open to anyone – this Thursday at 11am EDT.

Frank has worked with customers of all sizes to implement IBM replication and federation solutions.  We will combine his real world experience with the latest product information shared by our colleagues Dylan Murphy and Steve Tessler from IBM.

These tools, IBM’s replication solutions Q Replication and InfoSphere Change Data Capture, and federation solutions Data Explorer and InfoSphere Federation Server, work with Oracle, as well as most vendor databases (so yes, DB2 fans are welcome to join us!)

Register:  HERE

Date: Thursday, October 3, 2013

Time: 11am – noon EDT

TFG’s VAP is Re-upped!

Posted by Kim May on July 25, 2013 under Authorized Training Partner, DB2 Education, DB2 for Linux Unix Windows, DB2 for z/OS, DB2 Migrations, IBM DB2 Services, IBM Information Management Software Sales, Q-Replication, TFG Blog. Tags: , , , , , .

We live in a TLA (Three Letter Acronym) happy world, and there’s one very special TLA that very few IBM customers – and even IBM’ers – are aware of – VAP.  We have a VAP that we are very proud of and today received notification from IBM that it was recently revalidated.  I thought I should write about it, because VAP really is the best way for customers to buy IBM solutions.  Even if the VAP you need isn’t one we offer, ask your IBM team or Business Partner if they offer a VAP for the solution you are considering.

VAP stands for Value Advantage Plus.  Not exactly clear, huh?  Well, basically what a VAP does is offers IBM Business Partners a discount on IBM software solutions when they bundle services and training.   This does two things:  1) it offers an incentive to Business Partners to include services and training in a solution proposal, and 2) it reduces the cost of software to the partner.

Most technical solutions require technical assistance to implement; anyone who has been given a redbook and told to figure it out knows how difficult a do-it-yourself implementation is, and we have all unfortunately become accustomed to the software license cost being the only cost discussed when purchasing IBM software.  The second benefit, reduced cost to the Business Partner should, if you are working with an honest and ethical partner (think The Fillmore Group!) result in a lower price for you, the customer.

The Fillmore Group’s VAP is for IBM replication solutions, including Q Replication and ICDC.  We are currently working on both Q Replication and ICDC implementation projects and have historically been the exclusive provider of public IBM education for these products.

If you are considering a replication solution purchase and implementation please let us know – we would be happy to help you take advantage of this little known (terrific!) way to make sure your solution project is a success.

 

“Sick of Oracle? Break Free!” Webinar Recording

Posted by Frank Fillmore on June 27, 2013 under BLU Acceleration, DB2 Education, DB2 for Linux Unix Windows, DB2 Migrations, IBM Information Management Software Sales, Oracle, pureScale. Tags: .

The materials for yesterday’s webinar detailing the reasons to consider migrating from Oracle to DB2 are found here: Break Free from Oracle Presentation 6.26.13

The recorded webinar is found on ChannelDB2.

Break Free from Oracle Webinar

Posted by Kim May on June 21, 2013 under BLU Acceleration, DB2 Education, DB2 for Linux Unix Windows, DB2 Gold Consultants, DB2 Migrations, Frank Fillmore, IBM Champion, IBM DB2 Services, IBM Information Management Software Sales, IBM Pure Systems, Oracle, pureScale, TFG Blog. Tags: , , , , .

The Fillmore Group will deliver a free webinar Wednesday, June 26th, from 11am-noon EDT on the value of migrating from Oracle to DB2.  We have been assisting customers with Oracle to DB2 migrations for the past few years and believe that with the recent DB2 BLU enhancements and IULA announcement the time is right to break free!

Register Here.

What’s an IULA?  It’s the IBM Unlimited License Agreement, a new way to license DB2 use that provides a low cost entry point to purchase DB2, and allows customers to predict and control their ongoing maintenance and support costs.  

As long-time believers in the superiority of IBM’s database technology, we also want to spread the word about the technical enhancements announced for the new IBM BLU Acceleration.  With beta customers reporting 90%-95% compression and amazing performance improvements, the DB2 vs. Oracle performance comparison is a great story to tell.

Most importantly, however, is helping current and prospective IBM customers understand where IBM’s efforts to compete directly with Oracle will deliver the most benefit to their organizations.  Whether it’s cost, performance, or simplifying their in-house database environment, we want to help each one understand why and how IBM has the lead.

I hope you will join us!

Webinar Thursday: IBM Big Data Announcements – What You Should Know

Posted by Kim May on May 6, 2013 under Baltimore Washington DB2 Users Group, Big Data, BigInsights, BLU Acceleration, DB2 Education, DB2 for Linux Unix Windows, DB2 Migrations, Hadoop, IBM Champion, IBM DB2 Services, IBM Information Management Software Sales, IBM Pure Systems, Informix, InfoSphere Streams, Netezza, pureScale, TFG Blog. Tags: .

On April 30th IBM announced several significant solution enhancements related to data management and big data.  These announcements reflect IBM’s commitment to leading the next generation of data solutions through improved functionality in their core database and data warehouse solutions, as well as expanding the capabilities of their solutions built to exploit big data, BigInsights and InfoSphere Streams.  For DB2 database customers IBM announced BLU Acceleration, delivering 8 to 25 times faster reporting and analytics on DB2, along with significant compression and space savings.  For customers considering IBM’s Big Data solutions, IBM announced BigSQL, its ANSI SQL interface that makes BigInsights analysis accessible to business users, not just data scientists.    And for organizations looking to simplify administration, a new appliance, the IBM PureData System for Hadoop was announced.

Join us Thursday, May 9th from 11am-12pm Eastern for an overview of the announcement and learn how your organization can benefit from IBM’s continued investment in data management.  Register here.

Presenter:
Warren Heising, Certified Consulting IT Specialist IBM
Warren is a Certified Consulting IT Specialist for IBM working in the Mid-Atlantic region.  He has over 25 years experience in the database field including 9 years at Informix prior to the IBM acquisition. He has a strong background in both OLTP and DSS Informix products and has worked with numerous clients in both Commercial and Federal accounts. Currently, he supports the full family of IBM Informix products along with DB2 and big data products for the Mid-Atlantic region and is actively involved in Proof of Technology and Proof of Concept scheduling and delivery.

Big Data Announcement – in 2 Hours!

Posted by Kim May on April 30, 2013 under Big Data, BigInsights, BLU Acceleration, DB2 Education, DB2 for Linux Unix Windows, DB2 Migrations, Hadoop, IBM Information Management Software Sales, IBM Pure Systems, InfoSphere Streams, Netezza, TFG Blog. Tags: , .

Here’s the “teaser” for IBM’s Big Data Announcement, “Big Data at the Speed of Business” scheduled for 11am today.  Watch the teaser and don’t miss the webcast!

Frank’s IDUG Session on QCR – Thursday at 3:30pm

Posted by Kim May on April 29, 2013 under DB2 Education, DB2 for Linux Unix Windows, DB2 for z/OS, DB2 Gold Consultants, DB2 Migrations, Frank Fillmore, IBM Champion, International DB2 Users Group (IDUG). Tags: , , .

Frank is attending IDUG in Orlando this week to present on one of our favorite new IBM Information Management solutions, Query Capture Replay (QCR).  If you are heading to Florida this week, please say hi to Frank and join him on Thursday, May 2nd, from 3:30pm – 4:30pm in Bonaire 7&8 for his session.  

“Don’t Guesstimate! Migration Testing with Query Capture Replay”

This presentation focuses on several migration use cases for IBM’s new InfoSphere Optim Query Capture and Replay tool, announced in 2012. Query Capture and Replay (QCR) enables users to capture database activity on a production database and run it to analyze and evaluate the performance when changes – to SQL, hardware, operating system software and even the underlying database – are completed. It’s a great new migration tool.

IBM Data Strategy 2013: #BigData #BLU and much, much more…

Posted by Frank Fillmore on April 16, 2013 under Big Data, BigInsights, BLU Acceleration, DB2 for Linux Unix Windows, DB2 for z/OS, DB2 Migrations, Hadoop, IBM DB2 Services, IBM Information Management Software Sales, IBM Mid Market Customers, IBM Pure Systems, IBM Smart Analytics System, IDAA, InfoSphere Streams, Netezza, Optim, Oracle, pureScale, Q-Replication. Tags: , , , .

Thank you to all of the customers, colleagues, and IBMers who joined The Fillmore Group on April 11, 2013 at Cinghiale in Baltimore, USA to discuss IBM’s Data Strategy – which we call “DB2 101”.  As it happens, many DB2 customers don’t realize the strength and depth of the IBM Information Management portfolio.  And many non-DB2 customers don’t know about the governance and management tooling available in InfoSphere and Optim (e.g. Guardium) which IBM provides for Oracle, SQL Server, Teradata, and other-vendor database servers.

Prominently featured were the highlights of IBM’s April 3rd announcement held at Almaden Lab which my colleague, Kim May, and I attended.

Also of note is the bundling of functionality in DB2 Advanced Enterprise Server Edition (AESE).

  1. pureScale – shared-disk clustering
  2. Data Partitioning Feature (DPF) – shared-nothing hash partitioning
  3. DB2 for LUW v10.5 columnar compression database

The presentation is available at DB2 101 – IBM Information Management Software Portfolio Overview 2013-04  The audio-video recorded delivery can be viewed here.

Cinghiale DB2 101 Thursday

Posted by Kim May on April 9, 2013 under Big Data, BLU Acceleration, DB2 Education, DB2 for Linux Unix Windows, DB2 for z/OS, DB2 Gold Consultants, DB2 Migrations, Frank Fillmore, Hadoop, IBM Champion, IBM DB2 Services, IBM Information Management Software Sales, IBM Mid Market Customers, IBM Pure Systems, IDAA, Netezza, pureScale, TFG Blog. Tags: , , , , , .

Frank is putting the final touches on his DB2 101 presentation for Thursday, incorporating last week’s Big Data announcements from IBM (great stuff; visit the IBM Big Data Hub to learn more) along with his fast-paced presentation on the solutions in the IBM Information Management portfolio.  We are expecting a great turnout but as always, we are happy to make room for more.  If you are in the Baltimore area and interested in joining us, please read my post on the event here, register here and join us.