syslocks shows negative rowid

Posted in 2017

Summary

Roger Vilca saw a negative rowidlk value in syslocks (-1316080380) while onstat -k showed b18e3504. Art Kagel explained the rowid is 32 bits and the display is signed. Jacques Renaut confirmed the value is the lock being sought, since 0xb18e3504 equals -1316080380 signed, and suggested selecting hex(rowidlk) to match onstat -k. Roger thanked them; solved.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: General Discussion

ROGER VILCA — Thu, 26 Jan 2017 22:24:33 — source: IIUG Forums & Mailing Lists

Hi, Please anybody knows what it means the negative value in the field rowidlk ? For example: dbsname dbt tabname pr_tab rowidlk -1316080380 keynum 0 type X owner 2561937 waiter I'm looking for a lock, but I don't be able to detect it. Moreover, in onstat -k the rowid is b18e3504 Regards

↪ replying to ROGER VILCA

Art Kagel — Thu, 26 Jan 2017 23:30:49 — source: IIUG Forums & Mailing Lists

Roger: It indicates that the rowid is 32bits long so the display, which is unfortunately signed, is showing as a negative. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Jan 26, 2017 at 5:24 PM, ROGER VILCA <rvilca@luzdelsur.com.pe> wrote: > Hi, > > Please anybody knows what it means the negative value in the field rowidlk > ? > > For example: > > dbsname dbt > tabname pr_tab > rowidlk -1316080380 > keynum 0 > type X > owner 2561937 > waiter > > I'm looking for a lock, but I don't be able to detect it. > > Moreover, in onstat -k the rowid is b18e3504 > > Regards > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --94eb2c1b6e0695ea8d054707bc72

↪ replying to ROGER VILCA

JACQUES RENAUT — Fri, 27 Jan 2017 13:13:46 — source: IIUG Forums & Mailing Lists

Original post: Hi, Please anybody knows what it means the negative value in the field rowidlk ? For example: dbsname dbt tabname pr_tab rowidlk -1316080380 keynum 0 type X owner 2561937 waiter I'm looking for a lock, but I don't be able to detect it. Moreover, in onstat -k the rowid is b18e3504 Regards Response: Ironically, what you show above is the lock you are looking for. onstat -k prints out the rowid in hexidecimal so 0xb18e3504. The select statement appears to be printing the rowid as a signed integer, so 0xb18e3504 is equal to -1316080380. You could change your select statement to hex(rowidlk) and it would be easier to match to output in onstat -k. Jacques Renaut IBM Informix

↪ replying to JACQUES RENAUT

ROGER VILCA — Fri, 27 Jan 2017 16:51:44 — source: IIUG Forums & Mailing Lists

Art, Jacques, thanks very much. Regards. Roger

Related threads

Glossary

onstat