SQL1224 is returned during the execution of an SQL procedure
SQL1224 is returned during the execution of an SQL procedure
https://www.ibm.com/support/pages/sql1224-returned-during-execution-sql-procedure
Question & Answer
Question
The execution of an SQL procedure can fail with error SQL1224 if a LOAD command is executed at the same time.
Answer
PROBLEM
The following message might be logged in the db2diag.log during execution of a SQL procedure.
2007-05-02-11.06.17.513639-300 I2535A1111 LEVEL: Error
PID : 43578 TID : 1 PROC : db2agent (SAMPLE) 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-98 APPID: *N0.db2inst1.070502160554
MESSAGE : Severe TERMINATE err at nest lvl 1, in SQL from rtn<
DB2INST1.SELECTROW:
DATA #1 : Hexdump, 136 bytes
0x0000000110362C48 : 5351 4C43 4120 2020 0000 0088 FFFF FB38 SQLCA .......8
0x0000000110362C58 : 0000 2020 2020 2020 2020 2020 2020 2020 ..<<<<<<<<<<<<<<
0x0000000110362C68 : 2020 2020 2020 2020 2020 2020 2020 2020<<<<<<<<<<<<<<<<<<<<
0x0000000110362C78 : 2020 2020 2020 2020 2020 2020 2020 2020<<<<<<<<<<<<<<<<<<<<
0x0000000110362C88 : 2020 2020 2020 2020 2020 2020 2020 2020<<<<<<<<<<<<<<<<<<<<
0x0000000110362C98 : 2020 2020 2020 2020 5351 4C45 4752 5054 SQLEGRPT
0x0000000110362CA8 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0000000110362CB8 : 0000 0000 0000 0000 2020 2020 2020 2020 ........<<<<<<<<
0x0000000110362CC8 : 2020 2035 3530 3332 55032
CAUSE
The above error indicates that the SQL procedure DB2INST1.SELECTROW failed with SQL1224 because during its execution, a LOAD command using the LOCK WITH FORCE option was issued against the same table that is referenced in the stored procedure. The LOCK WITH FORCE option allows the load command to force off other applications that hold conflicting locks on the target table.
SOLUTION
Execute the SQL stored procedure after the load is complete.
------------------------------------------------------------------------------------------
如果你觉得文章有用,欢迎打赏
最新文章
- 【原创】SQL常用函数
- JAVA匿名内部类
- redis之理解
- 移动端设置字体px转换rem的脚本
- 【LeetCode】Add Digits
- WCF服务创建与使用(双工模式)
- 关于Jquery学习的几点反思
- PIC32MZ tutorial -- Output Compare
- struts配置测试中遇到报错信息,记录下
- 【转】ASP.NET数据库连接字符串总结
- Android 逐帧动画isRunning 一直返回true的问题
- Docker配置镜像加速
- ES6解构过程添加一个默认值和赋值一个新的值
- Android ConstraintLayout 布局警告
- _tcsdup这个函数容易出现堆错误
- 为什么入门首选C语言
- code vs 2597 团伙
- I/O Completion Ports学习
- 2018java面试知识汇总
- HTTP监视器charles入门使用教程分享---http/s packet monitors---ubuntu installation