error
文章平均质量分 73
不爱学习的小枫
这个作者很懒,什么都没留下…
展开
-
DB2建表时报错:DB2 SQL Error: SQLCODE=-286, SQLSTATE=42727
问题描述:DB2在创建一个200多列的大数据表时,报错:SQL 错误 [42727]: A default table space could not be found with a page size of at least “16384” that authorization ID “PAS” is authorized to use… SQLCODE=-286, SQLSTATE=42727, DRIVER=4.16.53原创 2021-01-06 15:34:27 · 2988 阅读 · 1 评论 -
ora数据库索引被锁解决方法
索引被锁错误描述:在程序跑批时,出现报错"sqlcode:-12801 ORA-12801: 并行查询服务器 P000 中发出错误信号ORA-00060: 等待资源时检测到死锁ORA-06512",后经过程序逐步执行,发现报错的执行sql语句’alter index index_2009 rebuild partition P19 nologging parallel 5 tablespace TBS_IDX‘该sql是创建索引,故猜测是因索引被锁造成的。解决方法--查询被锁的s.原创 2020-10-10 08:50:40 · 1277 阅读 · 0 评论 -
db2中SQLCODE=-1585,SQLSTATE=54048报错问题的解决
在db2创建库时,出现以下报错:SQL 错误 [56098]: An error occurred during implicit system action type "2". Information returned for the error includes SQLCODE "-1585", SQLSTATE "54048" and message tokens "54048".. ...原创 2019-11-27 10:06:18 · 9132 阅读 · 0 评论 -
hibernate删除有外键的数据时出错
控制台出现报错:01:59:12,862 WARN SqlExceptionHelper:127 - SQL Error: 1048, SQLState: 2300001:59:12,862 ERROR SqlExceptionHelper:129 - Column 'lkm_cust_id' cannot be null01:59:12,870 INFO AbstractBatchI...原创 2019-04-01 02:07:35 · 1562 阅读 · 0 评论 -
’SQLCODE=-419 十进制除法运算无效‘ 解决办法
db2 报错 信息SQL 错误 [42911]: A decimal divide operation is not valid because the result would have a negative scale.. SQLCODE=-419, SQLSTATE=42911, DRIVER=4.16.53 A decimal divide operation is not ...转载 2019-10-11 18:51:38 · 2694 阅读 · 0 评论