MaxDB Check Database Structure: How to check status?

[Former Member]

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

[lbreddemann · Accepted solution]

> 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

[Former Member · Accepted solution]

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

[lbreddemann · Accepted solution]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Thanks for replying to my post.

You helped me a lot.

Till next time.

Regards,

Rayel

[Former Member · Accepted solution]

Thanks for replying to my post.

You helped me a lot.

Till next time.

Regards,

Rayel

[Former Member]

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