Solution to the problem that DB2ADMIN has no permissions on the Sample database (1)

This article describes how to solve the problem that users using the Administrator and DB2ADMIN cannot access the tables of the Sample database when installing the DB2 database. It is attached with a diagram for your reference.

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