syslocks shows negative rowid

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

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

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

Art, Jacques, thanks very much. Regards. Roger