Solved: check database

former_member829550 · ‎08-19-2008

hi frnds,

what is the difference between checkDB and verifyDB in db13 tcode and when should i perform them.

also how to lock and unlock the clients...

points will be awarded for the right answers.

regards,

bhupesh

Former Member · ‎08-19-2008

Hi,

I think that would be verify backup not verify db.

Verify backup will check the backup which you have taken.

Check DB is the job which will check the database for consistency.

I dont think so there is a mechanism for client locking.

But if you dont want any user to login into that client then you can delete from scc4.

But the actual clinet will still be there.Again if you want that client to be used then create the entries in the scc4.

Regards,

Vamshi.

former_member829550 · ‎08-19-2008

thanks all,

my question is answered.

Former Member · ‎08-19-2008

Dear Mudari,

Dont think you can lock a client.However you can lock all the user via SU10.

Now you can unlock it via.

Say you want to unlock SAP*

sqlplus /nolog;

conn /as sysdba

DELETE FROM <sid>.USR02

WHERE BNAME='SAP*' AND MANDT='<client no.>'

EG-->

DELETE FROM dev.USR02

WHERE BNAME='SAP*' AND MANDT='123'

Note: in your instant profile logon/no_automatic_user_sapstar = 0

Then restart and login with passowrd pss and user ID pass.

I guess you must already be knowing this.

Database verify backup will see weather backup has taken place successfully or not and check database will see for consistency.

Regards,

Ashutosh

check database