Script:
Owner:
Subdir:
Blog ID: 75809171
Group ID: User ID:

Top Point Earners

Global WebSphere Community Newsletter — June 2012
By Global WebSphere Community Management Team
Jun 15, 2012 1:05 PM CDT
     

WUG News and Updates

Upcoming WUG Meetings:
Highlights From the June Blogs:

Get Your Free Subscription to WebSphere Insights Magazine
WebSphere Insights is jam-packed with product announcements, customer testimonial, executive interviews, and strategies for WebSphere customers to get the most from their IBM investments. Available as a free web app, WebSphere Insights gives you a comprehensive and strategic look at the WebSphere market so you can stop wasting time searching for the information you need to make smart, sound, WebSphere decisions.


July Monthly Focus Webcasts: Don’t Let your Application Become a Bottleneck to the Business

July 12 Webcast: Modularizing Your Applications – Preventing Applications from Becoming Bottlenecks to the Business

Date: July 12, 2012
Title: Modularizing Your Applications – Preventing Applications from Becoming Bottlenecks to the Business

Watch the video replay and download the presentation here

Lack of good modularity is one of the biggest challenges when it comes to making your enterprise applications more flexible and extensible. Without strong modularity, systems become entangled and brittle and development teams become afraid to make changes for fear of breaking things. The application becomes a bottleneck to the business. OSGi Application support in WebSphere Application Server provides a programming model that allows you to blend OSGi modularity into existing applications - without throwing away current skills and assets. With that said, adopting OSGi is not without its challenges, but lucky for you Graham Charters, Senior Technical Staff Member in the IBM WebSphere Application Server development organization, has developed a presentation on just what you need to face that challenge. Join us for this free webcast and:

  • Find out how to beat the learning curve and take the most difficult first step – determining where to start
  • Save yourself work – Graham will dissect an OSGi module and show you what proper composition should look like
  • Get the low down on how to handle third-party libraries
  • Plus, come away with the tools, strategies, and best practices that have been used by IBM and its customers when adopting OSGi modularity in existing systems
The webcast is free, but required pre-registration. Register today!

July 18 Webcast: Enhancing WebSphere Portal & IBM Content Manager with Elastic Caching

Date:
July 18, 2012
Title:
Enhancing WebSphere Portal & IBM Content Manager with Elastic Caching
Time:
11 AM EDT (GMT -4)

Watch the video replay and download the presentation

Websites and applications have become progressively more complex as our industry’s technologies and methodologies advance. The load capacity and response times of modern applications are increasingly constrained by access to back-end datastores such as content repositories and general database systems which are difficult to scale up. Caching of content by applications as done by WebSphere's Dynamic Caching service can help with this problem but runs into a number of limitations including invalidation/consistency problems and application server memory constraints.

WebSphere eXtreme Scale and the XC10 caching appliance can help address these challenges. If you are looking to improve customer experience by providing a basis for faster, more reliable web sites, the WebSphere eXtreme Scale product family offers an implementation of dynacache which stores cached content in an in-memory elastic data grid instead of using the default dynacache implementation which stores cached content in WebSphere Application Server heap space or on disk. There are numerous advantages to this configuration such as: caches can be much larger than what the application server heap would otherwise support while not paying the penalty of storing on disk, caches are shared between application server instances, and cached content can survive an application server restart. This implementation can be enabled without requiring any application code changes.

Join us for a free webcast to learn:
  • The benefits of distributed in-memory data grids aimed at high-performance/high-scale data-intensive applications
  • Details surrounding the WebSphere eXtreme Scale dynacache provider
  • The performance benefits achieved from moving a Portal Dynacache instance into a data grid hosted by an DataPower XC10 caching appliance
  • The configuration steps needed to enable the WebSphere eXtreme Scale dynacache provider
July 26 Webcast: Developing an Infrastructure that Supports Mobile, Cloud, Big Data and Social Solutions

Date: July 26, 2012
Title: Developing an Infrastructure that supports Mobile, Cloud, Big Data and Social Solutions
Time: 11 AM EDT (GMT -4)

Register Now!

As Mobile, Cloud, Big Data and Social drive development and computing on a new scale. The speed and processing power needed to provide integrity for the sheer volume of transactions being created is stressing today’s backend infrastructures to breaking. Join Leif Davidsen Senior WebSphere MQ Product Manager and Mark Taylor Senior WebSphere MQ Technical Strategist for this free Webcast to learn:
  • The new technical enhancements in V7.5
  • How WebSphere MQ now better supports development needs for Mobile
  • How to implement the enhanced capabilities Managed File Transfer and Advanced Message Security
  • And how WebSphere MQ V7.5 simplifies development in this new era of development

The webcast is free to join, but required pre-registration. Please register today!


Recap: June 2012 Monthly Focus Webcasts: New Approaches to Integrated Systems and Extensibility

June 14 Webcast: Introducing IBM Mobile Foundation

Date: June 14, 2012
Title: Introducing IBM Mobile Foundation

Watch the video replay and download the presentation here

Come discover IBM Mobile Foundation, a new middleware offering that brings together key mobile capabilities into a single integrated package to address the full array of challenges and opportunities the mobile channel presents. The IBM Mobile Foundation offering delivers a range of application development, connectivity, and management capabilities that support a wide variety of mobile devices and mobile application types. In this webcast, you will:

  • Understand detailed capabilities of the IBM Mobile Foundation components
  • Discover how to easily connect mobile applications to a variety of Cloud and back-end systems
  • See how application code can be shared among environments while optimized for the specific requirements and design guidelines of different operating systems
  • See how you can manage the Bring Your Own Device or “BYOD” trend with slick capabilities like wiping enterprise data and applications from endpoints when needed
  • Learn how IBM Mobile Foundation can help you bring new mobile applications to market in a time- and cost-effective manner

June 20 Lab Chat: Build, Socialize, and Manage World-Class Web APIs with WebSphere Cast Iron Live Web API Services

Date: June 20, 2012
Lab Chat:
Build, Socialize, and Manage World-Class Web APIs with WebSphere Cast Iron Live Web API Services

Watch the video replay and download the presentation here

Take a look at our June Lab Chat and hear expert advice on defining, creating, socializing, and managing Web APIs from a panel of IBM’s top Web API developers and solution architects. See a demonstration of the recently announced WebSphere Cast Iron Live Web API Services. Find out how to avoid common pitfalls associated with creating and managing Web APIs such as security and versioning and get the lowdown on how Cast Iron Live Web API Services can:

  • Reduce the time it takes to create and socialize APIs by using configuration instead of coding
  • Ease maintenance and management of APIs by leveraging a single dashboard that provides visibility with analytics

June 26 Webcast: The New Reality in Middleware Administration: IT and the Business Unit Working Together

Date: June 26, 2012
Title: The New Reality in Middleware Administration: IT and the Business Unit Working Together

Watch the video replay and download the presentation here

In today’s business environment, a proper middleware management approach needs to integrate the demands of IT and business units. But until recently, middleware management tools have been designed exclusively for people with a deep technical understanding of their systems and applications. This has excluded the business leaders and left IT holding the bag, spending hours creating and managing systems to support business units.

Watch this free video recording presented by Peter D’Agosta, Infrared360 Product Manager at Avada Software. You’ll hear about an approach to middleware management that increases collaboration between IT and business departments and improves productivity. Discover how you can get the deep level IT information you need and save time and effort in providing your business leaders with the reporting they need. Plus, you will:

  • Discover how you can you can improve administration, testing, reporting, and monitoring of enterprise middleware environments such as WebSphere: MQ, Broker, and Application Server
  • Come away with a list of perimeter devices and processes you’re probably not currently monitoring, but can impact your middleware environment - and learn how you can include them in your management process
  • Learn how to configure reporting to fit the specific roles of the person looking at the report, from general transaction rate of your app all the way down to modifying a configuration attribute of the MQ subsystem such as enabling or disabling queues for messaging
June 28 Webcast: Developing and Deploying Applications on the New IBM PureApplication System

Date: June 28, 2012
Title:
Developing and Deploying Applications on the New IBM PureApplication System

Watch the video replay and download the presentation here

As we are entering a new era of computing with IT moving to the strategic center of businesses, application lifecycle management needs to be simplified through every stage. This is now possible with expert integrated systems like IBM’s PureSystems family.

Check out this free webcast, presented by Savio Rodrigues, IBM Program Director for PureApplication System and Private Cloud Product Management, to learn how IBM PureSystems’ flexibility of a general purpose system, elasticity of the cloud, and simplicity of an appliance tuned to the workload will be critical to reduce IT complexity and drive on-time project completion.  Plus, you’ll see how you can:

  • Get ahead of the curve with a tutorial on how to develop and repeatedly deploy applications on the new PureApplication System.
  • Save time and reduce risk with test and production deployment -  driving faster time to value for new, innovative applications
  • Simplify your interaction with your enterprise application solutions through a single management console.

On-Demand: Accelerating Application Change Cycles
DevOps is a software development method that is becoming more and more ubiquitous; it stresses communication, collaboration and integration between software developers and Information Technology professionals. The methodology aims to address the “siloed” operational structures of software development and IT operations to improve an organizations ability to rapidly produce software products and services.

The heightened use of agile development methods and Cloud computing are causing organizations to consider how DevOps strategies support the entire application change cycle.  Companies are looking to enable rapid, open collaboration between all application stakeholders including Dev, QA, Operations, application owners — and even end users.  The DevOps Cycle extends across the application release phase to managing the end-user experience and change management functions that channel problem records, requirements and change requests back through Development to drive the next iteration of the change cycle.

The DevOps Cycle enables enterprises to become truly agile across all the business functions supported by web-based applications. A critical challenge in the cycle is visibility across both development and operations tools.

The Global WebSphere Community has a great resource on our site for you to learn how your organization can achieve a high-performance DevOps Cycle and accelerate application delivery. Check out our recording of a live presentation by Clyde Logue, Senior Program Director and Product Manager at BMC Software, The DevOps Cycle: Accelerating Application Change Cycles. It’s free to watch the video, and you’ll gain an understanding of how the need for DevOps came about and if you should be thinking about it if you’re not already. You’ll see some real-world customer examples of DevOps in use at different types of organizations and hear actual issues customer have been facing in the emerging stages of DevOps implementations. Plus, you’ll pick up some critical strategies for improving the application delivery process, and hear some actual before and after results from real companies who have made the leap. Whether you’re part of a development organization or a member of IT operations, take a few minutes to watch this video, you’ll be glad that you did.

Watch the replay today!


Interested in Becoming a GWC Business Partner?
The Global WebSphere Community reaches tens of thousands of WebSphere professionals every month – the GWC Partner Program allows companies to get their message to decision makers in the community that they may otherwise not have the opportunity to reach. “When we want to send a targeted message specifically to people working in the WebSphere platform, the GWC Partner Program makes that happen for us”, says XebiaLabs CEO Coert Baart, a recent GWC Partner Program participant. He added, “A recent email sent to the community on our behalf resulted in dozens of new leads overnight.”

The GWC Partner Program delivers value far beyond simple advertising. They work as an advisor helping partners choose the right mix of sponsored articles, white papers and webinars that are likely to deliver the desired outcome to partners in terms of brand recognition and lead generation.

To learn how the GWC Business Partner Program can help you deliver targeted messages to WebSphere professionals, contact Scott Treggiari at scott.treggiari@wispubs.com or 1-781-751-8734.


WebSphere News and Announcements

Announcing IBM WebSphere DataPower Appliances Firmware V5.0
IBM WebSphere DataPower Appliances firmware V5.0 adds support for extended memory, OAuth 2.0, and enhanced governance and SLA management features.

WebSphere Appliance Management Center for WebSphere Appliances is available at no charge

Planned availability dates are:
June 26, 2012: Electronic availability
July 19, 2012: Physical availability (7198, 7199, and 4195 models)


Existing WebSphere MQ Customers: Download Extended Transactional Client at NO FEE
Using your active Subscription and Support account existing customers of WebSphere MQ can download the Extended Transactional Client for all supported versions of WebSphere MQ at no fee. Additionally a number of functional enhancements have been announced. This includes message security capabilities, which bring a better user experience and integration capabilities.

To learn more on improvements on WebSphere MQ v7.5 – view the What’s New Page and version to version comparison points.


New on the Web

Customer Video Panel: A New Wave in Automated, Personalized Feedback with ODM
This 30-minute virtual panel discussion is now available on demand. It features IBM customer, BodyMedia, a leader in wearable body monitors designed to promote health and wellness.  BodyMedia's CIO, Steve Menke, tells how rules-based Decision Management technology is powering their new product, FITCoach, providing  “a new wave in self-empowered healthcare" (in the words of their CEO, Christine Robins). Steve is joined by Jason Armstrong from IBM business partner Summa Technologies and Brett Stineman from IBM.


How Will Mainframes Fare in the Face of Mobile and Web?
“Scale really is going gangbusters,” exclaimed James Governor, principal analyst and founder of RedMonk. “The growing “Internet of things” and a big rush of Smartphone-style devices will stress systems. Workloads are going up significantly.”

Know how the mainframe supporting system handles the load.


Using WebSphere eXtreme Scale to Enhance WebSphere Portal and IBM Web Content Manager Performance
WebSphere eXtreme Scale and the XC10 caching appliance offers an implementation of dynacache that stores cached content in an elastic data grid instead of using the default dynacache implementation.

This article examines the significant performance benefits of moving the WebSphere Portal advanced cache content into a data grid hosted by an XC10 caching appliance without requiring any application code changes.


Education and Certification

New Complimentary IBM WebSphere Education Courses Available from the Global WebSphere Community (GWC)
You asked, and we listened.  Last year, we polled our Global WebSphere Community members asking you what WebSphere topics you were most interested in having additional training information on from the GWC.  The results came back showing a strong interest in WebSphere Application Server and WebSphere MQ. The Global WebSphere Community is pleased to announce the availability of the following complimentary IBM WebSphere Education courses available exclusivelt to GWC members:

WebSphere MQ v7 Installation and Configuration
WebSphere MQ V7 High Availability Considerations
Using WebSphere MQ V7 Traces, Error Logs, and Failure Data Capture Files
WebSphere MQ V7 Clustering
WebSphere Application Server V8 Architecture
WebSphere Application Server v8 Workload Management


Cool Portal 8 Training is Hot this Summer
This summer, gain the skills you need to manage and deliver customized, multi-channel web experiences via a single access point to web content and applications.

Available in July:

WPL83 - IBM WebSphere Portal 8.0: Administration, Configuration and
Installation on Windows

WPL53 - Developing Applications for IBM WebSphere Portal 8.0 with RAD 8.5

WPL43 - Developing Websites Using IBM Web Content Manager 8.0

View each course and register your interest as classes will be scheduled soon!


No-Charge Mobile Formatted Education Modules
Define where and when you learn with new IBM WebSphere mobile training modules. These short duration modules are focused on single topics so they are ideal for learning on the go. Built on HTML 5, the mobile modules are compatible with iOS and Android phones and tablets. You can now access twelve training modules for no-charge on topics, including WebSphere MQ, BPM, cloud and WebSphere DataPower. Visit http://ibm.co/mobilepreview to get your no-charge access.


Summer Skill Up Opportunity with Assess and Save
The IBM Collaboration Solutions Certification program is pleased to announce a new Summer Skill Up opportunity with Assess and Save.

Candidates who purchase and pass any online assessment test under the ICS portfolio - including WebSphere Portal - will receive a 50% off voucher good toward the purchase of the corresponding exam at any Prometric Authorized Testing Center.

The Assess and Save Summer Skill Up, is open to all professionals, not just business partners. It is a global initiative, so any test taker at any testing location can take advantage of this offering. Assess and Save will run July through September of this year.


WebSphere/SOA/XML Certification

Deployment Professional - Business Process Manager Advanced V7.5.1

Train and Certify Promotion

IBM Academic Initiative

Certification Removed from 2012 Plan


Upcoming Webcasts, Seminars, and Events

Don't Miss These Upcoming and On-Demand Webcasts:

Live Monthly Demos: For WebSphere Operational Decision Management
Each month one of our technical experts provides an interactive walk-through of the WebSphere Operational Decision Management product -- the next generation of business rules management capabilities. This live demo is a good opportunity to see key product features and functions in action with live Q&A.

Upcoming WODM in Action demos: Sign up now


On-Demand: WebSphere DataPower for Mobile Application Security
New platforms and new technologies have always been the most fertile and interesting targets for hackers, particularly ones that are growing as explosively as mobile applications have been and are projected to be. Why? Because with new technologies and platforms, the security infrastructure and standards tend to be weak or non-existent. What capabilities do exist are often implemented by inexperienced IT workers. Best practices are not yet known and distributed, and are often formed at the expense of early adopters and their pain. Mobile applications are especially appealing in that they present distributed applications and deployment processes, as well as naive users who may not have any understanding of security concepts or practices at all. In this session, learn how you can secure your mobile applications and infrastructure with the current state of the art techniques and tools.


On-Demand: First Look: The Most Consumable Business Rule Management System Ever
Imagine being able to manage and maintain business rules in an environment as familiar as your favorite social media – one that's intuitive, easy, fast and features social media style collaboration; one that requires little to no training for subject matter experts. Imagine no more. It's here.

At the Impact 2012 Conference in May, IBM announced and demonstrated a new business user interface in the latest version of its Operational Decision Management product, which is based on its market-leading business rules management platform. With the new UI, business users can easily interact with others, track comments in activity streams, see an overview of recent activities, subscribe to content of interest, search simply, and more.

Join IBM Executive, Phil Gilbert, and product expert, Jared Michalec, as they demonstrate the new "social" features and functions and show the business value of enabling line-of-business to confidently manage changes to the operational decisions for which they're accountable.


On-Demand: IBM Business Process Management - Core to IBM, Core to Your Success
There are many benefits to Business Process Management, but in order to fully capture the full value of a process improvement effort the right solution must be implemented, and done correctly. The right solution is more than just software - it also includes the organization you partner with to achieve process success. Would you rather partner with an organization that considers BPM core to its business, with industry leadership for over 15 years and over 5000 BPM customers - IBM, or one of the other vendors in the market who either does not consider BPM core, or can not offer the capabilities, support and services on the level that IBM offers? Join us to hear why Securian decided to team with IBM BPM over competitors, and how they successfully implemented their solution.

Speakers include:
Neil Tootill, IBM
Leslie Kramols, Securian


Don't Miss These Upcoming Events:


Impact Comes To You NA Cities
Impact Comes to You is the unique event where business and IT leaders can come together to discuss how interconnecting business strategies and IT technologies can help optimize organizations and uncover new market opportunities. The event will include discussions on innovative technologies such as Mobile, expert integrated systems, Business Process Management (BPM), Service Oriented Architecture (SOA) and Cloud computing.

Costa Mesa       09/12/2012
Edmonton          09/13/2012
Minneapolis        09/18/2012
Nashville            09/20/2012
Boston               09/26/2012
Bloomington       10/03/2012


October 9-12: WebSphere MQ Administration Seminar in Chicago
Join us October 9-12 for the WebSphere MQ Administration seminar to get the technical training you need for guaranteed messaging. As a member of the Global WebSphere Community, you can receive an additional $100 off of seminar registration.

Get expert advice from speakers T. Rob Wyatt, A.J. Aronoff, and Richard Christian to solve your MQ challenges on both distributed platforms (Unix and Windows) and the mainframe (IBM System z), including:

  • Performance tuning
  • Security
  • HA and clustering
  • Migrating to WebSphere MQ v7.x
  • WebSphere trends and futures

To receive your $100 discount, please register online or call us at +1-781-751-8612.

New to WebSphere MQ Administration or want to sharpen your MQ skills? Join us at our 1-day workshop prior to the seminar and ensure you have a foundation to execute with confidence.

Additional dates for the MQ seminar are:
October 23-26, London
November 12-14, Orlando
December 4-7, Amsterdam


October 15 - 18, 2012: Participate in the IBM European WebSphere Technical Convention, Berlin, Germany

Attend the IBM WebSphere Technical Convention and expand your knowledge of SOA, CICS, Messaging WebSphere Application Servers and Infrastructure, including a focus on BPM and Cloud Computing. You can also expect to gain insight into IBM’s software strategy and learn about the latest development directions for the products in the WebSphere software platform.

With over 100 unique sessions, the WebSphere Technical Convention will feature these key themes in today's technology trends.


GWC Members Receive 10% Off Registration for the IBM WebSphere Technical Convention, 15-18 October 2012, Berlin, Germany
Attend the IBM WebSphere Technical Convention and expand your knowledge of SOA, CICS, Messaging WebSphere Application Servers and Infrastructure,
including a focus on BPM and Cloud Computing. You can also expect to gain insight into IBM’s software strategy and learn about the latest development directions for the products in the WebSphere software platform.

With over 100 unique sessions, the WebSphere Technical Convention will feature these key themes in today's technology trends.

For information and enrollment go to: ibm.com/training/conf/europe/ws

To receive your GWC member discount, please insert the discount code: GWC12


November 5 - 8: Ninth International Cloud Expo New York 2012
Come hear IBMer, Kristin Lovejoy speak about the cloud at the 9th International Cloud Expo New York 2012


Tech Tracks

A Guide to Establishing a High Availability Disaster Recovery (HADR) DB2 Cluster for WebSphere Infrastructure Administrators
By Mandar Gadre, Ascendant Technology LLC

As WebSphere infrastructure consultants or administrators, most of the times we have to install the necessary backend IBM DB2 database software and create instances or databases on our own.  Stand-alone installs are straightforward but my last project required me to install and configure the IBM DB2 server in HADR mode and then create a cluster for failover. Since I am not a trained DB2 database administrator, this was a herculean task for me. I didn’t find much help on the Internet apart from a Redbook.  It took me some significant time and couple of PMRs to achieve the HADR and cluster failover, so I decided to write more concise guidelines that I hope will help my fellow administrators save some time and energy.

Configuring HADR

This section talks about setting up the HADR between two DB2 servers. These instructions are written for DB2 V9.7 but should also work for V9.5 and V9.1.

HADR Concept

As the name suggests, HADR keeps two DB2 databases in sync.  Out of the two databases, one is called “primary” and other is called “standby”. Application (any WebSphere application such as WAS, WP, etc.) is usually connected to the primary database. If any data is modified on the primary database, it will also be modified on the standby database.

Pre-requisites / Assumptions:

  1. Full use of HADR is allowed only for Enterprise Server Edition.
  2. Both the DB2 servers should have the same OS with exact same fix level.
  3. DB2 binaries should be installed at the same level.
  4. TCP/IP interface must be available between the primary and standby server.
  5. Buffer pool sizes on the primary and the standby database should be the same.
  6. Table spaces must be identical on the primary and standby databases including:
    • Table space type
    • Table space size
    • Container path
    • Container size
    • Container file type
  7. An instance with the same name is created on both the servers and is listening on the same port number.
  8. Databases with same name are created under the instance.
  9. The amount of space allocated for log files should also be the same on both the primary and standby databases.
  10. Create a backup directory where backups during the HADR establishment procedure (and future backups), active logs, and archive logs are stored. The instructions below assume this backup directory is at mount point /backup.
  11. Note that HADR is established at the database level and not at the instance level. So, for example, if you want to establish HADR for WebSphere Portal server, then you will have to establish HADR for each database individually. Each database in HA configuration needs two unique ports. Identify all such ports beforehand.
  12. HADR doesn’t support circular logging. Archive (linear) logging must be enabled. Below instructions will cover that.
  13. When I had to configure HADR for customer, it was for both Portal and Connections in QA and Prod. So I developed some basic scripts to make this process more repetitive. Appendix has all these scripts and following instructions will use these scripts.

Procedure:
 
There are two ways to establish HADR: Use DB2 command center (CC) graphical interface or DB2 command line processor (CLP).  I will discuss the latter method in this article since it’s repeatable and can be easily automated.

    1. Stop all the applications connecting to DB2 (e.g. Portal server, connections servers etc.)
    2. Open two SSH sessions for the primary and standby servers. Login to both the DB2 servers as instance owner user and root user.
    3. First make sure backup directory (e.g. /backup) is created with enough space on both DB servers.
    4. As a root user, create a directory structure under the backup directory to store active logs, archive logs and database backups (e.g. /backup/ < instance_name > / < db_name > /archlog, /backup/ < instance_name > / < db_name > /actlog, /backup/ < instance_name > / < db_name > /dbbackup).
    5. As a root user, update the  /etc/servicesfile on both primary and standby servers with the High Availability ports. Do this for each database you want to establish HADR.

      e.g.

      DB1_HA_1 55101/tcp

      DB1_HA_2 55102/tcp

      DB2_HA_1 56101/tcp

      DB2_HA_2 56102/tcp

    6. For each database on both primary and standby servers, change the circular logging to archive logging.

      e.g.

      db2 CONNECT TO DB1;

      db2 CONNECT TO DB1;

      db2 QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;

      db2 UNQUIESCE DATABASE;

      db2 CONNECT RESET;

      db2 UPDATE DB CFG FOR DB1 USING indexrec RESTART logindexbuild ON logarchmeth1 "DISK:/backup/ < instance_name > /DB1/archlog" logprimary 12 logsecond 20 logfilsiz 4000 newlogpath /backup/ < instance_name > /DB1/actlog

    7. Now it’s time to take offline backup for each database on the primary server.

      e.g.

      db2 backup db DB1 to /backup/ < instance_name > /DB1/dbbackup

    8. As an instance owner user on standby DB server, copy the backups taken on the primary server’s backup location (e.g. /backup/ < instance_name > / < db_name > /dbbackup)
    9. As an instance owner user on standby DB server, restore backups for each database. This will ensure both the primary and standby databases are exactly identical.

      e.g.

      db2 restore db DB1 from /backup/ < instance_name > /DB1/dbbackup replace history file

    10. Updating Alternate Server configuration is not mandatory but recommended. Update the configuration on both primary and standby servers for each database.

      e.g. On the Primary Server

      db2 update alternate server for database DB1 using hostname < standby_server_host > port 50002

      e.g. On the Standby Server

      db2 update alternate server for database DB1 using hostname < primary_server_host > port 50001

    11. Now it’s time to update database HADR configuration variables for each database on primary and standby servers.

      e.g. On the Primary server

      db2 update db cfg for DB1 using HADR_LOCAL_HOST < PRIMARY_HOST >

      db2 update db cfg for DB1 using HADR_LOCAL_SVC DB1_HA_1

      db2 update db cfg for DB1 using HADR_REMOTE_HOST < STANDBY_HOST >

      db2 update db cfg for DB1 using HADR_REMOTE_SVC DB1_HA_2

      db2 update db cfg for DB1 using HADR_REMOTE_INST < INSTANCE_NAME >

      db2 update db cfg for DB1 using HADR_SYNCMODE NEARSYNC

      db2 update db cfg for DB1 using HADR_TIMEOUT 120

      db2 update db cfg for DB1 using HADR_PEER_WINDOW 300

      db2 connect to DB1

      db2 quiesce database immediate force connections

      db2 unquiesce database

      db2 connect reset

      e.g. On the Standby server

      db2 update db cfg for DB1 using HADR_LOCAL_HOST < STANDBY_HOST >

      db2 update db cfg for DB1 using HADR_LOCAL_SVC DB1_HA_2

      db2 update db cfg for DB1 using HADR_REMOTE_HOST < PRIMARY_HOST >

      db2 update db cfg for DB1 using HADR_REMOTE_SVC DB1_HA_1

      db2 update db cfg for DB1 using HADR_REMOTE_INST < INSTANCE_NAME >

      db2 update db cfg for DB1 using HADR_SYNCMODE NEARSYNC

      db2 update db cfg for DB1 using HADR_TIMEOUT 120

      db2 update db cfg for DB1 using HADR_PEER_WINDOW 300

    12. Start the standby databases first. If this step is successful proceed to the next step.

      e.g.

      db2 deactivate database DB1

      db2 start hadr on database DB1 as standby

    13. Then start databases on the primary server.

      e.g.

      db2 deactivate database DB1

      db2 start hadr on database DB1 as primary

You should now have HADR established. You can check the database configuration by running db2pd –hadr –alldbs on both primary and standby servers.

Establish Failover or Clustering Between HADR Servers

After HADR is established, data will be synced between primary and standby servers. But in the event of primary server failure, the application will not automatically switch connection to standby server. Either the administrator has to manually switch to the standby server or failover needs to be established between the HADR servers.

Assumptions / Pre-requisites:

  1. HADR is configured between all the database pairs and working as expected.
  2. Virtual IP addresses (unique and should be able to ping for each HADR database pair) are ready.
  3. Network quorum device (should have unique IP address that can be pinged) is ready.
  4. Latest TSAMP fixpack is applied to each database.
  5. Both the DB2 server hosts files have host entries with short host names.

Procedure:

    1. On the primary DB node, login as root and run the following commands:

      e.g.

      /usr/sbin/rsct/bin/preprpnode < PRIMARY_HOST > < STANDBY_HOST >

      /usr/sbin/rsct/bin/preprpnode < FQDN_PRIMARY > < FQDN_STANDBY >
      Note: FQDN stands for Fully Qualified Domain Name

    2. On the standby DB node, login as root and run the following commands:

      e.g.

      /usr/sbin/rsct/bin/preprpnode < STANDBY_HOST > < PRIMARY_HOST >

      /usr/sbin/rsct/bin/preprpnode < FQDN_PRIMARY > < FQDN_STANDBY >

  1. On both primary and standby as root, run command startsrc -g rsct_rm. This will ensure that all the resource managers are started on both the HADR servers.

  2. On standby, login as instance owner user.

  3. Run db2haicu command and follow the below example. Note that in the below example conninst is the instance owner name and HOST2 is the host name of the standby server.
    conninst@HOST2:~> db2haicu
    Welcome to the DB2 High Availability Instance Configuration Utility (db2haicu).

    You can find detailed diagnostic information in the DB2 server diagnostic log file called db2diag.log. Also, you can use the utility called db2pd to query the status of the cluster domains you create.

    For more information about configuring your clustered environment using db2haicu, see the topic called 'DB2 High Availability Instance Configuration Utility (db2haicu)' in the DB2 Information Center.

    db2haicu determined the current DB2 database manager instance is conninst. The cluster configuration that follows will apply to this instance.

    db2haicu is collecting information on your current setup. This step may take some time as db2haicu will need to activate all databases for the instance to discover all paths ...

    When you use db2haicu to configure your clustered environment, you create cluster domains. For more information, see the topic 'Creating a cluster domain with db2haicu' in the DB2 Information Center. db2haicu is searching the current machine for an existing active cluster domain ...

    db2haicu did not find a cluster domain on this machine. db2haicu will now query the system for information about cluster nodes to create a new cluster domain ...

    db2haicu did not find a cluster domain on this machine. To continue configuring your clustered environment for high availability, you must create a cluster domain; otherwise, db2haicu will exit.

    Create a domain and continue? [1]
    1. Yes
    2. No

    Create a unique name for the new domain:
    QADomain

    Nodes must now be added to the new domain.
    How many cluster nodes will the domain QADomain contain?
    2

    Enter the host name of a machine to add to the domain:
    HOST1

    Enter the host name of a machine to add to the domain:
    HOST2

    db2haicu can now create a new domain containing the 2 machines that you specified. If you choose not to create a domain now, db2haicu will exit.

    Create the domain now? [1]
    1. Yes
    2. No

    Creating domain QADomain in the cluster ...

    Creating domain QADomain in the cluster was successful.

    You can now configure a quorum device for the domain. For more information, see the topic "Quorum devices" in the DB2 Information Center. If you do not configure a quorum device for the domain, then a human operator will have to manually intervene if subsets of machines in the cluster lose connectivity.

    Configure a quorum device for the domain called QADomain? [1]
    1. Yes
    2. No

    The following is a list of supported quorum device types
    1. Network Quorum

    Enter the number corresponding to the quorum device type to be used: [1]

    Specify the network address of the quorum device:
    10.50.26.21

    Configuring quorum device for domain QADomain ...

    Configuring quorum device for domain QADomain was successful.

    The cluster manager found 2 network interface cards on the machines in the domain. You can use db2haicu to create networks for these network interface cards. For more information, see the topic 'Creating networks with db2haicu' in the DB2 Information Center.

    Create networks for these network interface cards? [1]
    1. Yes
    2. No

    Enter the name of the network for the network interface card: eth2 on cluster node: HOST1.fdnet.com
    1. Create a new public network for this network interface card.
    2. Create a new private network for this network interface card.

    Enter selection:
    1

    Are you sure you want to add the network interface card eth2 on cluster node HOST1.fdnet.com to the network db2_public_network_0? [1]
    1. Yes
    2. No

    Adding network interface card eth2 on cluster node HOST1.fdnet.com to the network db2_public_network_0 ...

    Adding network interface card eth2 on cluster node HOST1.fdnet.com to the network db2_public_network_0 was successful.

    Enter the name of the network for the network interface card: eth2 on cluster node: HOST2
    1. db2_public_network_0
    2. Create a new public network for this network interface card.
    3. Create a new private network for this network interface card.

    Enter selection:
    1

    Are you sure you want to add the network interface card eth2 on cluster node HOST2 to the network db2_public_network_0? [1]
    1. Yes
    2. No

    Adding network interface card eth2 on cluster node HOST2 to the network db2_public_network_0 ...

    Adding network interface card eth2 on cluster node HOST2 to the network db2_public_network_0 was successful.

    Retrieving high availability configuration parameter for instance conninst ...

    The cluster manager name configuration parameter (high availability configuration parameter) is not set. For more information, see the topic "cluster_mgr - Cluster manager name configuration parameter" in the DB2 Information Center. Do you want to set the high availability configuration parameter?

    The following are valid settings for the high availability configuration parameter:
      1.TSA
      2.Vendor

    Enter a value for the high availability configuration parameter: [1]
    1

    Setting a high availability configuration parameter for instance conninst to TSA.

    Adding DB2 database partition 0 to the cluster ...

    Adding DB2 database partition 0 to the cluster was successful.

    Do you want to validate and automate HADR failover for the HADR database DB1? [1]
    1. Yes
    2. No

    All cluster configurations have been completed successfully. db2haicu exiting ..

  4. On the primary server, login as an instance owner. Follow the below command and outputs.
    conninst@HOST1:~> db2haicu
    Welcome to the DB2 High Availability Instance Configuration Utility (db2haicu).

    You can find detailed diagnostic information in the DB2 server diagnostic log file called db2diag.log. Also, you can use the utility called db2pd to query the status of the cluster domains you create.

    For more information about configuring your clustered environment using db2haicu, see the topic called 'DB2 High Availability Instance Configuration Utility (db2haicu)' in the DB2 Information Center.

    db2haicu determined the current DB2 database manager instance is conninst. The cluster configuration that follows will apply to this instance.

    db2haicu is collecting information on your current setup. This step may take some time as db2haicu will need to activate all databases for the instance to discover all paths ...

    When you use db2haicu to configure your clustered environment, you create cluster domains. For more information, see the topic 'Creating a cluster domain with db2haicu' in the DB2 Information Center. db2haicu is searching the current machine for an existing active cluster domain ...

    db2haicu found a cluster domain called QADomain on this machine. The cluster configuration that follows will apply to this domain.

    Retrieving high availability configuration parameter for instance conninst ...

    The cluster manager name configuration parameter (high availability configuration parameter) is not set. For more information, see the topic "cluster_mgr - Cluster manager name configuration parameter" in the DB2 Information Center. Do you want to set the high availability configuration parameter?

    The following are valid settings for the high availability configuration parameter:
      1.TSA
      2.Vendor

    Enter a value for the high availability configuration parameter: [1]

    Setting a high availability configuration parameter for instance conninst to TSA.

    Adding DB2 database partition 0 to the cluster ...

    Adding DB2 database partition 0 to the cluster was successful.

    Do you want to validate and automate HADR failover for the HADR database DB1? [1]
    1. Yes
    2. No

    Adding HADR database DB1 to the domain ...

    Adding HADR database DB1 to the domain was successful.

    Do you want to configure a virtual IP address for the HADR database DB1? [1]
    1. Yes
    2. No

    Enter the virtual IP address:
    10.50.26.59
    Enter the subnet mask for the virtual IP address 10.50.26.59: [255.255.255.0]
    255.255.254.0
    Select the network for the virtual IP 10.50.26.59:
    1. db2_public_network_0

    Enter selection:
    1

    Adding virtual IP address 10.50.26.59 to the domain ...

    Adding virtual IP address 10.50.26.59 to the domain was successful.

    All cluster configurations have been completed successfully. db2haicu exiting ...

    conninst@HOST1:~>

  5. If you successfully configure cluster domain for one instance, for remaining HADR instances on the same servers you just have to run db2haicu command. It will automatically detect the existing domain and add new databases to it.

  6. Once the domain is successfully configured, log on to the WebSphere Application Server or WebSphere Portal server DMGR console. Click Resources -> Data sources. Click on each data source and change the IP address to the virtual IP address we provided during the above configuration. Click OK and save to master configuration. Now test the datasource connectivity and it should be successful. Restart the application servers and make sure applications work fine.

References:
1. IBM Redbook: High Availability and Disaster Recovery Options for DB2 on Linux, UNIX, and Windows.

Mandar has vast administration and architectural experience with IBM Middleware products like WebSphere Application Server and WebSphere Portal Server along with Lotus Connections server, Lotus Quickr server, RAFW. Mr. Gadre is an IBM certified System Administrator for WebSphere Portal v7.0, v6.1, v6.0 and v5.1, WebSphere Application Server ND v6.1, v6.0 and WebSphere Application Server v5.0. He has co-authored an article in “The Sphere” Journal on deploying to the Portal with XMLAccess and ReleaseBuilder technologies. He has also co-authored a guided activity for IBM on “Deploying Themes and Skins to WebSphere Portal Server using Rational Automation Framework for WebSphere (RAFW)”. He works for Ascendant Technologies, a premier IBM business partner. He can be reached at mgadre@atech.com


 
Related
Comments

Connect with Others