The example in Listing 2 connects to the test database and creates two tables.

清单2中的例子连接到测试数据库并创建了两个表。

youdao

To determine which tables in a database have page-level locking and need to be modified to row-level locking, I use a helpful SQL script: genlockmod.sql (see Listing 1).

为了确定数据库中的哪些表具有页面级锁定以及需要修改为行级别锁定，我使用了一段sql脚本：genlockmod . sql(参见清单1)。

youdao

Listing 7 shows how to use the db2pd utility to get this information for all indexes on all tables in a database.

清单7显示了如何使用db 2 pd实用程序为数据库中的所有表上的索引获取该信息。

youdao

The SQL command to obtain this list varies from database to database, The script in Listing 18 uses MySQL's SHOW TABLES command, but this is not portable across different RDBMS.

获取此列表的SQL命令随数据库的不同而有所不同，清单18中的脚本使用MySQL的SHOWTABLES 命令，但是这并不能在不同的 RDBMS 之间移植。

youdao

Deploy these tables into the sample database using the DDL shown in Listing 1 on the local DB2 server, and load some sample data, as shown in figures 2.1 and 2.2.

使用清单1中的DDL，将这些表部署到本地DB 2服务器上的示例数据库中，并装载一些示例数据，如图2.1和2.2所示。

youdao

Also of note in Listing 7 are the and <table-column> elements for your entity beans, where you must configure which database tables and columns map to the entity bean fields.

在清单7 中还需注意实体bean的 和 column>元素，在此必须配置哪些数据库表和列映射到实体bean字段。

youdao

The script vc_candidates.sql can be used to find all tables in a database that would benefit from the alternate row format of value compression. To execute the script, enter the commands in Listing 5.

脚本vc _ candidates. sql可用于发现数据库中所有能从值压缩行格式中受益的表。

youdao

Looking at the underlying database, I see nothing but the tables I'd expect to see, as shown by the output of the MySQL show tables command in Listing 7.

查看一下底层数据库，我只看到了期望看到的表，如清单7中的MySQLshowtables命令的输出所示。

youdao

Looking at the underlying database, I see nothing but the tables I'd expect to see, as shown by the output of the MySQL show tables command in Listing 7.

查看一下底层数据库，我只看到了期望看到的表，如清单7中的MySQLshowtables命令的输出所示。

youdao