Just to follow up on my previous posts, here are some links on deeper details on how to setup IBM middleware for high availability and disaster recovery.
Disaster Recovery and High Availability * Seven Tiers of Disaster Recovery* IBM High-Availability Center of Competency* Business continuity* Business Continuity Self-Assessment Tool* IBM Global Services Business Continuity and Recovery Services
WebSphere Application Server* WebSphere Application Server Network Deployment V6: High Availability Solutions
WebSphere MQ* Understanding high availability with WebSphere MQ* High Availability for WebSphere Message Broker on Distributed Platforms (examples using HACMP and Linux-HA)
DB2 UDB* Open Source Linux High Availability for IBM® DB2® Universal Database™ Implementation Guide* DB2 Universal Database (DB2 UDB) for Linux with DRBD and Heartbeat: A Low-Cost Open Linux High Availability Solution* DB2 HADR Introduction* DB2 HADR Overview* Database Availability Comparison* Is HADR Hard?* Technical Comparison of DB2 HADR and Oracle Data Guard* Automating IBM DB2 UDB HADR with HACMP* Automating DB2 Universal Database (DB2 UDB) HADR Failover using Heartbeat for Linux* Automating DB2 HADR Failover on Linux using Tivoli System Automation for Multiplatforms* HADR - High Availability Disaster Recovery Demystified in IBM DB2 8.2
Please note that there are other potential solutions: GPFS, Linux-HA, HACMP, Storage (Global Mirror, Metro Mirror), System I iCluster, System I HASM, zOS GDPS, zOS Parallel Sysplex
Thanks to Alan Robertson for the links![Read More]
Pragmatic viewpoints of Open Computing
Matching: information_management X
More links of high availablity and disaster recovery with WebSphere MQ, WebSphere Application Server, DB2
I recently got a request from a business partner about how to plan for disaster using IBM technology. As many people know, the short answer is that it depends. What I'll try to do is to build a disaster environment across multiple sites connected by WAN on the "cheap".
Here's the scenario. Retailer just like any other company needs to have disaster recovery (failover), disaster avoidance / disaster resilience (availability across multiple sites) plan. Retailer currently has two sites connected by a WAN with 6 meg connection. Their application is JEE based using on WebSphere Application Server, DB2 Workgroup and WebSphere MQ. They're looking to have an hot-warm (active-standby) configuration to save a bit instead of the usual hot-hot (active-active) configuration.
With this situation, you can have a range of hardware only, software only or blend of hardware and software. Let's list out the options
* Hardware: SAN at each location and doing flash copy between the two locations. * File system: Using something like GPFS and replicating the file system across a WAN.* Middleware: Cluster WebSphere Application Server using WebSphere Application Server Network Deployment. Cluster DB2 Workgroup using DB2 Workgroup High Availability Disaster Recovery (HADR) feature or WebSphere Replication Server or IBM InfoSphere Data Capture (DataMirror).
If you look at the options the most cost effective solution (and bandwidth friendly) is just to replicate just the data between the two sites. So what is the pros/cons of the 3 database replication options.
DB2 Workgroup High Availability Disaster Recovery (HADR) featureHow does it work: Works by moving the transactions logs from one database server onto another and running them again to duplicate the data.Pros: It's free with DB2 Workgroup. Does full database replication only. Cons: You're talking about failover in minutes. Only replicates on exact same systems. One way replication. No network compression and encryption.
WebSphere Replication ServerHow does it work: Multiple ways, it can keep a separate table that "tracks" the changes or move and run transactions logs. Replicates via SQL replication (socket) or Q replication (WebSphere MQ).Pros: Does row replication. Seconds failover and replication. If using queue replication, moves delivery of data replication to WebSphere MQ. Replication can be done on different database vendors. Can do one way, both way and peer to peer replication. Has network compression and encryption features.Cons: If you really want to do it right, you'll have to buy WebSphere MQ.
IBM InfoSphere Data Capture (DataMirror)How does it work: Similar with WebSphere Replication ServerPros: Replication can be database or applications or data warehouse. Built not just for replication but also for transformation of data.Cons: Not optimized for replication per se.
Now that we have looked at all the options, here is my take on the best, cheapest solution. Obviously HADR gives you a lot if you can live with the limitations. In this configuration, I would use HADR between site 1 and site 2 and have people only write to site 1 and read from site 1. I would only have to pay for 1 DB2 Workgroup server licenses (site 1 server 1). Now the problem is (assuming I can live with all the limitations of HADR) is how do I replicate the data from site 2 back to site 1. The sad answer is that it's a manual process. So the next best option (and best IMHO) is a blend of HADR and WebSphere Replication Server. I would have the same HADR configuration with site 1 and site 2 using HADR. I would have write happen at site 1 and read from site 1. I would then have WebSphere Replication Server to sync the data when site 1 comes back online.
I would also note that if I wanted a hot-hot (active-active) configuration across 2 site connected by a WAN, the should would be similar but I would have 2 DB2 Workgroup Server at each site. Site 1 Server 1 is connected via HADR to Site 1 Server 2. Site 2 Server 1 is connected via HADR to Site 2 Server 2. Site 1 and Site 2 are connected by WebSphere Replication Server. Getting this next level of DR would only be an increment of 2 additional servers and 1 more license of DB2 Workgroup.
Just as a summary of using DB2 HADR and WebSphere Replication Server would allow:
* Allows the fastest switchover with transaction-consistent data* Excellent solution for scheduled outage* Allows flexibility of OS level, DB level, application level, data format* Can be easily tested and monitored* Allows for database read or write activity on secondary* Can supplement other HA solutions* Allows for lower cost hardware or platform* Low impact on source applications* Choice of conflict detection options. One-site wins vs time-based
Disadvantages* Asynchronous* Application awareness is required (triggers, generated always columns if p2p)
Here are some article that you might want to check out: An Overview of High Availability and Disaster Recovery for DB2 UDB (circa 2003), Q Replication recovery (circa 2007)
I'd also like to thank fellow IBMers Derek Botti, Peter Inzana, David Tolleson, and Wendy Tam for educating me about all these DR / HA options.[Read More]
So in Retail, as with any business, it's all about information. A lot of customers ask me about "data trust", "data integrity" and a host of other issues with their data. Let me give you some examples of what people tell me.
- I pull inventory reports so that I know what I have and where is it. Pulling reports from different systems gives me different answers. Which one do I trust?- I get 3 entries of the same customer because some sales representative mistyped his last name and called him "mike" in one system and called him "michael" in another. Is there a way for me to fix these issues?- 100 what? Item A is sold by ounce and by milliliter. How can the system help me understand my data in context?- Customer put in a partial address and it is not the same quality of data needed for our other systems. How can I enrich the data?- In order for me to print out my financial reports, all the data from my stores need to come in. Is there a way for me to speed this process?
IBM has a product called IBM Information Server that helps you solve these issues. Here's a funny movie that talks a little about the product.
IBM WebSphere® Remote Server V6.2 is a scalable and stable service oriented architecture (SOA) foundation for remotely managed distributed environments designed specifically to integrate and provide support for store-level devices and applications — past, present, and future. As the core component for the IBM Retail Integration Framework, WebSphere Remote Server provides the foundation for innovation in store and distributed environments where customer-facing and self-service technologies are in high demand as a way of delivering a customer-centric experience. WebSphere Remote Server provides a platform to build, assemble, deploy, and manage these next generation solutions supporting industry standards, as well as protecting existing solutions, delivering a true plug-and-play platform leveraging J2EE middleware technologies.
IBM WebSphere Remote Server is a flexible, complete, feature rich middleware suite composed of IBM application server, database, messaging, and system management software in advanced editions. WebSphere Remote Server V6.2 includes an updated set of system management accelerators to streamline installation and simplify configuration, as well as reducing cost of ownership. The WebSphere Remote Server editions provide a cost-effective software platform, integrated and supported by IBM, and delivered as a single product on common physical media. V6.2 of WebSphere Remote Server provides product release updates, simplified packaging, and enhanced installation and management.
Editions of IBM WebSphere Remote Server V6.2:
* IBM WebSphere Remote Server Starter Edition V6.2 * IBM WebSphere Remote Server Standard Edition V6.2 * IBM WebSphere Remote Server Advanced Edition V6.2 * IBM WebSphere Central Site Server V6.2
IBM WebSphere Remote Server V6.2:
* Is delivered in new bundles customized to better meet your needs * Offers consolidated password management within bundled products and enables single sign on across the enterprise * Includes in every bundle the functionality of IBM WebSphere Systems Management Accelerators that optimize the installation and configuration of WebSphere Remote Servers * Includes the latest versions of IBM DB2® Workgroup Server Edition (V9.5), IBM Tivoli® Monitoring (V6.2), and IBM Tivoli Monitoring for Database Servers (V6.2) * Includes minor release or Fix Pack upgrades to all other products that are included in IBM WebSphere Remote Server * Provides enhanced tools and documentation for installation and management procedures
The IBM Solutions Consultant Express Tool (pre-announced as the Midmarket Patterns Consultant Tool) provides a prescriptive approach for fitting the right solution to your customer's business problem and their current IT environment.
It accelerates solution design by codifying the information in the Patterns for e-business in an easy-to-use tool that guides you through the solution design process. From your answers about the customer's business problem and their IT environment, the tool can recommend the best pattern to solve the problem. The pattern identifies the appropriate Express and non-Express products that are required to implement the pattern. From there it provides information in the form of pattern guidance that helps you get started with the implementation of the pattern.
Optionally, you can use the tool's expert mode to more quickly build solutions. The expert mode lets you bypass most of the constraints of the interview process and assemble any set of pattern components together.
Reduce IT complexity with free architecture tools, technologies, and information from IBM.
Architecting software systems is complex. New architectural styles, such as Service-Oriented Architecture (SOA), add further complexity -- not only to individual projects, but to the entire enterprise. You need the right people, process, and tools to more easily plan and design high-quality software that meets specific business requirements. Explore the Software Architect Kit and find out how to use IBM's tools, designed to unify all aspects of software design and development.
IBM Store Integration Framework
Enable the On Demand Store with IBM Store Integration Frameworkhttp://www.redbooks.ibm.com/abstracts/sg246698.html?Open
IBM WebSphere Remote Server 6.1
WebSphere Remote Server InfoCenterhttp://publib.boulder.ibm.com/infocenter/imshelp1/v3r0/topic/com.ibm.wrs61.doc/retail_welcome.htm
Enabling the On Demand Store with IBM Store Integration Frameworkhttp://www.redbooks.ibm.com/abstracts/sg246698.html
Highly Available Architectures & Capacity Planning with WebSphere Remote Server V6http://www.redbooks.ibm.com/abstracts/sg247184.html
White paper: WRS Monitoring Installation of an Enterprisehttp://publib.boulder.ibm.com/infocenter/imshelp1/v3r0/index.jsp?topic=/com.ibm.wrs61.doc/entmon.pdf
White paper: Reference implementation for end-to-end monitoringhttp://publib.boulder.ibm.com/infocenter/imshelp1/v3r0/index.jsp?topic=/com.ibm.wrs61.doc/e2emon.pdf
White paper: RMA v2 and IBM Director integration with WRShttp://publib.boulder.ibm.com/infocenter/imshelp1/v3r0/index.jsp?topic=/com.ibm.wrs61.doc/rmadir.pdf
White paper: In-Store Processor Update Strategyhttp://publib.boulder.ibm.com/infocenter/imshelp1/v3r0/index.jsp?topic=/com.ibm.wrs61.doc/updisp.pdf
White paper: Deploying WebSphere Remote Serverhttp://publib.boulder.ibm.com/infocenter/imshelp1/v3r0/index.jsp?topic=/com.ibm.wrs61.doc/depwrs.pdf
White paper: POS Deployment and Update Strategy for WebSphere Remote Serverhttp://publib.boulder.ibm.com/infocenter/imshelp1/v3r0/index.jsp?topic=/com.ibm.wrs61.doc/posdep.pdf
IBM Support Assistanthttp://www.ibm.com/software/support/isa/
IBM Solution Assembly Toolkithttp://www.ibm.com/software/webservers/expressruntime/features
General Best Practices
Best practices for software development projectshttp://www-128.ibm.com/developerworks/websphere/library/techarticles/0306_perks/perks2.html
Common malpractices whitepaper (Eleven ways to wreck a deployment)http://www-1.ibm.com/support/docview.wss?rs=180&context=SSEQTP&q1=%22Best+Practice%22&uid=swg27007543&loc=en_US&cs=utf-8&lang=en#Development
Best Practice for Using Common Application Fileshttp://www-1.ibm.com/support/docview.wss?rs=180&context=SSEQTP&q1=%22Best+Practice%22&uid=swg27006159&loc=en_US&cs=utf-8&lang=en
Key principles for business-driven developmenthttp://www-128.ibm.com/developerworks/rational/library/oct05/kroll/
IBM WebSphere Application Server 6.1
WebSphere Application Server InfoCenter 6.1http://publib.boulder.ibm.com/infocenter/wasinfo/v6r1/index.jsp
WebSphere Application Server V6.1 Technical Overviewhttp://publib-b.boulder.ibm.com/abstracts/redp4191.html?Open
Designing and Coding Applications for Performance and Scalability in WebSphere Application Serverhttp://www.redbooks.ibm.com/redpieces/abstracts/sg247497.html?Open
WebSphere Application Server V6.1 Planning and Design WebSphere Handbook Serieshttp://publib-b.boulder.ibm.com/abstracts/sg247305.html?Open
IBM WebSphere Application Server V6.1 Security Handbookhttp://www.redbooks.ibm.com/abstracts/sg246316.html?Open
WebSphere Application Server V6.1: System Management and Configuration,http://www.redbooks.ibm.com/abstracts/sg247304.html?Open
WebSphere Application Server V6.1: Planning and Designhttp://www.redbooks.ibm.com/abstracts/sg247305.html?Open
Web Services Handbook for WebSphere Application Server 6.1,http://www.redbooks.ibm.com/abstracts/sg247257.html?Open
WebSphere - Best Practiceshttp://www-1.ibm.com/support/search.wss?rs=0&apar=include&q1=%22Best+Practice%22&tc=SSEQTP&loc=en_US&cs=utf-8&lang=&sort=desc&rankfile=8
Sample common scripts for WebSphere (start/stop, etc etc)http://www-128.ibm.com/developerworks/websphere/library/samples/SampleScripts.html
WebSphere Installation Factoryhttp://www-1.ibm.com/support/docview.wss?uid=swg24009108
IBM WebSphere Developer Technical Journal: The top Java EE best practiceshttp://www.ibm.com/developerworks/websphere/techjournal/0701_botzum/0701_botzum.html
Older but goodWebSphere Application Server - Express V6 Developers Guide and Development Exampleshttp://www.redbooks.ibm.com/abstracts/sg246500.html?Open
WebSphere Application Server V6 Migration Guidehttp://www.redbooks.ibm.com/abstracts/sg246369.html?Open
Migrating Applications from WebLogic, JBoss and Tomcat to WebSphere V6http://www.redbooks.ibm.com/abstracts/sg246690.html?Open
IBM WebSphere MQ 6.0WebSphere MQ 6.0 InfoCenterhttp://publib.boulder.ibm.com/infocenter/wmqv6/v6r0/index.jsp
An WebSphere MQ Primerhttp://www-1.ibm.com/support/docview.wss?rs=171&uid=swg24006526&loc=en_US&cs=utf-8&lang=en
IBM WebSphere MQ support (FixPak/CSD, SupportPacs and technotes,etc.)http://www-306.ibm.com/software/integration/wmq/support/
WMQ publications and Library:http://www-306.ibm.com/software/integration/wmq/library/library6x.html
WebSphere MQ V6 Fundamentalshttp://www.redbooks.ibm.com/abstracts/sg247128.html?Open
WebSphere MQ V6 and Web Serviceshttp://www.redbooks.ibm.com/redpieces/abstracts/sg247115.html?Open
WebSphere MQ Solutions in a Microsoft .NET Environmenthttp://www.redbooks.ibm.com/abstracts/sg247012.html?Open
IBM DB2 9.1
DB2 9.1 InfoCenterhttp://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp
High Availability and Scalability Guide for DB2 on Linux, UNIX, and Windowshttp://www.redbooks.ibm.com/abstracts/sg247363.html?Open
DB2 best practices for basic design, performance, and manageabilityhttp://www.ibm.com/developerworks/db2/library/techarticle/dm-0709martin/
DB2 Migration Toolkithttp://www-306.ibm.com/software/data/db2/migration/mtk/
Older but goodDB2 UDB V8.2 on the Windows Environmenthttp://www.redbooks.ibm.com/abstracts/sg247102.html?Open
DB2 UDB V8 and WebSphere V5 Performance Tuning and Operations Guidehttp://www.redbooks.ibm.com/abstracts/sg247068.html?Open
DB2 UDB/WebSphere Performance Tuning Guidehttp://www.redbooks.ibm.com/abstracts/sg246417.html?Open
MySQL to DB2 UDB Conversion Guidehttp://www.redbooks.ibm.com/abstracts/sg247093.html?Open
Oracle to DB2 UDB Conversion Guidehttp://www.redbooks.ibm.com/abstracts/sg247048.html?Open
Microsoft SQL Server to IBM DB2 UDB Conversion Guidehttp://www.redbooks.ibm.com/abstracts/sg246672.html?Open
IBM Tivoli Monitoring 6.1
IBM Tivoli Monitoring InfoCenterhttp://publib.boulder.ibm.com/infocenter/tivihelp/v3r1/index.jsp
Getting Started with IBM Tivoli Monitoring 6.1 on Distributed Environmentshttp://www.redbooks.ibm.com/abstracts/sg247143.html?Open
Deployment Guide Series: IBM Tivoli Monitoring 6.1http://www.redbooks.ibm.com/abstracts/sg247188.html?Open
IBM Tivoli and IT Infrastructure Library (ITIL)http://www-306.ibm.com/software/tivoli/features/ITIL/
Demos/Videos of Tivoli Monitoring in actionhttp://www-306.ibm.com/software/tivoli/library/demos/
Step-by-step guide on how to integrate and manage your old and new Retail devices in IBM Remote Management Agent and IBM Tivoli Monitoring 6.1http://www.ibm.com/developerworks/tivoli/library/t-rmaitm/index.html?S_TACT=105AGX14&S_CMP=EDU
Step by step how-to on integrating your application with IBM Tivoli Monitoring 6.1http://www.ibm.com/developerworks/tivoli/library/t-inttivmon/index.html?S_TACT=105AGX14&S_CMP=EDUIBM Tivoli Provisioning Manager for Software 5.1
Tivoli Provisioning Manager for Software InfoCenterhttp://publib.boulder.ibm.com/infocenter/tivihelp/v21r1/topic/com.ibm.tivoli.tpm.doc/welcome/tpmsofthome.htm
Deployment Guide Series: IBM Tivoli Provisioning Manager Version 5.1http://www.redbooks.ibm.com/abstracts/sg247261.html?Open
IBM Tivoli Configuration Manager 4.2.3
IBM Tivoli Configuration Manager InfoCenterhttp://publib.boulder.ibm.com/infocenter/tivihelp/v3r1/index.jsp
Deployment Guide Series: IBM Tivoli Configuration Managerhttp://www.redbooks.ibm.com/abstracts/sg246454.html?Open
All About IBM Tivoli Configuration Manager Version 4.2http://www.redbooks.ibm.com/abstracts/sg246612.html?Open
Automated Distribution and Self-Healing with IBM Tivoli Configuration Manager V 4.2http://www.redbooks.ibm.com/abstracts/sg246620.html?Open
Demos/Videos of Tivoli Configuration Manager in actionhttp://www-306.ibm.com/software/tivoli/library/demos/
IBM Tivoli Enterprise Console
IBM Tivoli Enterprise Console InfoCenterhttp://publib.boulder.ibm.com/infocenter/tivihelp/v3r1/index.jsp
White paper: WRS Monitoring Installation of an Enterprise (best step by step guide on installing Tivoli Enterprise Console)http://publib.boulder.ibm.com/infocenter/imshelp1/v3r0/index.jsp?topic=/com.ibm.wrs61.doc/entmon.pdf
IBM Tivoli Enterprise Console Integration with Service Desk Applicationshttp://www-18.lotus.com/tec?NavCode=1TW10EC04
Tivoli Enterprise Console Rule Development Guidehttp://publib.boulder.ibm.com/tividd/td/tec/SC32-1234-00/en_US/PDF/ecodmst.pdf
Demos/Videos of Tivoli Enterprise Console in actionhttp://www-306.ibm.com/software/tivoli/library/demos/[Read More]
The server has an initial ip and hostname of 192.168.100.100, alias and alias.us.ibm.com.
1. Put in a entry into /etc/host with
192.168.100.100 alias.us.ibm.com alias
2. Install all IBM products against "alias" hostname3. When you need to change the hostname, expand the alias entry to /etc/hosts. Your /etc/hosts should look like this
18.104.22.168 newhostname.us.ibm.com newhostname alias
The IBM software should resolve always to "alias" while the external connectivity would be tied to "newhostname" and "newhostname.us.ibm.com". Works with WebSphere Application Server, DB2 Workgroup Server and WebSphere MQ Server.[Read More]
A great article written by one of my teammates, Colin Meiser.
Over the past few years, much has been written about DB2 design and implementation best practices. There are many books, along with dozens of articles, that provide insight into how DB2 should be designed and integrated into applications. To provide some basic guidance for customers and business partners entering this maze, this article compiles a list of arguably the best practices to be considered during design and implementation of your application using IBM® DB2® technology. The intended result of this article is a more effective and efficient DB2 implementation. This article is not intended to provide detailed performance best practices for existing DB2 customers and independent software vendors (ISVs).
Here's the short answer of how to change hostname and ip address of a DB2 database server.
1. change the file /home/db2inst1/sqllib/db2nodes.cfg with the right hostname. If the server is called sampleserver.ibm.com. The file should have one line with "0 sampleserver.ibm.com 0".2. change your db2 client setting. Execute "db2set -g DB2SYSTEM=sampleserver.ibm.com". Check to see if it was set correctly by executing "db2set -all". If it isn't set, change to root or db2inst1 and try again.3. Execute "db2stop" and "db2start"
Here is a link for details -> FAQ: How do I rename a server that is running DB2?[Read More]
Great way to see how IBM software works!
Bringing the vision of on demand business to life
* Play or download narrated demonstrations from the IBM software recorded demonstration portfolio. * See examples of IBM software solutions that can help your business become more efficient, responsive, and competitive.
The best way to understand IBM software is to see it in action.
IBM Lifecycle Policy gives customers a reasonable amount of time to purchase, install, productively use and migrate to the next product release
IBM Lifecycle Policy gives customers a reasonable amount of time to purchase, install, productively use and migrate to the next product release. For more information see:
Software Support Handbook is a one stop guide for all IBM software support. It details examples; delivery processes; checklists; ‘how tos’ of invoking software support, escalate problem records, purchase software maintenance; STCs role and process to setup authorized online users; worldwide list of support center phone numbers and much more. For more information, refer to the Software support handbook
If you're a business partner of IBM's and you sell IBM solutions and you can't make it the IBM's Conferences for sales and technical sales training on IBM Software and Hardware solutions, perhaps attending a IBM Top Gun class is for you.
IBM Top Gun training is designed to increase sales, solutions, competitive and technical skills for I/T Industry professionals. The program uses a popular "Top Gun" format involving unique class themes, stimulating lectures, stand-up exercises, hands-on labs, quizzes, and product demonstrations.
Top Gun training is for sales and solution specialists, IBM Business Partners, eSM's, client reps, telemarketing personnel or anyone who spends a significant amount of their time selling, marketing, and supporting IBM eServer, TotalStorage and Software products and solutions.