I have three DB2 database accounts. I was wondering if it is possible to access SAP database using the DB2 database accounts like from the SAP GUI. I would also like to know if we can find the account status of the DB2 users (locked/unlocked) etc.
You cannot access the SAP application using the DB2 accounts. SAP users are defined and the information is stored amongst others in the usr02 table.
The db2 user are defined on the OS or in the authentication tool used by the database.
You might access the SAP data using the DB2 instance user depending on data access setup.