PWH.DATABASE for database snapshot data.
DATABASE针对数据库快照数据。
The following are the most pertinent lines in the database snapshot.
以下是数据库快照中最相关的几行。
You can then leverage the database snapshot to identify the sort activities at the database level.
然后,您可以利用数据库快照来确定数据库层的排序活动。
A database snapshot is a read-only offline copy of a database, and is not related to a replication snapshot.
数据库快照是数据库的只读脱机副本,与复制快照无关。
You can use the database snapshot to determine whether the LOGBUFSZ database parameter is optimal by viewing the following snapshot elements.
您可以通过查看下列快照元素,使用数据库快照来确定LOGBUFSZ数据库参数是否是最优的。
These tools include Cluster Visualization and Snapshot Visualization run-time graphs which are stored in a database for offline view at a later time.
这些工具包括集群可视化和对运行状态快照的可视化图表,这些图表存储在数据库中以便之后可以离线浏览。
The lock snapshot includes database summary information, application information and, of course, the lock information.
锁快照包含数据库摘要信息、应用程序信息,当然还有锁信息。
Use the database system monitor to help you tune this configuration parameter using information from the snapshot data (or event monitor) about write activity from a buffer pool.
使用数据库系统监视器,利用有关从缓冲池进行写操作的快照数据(或事件监视器)信息来帮助您调优该配置参数。
From the table space snapshot data, the used page objects can be used to tell the total size of the index, tables, and the total database size.
从表空间快照数据中可以看出,这些用过的页面对象可用于告知索引、表和数据库的总大小。
A split mirror of a DB2 UDB database can be initialized as a snapshot of the source database, essentially an instantaneous clone of the source database.
DB 2UD b数据库的分割镜像可以被初始化为源数据库的一个快照,实质上是源数据库的一个瞬时克隆。
This option is only useful for a database level health snapshot since that’s the only level at which collection health indicators are defined.
这个选项只能用在数据库级的健康快照中,因为集合健康指示器只在这一级别上定义。
We are now ready to export the data from the NEWSTAFF table, and to simultaneously capture a database lock snapshot.
现在我们已经准备就绪,可以从newstaff表导出数据,并同步捕获数据库锁快照了。
A database complicates the matter, because it caches some disk writes, which may result in an inconsistent snapshot.
数据库使问题复杂化,因为它缓存了一些磁盘写操作,这可能会生成一个不一致的快照。
Once you have created similar XML documents for every table within a database, you'll have a complete snapshot of the database.
为数据库中的每个表创建了类似的XML文档后,您就拥有了整个数据库的快照。
For example, a lock snapshot captures and returns database lock information.
例如,锁快照捕获并返回数据库锁信息。
A snapshot of the run data needs to include both the database data and the transaction logs.
运行数据的快照需要包括数据库数据和事务日志。
The Business Process Database is not intended to be used as an 'audit store' because of performance impacts and that there is only a snapshot and no complete history.
由于性能影响以及仅存在快照并且没有任何完整历史记录,因此,业务流程数据库不适于用作“审核存储”。
Database activity based on DB2 snapshot data.
基于DB 2快照数据的数据库活动。
Image shows snapshot of failed command on what database it has been executed with start and end time of execution.
图像显示失败的命令的快照,其中显示命令在什么数据库上执行,以及执行的起始和结束时间。
Anytime during a run, you can use the following command to get the snapshot data for database manager.
在运行期间的任何时候,您都可以使用下面这个命令来获取数据库管理器的快照数据。
The following example shows how to select health indicator information for db.spilled_sorts for the SAMPLE database as a global snapshot.
下面的例子显示了如何以全局快照的方式为SAMPLE数据库的db . spilled_sorts选择健康指示器信息?
Perl scripts are provided to help you collect and analyze the DB2 snapshot data and to provide hints to improve database performance.
本文提供了perl脚本来帮助您收集和分析DB 2快照数据以及提供提示以提高数据库性能。
The GET HEALTH SNAPSHOT command is similar to the GET SNAPSHOT command and can be used globally, for specific database partitions. The syntax for this command is shown in Figure 17
GETHEALTHSNAPSHOT命令与 GET SNAPSHOT 命令相似,并且可以在特定的数据库分区上全局使用。
If you want to start using migrations with an existing database, you can snapshot your existing schema with rake schema_dump.
如果想对现有数据库使用迁移,可以用rake schema_dump对现在的模式做个快照。
For example, running a file system copy while the database is running won't give you a snapshot for your database for a particular point in time (PIT).
例如,如果数据库在运行,那么执行文件系统复制操作时将得不到即时点(pointintime,PIT)上数据库的快照。
As an example, try using the BANK database to take a snapshot. From the DB2 command window, issue the commands as shown here.
例如,尝试使用BANK数据库来获取快照。
Take a database manager snapshot: db2 get snapshot for dbm
截取一个数据库管理器快照:db2getsnapshotfor dbm
The snapshot retrieves the health status information for the database manager and its objects.
快照可以为数据库管理器及其对象检索健康状态信息。
There are two primary tools, each serving a different purpose, with which you can access database monitor information: the snapshot monitor and event monitors.
有两个主要工具,用途不一,有了它们您就可以访问数据库监控信息:快照监控器和事件监控器。
Figure 1 contains a snapshot of the database structure, along with a few records.
图1包含了数据库结构的屏幕快照,其中包含一些记录。
应用推荐