Post July 24th, 2009, 2:44 pm

Permission problems with DB2

Some permission problems can arise on DB2 Express-c on windows and Portus.

Essentially, these are the steps one must take:

1. Log onto as a user which is in the Administrator group, either on the local machine or the domain.
2. Install DB2.
3. Create WORLD database ( or equivalent )
4. Load WORLD database ( or equivalent )
5. GRANT all authorities to DB2ADMIN.
6. Set up ODBC connection to WORLD database user DB2ADMIN.