Why the negative value on isread ?

Hello Masters: Why the negative value on isread ? What are the real value ? Thanks JUAN VALERIANO VILLEGAS DBA ---------------------------------------------------- fecha 08/23/2006 dbspace rltab1 partnum 23068801 extnum 5 phys 70787655 size 1659 log 6640 tabname 245_1584 dbsname viajes owner informix isread -1173772654 iswrite 0 isrwrite 0 isdelete 0 seqscan 0 ----------------------------------------------------- unload to /informix/monito/tab_x_dbs/tmp.txtselect today, DBINFO("DBSPACE",pe_partnum) dbs , a.pe_partnum, a.pe_extnum, a.pe_phys, a.pe_size, a.pe_log, b.tabname, b.dbsname, b.owner, c.pf_isread, c.pf_iswrite, c.pf_isrwrite, c.pf_isdelete,c.pf_seqscans from sysptnext a, systabnames b , sysptntab c where a.pe_partnum = b.partnum and b.partnum = c.partnum order by 2,3,1 ;

The stats are all 32bit quantities. They will wrap negative if > 2^31-1 (~2.4 billion. If you fetch the value into an unsigned host variable in an ODBC or ESQL/C app you can see the actual value. Art S. Kagel

Add 2 billion to the number. The number rolls around at 2 billion and change. A good reason to run onstat -z with some regularity. j. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]On Behalf Of Valeriano Villegas Juan Sent: Thursday, August 31, 2006 7:28 PM To: ids@iiug.org Subject: Why the negative value on isread ? [7387] Hello Masters: Why the negative value on isread ? What are the real value ? Thanks JUAN VALERIANO VILLEGAS DBA ---------------------------------------------------- fecha 08/23/2006 dbspace rltab1 partnum 23068801 extnum 5 phys 70787655 size 1659 log 6640 tabname 245_1584 dbsname viajes owner informix isread -1173772654 iswrite 0 isrwrite 0 isdelete 0 seqscan 0 ----------------------------------------------------- unload to /informix/monito/tab_x_dbs/tmp.txtselect today, DBINFO("DBSPACE",pe_partnum) dbs , a.pe_partnum, a.pe_extnum, a.pe_phys, a.pe_size, a.pe_log, b.tabname, b.dbsname, b.owner, c.pf_isread, c.pf_iswrite, c.pf_isrwrite, c.pf_isdelete,c.pf_seqscans from sysptnext a, systabnames b , sysptntab c where a.pe_partnum = b.partnum and b.partnum = c.partnum order by 2,3,1 ; **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.