SQL0818N/SQL0901N error when running db2advis
SQL0818N/SQL0901N error when running db2advis
Troubleshooting
Problem
Symptom
Error at line 11257, in file partadvise.SQC
DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -818 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLRA145
sqlerrd : (1) 0x801A006D (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0xFFFFFD76 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 51003
| | | | | | parser entry
(snip)
| | | | | | | | sqljrDrdaArExecute exit [rc = 0x8037006D = -2143879059 = SQLJR_CABLT]
| | | | | | | sqlacall error [probe 3317]
| | | | | | | | sqlofica entry
| | | | | | | | | pdLog entry
(snip)
| | | | | | | | | sqlnxDbgPrint::printf entry
| | | | | | | | | sqlnxDbgPrint::printf exit [rc = 0x000001B7 = 439]
| | | | | | | | sqldesOutputMsg exit
| | | | | | | usage exit
| | | | | | parser exit [rc = 0xFFFFFC7B = -901]
| | | | | | report_error_with_loc entry
| | | | | | | report_diag_error entry
Cause
Resolving The Problem
To resolve the issue you will need bind the packages for the db2advis command to work.
db2advindex.bnd+
db2advio.bnd+
db2advis.bnd+
db2advmdc.bnd+
db2advmisc.bnd+
db2advmqt.bnd+
db2advsimulation.bnd+
db2advworkload.bnd+
gseClAdv.bnd+
mdcadvise.bnd+
partadvise.bnd
db2 connect to SAMPLE
cd sqllib/bnd
db2 "bind @db2advis.lst action replace blocking all grant public
sqlerror continue messages bindadvs.out"
- Root required to create files in ~/sqllib/bnd (Unix/Linux). Alternative is to copy the contents of ~/sqllib/bnd to another directory then create db2advis.lst in new directory. Ensure there are no spaces at end of each file in db2advis.lst.
- See technote DB2ADVIS returning error -220
Related Information
Document Information
More support for:
Db2 for Linux, UNIX and Windows
Software version:
9.7, 9.5, 9.1, 10.1, 10.5, 11.1
Operating system(s):
AIX, HP-UX, Linux, Solaris, Windows
Document number:
433575
Modified date:
17 April 2019
Click the Subscribe button to stay informed of critical IBM support updates with My Notifications.
Take a proactive approach to problem prevention.
Receive support content tailored to your needs, delivered directly to you!
Receive immediate notifications of Security Bulletins and Flashes.
Receive daily or weekly notifications of technical support information such as downloads, tips, technical notes, and publications.
Log in to Subscribe
Need support?
------------------------------------------------------------------------------------------
如果你觉得文章有用，欢迎打赏
最新文章
- HTML案例—很讨巧的一种js+css制作hover模式展示二级菜单方法
- 使用AFNetWorking读取JSON出现NSCocoaErrorDomain Code=3840的解决方法
- 面向对象的JavaScript
- webstorm编辑RN代码提示功能
- [LeetCode] Implement strStr()
- [C++] socket - 2 [UDP通信C/S实例]
- BZOJ1092 : [SCOI2003]蜘蛛难题
- lcd 图片
- /bin/rm: Argument list too long解決方法
- MVC简捷调用EasyUI的datagrid
- 注册微信小程序
- Linux&shell 之基本Shell命令
- Proving Equivalences（加多少边使其强联通）
- 【转】matlab图形句柄详解(一)
- Filecoin协议(挖矿)
- ImageMagick简单记录
- The following packages have unmet dependencies错误
- vue教程3-05 vue组件数据传递、父子组件数据获取，slot,router路由
- MyEclipse持续性开发教程：用JPA和Spring管理数据（四）
- UVA-1152 4 Values whose Sum is 0 （二分）