. ~ db2instance /sqllib/db2profile

db2start id=220 pgrp=staff groups=staff,db2ctrl home=/home/db2start shell=/usr/bin/ksh login=true su=true rlogin=true daemon=true admin=false sugroups=ALL admgroups= tpath=nosak ttys=ALL expires=0 auth1=SYSTEM auth2=NONE umask=22 registry=files SYSTEM=compat logintimes= loginretries=0 pwdwarntime=0 account_locked=false minage=0 maxage=0 maxexpired=-1 minalpha=0 minloweralpha=0 minupperalpha=0 minother=0 mindigit=0 minspecialchar=0 mindiff=0 maxrepeats=8 minlen=0 histexpire=0 histsize=0 pwdchecks= dictionlist= default_roles= fsize=-1 cpu=-1 data=-1 stack=-1 core=-1 rss=-1 nofiles=-1 time_last_login=1546944095 tty_last_login=/dev/pts/1 host_last_login=172.28.20.122 unsuccessful_login_count=0 roles=

dsadm id=208 pgrp=dstage groups=dstage,staff,db2ctrl home=/home/dsadm shell=/bin/ksh login=true su=true rlogin=true daemon=true admin=false sugroups=ALL admgroups= tpath=nosak ttys=ALL expires=0 auth1=SYSTEM auth2=NONE umask=22 registry=files SYSTEM=compat logintimes= loginretries=0 pwdwarntime=0 account_locked=false minage=0 maxage=0 maxexpired=-1 minalpha=0 minloweralpha=0 minupperalpha=0 minother=0 mindigit=0 minspecialchar=0 mindiff=0 maxrepeats=8 minlen=0 histexpire=0 histsize=0 pwdchecks= dictionlist= default_roles= fsize=-1 cpu=-1 data=-1 stack=-1 core=-1 rss=-1 nofiles=-1 time_last_login=1399018738 time_last_unsuccessful_login=1397714590 tty_last_login=/dev/pts/1 tty_last_unsuccessful_login=ssh host_last_login=192.168.106.116 host_last_unsuccessful_login=192.168.106.116 unsuccessful_login_count=21 roles=

grep -p db2profile ~dasadm/.profile

vi ~db2start/.profile

grep -p db2profile ~dsadm/.profile

grep -p "^mytusr:" /etc/security/passwd | grep -p ADMCHG

pwdadm -c mytusr

su - mytusr

su – mytusr

db2 connect to TEST
db2 connect to TEST user mytusr

db2 list db directory
db2 list node directory
db2 get dbm cfg | grep -i plugin

db2 "? SQL5193N"

Не:
GRANT CONNECT TO DATABASE T_D TO USER MYTUSR
а:
GRANT CONNECT ON DATABASE TO USER MYTUSR

select WORKLOADNAME, ENABLED from syscat.workloads;

SELECT  
  P.PRIVILEGE, P.OBJECTTYPE, P.OBJECTSCHEMA, P.OBJECTNAME
, U.AUTHID, U.AUTHIDTYPE
FROM SYSIBMADM.PRIVILEGES P
CROSS JOIN TABLE(VALUES '<USER>') A (AUTHID)
JOIN TABLE (
SELECT GROUP, 'G' FROM table(AUTH_LIST_GROUPS_FOR_AUTHID(A.AUTHID))
  UNION ALL
select ROLENAME, 'R' from table(AUTH_LIST_ROLES_FOR_AUTHID(A.AUTHID, 'U'))
  UNION ALL
SELECT * FROM TABLE(VALUES ('PUBLIC', 'G'), (A.AUTHID, 'U')) T (AUTHID, AUTHIDTYPE)
) U (AUTHID, AUTHIDTYPE) ON U.AUTHID=P.AUTHID AND U.AUTHIDTYPE=P.AUTHIDTYPE
WHERE P.OBJECTTYPE='WORKLOAD'
ORDER BY 2, 3, 4;

select 'GRANT EXECUTE ON PACKAGE "'||pkgschema||'"."'||pkgname||'" TO USER MYTUSR;'
from syscat.packages
where pkgschema='NULLID' and (pkgname like 'SYS%' or pkgname like 'SQLL9%');

. ~db2inst1/sqllib/db2profile

 GRANT  CONNECT ON DATABASE TO GROUP <MYGROUP>

/usr/local/bin/db2ls

${DB2DIR}/bin/db2greg -dump | grep '^I,DB2,'

db2 terminate
. ~ db2inst /sqllib/db2profile