Db2

Hello Aviv

I haven't done a Windows install in some time, but did you follow the post-install procedures from IBM?

In particular: Adding your user ID to the DB2ADMNS and DB2USERS user groups (Windows) - IBM Documentation

Good Luck!

Hi,

Account you specified during installation is an account under which Db2 services are being run. This account does not have priviledges on database. 
I am assuming that either you logged on as db2admin or used "runas .." to open session (you can verify by command whoami).

Db2admin - has the ability to create a database - and create tables in such created database - but not necessarily to create table in other databases.

If you need anything else -0 let us know...

 

You may have created the db using your own windows session Id.  not the db2admin,  

hence the db2admin user has no privileges against your db.   if that was the case, you need to grant it access, like DBADM, using the same ID your DB was created with, which should have the proper privilege to grant it.  

Confused !? 

What's the result of these queries in your database?

SELECT *
FROM TABLE(AUTH_LIST_AUTHORITIES_FOR_AUTHID('DB2ADMIN', 'U'))
WHERE AUTHORITY IN ('DBADM', 'CREATETAB', 'IMPLICIT_SCHEMA')
;

SELECT GRANTEE, GRANTEETYPE, DBADMAUTH, CREATETABAUTH, IMPLSCHEMAAUTH, SECURITYADMAUTH
FROM SYSCAT.DBAUTH
WHERE 'Y' IN (DBADMAUTH, CREATETABAUTH, IMPLSCHEMAAUTH, SECURITYADMAUTH)
;

Hi,

Did you add the user (db2admin) to the administrator group on the server? if not please add it.

Most likely you follow default installation, where the database creation and their objects will be under C: drive.

For that and other stuff you will need system permission regardless of the database permission.

Thanks ..

Khalid