db2diag rc code
db2diag中經常會出現類似 rc = -2146500507的錯誤,使用db2diag -rc可檢視錯誤程式碼詳細說明;
2016-03-17-10.12.28.681732+480 I140493306E446 LEVEL: Warning
PID : 23375 TID : 140171072759552PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SASDB
APPHDL : 0-15020
EDUID : 187 EDUNAME: db2agent (SASDB) 0
FUNCTION: DB2 UDB, bsu security, sqlexLogPluginMessage, probe:20
DATA #1 : String with size, 67 bytes
Password validation for user db2inst1 failed with rc = -2146500507
Using the "db2diag -rc -2146500507" command, we can verify what the return code represents:
Input ZRC string '-2146500507' parsed as 0x800F0068 (-2146500504).
[db2inst1@cnlnx104 ~/sqllib/db2dump]$ db2diag -rc -2146500507
Input ZRC string '-2146500507' parsed as 0x800F0065 (-2146500507).
ZRC value to map: 0x800F0065 (-2146500507)
V7 Equivalent ZRC value: 0xFFFF8665 (-31131)
ZRC class :
SQL Error, User Error,... (Class Index: 0)
Component:
SQLO ; oper system services (Component Index: 15)
Reason Code:
101 (0x0065)
Identifer:
SQLO_BAD_PSW
Identifer (without component):
SQLZ_RC_BADPSW
Description:
The password is not valid for the specified userid
Associated information:
Sqlcode -30082
SQL30082N Security processing failed with reason "" ("").
Number of sqlca tokens : 2
Diaglog message number: 8111
2016-03-17-10.12.28.681732+480 I140493306E446 LEVEL: Warning
PID : 23375 TID : 140171072759552PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SASDB
APPHDL : 0-15020
EDUID : 187 EDUNAME: db2agent (SASDB) 0
FUNCTION: DB2 UDB, bsu security, sqlexLogPluginMessage, probe:20
DATA #1 : String with size, 67 bytes
Password validation for user db2inst1 failed with rc = -2146500507
Using the "db2diag -rc -2146500507" command, we can verify what the return code represents:
Input ZRC string '-2146500507' parsed as 0x800F0068 (-2146500504).
[db2inst1@cnlnx104 ~/sqllib/db2dump]$ db2diag -rc -2146500507
Input ZRC string '-2146500507' parsed as 0x800F0065 (-2146500507).
ZRC value to map: 0x800F0065 (-2146500507)
V7 Equivalent ZRC value: 0xFFFF8665 (-31131)
ZRC class :
SQL Error, User Error,... (Class Index: 0)
Component:
SQLO ; oper system services (Component Index: 15)
Reason Code:
101 (0x0065)
Identifer:
SQLO_BAD_PSW
Identifer (without component):
SQLZ_RC_BADPSW
Description:
The password is not valid for the specified userid
Associated information:
Sqlcode -30082
SQL30082N Security processing failed with reason "" ("").
Number of sqlca tokens : 2
Diaglog message number: 8111
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17086096/viewspace-2058637/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- db2diag應用DB2
- RC4加密加密
- Kotlin 1.4.0-RC!Kotlin
- Rc+RefCell解釋
- /etc/rc.d/rc.local不執行的解決辦法
- 以殼解殼――ASProtect 1.23RC4殼的Stolen Code簡便解決方案
- rc-form流程簡析ORM
- RC4演算法演算法
- Announcing MSTest Framework support for .NET Core RC2 / ASP.NET Core RC2[譯]FrameworkASP.NET
- Layotto v0.4.0-rc 釋出
- bbossgroups-2.0-RC釋出
- Ubuntu "Dapper Drake" RC 釋出UbuntuAPP
- .NET 9 RC 2正式釋出
- 2009-12-01 使用db2diag過濾DB2診斷日誌DB2
- iView 釋出 2.0.0-rc.15 版本View
- Python 3.3.3 RC2 釋出 Python
- ASP.NET MVC 3 RC釋出ASP.NETMVC
- ASP.NET WebHooks RC 1釋出ASP.NETWebHook
- libvpx中的rc_dropframe_thresh
- Kotlin 1.4.0-RC協程除錯Kotlin除錯
- runc 1.0-rc6 釋出之際
- runc 1.0-rc7 釋出之際
- What’s New in TiDB 3.0.0-rc.1TiDB
- 【翻譯】.NET 5 RC1釋出
- Linux Kernel 5.9-rc3 釋出了Linux
- Julia 0.5.2和0.6-rc1釋出了
- rc.local自啟動學習(轉)
- Frugalware Linux 1.9 RC1 釋出Linux
- Kwort Linux 3.5 RC1 釋出Linux
- RC4加密解密java演算法加密解密Java演算法
- [ CSSCLNT][1]clsssInitNative: connect failed, rc 9CSSAI
- RC-u3 跑團機器人機器人
- Luogu P6864 [RC-03] 記憶
- ABP Framework V4.4 RC 新增功能介紹Framework
- WEB網頁測試利器Selenium-RCWeb網頁
- Load of cache file failed. rc=1301AI
- 軟體版本GA,RC,alpha,beta,Build 含義UI
- 更多的Windows 7 RC1細節披露Windows