DB2 Audit Rc Table

2024-07-12 工作雜記 db2

db2diag -l Warning  | db2diag -g "comp^=bsu security"

DB2 稽核 失敗 rc 對照表

# rc Corresponding SQL30082N rc Explanation
1 -2146500508 1 Password has expired
2 -2146500507 2 The password is not valid for the specified user id
3 -2146500290 3 Password missing
4 -2146500504 15, 24, 26, 36 Password length is greater than the supported password length
5 -2146500289 5 User ID missing
6 -2146500502 6 Bad User
7 -2146500316 7 User ID is revoked
8 -2146500483 19 User ID suspended
9 -2146500315 24 Invalid User ID or password
10 -2146500271 4 Security protocol violation
11 -2146499492 15, 24 Encryption types do not match
12 -2146500270 17 Authentication types do not match
13 -2146500288 17 Unsupported function
14 -2146500301 20 Mutual authentication failed
15 -2146499529 41 A trusted connection was not established, so switch user request is invalid
16 -2146499506 42 Root capability required
17 -2146500252 N/A The specified node or server is not available
18 -2146500307 N/A Unable to authenticate because of system error
19 -2146500234 25 The security plugin has disallowed the connection
20 -2146500233 26 The server security plugin encountered an unexpected error
21 -2146500232 27 The server security plugin encountered an invalid server credential
22 -2146500231 28 The server security plugin encountered an expired server credential
23 -2146500230 29 The server security plugin encountered an invalid security token sent by the client
24 -2146500229 30 The client security plugin is missing a required API
25 -2146500228 31 The client security plugin is of the wrong plugin type
26 -2146500227 32 The client security plugin does not have a matching GSS-API security plugin available for connection to the database
27 -2146500226 33 The client security plugin cannot be loaded
28 -2146500225 34 The client security plugin name is invalid
29 -2146500224 35 The client security plugin reports an API version that is incompatible with DB2
30 -2146500223 36 The client security plugin encountered an unexpected error
31 -2146500222 37 The server security plugin encountered an invalid principal name
32 -2146500221 38 The client security plugin encountered an invalid client credential
33 -2146500220 39 The client security plugin encountered an expired client credential
34 -2146500219 40 The client security plugin encountered an invalid security token sent by the server

參考資料