Services – Available Help for the “tions”

Posted by Kim May on May 30, 2014 under Authorized Training Partner, Big Data, Data Studio, DB2 Connect, DB2 Education, DB2 for i, DB2 for Linux Unix Windows, DB2 for VSE&VM, DB2 for z/OS, DB2 Gold Consultants, DB2 Migrations, Federation, Frank Fillmore, Hadoop, IBM Champion, IBM DB2 Services, IBM Pure Systems, IDAA, InfoSphere, InfoSphere Streams, MQT's, Netezza, Optim, Oracle, pureScale, Q-Replication, SQL Tuning, TFG Blog. Tags: , , , , , , , , , , , , , , , , , .

I was on a call this morning with an IBM technical team to discuss our progress filling the seats in one of our upcoming free IDAA classes.  Not surprising, given the number of people on the call (and who they were!) we went a bit off topic and ended up chatting about services and what appears to be – to IBM customers and sellers at least – a shortage of skilled consultants available to help with the “tions” – replication, implementations, migrations and federation.

The Fillmore Group has skilled consultants available to support these efforts, at rates that are typically about half of those being charged by “the competition”.

If your team has a project pending, or one in process, where a skilled consultant, at a reasonable hourly rate, can get things back on track, please contact me.  We are ready to work!  A list of our IBM Information Management capabilities is attached here.

 

Summary of DB2 and Q Replication Performance Tuning Techniques

Posted by Frank Fillmore on March 25, 2014 under DB2 for Linux Unix Windows, Q-Replication, SQL Tuning. Tags: , .

Performance tuning for both DB2 and Q Replication are an ongoing process.  However, there are three tools which provide an initial set of recommendations for bufferpools, Database Manager (DBM or instance) and database configuration parameters, indexes, and other application table objects.

 

DB2 Configuration Advisor

The DB2 Configuration Advisor recommends the initial values of the bufferpool size, database configuration parameters, and database manager configuration parameters.

To use the Configuration Advisor, specify the AUTOCONFIGURE command for an existing database, or specify AUTOCONFIGURE as an option of the CREATE DATABASE command.

Example:

db2 autoconfigure using mem_percent 50 num_stmts 100000 tpm 6000 admin_priority performance num_local_apps 144 num_remote_apps 0 isolation UR apply none

DB2 Design Advisor

The DB2 Design Advisor is used to improve application SQL performance by creating (or dropping) indexes, Materialized Query Tables (MQTs), and MultiDimensional Clustering (MDCs).  The Design Advisor analyzes an SQL workload against existing table structures and recommends changes to improve performance.  The workload can be derived from Dynamic Statement Cache (DSC).  The DB2 Design Advisor command can be invoked by the db2advis command.

A prerequisite is creating the DB2 EXPLAIN tables for the schema conducting the analysis.

cd /<path>/sqllib/misc

db2 –vtf EXPLAIN.DDL

Then run the db2advis command.

db2advis -d mydb -g -a myuser -x -c USERSPACE1 -f -m IMCP -o db2advis_output

 

Q Replication Dashboard Performance Advisor

The Q Replication Performance Advisor helps you identify latency issues with your replication environment and suggests ways to lower end-to-end latency.  The Performance Advisor tab is located within each Monitoring Group.  The Q Replication Dashboard Performance Advisor can recommend updating statistics or reorganizing tables.

IBM zEnterprise Technology Summit – May 6th, Washington, DC

Posted by Kim May on March 21, 2014 under Baltimore Washington DB2 Users Group, DB2 for z/OS, IBM DB2 Services, IDAA, Optim, Q-Replication, TFG Blog. Tags: , , , , , , .

IBM has scheduled a second presentation of the 2014 zEnterprise Technology Summit due to the snowstorm that hit in January when the event ran originally.  If you are in the area and have time to attend, please do!  Information on the event is below; register on the IBM site here.  There are several other events scheduled across the US in 2014 – view them on the IBM site here.

IBM zEnterprise Technology Summit Tuesday, May 6, Washington, DC

New technology is stretching IT budgets in many directions, forcing IT to find better ways of meeting business demands in increasingly complex data centers. Read More…

Hot-off-the-presses Redbook on DB2 for z/OS High Availability #DB2forz/OS

Posted by Frank Fillmore on January 25, 2014 under DB2 for z/OS, Q-Replication. Tags: , , , .

IBM just published a new Redbook titled Understanding and Using Q Replication for High Availability Solutions on the IBM z/OS Platform.  Two of my fave Silicon Valley Lab replication developer/experts – Cecile Madsen and Jayanti Mahapatra – are co-authors.

Customer expectations in 2014 are that they can conduct business with a variety of financial, retail, and other enterprises 24x7x365.  Even with the availability characteristics of the System z platform in general and DB2 for z/OS in particular, planned and unplanned outages will occur. 

The Redbook focuses on IBM InfoSphere Data Replication (IIDR) Q Replication as the undergirding HA technology.  It details two-node and three-node active-active replication topologies.  I suspect much of the basis for the document is the massive deployment of Q Replication at a large commercial bank in Brazil.

TFG and Arrow Bring Back Training with a BANG! #ibmiod

Posted by Kim May on November 2, 2013 under Arrow ECS, Authorized Training Partner, BigInsights, BLU Acceleration, DB2 Education, DB2 for Linux Unix Windows, DB2 for z/OS, IBM Training Services Delivery Partner, InfoSphere, Q-Replication. Tags: , , , , .

To everyone joining us at IOD, I invite you to stop by Arrow ECS’s booth in the Expo, #1309, to pop a balloon and possibly win a valuable training class prize – or an iPad!  Arrow ECS is one of the four new IBM-selected Global Training Partners, and in addition to being The Fillmore Group’s software distributor, Arrow is the partner TFG has aligned with to continue to deliver IBM Authorized Information Management classes.

To qualify to win you must stop by the booth and pop a balloon.  Special prizes are in *some* balloons.  Good luck!  Let’s get IBM IM training restarted with a BANG!

Q Replication Dashboard Enhancements Requested

Posted by Frank Fillmore on October 22, 2013 under InfoSphere, Q-Replication. Tags: , , , .

If you work with IBM InfoSphere Data Replication (IIDR), you are probably familiar with the Q Replication Dashboard.  The Dashboard is a GUI which enables you to manage and monitor your Replication and Event Publishing topologies.  For example, IBM’s direction is to move away from using asnmon to set monitoring and alert thresholds and to build this functionality into the Dashboard.

Here’s an opportunity to make a good product even better.  One of my customers had a series of requests to enhance the Dashboard:

  1. Provide the ability to export/import connection and configuration settings.
  2. Enable LDAP authentication.
  3. Provide something other than e-mail alerts (e.g. SNMP or Tivoli Systems Management integration).

Take a moment to review the formal Request for Enhancemant (RFE).

TFG (Finally!) Offers Training Again

Posted by Kim May on October 8, 2013 under Authorized Training Partner, DB2 Education, DB2 for Linux Unix Windows, DB2 for z/OS, IBM Training Services Delivery Partner, Q-Replication, TFG Blog. Tags: , , , , , , , .

This past summer IBM rolled out the Global Skills Initiative, essentially outsourcing all education marketing and delivery to four selected Global Training Partners.  IBM will continue to develop course curriculum, but everything else is now in the hands of the four Global Training Partners, or GTP’s.

The Fillmore Group has aligned with Global Training Partner Arrow ECS, our software distributor, and I am pleased to finally be able to announce that we are back in the training business.

There are still challenges.  Two of the biggest are the process of finding our classes on the IBM training site and actually registering for a class.  While I work through this process so I can update our website with accurate information, I am going to post our schedule in as many places as possible (right here for starters), and invite anyone in search of an IBM class to contact me if you need help.  Public classes, private classes, in the classroom or remote – please don’t hesitate to email me.  I want to help!

Data Interoperability Webinar – Recording and Materials

Posted by Frank Fillmore on October 3, 2013 under DB2 for Linux Unix Windows, DB2 for z/OS, Federation, IBM Information Management Software Sales, IBM Mid Market Customers, Informix, InfoSphere, Optim, Oracle, Q-Replication. Tags: , , , , , , , , .

Kim and I conducted a webinar on Thursday, October 3, 2013 that focused on IBM Data Interoperability software products and their specific strengths, weaknesses, and use cases.  We highlighted the application of the InfoSphere family of products to other-vendor databases such as Oracle, SQL Server, Sybase, and Teradata.  Kudos to Kim for putting together a presentation of disparate, but complementary technologies.

The recording of the webinar can be found here.  The presentation materials can be downloaded: Data Interoperability Presentation – FINAL 10.3.13

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