Solutions for installing DB2: Administrator and db2admin with no permissions on the sample database

Install the sample database when installing the DB2 database (DB2 v 9.7 is used here). Only system has the permission for the installed sample database. The default mode is system, users using the Administrator and db2admin cannot access the tables in the sample database, and are not authorized to access the tables.

Step 1: Delete the sample database.

Step 2: add the db2amins group to the Administrator:

Step 3: Use DB2's "Step 1" to create a database

In this way, the administrator user has the permission to manage the sample. The default mode of the sample database is administrator. You can use the Administrator to authorize db2admin:

After authorization, the db2admin user also has the permission to access the sample data.