Understanding DB2®: Learning Visually with Examples

10.8. Case Study

Assume that you have just created a database (SAMPLE) in a DB2 instance (DB2) for application testing. Before the testers can access the database, you need to make sure they have all the necessary privileges and authorities to perform requested database operations.

First of all, you want to enforce that all client authentications are validated at the server. To retrieve the current authentication setting, issue the following command:

					get dbm cfg
				

The result indicates that user IDs and passwords will be authenticated at the DB2 server:

					Database manager authentication        (AUTHENTICATION) = SERVER
				

Recently, a company-wide alert announced that encryption should be used wherever possible to prevent eavesdropping. To do this, you can ...