Does this help?
d:\contentreporter\maxdb\prog\pgm\dbmcli.exe on cr>db_cons show active 1 10
OK
SERVERDB: CR
ID UKT Win TASK APPL Current Timeout Region Wait
tid type pid state priority cnt try item
T68 7 0x7E8 User 544 Vwait 0 0
116374(s)
T69 7 0x7E8 User 2352 Vwait 0 0
116374(s)
ID UKT Win TASK APPL Current Timeout Region Wait
tid type pid state priority cnt try item
T68 7 0x7E8 User 544 Vwait 0 0
116374(s)
T69 7 0x7E8 User 2352 Vwait 0 0
116374(s)
ID UKT Win TASK APPL Current Timeout Region Wait
tid type pid state priority cnt try item
T68 7 0x7E8 User 544 Vwait 0 0
116374(s)
T69 7 0x7E8 User 2352 Vwait 0 0
116374(s)
ID UKT Win TASK APPL Current Timeout Region Wait
tid type pid state priority cnt try item
T68 7 0x7E8 User 544 Vwait 0 0
116374(s)
T69 7 0x7E8 User 2352 Vwait 0 0
116374(s)
ID UKT Win TASK APPL Current Timeout Region Wait
tid type pid state priority cnt try item
T68 7 0x7E8 User 544 Vwait 0 0
116374(s)
T69 7 0x7E8 User 2352 Vwait 0 0
116374(s)
ID UKT Win TASK APPL Current Timeout Region Wait
tid type pid state priority cnt try item
T68 7 0x7E8 User 544 Vwait 0 0
116374(s)
T69 7 0x7E8 User 2352 Vwait 0 0
116374(s)
ID UKT Win TASK APPL Current Timeout Region Wait
tid type pid state priority cnt try item
T68 7 0x7E8 User 544 Vwait 0 0
116374(s)
T69 7 0x7E8 User 2352 Vwait 0 0
116374(s)
ID UKT Win TASK APPL Current Timeout Region Wait
tid type pid state priority cnt try item
T68 7 0x7E8 User 544 Vwait 0 0
116374(s)
T69 7 0x7E8 User 2352 Vwait 0 0
116374(s)
ID UKT Win TASK APPL Current Timeout Region Wait
tid type pid state priority cnt try item
T68 7 0x7E8 User 544 Vwait 0 0
116374(s)
T69 7 0x7E8 User 2352 Vwait 0 0
116374(s)
ID UKT Win TASK APPL Current Timeout Region Wait
tid type pid state priority cnt try item
T68 7 0x7E8 User 544 Vwait 0 0
116374(s)
T69 7 0x7E8 User 2352 Vwait 0 0
116374(s)
---
Doesn't look like there is much change...
Kind regards
robert
2005/9/15, "Döhr, Markus ICC-H" <[EMAIL PROTECTED]>:
> > Thanks for the hint. I'm still interested in an explanation what
> > really happens here. Any takers? Thanks!
> >
> > Btw, the test with MAXCPU=2 also exibits similar behavior: four bulk
> > loads started in parallel, only two active import tasks and they seem
> > to hang. Also there are numerous lock collisions (~350 at the
> > moment). There also seem to be only two processes loadercli although
> > four were started concurrently (via dbmcli) and there is no message of
> > termination yet. When the process finally terminates I'll post error
> > messages.
>
> Check what the db is doing with x_cons <SID> show active 1, then you can
> see, what is happening (Vwaits, Runnable tasks etc.)
>
>
> Greetz,
>
>
> SIEGENIA-AUBI KG
> Informationswesen
>
> i.A.
>
> Markus Döhr
> SAP-CC/BC, SAPDB-DBA
>
> Tel.: +49 6503 917-152
> Fax: +49 6503 917-7152
> E-Mail: [EMAIL PROTECTED]
> Internet: http://www.siegenia-aubi.com
>
>
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
