Product:                  RFIDIC 
Platform:                 RFIDIC v1.1.0.3, Redhat linux AS 4 update 6, Informix Dynamic Server v10, WAS Express 6.0.2 
Date:                     26 August 2008

Description:
------------

PMR: 27315,999,000: Issue with rootdbs dbspace when using Informix


Package contents:
-----------------

Filename                               Description 
----------------------------------------------------------------------
README.txt                             This Readme file
com.ibm.rfidic.utils.db.jar	       JAR file
com.ibm.rfidic.utils.server.jar	       JAR file
RFIDICServer.jar                       JAR file
com.ibm.rfidic.metadata.jar            JAR file


Installation Instructions:
--------------------------


Instructions for deploying new JAR file:
  1. Log in to the system are root.
  2. Ensure that you have 4 patch jars required for the fix:
	a) com.ibm.rfidic.utils.db.jar
	b) com.ibm.rfidic.utils.server.jar
	c) RFIDICServer.jar
        d) com.ibm.rfidic.metadata.jar
  3. cd to the RFIDIC Home Directory/lib.
  4. Move a backup copy of the original jar files into a temporary directory. (Move the files instead of renaming them.)
  5. Copy the new files into the lib directory.
  6. Create database space (see Test Step 1 below). 
  7. Login as rfidic.
  8. Configure RFIDIC to use this space (see Test Step 2 below).
  9. Restart the server.
  10. Redeploy with the script (see Test Step 3 below).
  11. Cross verify that the tables are created in the newly created DBSpace. 



Test and Usage Instructions:
----------------------------

  1. Create the database space.

    The example below would create a small (10MB) DB space. 
      touch $DBSPACEDIR/MySpace 
      chmod 660 $DBSPACEDIR/MySpace
      chown -R informix $DBSPACEDIR/MySpace
      chgrp -R informix $DBSPACEDIR/MySpace
      $INFORMIXDIR/bin/onspaces -c -d MySpace -p $DBSPACEDIR/MySpace -o 0 -s 102400


  2: Configure RFIDIC to use this DB space. Change RFIDICServer.xml to add the DBTableSpace tag. If it's not present we will use the default/root db           space.

    <WASCapture enabled="true">
         [...]
  	    <StoreCapturedXML>true</StoreCapturedXML>
  	    <EnableAlerts>true</EnableAlerts>
            <DBTableSpace>MySpace</DBTableSpace>
      </WASCapture>


  3: Redeploy with the "deployMetadata.sh -force_drop_tables" script. All data is lost, per the customer's approval. 

  CAUTION - This step will erase all the data!!


Verification Instructions:
----------------------------

  1. > SELECT tabname, partnum , tabtype FROM informix.SYSTABLES where tabname='event';
  2. Use the partnum value for the entry with table type=T and and replace <tblspace_num> in this query with partnum and run it
  3. > SELECT DBINFO ('dbspace',<tblspace_num>) FROM informix.SYSTABLES where tabname='event' AND tabtype='T';