HP Integrity Virtual Machines Online Migration with IBM Informix Dynamic Server 11.50 Table of contents Executive summary............................................................................................................................... 2 Integrity VM overview .......................................................................................................................... 2 Integrity Virtual Machines Online Virtual Machine Migration......................................................
Executive summary Most data centers have server hardware that is underutilized. These same data centers almost never have enough servers to satisfy their customers. These seemingly contradictory situations have led administrators to the obvious conclusion for years – ―I should be able to make better use of the resources I already have.
For more information on HP Integrity Virtual Machines (Integrity VM) go to http://www.hp.com/go/IntegrityVM Integrity Virtual Machines Online Virtual Machine Migration Online VM Migration for Integrity Virtual Machines enables a running VM, its guest OS and its applications to be moved to a different VM Host without service interruption. Service remains active without an OS reboot or application restart. All I/O connections to storage and networks remain active throughout the migration.
Note Online VM Migration is available with HP Integrity Virtual Machines v4.1 (HPVM). Configuration Software HPVM host systems HP-UX 11i v3 HPUX11i-DC-OE (Data Center Operating Environment) installed on Host A and Host B HP-UX Virtual Machine 4.1 installed on Host A and Host B Virtual Server Environment Management Software installed on Host A and Host B HPVM guest system HP-UX 11i v3 HPUX11i-DC-OE (Data Center Operating Environment) installed on HPVM guests Informix Dynamic Server 11.
Figure 1. HPVM Online Migration topology BladeSystem Enclosure c7000 Client 156.153.117.50 Standby Server 156.153.117.27 VM Host B 156.153.117.
Network (SAN) based storage LUNs (/dev/rdisk/disk24, /dev/rdisk/disk26) were presented to both of the HPVM host systems for common access. Table 1. Host System Information VM Host A VM Host B System BL870c BL870c Host IP External: 156.153.117.51 External: 156.153.117.52 Private: 10.1.0.100 Private: 10.1.0.200 vega7051-root-># ifconfig lan0 lan0: flags=843 inet 156.153.117.51 netmask fffffc00 broadcast 156.153.119.
HPVM installation and creation of guests Steps 1. Install HP Integrity VM 4.1 software using swinstall command # swinstall -x autoreboot=true -s my.server.foo.com:/depot/path T2767CC T8718AC To list the bundles installed use swlist command # swlist | grep -i “integrity vm” Note You can install Integrity VM on a hard partition (nPar) running HP-UX, but do not attempt to install Integrity VM on a virtual partition (vPar). 2. Verify the installation # hpvminfo hpvminfo: Running on an HPVM host. 3.
4. Create virtual machine guest hpvmids1 hpvmcreate — Create a new Integrity Virtual Machines virtual machine -P vm-name Specifies the name of the virtual machine -e percent Specifies the percentage of CPU resources to which each of the guest‟s virtual CPUs is entitled. -a Specifies the mapping of a guest virtual device to a VM Host backing store. -O os-type[:version]] Specifies the type and version of the operating system running on the virtual machine.
HP Virtual Machines guest hpvmids1 and hpvmids2 details on Host A: HPVM guest : hpvmids1 HPVM guest : hpvmids2 vega9016-root-># machinfo vega9018-root-># CPU info: 2 Intel(R) Itanium 2 9100 series processors (1.59 GHz, 12 MB) 266 MHz bus, CPU version A1 CPU info: 2 Intel(R) Itanium 2 9100 series processors (1.59 GHz, 12 MB) 266 MHz bus, CPU version A1 Memory: 16378 MB (15.99 GB) Memory: 16378 MB (15.99 GB) Firmware info: Firmware revision: 04.10.00 FP SWA driver revision: 1.
Install CSDK on Client system Complete details on IDS and CSDK (Client Software Development Kit) installation can be found in IDS 11.5 infocenter: http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp HPVM Online Migration HPVM Online migration of guest hpvmids1 from Host A (156.153.117.51) to Host B (156.153.117.52) Check HPVM status: hpvmids1 is „On‟ on Host A (vega7051) and „Off‟ on Host B (vega7052) On: The virtual machine is “powered on.
disk disk disk /dev/rdisk/disk24 scsi 0 1 /dev/rdisk/disk26 0 [Network Interface Details] Interface Adaptor Name/Num Bus Dev Ftn Mac Address ========= ========== ========== === === === ================= vswitch avio_lan vlan 0 2 0 46-98-df-22-ba-54 vswitch avio_lan blan 0 4 0 de-8e-71-14-3a-7d 0 0 PortNum ======= 2 2 [Misc Interface Details] Guest Physical Device Adaptor Bus Dev Ftn Tgt Lun Storage Device ======= ========== === === === === === ========= ========================= serial com1 tty conso
Test scenarios for HP Integrity Online VM Migration with IDS 11.50 The following scenarios were tested. Oncheck was used to validate the integrity of the system before and after the HPVM Online Migration. Objective: Validate HP Integrity Virtual Machines Online Migration with Integrity VM Guest running IDS 11.50 migrating from Host A to Host B and client connections not being interrupted during and after the migration.
7 HDR Scenario 1 – migrate Primary (Requires the Standby Server) Set up an HDR (High Availability Data Replication) pair with the Primary running on HPVM1 on Host A and the Secondary running on the Standby Server. Set up the connection manager such that the Secondary becomes the Primary when the Primary fails. Initiate some Client connections doing DDL/DML against IDS. While the clients are connected and transactions are going on, migrate HPVM1 to Host B.
Appendix A: Server onconfig.idsqa IDS server configuration files: onconfig.idsqa ################################################################### # Licensed Material - Property Of IBM # # “Restricted Materials of IBM” # # IBM Informix Dynamic Server # Copyright IBM Corporation 1996, 2009. All rights reserved. # # Title: onconfig.std # Description: IBM Informix Dynamic Server Configuration Parameters # # Important: $INFORMIXDIR now resolves to the environment # variable INFORMIXDIR.
# Physical Log Configuration Parameters ################################################################### # PHYSFILE - The size, in KB, of the physical log on disk. # If RTO_SERVER_RESTART is enabled, the # suggested formula for the size of PHSYFILE # (up to about 1 GB) is: # PHYSFILE = Size of BUFFERS * 1.
# logical log space. # # When using Enterprise Replication, set LTXEHWM to at least 30% # higher than LTXHWM to minimize log overruns.
# SBSPACENAME - The default sbspace name where smart large objects # are stored if no sbspace is specified during # smart large object creation. Some DataBlade # modules store smart large objects in this # location. # SYSSBSPACENAME - The default sbspace for system statistics # collection. Otherwise, IDS stores statistics # in the sysdistrib system catalog table. # ONDBSPACEDOWN - Specifies how IDS behaves when it encounters a # dbspace that is offline.
MAX_INCOMPLETE_CONNECTIONS 1024 FASTPOLL 1 ################################################################### # CPU-Related Configuration Parameters ################################################################### # MULTIPROCESSOR - Specifies whether the computer has multiple # CPUs. Acceptable values are: 0 (single # processor), 1 (multiple processors or # multi-core chips) # VPCLASS cpu - Configures the CPU VPs.
LOCKS 20000 DEF_TABLE_LOCKMODE page ################################################################### # Shared Memory Configuration Parameters ################################################################### # RESIDENT - Controls whether shared memory is resident.
# more frequently if there is a chance that # transaction blocking might occur. # RTO_SERVER_RESTART - Specifies, in seconds, the Recovery Time # Objective for IDS restart after a server # failure. Acceptable values are 0 (off) and # any number from 60-1800, inclusive. # BLOCKTIMEOUT - Specifies the amount of time, in seconds, # for a system block.
################################################################### # Backup and Restore Configuration Parameters ################################################################### # BAR_ACT_LOG - The ON-Bar activity log file location. # Do not use the /tmp directory. Use a # directory with restricted permissions. # BAR_DEBUG_LOG - The ON-Bar debug log file location. # Do not use the /tmp directory. Use a # directory with restricted permissions. # BAR_DEBUG - The debug level for ON-Bar.
BAR_NB_XPORT_COUNT 20 BAR_XFER_BUF_SIZE 31 RESTARTABLE_RESTORE ON BAR_PROGRESS_FREQ 0 BAR_BSALIB_PATH BACKUP_FILTER RESTORE_FILTER BAR_PERFORMANCE 0 ################################################################### # Informix Storage Manager (ISM) Configuration Parameters ################################################################### # ISM_DATA_POOL - Specifies the name for the ISM data pool # ISM_LOG_POOL - Specifies the name for the ISM log pool #####################################################
# STMT_CACHE - Controls SQL statement caching. Acceptable # values are: # 0 Disabled # 1 Enabled at the session level # 2 All statements are cached # STMT_CACHE_HITS - The number of times an SQL statement must be # executed before becoming fully cached. # 0 indicates that all statements are # fully cached the first time. # STMT_CACHE_SIZE - The size, in KB, of the SQL statement cache # STMT_CACHE_NOLIMIT - Controls additional memory consumption.
# pages that have variable length rows as # full as possible # BTSCANNER - Specifies the configuration settings for all # btscanner threads. The format is: # BTSCANNER num=<#>,threshold=<#>,rangesize=<#>, # alice=(012),compression=[low|med|high|default] # ONLIDX_MAXMEM - The amount of memory, in KB, allocated for # the pre-image pool and updator log pool for # each partition.
# EXT_DIRECTIVES - Controls the use of external SQL directives. # Acceptable values are: # 0 Disabled # 1 Enabled if the IFX_EXTDIRECTIVES environment # variable is enabled # 2 Enabled even if the IFX_EXTDIRECTIVES # environment is not set # OPT_GOAL - Controls how the optimizer should optimize for # fastest retrieval. Acceptable values are: # -1 All rows in a query # 0 The first rows in a query # IFX_FOLDVIEW - Enables (1) or disables (0) folding views that # have multiple tables or a UNION ALL clause.
# for each user who needs database # creation privileges. Ensure user # informix is authorized when you # first initialize IDS. # DB_LIBRARY_PATH - Specifies the locations, separated # by commas, from which IDS can use # UDR or UDT shared libraries. If set, # make sure that all directories containing # the blade modules are listed, to # ensure all DataBlade modules will # work.
# LBAC Configuration Parameters ################################################################### # PLCY_POOLSIZE - The maximum number of entries in each hash # bucket of the LBAC security information cache # PLCY_HASHSIZE - The number of hash buckets in the LBAC security # information cache # USRC_POOLSIZE - The maximum number of entries in each hash # bucket of the LBAC credential memory cache # USRC_HASHSIZE - The number of hash buckets in the LBAC credential # memory cache ############################
ENCRYPT_HDR ENCRYPT_SMX ENCRYPT_CDR 0 ENCRYPT_CIPHERS ENCRYPT_MAC ENCRYPT_MACFILE ENCRYPT_SWITCH ################################################################### # Enterprise Replication (ER) Configuration Parameters ################################################################### # CDR_EVALTHREADS - The number of evaluator threads per # CPU VP and the number of additional # threads, separated by a comma.
################################################################### # High Availability Cluster (HDR, SDS, and RSS) # Configuration Parameters ################################################################### # DRAUTO - Controls automatic failover of primary # servers. Valid for HDR, SDS, and RSS.
# Valid for HDR, SDS, and RSS. # FAILOVER_CALLBACK - Specifies the path and program name called when a # secondary server transitions to a standard or # primary server. Valid for HDR, SDS, and RSS. # TEMPTAB_NOLOG - Controls the default logging mode for temporary # tables that are explicitly created with the # CREATE TEMP TABLE or SELECT INTO TEMP statements. # Secondary servers must not have logged temporary # tables. Acceptable values are: # 0 Create temporary tables with logging enabled by # default.
ON_RECVRY_THREADS 1 OFF_RECVRY_THREADS 10 ################################################################### # Diagnostic Dump Configuration Parameters ################################################################### # DUMPDIR - The location Assertion Failure (AF) diagnostic # files # DUMPSHMEM - Controls shared memory dumps.
# RAS Configuration Parameters ################################################################### # RAS_PLOG_SPEED - Technical Support diagnostic parameter. # Do not change; automatically updated. # RAS_LLOG_SPEED - Technical Support diagnostic parameter. # Do not change; automatically updated.
#VPCLASS jvp,num=1 JVPJAVAHOME /IDS/IBM/informix/extend/krakatoa/jre JVPHOME /IDS/IBM/informix/extend/krakatoa JVPPROPFILE /IDS/IBM/informix/extend/krakatoa/.jvpprops JVPLOGFILE /IDS/IBM/informix/jvp.log #JDKVERSION 1.5 JVPJAVALIB /lib/IA64W JVPJAVAVM server #JVPARGS -verbose:jni #JVPCLASSPATH /IDS/IBM/informix/extend/krakatoa/krakatoa_g.jar:/IDS/IBM/informix/ext end/krakatoa/jdbc_g.jar JVPCLASSPATH /IDS/IBM/informix/extend/krakatoa/krakatoa.jar:/IDS/IBM/informix/exten d/krakatoa/jdbc.
Appendix B: Server sqlhost.idsqa sqlhost.idsqa #******************************************************************* # Licensed Material - Property Of IBM # # “Restricted Materials of IBM” # # IBM Informix Dynamic Server # (c) Copyright IBM Corporation 1996, 2004 All rights reserved. # # Title: sqlhosts.demo # Description: # Default sqlhosts file for running demos. # #********************************************************************* ***** # IANA (www.iana.
Appendix C: Client sqlhosts.idsqa #********************************************************************* ***** # # Licensed Material - Property Of IBM # # “Restricted Materials of IBM” # # IBM Informix Dynamic Server # (c) Copyright IBM Corporation 1996, 2004 All rights reserved. # # Title: sqlhosts.demo # Description: # Default sqlhosts file for running demos. # #********************************************************************* ***** # IANA (www.iana.
For more information For additional information, please visit the following sites: HP Partitioning Continuum, http://www.hp.com/go/partitions HP Integrity Servers, http://www.hp.com/go/integrity The HP Partitioning Continuum for HP-UX 11i: Integrity Virtual Machines (Integrity VM), http://h71028.www7.hp.com/enterprise/w1/en/os/hpux11i-partitioning-integrity-vm.html HP Virtual Server Environment (HP Insight Dynamics – VSE for Integrity servers), http://www.hp.
