If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > HADR Connectivity

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-17-08, 21:27
koganti koganti is offline
Registered User
 
Join Date: Jul 2002
Location: ATL
Posts: 170
HADR Connectivity

Is is possible to connect to secondary server and access the data in HADR configuration.
What kind of user activity not allowed on secondary server. I tried to search the IBM document and i dont have any luck finding the info yet.

Thx
koganti
Reply With Quote
  #2 (permalink)  
Old 12-17-08, 21:40
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,196
No, a connection cannot be made to a HADR standby database. IBM says that it understands that customers would like select-only access to the HADR standby database, and that it might be available in some future release of DB2.

However, when you have a physical server that only contains one or more HADR standby databases (except for occassional takeovers that are necessary for high availability and/or maintenance) you only need to have 100 PVU (processor value units) worth of DB2 licenses on the standby server, regardless of the number of actual CPU's or cores on the server. 100 PVUs is equivlient to 1 dual-core Intel CPU. If read access is allowed, that is likely to change.
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On