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
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语句看看
貌似多了个table吧
试试:
db2 “create index IDX_TF_B_WRITEOFFLOG_EXT on microact4.TF_B_WRITEOFFLOG(CHARGE_ID ASC) allow Reverse scans collect sampled detailed statistics ”