Oninit cdi / Archive
Talk to an expert →

Table reports different.....

Posted in 2008

Topics: Storage & Space Management, Server Administration, Internationalization & Character Sets

NETSKY LIAO — — source: IIUG Forums & Mailing Lists

Hi,all The databases is IDS10.00.FC5,while use "oncheck -pt <db>:<table>" and use SQL get info from <db>:systables. the create date is "Creation date 04/27/2007 17:54:40" / "created 03/18/2008" ? And also has other info not equal,any cause that ? THANK ALL. <1 DB101 [info] :/home/info>oncheck -pt iip:crbt_chargelog TBLspace Report for iip:iip.crbt_chargelog Physical Address 7:775675 Creation date 04/27/2007 17:54:40 TBLspace Flags 800801 Page Locking TBLspace use 4 bit bit-maps Maximum row size 187 Number of special columns 0 Number of keys 1 Number of extents 181 Current serial value 114547412 First extent size 8 Next extent size 16384 Number of pages allocated 368920 Number of pages used 354268 Number of data pages 327415 Number of rows 3274142 Partition partnum 5243907 Partition lockid 5243907 <2 DB101 [info] :/home/info>dbaccess iip - Database selected. > select * from systables where tabname="crbt_chargelog"; tabname crbt_chargelog owner iip partnum 5243907 tabid 2616 rowsize 187 ncols 18 nindexes 2 nrows 3270611 created 03/18/2008 version 171638789 tabtype T locklevel P npused 327062 fextsize 16 nextsize 16 flags 0 site dbname type_xid 0 am_id 0 pagesize 2048 <3 DB101 [info] :/home/info>dbaccess sysmaster - Database selected. > select * from sysdatabases where name="iip"; name iip partnum 5242944 owner informix created 01/05/2004 is_logging 1 is_buff_log 1 is_ansi 0 is_nls 0 flags 20483

↪ replying to NETSKY LIAO
VARTIKA AGRAWAL — — source: IIUG Forums & Mailing Lists

Hi, Oncheck -pt gives the exact date of creation of the table whereas systable gives you the date when the table (ie schema) was last modified/altered, hence the difference. vartika.

↪ replying to NETSKY LIAO
John Miller iii — — source: IIUG Forums & Mailing Lists

The partition page created time which is printed by oncheck -pt dbs:table, Tells you the date and timethe table was created or when the last light append was run, which every is more recent. John = "NETSKY LIAO" = <liaosnet@126.com = > = To Sent by: ids@iiug.org = ids-bounces@iiug. = cc org = Subj= ect Table reports different..... = 03/31/2008 07:32 [11759] = PM = = = Please respond to = ids@iiug.org = = = Hi,all The databases is IDS10.00.FC5,while use "oncheck -pt <db>:<table>" and = use SQL get info from <db>:systables. the create date is "Creation date 04/27/2= 007 17:54:40" / "created 03/18/2008" ? And also has other info not equal,any cause that ? THANK ALL. <1 DB101 [info] :/home/info>oncheck -pt iip:crbt_chargelog TBLspace Report for iip:iip.crbt_chargelog Physical Address 7:775675 Creation date 04/27/2007 17:54:40 TBLspace Flags 800801 Page Locking TBLspace use 4 bit bit-maps Maximum row size 187 Number of special columns 0 Number of keys 1 Number of extents 181 Current serial value 114547412 First extent size 8 Next extent size 16384 Number of pages allocated 368920 Number of pages used 354268 Number of data pages 327415 Number of rows 3274142 Partition partnum 5243907 Partition lockid 5243907 <2 DB101 [info] :/home/info>dbaccess iip - Database selected. > select * from systables where tabname=3D"crbt_chargelog"; tabname crbt_chargelog owner iip partnum 5243907 tabid 2616 rowsize 187 ncols 18 nindexes 2 nrows 3270611 created 03/18/2008 version 171638789 tabtype T locklevel P npused 327062 fextsize 16 nextsize 16 flags 0 site dbname type_xid 0 am_id 0 pagesize 2048 <3 DB101 [info] :/home/info>dbaccess sysmaster - Database selected. > select * from sysdatabases where name=3D"iip"; name iip partnum 5242944 owner informix created 01/05/2004 is_logging 1 is_buff_log 1 is_ansi 0 is_nls 0 flags 20483 ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!! =

↪ replying to VARTIKA AGRAWAL
NETSKY LIAO — — source: IIUG Forums & Mailing Lists

OK.Thanks! These is another question.CAN it appear EXTENT is 263,but is 10 report by oncheck command ? If the table re-builded,the info in systable should change at time;if alter table,the first extent CAN'T be changed... <11 DB53 [info] :/home/info>oncheck -pt iip:crbt_ring TBLspace Report for iip:iip.crbt_ring Physical Address 5:914054 Creation date 01/11/2008 11:58:15 TBLspace Flags 901 Page Locking TBLspace contains VARCHARS TBLspace use 4 bit bit-maps Maximum row size 563 Number of special columns 1 Number of keys 5 Number of extents 10 Current serial value 382971 First extent size 64000 Next extent size 6400 Number of pages allocated 128000 Number of pages used 124333 Number of data pages 112609 Number of rows 337805 Partition partnum 5243030 Partition lockid 5243030 <12 DB53 [info] :/home/info>dbaccess iip - > select dbsname , tabname , count(*), sum(size) > from sysmaster:sysextents > where dbsname="iip" and tabname="crbt_ring" > group by 1,2 > order by 3 desc; dbsname iip tabname crbt_ring (count(*)) 263 (sum) 266784 1 row(s) retrieved.

Glossary