IT培训教育数据库

难道建立一个索引,也会产生大量的日志?

系统没有人访问,只是新建了一个索引create index pk_order_line on order_line (ol_w_id, ol_d_id, ol_o_id, ol_number)DB21034E  The command was processed as an SQL statement because it was not a valid Command Line Processor command.  Dur...显示全部

系统没有人访问,只是新建了一个索引

create index pk_order_line on order_line (ol_w_id, ol_d_id, ol_o_id, ol_number)

DB21034E  The command was processed as an SQL statement because it was not a

valid Command Line Processor command.  During SQL processing it returned:

SQL0964C  The transaction log for the database is full.  SQLSTATE=57011

收起
参与5

查看其它 1 个回答wangdehao的回答

wangdehaowangdehao数据库管理员IBM

跟日志参数设置和表的大小都有关系

软件开发 · 2016-08-01
浏览961

回答者

wangdehao
数据库管理员IBM

wangdehao 最近回答过的问题

回答状态

  • 发布时间:2016-08-01
  • 关注会员:3 人
  • 回答浏览:961
  • X社区推广