软件开发Db2创建索引

求助db2创建索引报错

db2在创建索引的时候报58040的错误,这个怎么解决啊
The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL5105N The statement failed because a Big SQL component encountered an
error. Component receiving the error: "DDL". Component returning the error:
"Hive". Log entry identifier: "[BSL-0-57919f85a]". SQLSTATE=58040

参与11

3同行回答

yufeng411yufeng411系统运维工程师sinosoft
ExplanationThe log identifier in the token log-entry-identifier is composed of three parts:A three-letter prefix that indicates which log file includes diagnostic details.A three-digit number that indicates on which database partition the log file re...显示全部

Explanation
The log identifier in the token log-entry-identifier is composed of three parts:
A three-letter prefix that indicates which log file includes diagnostic details.
A three-digit number that indicates on which database partition the log file resides.
An identifier that is printed in the log file near the related diagnostic details.
User response
Locate the diagnostic details in the appropriate log file by using the information in the log-entry-identifier runtime token.
Resolve the cause of the problem.
Submit the statement again.
建议贴出sql语句看看

收起
保险 · 2017-07-25
浏览2354
hufeng719hufeng719联盟成员系统工程师某钢铁企业
貌似多了个table吧试试:db2 “create index IDX_TF_B_WRITEOFFLOG_EXT on microact4.TF_B_WRITEOFFLOG(CHARGE_ID ASC) allow Reverse scans collect sampled detailed statistics ”显示全部

貌似多了个table吧
试试:
db2 “create index IDX_TF_B_WRITEOFFLOG_EXT on microact4.TF_B_WRITEOFFLOG(CHARGE_ID ASC) allow Reverse scans collect sampled detailed statistics ”

收起
能源采矿 · 2017-07-27
浏览2244
ambari 邀答
  • 原来是上面的那个用法创建的索引没有问题,上次删完表再创建索引就报错了
    2017-07-31
ambariambari软件开发工程师中国联通亦庄分公司
create index IDX_TF_B_WRITEOFFLOG_EXT on table microact4.TF_B_WRITEOFFLOG(CHARGE_ID)这是创建索引的语句显示全部

create index IDX_TF_B_WRITEOFFLOG_EXT on table microact4.TF_B_WRITEOFFLOG(CHARGE_ID)
这是创建索引的语句

收起
软件开发 · 2017-07-26
浏览2217

提问者

ambari
软件开发工程师中国联通亦庄分公司

相关问题

相关资料

相关文章

问题状态

  • 发布时间:2017-07-25
  • 关注会员:3 人
  • 问题浏览:3466
  • 最近回答:2017-07-27
  • X社区推广