自动客户端重新路由 [英] Automatic client reroute

问题描述

我有几个关于设置自动客户端重新路由的问题。

首先，在为数据库设置备用服务器之后，是否有一种

方式来验证设置稍后的？接下来我已经为我的HADR对添加了

这些值，但我不确定我是否正确测试了基本的

功能。我连接到主服务器，然后发出一个

交换机角色接管，然后尝试继续运行针对

数据库的SQL（我也试过连接到现在停用

数据库）。在所有情况下，我仍然得到SQL30081错误，所以

显然做错了。


谢谢，

Lisa

解决方案

< hu *********** @ gmail.comwrote in message

news： 85 ********************************** @ e23g2000 prf.googlegroups.com ...
< blockquote class =post_quotes>
>我有几个关于设置自动客户端重新路由的问题。

首先，在为数据库设置备用服务器之后，是否有一个

以后验证设置的方法？接下来我已经为我的HADR对添加了

这些值，但我不确定我是否正确测试了基本的

功能。我连接到主服务器，然后发出一个

交换机角色接管，然后尝试继续运行针对

数据库的SQL（我也试过连接到现在停用

数据库）。在所有情况下，我仍然得到SQL30081错误，所以

显然做错了。


谢谢，

Lisa

您如何提交SQL语句？使用类型2驱动程序或键入4

驱动程序？

我现在正在使用类型2（虽然稍后，将需要使用

type-4）。谢谢。


12月10日晚上11点07分，马克A < nob ... @ nowhere.comwrote：

< hummingbir ... @ gmail.comwrote in message


新闻：85 ********************************** @ e23g2000 prf.googlegroups.com ...

我有几个关于设置自动客户端重新路由的问题。

首先，在为数据库设置备用服务器之后，是否有一个

以后验证设置的方法？接下来我已经为我的HADR对添加了

这些值，但我不确定我是否正确测试了基本的

功能。我连接到主服务器，然后发出一个

交换机角色接管，然后尝试继续运行针对

数据库的SQL（我也试过连接到现在停用

数据库）。在所有情况下，我仍然会得到SQL30081错误，因此显然做错了。
显然做错了。

谢谢，

Lisa

你好吗？提交SQL语句？使用2型驱动程序或键入4

驱动程序？

< hu *********** @ gmail.comwrote in message

news：34 ********************************** @ y5g2000h sf.googlegroups.com ...

>我现在正在使用type-2（虽然稍后会需要使用

type-4）。谢谢。

如果你执行db2 list db directory在您的客户端上，它将显示从上次客户端成功连接到主数据库的
后的备用服务器信息。如果信息不正确，那么

是错误的。


当你开始使用类型4时，事情会变得有点复杂，因为， />
虽然备用服务器信息在

连接时返回给客户端，但它不会保留在任何地方供客户端使用，除非

客户端保存它在某个地方。你将不得不做一些研究如何使用

自动客户端重新路由与类型4连接。版本9驱动程序可能会比版本8提供一些改进，但我不能确定这一点。

I have a couple questions about setting up automatic client reroute.
First, after setting the alternate server for a database, is there a
way to verify the settings later on? The next thing is I''ve added
these values for my HADR pair, but I''m not sure I''m testing the basic
functionality correctly. I connect to the primary, then issue a
switch role takeover, then attempt to continue running SQL against the
database (I''ve also tried a connect with the now deactivated
database). In all cases, I still get the SQL30081 error, so have
obviously done something wrong.

Thanks,
Lisa

解决方案

<hu***********@gmail.comwrote in message
news:85**********************************@e23g2000 prf.googlegroups.com...

>I have a couple questions about setting up automatic client reroute.
First, after setting the alternate server for a database, is there a
way to verify the settings later on? The next thing is I''ve added
these values for my HADR pair, but I''m not sure I''m testing the basic
functionality correctly. I connect to the primary, then issue a
switch role takeover, then attempt to continue running SQL against the
database (I''ve also tried a connect with the now deactivated
database). In all cases, I still get the SQL30081 error, so have
obviously done something wrong.

Thanks,
Lisa

How are you submitting the SQL statements? Using type 2 driver or type 4
driver?

I am using type-2 right now (although later on, will need to use
type-4). Thanks.

On Dec 10, 11:07 pm, "Mark A" <[e-mail]:

<[e-mail] in message

news:85**********************************@e23g2000 prf.googlegroups.com...

I have a couple questions about setting up automatic client reroute.
First, after setting the alternate server for a database, is there a
way to verify the settings later on? The next thing is I''ve added
these values for my HADR pair, but I''m not sure I''m testing the basic
functionality correctly. I connect to the primary, then issue a
switch role takeover, then attempt to continue running SQL against the
database (I''ve also tried a connect with the now deactivated
database). In all cases, I still get the SQL30081 error, so have
obviously done something wrong.

Thanks,
Lisa

How are you submitting the SQL statements? Using type 2 driver or type 4
driver?

<hu***********@gmail.comwrote in message
news:34**********************************@y5g2000h sf.googlegroups.com...

>I am using type-2 right now (although later on, will need to use
type-4). Thanks.

If you do a "db2 list db directory" on your client, it will show the
alternate server info from the last time the client successfully connected
to the primary database. If the information is not correct, then something
is wrong.

When you start using type 4, then things get a bit more complicated since,
although the alternate server information is returned to the client upon
connection, it is not persisted anywhere for use by the client, unless the
client saves it somewhere. You will have to do some research on how to use
Automatic Client Reroute with a type 4 connection. The version 9 driver may
offer some improvements over version 8, but I am not 100 sure about that.

这篇关于自动客户端重新路由的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！