on 05-28-2009 4:11 AM
Dear All,
I'm performing a database structure check on our QA server using
DBMGUI. I would like to ask how can check for progress/status
of the check. I just know that it is still running by looking at the logs
but is there any way to know how many tables are still to be checked?
Been searching the forums and googling but can't find an answer.
Thank you very much.
Regards,
Rayel
> I'm performing a database structure check on our QA server using
> DBMGUI. I would like to ask how can check for progress/status
> of the check. I just know that it is still running by looking at the logs
> but is there any way to know how many tables are still to be checked?
> Been searching the forums and googling but can't find an answer.
> Thank you very much.
Hi Rayel,
besides the information in the KNLDIAG/KNLMSG file there is no output on the progress.
You can just see that the check is still active but not how long it will be running and/or how many tables are still to be checked.
Right now I don't even think that there are plans to change that ...
regards,
Lars
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Lars,
Thank you for your reply.
I did look into knldiag/knlmsg from time to time to see if the job is still active.
I see lines for Check Table and Check Index.
Now I don't see them? Does this mean that the job is finished?
DBMGUI still has this dialog box for Check Database structure,
saying "Please wait while checking database structure ..." so
I'm really not sure. Should I cancel it? I notice a line
CHECK 53000: Start check blobs
after the last Check Table line.
Tried to search for it but found nothing.
Hope you can shed some light.
Regards,
Rayel
Hi Rayel,
when the CHECK DATA begins to check the BLOB trees then there are no one-by-one entries for that in the KNLDIAG file.
Anyhow, as long as you don't see something like
"Check data finished ..."
it is still running.
An additional check can be done via x_cons:
x_cons db770 show active
SERVERDB: DB770
ID UKT Win TASK APPL Current Timeout Region Wait
tid type pid state priority cnt try item
T36 9 0x1628 User 4780 JobWait CheckD 0 0 188(s)
T38 4 0x1654 ChkData IO Wait (R) 0 0 4 740(s)
T39 4 0x1654 ChkData IO Wait (R) 0 0 3 740(s)
T40 4 0x1654 ChkData IO Wait (R) 0 0 3 740(s)
T41 4 0x1654 ChkData IO Wait (R) 0 0 5 740(s)
T42 4 0x1654 ChkData IO Wait (R) 0 0 5 740(s)
Console command finished (2009-05-28 11:16:49).
You can see here, there is one user taks in "JobWait CheckD"(ata) state
and several "ChkData" tasks doing IO.
As long as the user task is in this JobWait the check data is running.
regards,
Lars
Hi Lars,
Kinda worried when I didn't saw any entry in the log file. 😃
I did check the active tasks and saw a lot of ChkData IOWait (R).
But now there's only 1 active ChkData.
Really, patience is a virtue.
Will wait for that "Check data finished..." message.
Will update this thread after it finished.
Thank you for sharing your knowledge.
Now, I can breathe again. 😃
Regards,
Rayel
Rayel,
Check below SAP Notes. It may help you.
Note 846890 FAQ: MaxDB Administration
Note 940420 - FAQ: Database structure check (VERIFY)
http://help.sap.com/erp2005_ehp_04/helpdata/EN/0c/da70f176a6f147bf892a15bb643409/frameset.htm
Thanks,
Sushil
Edited by: Sushil Suryawanshi on May 28, 2009 10:07 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.