Cheatsheet: Solaris Express + Solaris Cluster Express + Informix Dynamic Server (IDS) 11. Note: This cheatsheet provides you with the required steps to install IDS 11 ontop of OHAC. For the purpose of simplicity a single node SPARC cluster will be used. Please note that IDS 11 from the open beta program was used. The IDS open beta program closed on 30th July 2007. Within this cheatsheet, IDS will be started, probed and stopped within a global zone and non-global zone. ZFS will be used as the IDS installation directory and the demo database will be used. All commands listed below should be executed from the global zone. If required you will be prompted to zlogin to the non-global zone to issue commands. Useful Links: (No particular order) http://opensolaris.org/os/community/ha-clusters/ohac/Documentation/SCX/ http://www-306.ibm.com/software/data/informix/ http://publib.boulder.ibm.com/infocenter/idshelp/v111/index.jsp http://www.ibm.com/developerworks/forums/dw_forum.jsp?forum=1071&cat=19 http://publib-b.boulder.ibm.com/redpieces/abstracts/sg247465.html?Open 1) Install Solaris Express + Solaris Cluster Express 07/07 ------------------------------------------------------- The following url http://opensolaris.org/os/community/ha-clusters/ohac/Documentation/SCX/ documents "How to install Solaris Cluster Express 7/07" and also "How to install a single node cluster". Install a single node cluster. 2) Create a Zpool/ZFS for IDS 11 ----------------------------- bash-3.00# zpool create informix c4t3d0 c4t4d0 c4t5d0 bash-3.00# zpool list informix NAME SIZE USED AVAIL CAP HEALTH ALTROOT informix 25.1G 60.5K 25.1G 0% ONLINE - bash-3.00# df -k informix Filesystem kbytes used avail capacity Mounted on informix 25933824 1 25933768 1% /informix bash-3.00# 3) Follow "Installing IDS - Quick Start Guide for UNIX/Linux ..." -------------------------------------------------------------- Use the following url, http://publib.boulder.ibm.com/infocenter/idshelp/v111/index.jsp The following steps are just a summary. 3.1) Create an informix user/group ----------------------------- bash-3.00# groupadd -g 500 informix bash-3.00# useradd -g 500 -u 500 -d /informix informix 3.2) Install IDS 11 -------------- Here, we'll install IDS 11 and the demo server onto ZFS /infomix. This will then allow us to simply manage IDS in the global zone and a non-global zone. bash-3.00# cd /SERVER bash-3.00# ./installserver -gui Click "Next" at Welcome to the InstallShield..." Select "I accept license ..." and Click "Next" Enter "/informix" for Directory Name and Click "Next" Select "Typical" and click "Next" Select "No" for roles and Click "Next" Select "Yes" for IDS demo db and Click "Next" Select "Use default config" and Click "Next" Click "Next" for server config parameters Click "Next" for summary Click "Next" for summary after instalaltion Click "Finish" 3.3) Setup (ksh) environment variables --------------------------------- After the installation of IDS 11, the demo database has already been initialized and is running. To issue commands against the demo database you must set some environment variables. sbash-3.00# su - informix Sun Microsystems Inc. SunOS 5.10 Generic January 2005 $ cd demo/server $ . ./profile_settings $ env HOME=/informix HZ=100 INFORMIXDIR=/informix INFORMIXSERVER=demo_on INFORMIXSQLHOSTS=/informix/etc/sqlhosts.demo_on LOGNAME=informix MAIL=/var/mail/informix ONCONFIG=onconfig.demo_on PATH=/informix/bin:/usr/bin: SHELL=/bin/sh TERM=xterm TZ=GB $ 4) Commands to start, probe and stop IDS 11 ---------------------------------------- Here, we will start, probe and stop IDS 11 in the global zone. 4.1) Start IDS 11 ------------ bash-3.00$ oninit -y Your evaluation license will expire on 2008-02-02 00:00:00 bash-3.00$ bash-3.00$ ptree informix 327 /usr/lib/inet/inetd start 11260 /usr/sbin/in.rlogind 11262 -sh 11266 bash 1998 -sh 2005 bash 2044 ptree informix 19175 /usr/sbin/in.rlogind 19177 -sh 24506 bash 5692 -sh 2007 oninit -y 2008 oninit -y 2009 oninit -y 2010 oninit -y 2011 oninit -y 2012 oninit -y 2013 oninit -y 2014 oninit -y 2015 oninit -y 2016 oninit -y 2017 oninit -y bash-3.00$ 4.2) Probe IDS 11 ------------ bash-3.00$ onstat - Your evaluation license will expire on 2008-02-02 00:00:00 IBM Informix Dynamic Server Version 11.10.FB7TL -- On-Line -- Up 00:00:14 -- 29696 Kbytes bash-3.00$ Official database states ------------------------ Offline Quiescent Administration On-Line Read-only Recovery Shutting Down (Other) observed database states from onstat -------------------------------------------- Initialization Single-User Fast Recovery shared memory not initialized for INFORMIXSERVER 'demo_on' Changing data structure forced command termination. Generic System Block: -1 seconds *** WARNING: IBM Informix Dynamic Server is no longer running. *** Blocked status -------------- CKPT LONGTX ARCHIVE MEDIA_FAILURE HANG_SYSTEM DBS_DROP DDR LBU ADMINISTRATION 4.3) Example of a blocked status --------------------------- bash-3.00$ oninit -y Your evaluation license will expire on 2008-02-02 00:00:00 bash-3.00$ bash-3.00$ onmode -c block Your evaluation license will expire on 2008-02-02 00:00:00 bash-3.00$ bash-3.00$ onstat - Your evaluation license will expire on 2008-02-02 00:00:00 IBM Informix Dynamic Server Version 11.10.FB7TL -- On-Line -- Up 00:00:41 -- 29696 Kbytes Blocked:ARCHIVE bash-3.00$ bash-3.00$ onmode -c unblock Your evaluation license will expire on 2008-02-02 00:00:00 bash-3.00$ bash-3.00$ onstat - Your evaluation license will expire on 2008-02-02 00:00:00 IBM Informix Dynamic Server Version 11.10.FB7TL -- On-Line -- Up 00:00:57 -- 29696 Kbytes bash-3.00$ 4.4) Stop IDS 11 ----------- bash-3.00$ onmode -ky Your evaluation license will expire on 2008-02-02 00:00:00 bash-3.00$ bash-3.00$ ptree informix 327 /usr/lib/inet/inetd start 11260 /usr/sbin/in.rlogind 11262 -sh 11266 bash 1998 -sh 2005 bash 2050 ptree informix 19175 /usr/sbin/in.rlogind 19177 -sh 24506 bash 5692 -sh bash-3.00$ 5) Start, probe and stop IDS under a logical host ---------------------------------------------- 5.1) Configure a logical host ------------------------ Note: You should ensure that exists within /etc/hosts and /etc/inet/ipnodes within the global zone. bash-3.00# ifconfig hme0 addif up 5.2) Amend /informix/etc/sqlhosts.demo_on from demo_on ontlitcp 9088 to demo_on ontlitcp 9088 5.3) Start, probe and stop IDS 11 ---------------------------- # su - informix Sun Microsystems Inc. SunOS 5.10 Generic January 2005 $ bash bash-3.00$ cd demo/server bash-3.00$ ls -l total 100225 -rw-rw-r-- 1 informix informix 31157 Aug 7 11:18 online.log -rw-rw---- 1 informix informix 51200000 Aug 7 11:18 online_root -rwxr-xr-x 1 informix informix 220 Aug 6 17:05 profile_settings -rwxr-xr-x 1 informix informix 190 Aug 6 17:05 profile_settings.csh bash-3.00$ . ./profile_settings bash-3.00$ oninit -y Your evaluation license will expire on 2008-02-02 00:00:00 bash-3.00$ bash-3.00$ onstat - Your evaluation license will expire on 2008-02-02 00:00:00 IBM Informix Dynamic Server Version 11.10.FB7TL -- On-Line -- Up 00:00:14 -- 29696 Kbytes bash-3.00$ bash-3.00$ onmode -ky Your evaluation license will expire on 2008-02-02 00:00:00 bash-3.00$ 6) Start, probe and stop IDS 11 in a non-global zone ------------------------------------------------- 6.1) Create a non-global zone ------------------------ bash-3.00# zonecfg -z zone1 zone1: No such zone configured Use 'create' to begin configuring a new zone. zonecfg:zone1> create zonecfg:zone1> set zonepath=/zones/zone1 zonecfg:zone1> set autoboot=true zonecfg:zone1> exit bash-3.00# bash-3.00# zoneadm -z zone1 install Preparing to install zone . Creating list of files to copy from the global zone. Copying <6079> files to the zone. Initializing zone product registry. Determining zone package initialization order. Preparing to initialize <1165> packages on the zone. Initialized <1165> packages on zone. Zone is initialized. Installation of <3> packages was skipped. The file contains a log of the zone installation. bash-3.00# Note: After the zone is configured and installed, you must complete the zone identification. bash-3.00# zoneadm -z zone1 boot bash-3.00# bash-3.00# zlogin -C zone1 [Connected to zone 'zone1' console] 5/122 Complete the "sysidcfg" identification. 6.2) Stop IDS 11 ----------- Here, we need to stop IDS if it's still running. bash-3.00# su - informix Sun Microsystems Inc. SunOS 5.10 Generic January 2005 $ cd demo/server $ ls -l total 100215 -rw-rw-r-- 1 informix informix 26070 Aug 7 10:09 online.log -rw-rw---- 1 informix informix 51200000 Aug 7 10:09 online_root -rwxr-xr-x 1 informix informix 220 Aug 6 17:05 profile_settings -rwxr-xr-x 1 informix informix 190 Aug 6 17:05 profile_settings.csh $ . ./profile_settings $ onmode -ky Your evaluation license will expire on 2008-02-02 00:00:00 $ 6.3) Place the logical host in the non-global zone --------------------------------------------- Note: You should ensure that exists within /etc/hosts and /etc/inet/ipnodes within the non-global zone. bash-3.00# ifconfig hme0:1 zone zone1 6.4) Export/Import the ZFS pool into the non-global zone --------------------------------------------------- bash-3.00# zpool list NAME SIZE USED AVAIL CAP HEALTH ALTROOT informix 25.1G 426M 24.7G 1% ONLINE - bash-3.00# zpool export informix bash-3.00# bash-3.00# zpool import -R /zones/zone1/root informix bash-3.00# zlogin zone1 df -k Filesystem kbytes used avail capacity Mounted on / 14798883 11572400 3078495 79% / /dev 14798883 11572400 3078495 79% /dev /lib 14798883 11572400 3078495 79% /lib /platform 14798883 11572400 3078495 79% /platform /sbin 14798883 11572400 3078495 79% /sbin /usr 14798883 11572400 3078495 79% /usr proc 0 0 0 0% /proc ctfs 0 0 0 0% /system/contract swap 3822320 312 3822008 1% /etc/svc/volatile mnttab 0 0 0 0% /etc/mnttab fd 0 0 0 0% /dev/fd swap 3822056 48 3822008 1% /tmp swap 3843232 21224 3822008 1% /var/run informix 25933746 436505 25497240 2% /informix bash-3.00# 6.5) Create an informix user/group in the non-global zone ---------------------------------------------------- bash-3.00# zlogin zone1 groupadd -g 500 informix bash-3.00# zlogin zone1 useradd -g 500 -u 500 -d /informix informix 6.6) Start, probe and stop IDS 11 in the non-global zone --------------------------------------------------- bash-3.00# uname -n zone1 bash-3.00# su - informix Sun Microsystems Inc. SunOS 5.10 Generic January 2005 $ bash bash-3.00$ cd demo/server bash-3.00$ ls -l total 100232 -rw-rw-r-- 1 informix informix 34622 Aug 7 11:19 online.log -rw-rw---- 1 informix informix 51200000 Aug 7 11:19 online_root -rwxr-xr-x 1 informix informix 220 Aug 6 17:05 profile_settings -rwxr-xr-x 1 informix informix 190 Aug 6 17:05 profile_settings.csh bash-3.00$ . ./profile_settings bash-3.00$ oninit -y Your evaluation license will expire on 2008-02-02 00:00:00 bash-3.00$ bash-3.00$ onstat - Your evaluation license will expire on 2008-02-02 00:00:00 IBM Informix Dynamic Server Version 11.10.FB7TL -- On-Line -- Up 00:00:14 -- 29696 Kbytes bash-3.00$ bash-3.00$ onmode -ky Your evaluation license will expire on 2008-02-02 00:00:00 bash-3.00$ 7) Relocate IDS from the non-global zone back to the global zone ------------------------------------------------------------- Ensure, IDS is stopped before you continue. 7.1) Place the logical host back into the global zone ------------------------------------------------ bash-3.00# ifconfig hme0:1 -zone 7.2) Export/Import the ZFS pool into the non-global zone --------------------------------------------------- bash-3.00# zpool list NAME SIZE USED AVAIL CAP HEALTH ALTROOT informix 25.1G 426M 24.7G 1% ONLINE /zones/zone1/root bash-3.00# bash-3.00# zpool export informix bash-3.00# bash-3.00# zpool import informix bash-3.00# bash-3.00# zpool list NAME SIZE USED AVAIL CAP HEALTH ALTROOT informix 25.1G 426M 24.7G 1% ONLINE - bash-3.00# 7.3) Start, probe and stop IDS 11 in the global zone ----------------------------------------------- bash-3.00# su - informix Sun Microsystems Inc. SunOS 5.10 Generic January 2005 $ cd demo/server $ ls -l total 100239 -rw-rw-r-- 1 informix informix 38087 Aug 7 11:26 online.log -rw-rw---- 1 informix informix 51200000 Aug 7 11:26 online_root -rwxr-xr-x 1 informix informix 220 Aug 6 17:05 profile_settings -rwxr-xr-x 1 informix informix 190 Aug 6 17:05 profile_settings.csh $ . ./profile_settings $ $ oninit -y Your evaluation license will expire on 2008-02-02 00:00:00 $ onstat - Your evaluation license will expire on 2008-02-02 00:00:00 IBM Informix Dynamic Server Version 11.10.FB7TL -- On-Line -- Up 00:00:19 -- 29696 Kbytes $ $ onmode -ky Your evaluation license will expire on 2008-02-02 00:00:00 $