指定了别名,就可以在目标数据库中用sql语句查询远程表,就像查询任何本地表一样。
Specifying the nickname, the remote table can be queried in SQL statements on the target database like any other local table.
如果QALIAS将一个主题(而不是一个队列)命名为其目标,则打开QALIAS的用户不仅需要拥有别名队列的访问权,还需要拥有对主题的访问权。
If the QALIAS names a topic as its target (rather than a queue), then the user opening the QALIAS must have access to not only the alias queue, but also the topic.
一旦定义QALIAS,就不会对别名的目标进行任何资源安全性检查。
When the QALIAS is defined, there is no resource security check for the target of the alias.
别名目的地还可以用于覆盖在目标目的地中指定的某些值,如缺省可靠性和最大可靠性。
An alias destination can also be used to override some of the values specified on the target destination, such as default reliability and maximum reliability.
注意,查询依赖于为表示特定数据库成员而创建的SQL别名,这些成员是选中目标性能集合所需的。
Note that the queries rely on SQL aliases created to represent the specific database members needed to target the performance collection selected.
请注意,如果您不想为目标服务器上的源数据库使用不同的名称,就不必要添加别名。
Please note that adding this alias is not necessary if you do not want to use a different name for the source database on the target server.
别名是指向非db2的目标而非一个物理表的指针。
A nickname is a pointer to the non-DB2 target rather than a physical table.
推荐:为带有参照完整性约束的别名使用“noload”选项,并在复制管理工具外部装入目标表。
Recommendation: Use the "no load" option for nicknames with referential integrity constraints and load the target table outside of the replication administration tools.
CCD目标表不能是别名。
如果需要QApply程序通过使用EXPORT和IMPORT实用程序执行装入操作,那么由别名所指的目标表就必须为空。
If you want the Q Apply program to perform a load by using the EXPORT and IMPORT utilities, the target table that is referred to by the nickname must be empty.
ReplicationCenter总是为非db2的目标表创建一个新的别名,即使该表已经存在一个或多个别名。
The Replication Center always creates a new nickname for a non-DB2 target table even if one or more nicknames already exist for the table.
asntrep 实用程序则更新别名,使源和目标同步。
The asntrep utility updates the nickname to bring the source and target into synch.
基础设施:在为非db 2目标配置q复制时,会在目标系统上创建多个QApply控制表,并通过别名就像访问目标表一样地访问控制表。
Infrastructure: When you configure Q replication for non-DB2 targets, several Q Apply control tables are created on the target system and accessed through nicknames just as target tables are.
到目标的数据应用:复制需要像属性一样的列(例如,从源表的INTEGERNOTNULL到别名上的INTEGER NOT NULL)。
Application of data to targets: Replication requires columns of like attributes (for example, INTEGER NOT NULL from the source table to INTEGER NOT NULL at the nickname).
换而言之,如果不想在目标服务器上为源ppmt_db数据库提供别名ppmt_db,就不必在源服务器上创建本地别名。
In other words, if you do not mind giving the alias PPMT_DB on the target server for the source PPMT_DB database, then you do not need to create a local alias on the source server.
微指令的别名,以源语言形式或目标代码形式组成微程序。
Another name for the microinstructions that make up a microprogram either in source language or in object-code form.
试验发现,别名探子扫描结果的完整性与目标网络和其他网络连接关系的复杂性有很大关系。
The experiment demonstrates that the completeness of the result of alias scanning relies heavily on the connectivity of the destination network and other networks.
此外,使用多个并行的版本时,版本号码也必须附加至目标型别名称中。
Further, when working with multiple concurrent versions, the version number must also be appended to the target type name as well.
此外,使用多个并行的版本时,版本号码也必须附加至目标型别名称中。
Further, when working with multiple concurrent versions, the version number must also be appended to the target type name as well.
应用推荐