The article USES modified TPoX tables created using the DDL shown in Listing 1.
本文使用修改后的tpox表,这些表使用清单1所示的DDL创建。
Click on Test connection to verify that you can connect to the DB2 TPOX database.
单击testconnection以验证是否可以连接到DB 2TPOX数据库。
For testing simplicity, the target data warehouse database is also configured to be TPoX.
为简化测试,目标数据仓库数据库也配置为TPoX。
For testing simplicity, the target data warehousing database is also configured to be TPOX.
为了简化测试过程,存储目标数据的数据库也配置为TPOX。
This includes the instance type (DB2), database name (TPOX), and a valid user id and password.
这包括实例类型(DB2)、数据库名(TPOX)以及有效的用户ID和密码。
The DB2 TPOX database already contains source and target tables, so you need to import metadata about these tables into DataStage.
DB 2TPOX数据库已经包含源和目标表,因此您需要将关于这些表的元数据导入到DataStage。
If you already have a database named TPOX on your server, this script drops the database and recreates it with new database objects.
如果在您的服务器上已经有名为TPOX的数据库,这个脚本会删除它并用新的数据库对象重新创建它。
For this scenario, specify that you intend to work against an online database, and select the TPoX database connection when prompted.
对于本场景,指定需要在一个在线数据库上操作,出现提示时选择TPoX数据库连接。
Click on the Test connection option in the upper right corner of this window to verify that you can connect to the DB2 TPOX database.
在该窗口的右上角单击testconnection选项,检查是否已经连接到DB 2TPOX数据库。
Enter the appropriate details for the connection, including the instance type (DB2), database name (TPOX), and a valid user id and password.
输入相应的连接细节,包括实例类型(DB2)、数据库名(TPOX)以及有效的用户ID和密码。
To simplify the sample scenarios in this article, we use a single DB2 database (named "TPOX") to store both the operational data and the warehouse data.
为了让本文的样例场景保持简单,我使用一个简单的DB 2数据库(名为“TPOX”)来存储运营数据和仓库数据。
Transaction Processing over XML (TPoX) is an application-level XML database benchmark based on a financial application scenario, specifically security trading.
TransactionProcessingoverXML (TPoX)是一个基于金融应用程序场景(特别是有价证券交易)的应用程序级别的XML数据库基准。
For simplicity, the sample queries in this article ignore the namespaces that are present in the TPoX XML data. (for more information about TPoX, see Resources.)
为了简单起见,本文的样例查询忽略了TPoXXML数据中的名称空间(更多有关TPoX的信息,请参见参考资料)。
This article uses a slightly modified form of the TPoX benchmark to show various options available in the XML guidelines infrastructure to influence optimizer plans.
本文使用一个经过轻微修改的TPoX基准来展示XML准则基础设施中可以用来影响优化器计划的各种选项。
This article uses a slightly modified form of the TPoX benchmark to show various options available in the XML guidelines infrastructure to influence optimizer plans.
本文使用一个经过轻微修改的TPoX基准来展示XML准则基础设施中可以用来影响优化器计划的各种选项。
应用推荐