To test your newly cataloged connection to the Apache Derby database, you can connect to the database from the DB2 command line as follows:
bash$ db2 CONNECT TO database USER user-name
The DB2 command line prompts you for a password and then tries to connect to the requested database. If the connection is successful, DB2 returns output like the following:
Enter current password for lynn: Database Connection Information Database server = Apache Derby CSS10000 SQL authorization ID = lynn Local database alias = YMLD
WHY DO I NEED TO SPECIFY A USER ID AND PASSWORD?
By default, Apache Derby does not enable any user authentication, so it might seem surprising that you have to specify a user ID and password for any connection ...