执行删除语句,数据量太大,报错
The transaction log for the database is full.. SQLCODE=-964, SQLSTATE=57011, DRIVER=3.61.75
日志满了,可以调大
一、查看配置
$ db2 get db cfg for dbName
日志文件大小(4KB)
Log file size (4KB) (LOGFILSIZ) = 1800(可以修改)
主日志文件的数目
Number of primary log files (LOGPRIMARY) = 30(可以修改)
辅助日志文件的数目
Number of secondary log files (LOGSECOND) = 20(可以考虑修改)
二、修改配置
db2 update db cfg for dbName using LOGFILSIZ 10240
db2 update db cfg for dbName using LOGPRIMARY 30
db2 update db cfg for dbName using LOGSECOND 20
三、重启数据库
db2 force application all(断掉所有连接)
db2stop
#db2stop force
db2start
相关推荐
在执行增删改语句(产生事务日志)的过程中提示,The transaction log for database ‘***’ is full due to ‘REPLICATION'(数据库“***”的事务日志已满,原因为“REPLICATION”). CDC以及复制的基本原理粗略地讲...
For example, if you defer constraint checking, it is your responsibility to ensure that the database is consistent. Isolation Concurrent transactions are isolated from the updates of other incomplete...
I enhanced the underlying framework for handling passive task processing to be named more intuitively and to have additional events at the TIB_Session level to tap into things happening at the ...
Select Created, Log_Mode, Log_Mode From V$Database; 四、ORACLE用户连接的管理 用系统管理员,查看当前数据库有几个用户连接: SQL> select username,sid,serial# from v$session; 如果要停某个连接用 SQL> ...
Software for the New Century 2. A Tour of SQL Server [加入我的離線書架] . The SQL Server Engine . DBMS-Enforced Data Integrity . Transaction Processing . Symmetric Server Architecture . Security...
creates MS SQL Server & Azure database backups, ...Makes full, differential or transaction log backups, runs custom scripts, backs up file folders, allows viewing of the results on the web and more.
只有行锁将用于SELECT FOR UPDATE, 但在更新时将获取表锁。 值范围: ALWAYS | DEFAULT | INTENT 默认值: ALWAYS shared_servers 说明 : 指定在启动例程后, 要为共享服务器环境创建的服务器进程的数量。 值范围: ...
缩减日志空间时使用 dump 和 load transaction .......... 137 使用 for load 选项进行数据库恢复 .......... 143 使用 create database 的 with override 选项 .......... 144 更改数据库所有权 .......... 145 ...
SELECT 'Original Size of ' + db_name() + ' LOG is ' + CONVERT(VARCHAR(30),@OriginalSize) + ' 8K pages or ' + CONVERT(VARCHAR(30),(@OriginalSize*8/1024)) + 'MB' FROM sysfiles WHERE name = @...
SELECT 'Original Size of ' + db_name() + ' LOG is ' + CONVERT(VARCHAR(30),@OriginalSize) + ' 8K pages or ' + CONVERT(VARCHAR(30),(@OriginalSize*8/1024)) + 'MB' FROM sysfiles WHERE name = @...
SELECT 'Original Size of ' + db_name() + ' LOG is ' + CONVERT(VARCHAR(30),@OriginalSize) + ' 8K pages or ' + CONVERT(VARCHAR(30),(@OriginalSize*8/1024)) + 'MB' FROM sysfiles WHERE name = @...
imp cssdj/cssdj@zr fromuser=cssdj_zsy touser=cssdj file=d:/cssdj.cmp log=d:/cssdj.log 2.1.7.3 数据泵 2.1.8 Dblink 2.1.8.1 创建 create database link orcllink connect to cssdj identified by cssdj using...
Using Log4J ............................................................................................. 14 II. What’s New in Spring Framework 4.x ......................................................
Using Log4J ............................................................................................. 14 II. What’s New in Spring Framework 4.x ......................................................
EXP_FULL_DATABASE, IMP_FULL_DATABASE这两个角色用于数据导入导出工具的使用。 自定义角色 Oracle建议我们自定义自己的角色,使我们更加灵活方便去管理用户 创建角色 SQL> create role admin; 授权给...