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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/17086096/viewspace-2058637/