SQL statements can be used to determine the contents of various tables. You should be familiar with these tables to learn about the OAM databases as they relate to DB2.
For a complete listing of the DB2 catalog tables and what they contain, see the "DB2 reference information" topic in the IBM Information Management Software for z/OS Solutions Information Center.