AW: SQL AS/400 Question

[Wiesmayr Rudolf <Rudolf.Wiesmayr@xxxxxxxxxxx>]

> -----Ursprüngliche Nachricht-----
> Von:  Graziano, Marie [SMTP:mgraziano@badgermeter.com]
> Gesendet am:  Donnerstag, 24. Februar 2000 15:14
> An:   'Midrange'
> Betreff:      SQL AS/400 Question
> 
> Does any know if when an SQL is being done in a program, does it lock by
> Rows or Records.
        [R.Wiesmayr]  That's the same thing.
        Usually, it does ROW level locking.

> I have a situation where a user is running a program on
> Two workstations and they take forever.
        [R.Wiesmayr]  Look at the joblog in debug mode to see
        what access method is taken...

> What I think may be happening is
> the row is locked until the 1st program finishes.
        [R.Wiesmayr]  This is only possible if the file wait time (see
DspFD)
        is extremely high. You get a SQL0913 when this time is exceeded.

HTH,
Rudi
-------------------------------------------------------------------
Dipl.-Ing. Rudolf Wiesmayr  /\ Tel:     +43 - 0732 / 7070 -    1720
SAP R/3 BASIS &             /\ Fax:     +43 - 0732 / 7070 - 54 1720
AS/400 Professional System Administrator (IBM Certified Specialist)
-------------------------------------------------------------------
Magistrat Linz, ADV/SB, Gruberstrasse 40-42, A-4041 Linz, Austria
-------------------------------------------------------------------
SAP on AS/400 mailing list  /\ mailto:sap400@mag.linz.at
Digital City Linz           /\ http://www.linz.at
Donate free food! Visit     /\ http://www.thehungersite.com/
-------------------------------------------------------------------
A system admin's life is a sorry one.  The only advantage he has
over Emergency Room doctors is that malpractice suits are rare.
On the other hand, ER doctors never have to deal with patients
installing new versions of their own innards!

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---