RE: AW: Why I can't get response

Thanks for your answer,I have repeat your suggesion.It's good.

But I want to ask more question,can you give me some examples,which 
deadlock depth are correspond to DEADLOCK_DETECTION's value which is 
1,2,3,4 or 5.


> From: "Zabach, Elke" <elke.zabach@xxxxxxx>
> To: "liu xiaotao" <tiger_liuxiaotao@xxxxxxxxxxx>, <maxdb@xxxxxxxxxxxxxxx>
> CC: <maxdb-owner@xxxxxxxxxxxxxxx>
> Subject: AW: Why I can't get response
> Date: Fri, 1 Apr 2005 08:48:08 +0200
>
> liu xiaotao wrote:
> >
> > I've ever ask some question but can't get reponse.So I ask this 
question
> > again, who can help me?
> >
> > I want to ask four question about MaxDB 7.5.Please help me!
> >
> > One,are there index reorganiztion and merge function in maxdb? And how 
to
> > use it?
>
> NO reorganization in MaxDB needed.
> What do you mean with 'merge-function'? A function like substr/length or 
something having to do with some kind of reorganization (see above)?
> >
> > Two,how to get information about the execution plan in maxdb? (It 
shuold
> > not be explain functon,which is too simple).
>
> Only explain available for users.
> For developers some other info is available, but in a 
non-user-read/understandable form.
> >
> > Three,can you give me a test case which will generate a deadlock and be
> > tested by maxdb,then maxdb cancel one of the transactions which 
generate
> > deadlock.
>
> As with all all database systems, a testcase will be:
>
> Transaction A                        Transaction B
> Update record xyz
>                                      Update record abc
> Try to update/read
> (with isolation level > 0)
> record abc
>                                                 Try to update/read
>                                                 (with isolation level > 0)
>                                                 record xyz
>
> >
> > Four,whether maxdb has function to kill deadlock by user and where can 
I
> > find it?
>
> To kill if deadlock happened? None
> To help shortening  waiting times: see installation parameter 
REQUEST_TIMEOUT
> To help finding DEADLOCKS (if it is not such easy one with exactly two 
tasks concerned. See parameter DEADLOCK_DETECTION, which will (per default) 
have an acceptable value of 4.
> Elke
> SAP Labs Berlin
> >
> > _________________________________________________________________
> > 与联机的朋友进行交流，请使用 MSN Messenger:  
http://messenger.msn.com/cn
> >
> >
> > --
> > MaxDB Discussion Mailing List
> > For list archives: http://lists.mysql.com/maxdb
> > To unsubscribe:    
http://lists.mysql.com/maxdb?unsub=elke.zabach@xxxxxxx
>

_________________________________________________________________
免费下载 MSN Explorer:   http://explorer.msn.com/lccn/  


--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx