How to use large BLOB/CLOB in HADR

Currently working on a Webspere Business Monitor application integrating with DB2 9.5 on Linux. I've made a few observations.One that is interesting , particuarly as Webspere Business Monitor uses BLOBs\CLOBs, relates to HADR and BLOB\CLOB replication. Database logs are used in HADR , for replicating the Primary database to the Standby database.The Primary database will support non-logged operations , such as changes to the configuration, changes to the recovery history file and BLOBs\CLOBs .But the problem - is that large BLOBs\CLOBs , which cannot be logged - cannot be replicated. Insert, update, delete operations performed on a table with CLOBs\BLOBs... Read more →

Tivoli Storage Automation for Multiplatforms(SA MP) and the shared disk approach

SA MP is defined as a highly available cluster – that uses various monitoring methods to detect availability and rules to define what actions to complete in order to correct a failure. SA MP can be implemented in two ways: 1)Shared disk approach 2)SA MP with Highly available disaster recovery – (HADR) (shared nothing approach) In the shared disk approach ,the databases will be located on a shared disk. The disk is shared by two servers. If failure occurs the other node will assign the virtual IP to the network adapter , mount the shared disk and start the DB2... Read more →