New to this.
Looking at db2 schemas, which should be equal to OS system users, right ? Doh apparently not. Except for PC,DB2ADMIN beeing on my OS system
How is it, that this
select * from sysibm.systabauth where grantee = 'DB2ADMIN'
produsces something and 'DB2ADMIN' is not on list of schemas ?
'DB2ADMIN' was created at db setup, so I assume it should have all privileges, but no, if I'm at 'PC' schemata 'DB2ADMIN' can't even execute simple select statement.
How to grant all privileges to 'DB2ADMIN' on 'PC schemata ?'
if this is my connection url: jdbc:db2://127.0.0.1:50000/SAMPLE What is SAMPLE, should be db, a little confuzig coz looking at db tree structure at sqirell client there is DB2 & schematas listed under it, and nowhere 'SAMPLE' ?