I created a user and forgot there password and I need to change it to something I know how the heck can I do that? I am very new to DB2. If you want just tell where the heck I can find it.

Depends on the authentication scheme you are using. By default, it will authenticate users to the local OS, so you would have to change the password through the OS.

There is no such user in the os just in the database.

Do not create users in DB2. You must create them (and change passwords) in the OS.

Opps. I created a schema with the same name as the user will it drop the schema objects? If not then I will create an os user and go from there.

What I did was create an os user of the same name as the db user and then I could change passwords, connect to the db etc using the user information from the o/s.

Thanks for pointing me in the right direction.