AW: Why I can't get response

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


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