Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

MaxDB Check Database Structure: How to check status?

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

Former Member
replied

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

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question