Re: ISM on Informix 7.3UC8

Benny, ism installation is pretty straightforward and extremely simple if you go by the article attached below....I suggest you remove the following two directories /nsr and $INFORMIXDIR/ism and start from scratch with an ism_startup -init...;-)...if you yet have problems post the errors. --Anil Karkera Title: INFORMIX STORAGE MANAGER (ISM) 7.3 INSTALL/CONFIGURATION The following is an example of setting up ISM going to disk in 7.3 version. It is also documented in the release notes: $INFORMIXDIR/release/en_us/0333/SERVERS_7.3 INFORMIX STORAGE MANAGER INSTALLATION AND CONFIGURATION ========================================================== ISM Setup Procedure on UNIX Database Servers ============================================ The following shell script provides the minimum setup required for ISM operations with ON-Bar. You must edit the locations for SM_DISKDEV1 and SM_DISKDEV2 as needed. Two of the operations must be done as root (or informix) as shown in the script comments below: echo "ISM setup begins" # the user must edit these two lines to # select appropriate disk locations for # storage manager use. setenv SM_DISKDEV1 /some/place/on/disk/dir1 setenv SM_DISKDEV2 /some/place/on/disk/dir2 # update storage manager version in sysutils echo "1|1.0.1|ism|1|" >> $INFORMIXDIR/etc/sm_versions userid informix dbaccess sysutils - <<EOF_UTIL load from '$INFORMIXDIR/etc/sm_versions' insert into bar_version; EOF_UTIL # start networker server echo "initialize ISM server, must be done as root" ism_startup -init echo "give test user ISM admin permissions, must be done as root" ism_add -admin $USER # we need to create some devices/media etc echo "create and mount ISM devices and pools" ism_add -device $SM_DISKDEV1 -type file ism_add -device $SM_DISKDEV2 -type file ism_op -label $SM_DISKDEV1 -pool ISMData -volume ISMData ism_op -label $SM_DISKDEV2 -pool ISMLogs -volume ISMLogs ism_op -mount $SM_DISKDEV1 ism_op -mount $SM_DISKDEV2 echo "end of ISM setup" ISM Setup Procedure on NT Database Servers ========================================== Requirement: ----------- The Netware IPX and SPX networking protocols should be installed and enabled on the computer where Informix Dynamic Server is installed. Script for Minimum SETUP and STARTUP ------------------------------------ The following batch file provides the minimum setup required for ISM operations with ON-Bar. This batch file will configure two devices, both of file type, to back up logical logs and dbspaces. This will allow you to back up logical logs and dbspaces to disk. You must edit the locations for SM_DISKDEV1 and SM_DISKDEV2 as needed. The operations must be done as user informix. REM setup for Informix Storage Manager echo "ISM setup begins" REM the user must edit these two lines to REM select appropriate disk locations for REM storage manager use. set SM_DISKDEV1=\\some\\place\\on\\disk\\dir1 set SM_DISKDEV2=\\some\\place\\on\\disk\\dir2 echo "give test user ISM admin permissions" ism_add -admin %USERNAME% REM we need to create some devices and media echo "create and mount ISM devices and pools" ism_add -device %SM_DISKDEV1% -type file ism_add -device %SM_DISKDEV2% -type file ism_op -label %SM_DISKDEV1% -pool ISMData -volume ISMData ism_op -label %SM_DISKDEV2% -pool ISMLogs -volume ISMLogs ism_op -mount %SM_DISKDEV1% ism_op -mount %SM_DISKDEV2% echo "end of ISM setup" Setup with ISM Administrator GUI ================================ If the Informix Enterprise Command Center component of the Informix Dynamic Server is also installed, you can configure the devices with the ISM GUI. To start the ISM GUI, type at the command line: start ism /s localhost To configure a device: a) Create a device: Select "New" from the "Devices" menu. Alternatively, type <CNTRL> + N. Enter the name of the backup location. This should be a directory if the backup device is of type file. Select "file" for the type of device and click <OK>. b) Label the device: Select the device and select "Label" from the "Volume" menu. Alternatively, type <CNTRL> + L. Select the pool to which the device should belong (ISMData for dbspaces, ISMLogs for logical logs). Set the volume number and click <OK>. c) Mount the device: Select the device and select "Mount" from the "Volume" menu. Alternatively, type <CNTRL> + M. ISM Configurations Not Using ISMData Pool ----------------------------------------- The onbar script invokes ism_catalog to back up the ISM bootstrap after successful ON-Bar logical-log and storage space backups. This ism_catalog invocation explicitly selects the ISMData pool for storing the ISM bootstrap. On UNIX, the command in the onbar script is as follows: ${INFORMIXDIR}/bin/ism_catalog -create_bootstrap -pool ISMData On Windows NT, the command in the onbar.bat script is as follows: %ISMDIR%\\bin\\ism_catalog -create_bootstrap -pool ISMData If you configure ISM and ON-Bar without a ISMData pool device, you will need to edit the onbar (on UNIX) or onbar.bat (on NT) scripts to direct ism_catalog to some other existing pool, such as ISMDiskData. On UNIX, the ism_catalog line of the onbar script would be as follows: ${INFORMIXDIR}/bin/ism_catalog -create_bootstrap -pool ISMDiskData On Windows NT, the change in onbar.bat would be as follows: %ISMDIR%\\bin\\ism_catalog -create_bootstrap -pool ISMDiskData If the onbar script ism_catalog invocation selects a non-existent storage pool, ON-Bar will seem to hang and a message will appear in the ISM log that an operation is waiting for ISMData pool to be mounted. For more information, see the documentation notes for ON-Bar in ONBARDOC_7.3. Do Not Use Rewind Devices with ISM ================================== The ISM Administrator Guide, on page 3-6, mentions that ISM writes a file mark at