处理在将旧分区中的行转移到新表分区时因alter操作而生成的DML日志记录。
Process DML log records generated due to an alter operation while moving the rows from the old partition to the new table partition.
有时候应用程序需要从给定表中删除所有的记录,以便清空日志记录或者装入新的一个月的销售数据。
Sometimes an application needs to delete all records from a given table to clean up a log or reload sales data for a new month.
注意:在清单14中,sales_fact表是通过单独一个事务填充完成的,这需要占用大量的磁盘空间来记录日志。
Note: in Listing 14, the SALES_FACT table is populated in a single transaction, which will require a large amount of disk space for logging.
在数据库处于循环日志记录模式时,单个表空间的备份不受支持。
Backing up individual table Spaces is not supported while the database is in circular logging mode.
表1比较不同架构和日志记录设置下的性能。
Table 1 compares the performance based on different architectures and logging Settings.
当出现表空间脱机以及对没有被写入硬盘的事务补偿日志记录时,就可能触发这种状态。
The state is triggered by conditions that result from a table space going offline and compensation log records for a transaction not being written.
对全局临时表的一个通用扩展,允许没有日志记录的临时表完全脱离事务控制。
A general extension to global temporary tables, which allows temporary tables that are not logged to be completely taken out of transaction control.
DB 2V8.2.2中这种新的DELETE算法可以显著减少与mdc表中行及其相应的块索引的删除相关的日志记录和处理。
This new DELETE algorithm in DB2 V8.2.2 can drastically reduce the logging and processing associated with the deletion of rows in an MDC table and its corresponding block indexes.
您可以在数据库上启用归档日志记录模式,并开始联机备份数据库以及备份数据库中的一组表空间。
You can enable archive logging mode on the database and start taking online backups of the database as well as backups of a set of table Spaces in the database.
此外,如果您使用数据复制,CAPTURE程序可以将日志中所记录的更新写到更改表。
In addition, if you are using data replication, the CAPTURE program can write the updates recorded in the logs to the change table.
为了避免分析重复的记录,从checking表中删除时间戳大于一个指定的、用于修剪日志的时间戳的行。
To avoid analyzing duplicate records, you delete rows from the CHECKING table with a timestamp greater than the one you pruned the pruned the audit log with.
但是填充staging表(更改表)和在日志中记录这些事务则需要数据库资源。
But the population of the staging tables (change tables) and the logging of these transactions require database resources.
如果这些字符串相匹配,通过logger函数把这个事件记录在另一个mysql表中作为日志,并且生成一个新的会话id。
If these strings match, this event is logged to another MySQL table via the logger function and a new session ID is generated.
除了wells _ pts表之外,再创建一个用于日志记录的wells_err表。
Along with the wells_pts table, create a wells_err table for logging purposes.
定时按规定巡视抄表,记录,做好工作日志。
Periodically inspect and record the meter, well done the logbook accoding to the regulations.
这个选项允许绕过日志记录机制,但是会使这个表无法通过前滚操作恢复。
This option allows logging to be bypassed, but makes the table unrecoverable with a roll forward operation.
记录问题:对每个提出的问题,获取表2中列出的信息,记录到问题日志上。
Record Issues: Capture the information in Table 2 on the Issue Log for each issue raised.
记录表上(或在航海日志),并作记录存储必要的信息。
Record the necessary information on the sheet (or in a log book) and store for your records.
通过合理的数据库表结构的设计以及对业务流程的详细分析,实现了质量文件的分级下发以及日志记录。
Through the rational design of the database structure and the detailed analysis of business processes to achieve the quality classification of documents issued, and logging.
传统的数据库一般地在从日志表中生成摘要表这方面的表现不怎么好,因为在这种情况下,行记录锁几乎没用。
Transactional database systems in general are not very good at generating summary tables from log tables, because in this case row locking is almost useless.
传统的数据库一般地在从日志表中生成摘要表这方面的表现不怎么好,因为在这种情况下,行记录锁几乎没用。
Transactional database systems in general are not very good at generating summary tables from log tables, because in this case row locking is almost useless.
应用推荐