This is a discussion on RE: LOCK MODE Question within the Informix forums, part of the Database Server Software category; --> From the command line use: onstat -g ses SESSION_ID Form within a program use DBINFO to get your session ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| From the command line use: onstat -g ses SESSION_ID Form within a program use DBINFO to get your session id and then query sysmaster:syssqlcurall to get your lockmode. Something like: jevc2 sysmaster:syssqlcurall where sqc_sessionid = (dbinfo("sessionid"))' | dbaccess jevic Database selected. Lockmode set. sqc_lockmode 30 1 row(s) retrieved. Database closed. jevc2 Regards, Bill > -----Original Message----- > From: David Snyder [SMTP:dave@snide.com] > Sent: Monday, September 08, 2003 9:00 PM > To: informix-list@iiug.org > Subject: LOCK MODE Question > > How can I determine the lock mode of an Informix process. > > From within the process (I4GL, ESQL/C, PERL, etc.)? > > From the command line? > > > Dave > -- > David Snyder @ Snide Computer Services - Folcroft, PA > Email: dave@snide.com Web: http://www.snide.com > > sending to informix-list |
| Thread Tools | |
| Display Modes | |
|
|