MaxDB Check Database Structure: How to check status?
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.
Lars Breddemann replied
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.