Symptom
1) SQL30082N Security processing failed with reason "19" ("USERID DISABLED or RESTRICTED"). SQLSTATE=08001
2) db2set DB2LOGINRESTRICTIONS NONE
3) lsuser sapsr3 shows both login=true and account_locked=false
. . .
<AIXhostnm>:<sid>adm 54>
sapsr3 id=346
pgrp=dbde7mon
groups=dbde7mon,staff
. . .
login=true
su=true
rlogin=true
. . .
account_locked=false
. . .
4) R3trans -x
trans.log
. . .
Supported features:
4 ETW000 [ dev trc,00000] ..retrieving configuration parameters
4 ETW000 [ dev trc,00000] ..done
4 ETW000 [ dev trc,00000] DB2 library has been loaded.
4 ETW000 [ dev trc,00000] Info: successfully loaded DB2 library '/usr/sap/<SID>/SYS/global/db6/AIX_64/db6_clidriver/lib/libdb2.a(shr_64.o)'
4 ETW000 [ dev trc,00000] Running with UTF-8 Unicode
4 ETW000 [ dev trc,00000] DB2 client driver version '11.01.0405'
4 ETW000 [ dev trc,00000] Running with CLI driver.
4 ETW000 [ dev trc,00000] *** ERROR in DB6Connect[/bas/753_REL/src/dbs/db6/dbdb6.c, 1961] CON = 0 CACHEID = -1 (BEGIN)
4 ETW000 [ dev trc,00000] &+ DbSlConnectDB6( SQLConnect ): [IBM][CLI Driver] SQL30082N Security processing failed with reason "19" ("USERID DI
4 ETW000 [ dev trc,00000] &+ SABLED or RESTRICTED"). SQLSTATE=08001
4 ETW000 [ dev trc,00000] &+
4 ETW000 [ dev trc,00000] &+
4 ETW000 [ dev trc,00000] &+
4 ETW000 [ dev trc,00000] *** ERROR in DB6Connect[/bas/753_REL/src/dbs/db6/dbdb6.c, 1961] (END)
4 ETW000 [dbdb6.c ,00000] *** ERROR => DbSlConnect to '<SID>' as 'sapsr3' failed
2EETW169 no connect possible: "DBMS = DB6 --- DB2DBDFT = '<SID>'"
trans.log: END
5) db2trc
Read more...
Environment
AIX
IBM Db2 LUW
Product
Keywords
KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.