Showing posts with label DB2. Show all posts
Showing posts with label DB2. Show all posts

Wednesday, September 26, 2012

DB2 10.1 High Availability Active Passive on RHEL 5 Update 8 with Tivoli SA MP and RSCT (Reliable Scalable Cluster Technology) Done


Below are the screenshot of the status of DB2 10.1 High Availability Active Passive on RHEL 5 Update 8 with Tivoli SA MP and RSCT (Reliable Scalable Cluster Technology).




Below is the status of DB2 Level and Cluster Manager integration in Instance Configuration:



next screenshot, I will try to Switch Role of Active/Passive Nodes (Current Active Node is rhel58n2 and Passive Node is rhel58n1):


See the Request=Move(Online:O)

We will wait again for few more seconds until the Pending Online status become Online for resource IBM.Application:db2_db2ap_0-rs and IBM.Application:db2_db2ap_0-rs:rhel58n1


And now the final status of the DB2 is Online at rhel58n1, it means that the switchover processes is success.


Finally we will check on rhel58n1 (Node 01 - Active one) the status of current DB2 Database named HADB:




Great..


Note: 
There's a lot of tricky part for doing this correctly, if you do have some problem configuring DB2 HA Active Passive, or wants to just asking questions, I would be glad to help or answer, if I do have time.


- wdanyant -

Tuesday, July 17, 2012

Error “DB2JAVIT : RC = 9505” when starting IBM DB2 Control Center on Windows 7 Platform


After installing IBM DB2 on Windows Platform especially on Windows 7 or Windows Vista Platform, when trying to launch Control Center or some of the IBM DB2 tools, usually you will meet this error “DB2JAVIT : RC = 9505” or don't seem to do anything or not showing at all.


Here is what you need to do to fix this:
Right Click on the launch shortcut and select “Run as administrator”



And then you will successfully run the IBM DB2 Tools such as Control Center:







If on every reboot after installation you get a "SQL5005C System Error", then you should add your user account to the local DB2ADMNS or to the local DB2USERS group. These groups are created during the DB2 installation, but left empty.







- wdanyant -