Re: Which table is getting light scan?

I did this. Just to be clear the Physical Page listed is 755fa0. So chunk number would be 7 and page number would be 352160. I run the query select * from sysptnext where pe_offset <= 352160 and ps_offset+pe_size-1 >= 352160 and pe_chunk = 7. No rows. I did force a light scan on a table and did the same thing and could not get it to tie back to anything. This table is fragmented if that makes a difference. Thanks On Jun 4, 3:18 am, Christian Knappke <chkNOSPAMn...@gmx.net> wrote: > From the keyboard of Roy Mercer <roy.mer...@gmail.com>: > > > > > > > From the onstat -g lsc output, how can you tell which table is > > getting the light scan? > > > IBM Informix Dynamic Server Version 10.00.FC7     -- On-Line -- > > Up 227 days 21:37:52 -- 345172 Kbytes> > > Light Scan Info > > descriptor  address           next_lpage  next_ppage > > ppage_left  bufcnt  look_aside > > 73          28c92dae8         21d0        755fa0 > > 16344       8            N > > 74          282229428         24469       755fa0 > > 1415        8            N > > 132         28c32a6a8         b7396       755fa0 > > 49514       8            N > > 133         288b8a8a8         86e66       755fa0 > > 47250       8            Y > > > The next_ppage is supposed the be the physical page, but i can > > not tie this back to anything. > > Hi Roy, > > a page address is composed as follows: 0xCCCPPPPP > where CCC is the chunk number and PPPPP the physical page in that > chunk. You can get the partition (pe_partnum) number from > sysmaster:sysptnext with pe_chunk = CCC and PPPPP in the range of > pe_offset and pe_offset+pe_size-1. With the partition number you > find the table name and further info in sysmaster:systabnames. > > HTH and best regards > Christian > -- > #include <std_disclaimer.h> > /* The opinions stated above are my own and not >    necessarily those of my employer. */- Hide quoted text - > > - Show quoted text -

On Jun 4, 1:57 pm, Roy Mercer <roy.mer...@gmail.com> wrote: > I did this. Just to be clear the Physical Page listed is 755fa0. > So chunk number would be 7 and page number would be 352160. > I run the query select * from sysptnext > where pe_offset <= 352160 and ps_offset+pe_size-1 >= 352160 > and pe_chunk = 7. > No rows. > > I did force a light scan on a table and did the same thing and could > not get it to tie back to anything. > This table is fragmented if that makes a difference. > > Thanks > > On Jun 4, 3:18 am, Christian Knappke <chkNOSPAMn...@gmx.net> wrote: > > > From the keyboard of Roy Mercer <roy.mer...@gmail.com>: > > > > From the onstat -g lsc output, how can you tell which table is > > > getting the light scan? > > > > IBM Informix Dynamic Server Version 10.00.FC7 -- On-Line -- > > > Up 227 days 21:37:52 -- 345172 Kbytes> > > > Light Scan Info > > > descriptor address next_lpage next_ppage > > > ppage_left bufcnt look_aside > > > 73 28c92dae8 21d0 755fa0 > > > 16344 8 N > > > 74 282229428 24469 755fa0 > > > 1415 8 N > > > 132 28c32a6a8 b7396 755fa0 > > > 49514 8 N > > > 133 288b8a8a8 86e66 755fa0 > > > 47250 8 Y > > > > The next_ppage is supposed the be the physical page, but i can > > > not tie this back to anything. > > > Hi Roy, > > > a page address is composed as follows: 0xCCCPPPPP > > where CCC is the chunk number and PPPPP the physical page in that > > chunk. You can get the partition (pe_partnum) number from > > sysmaster:sysptnext with pe_chunk = CCC and PPPPP in the range of > > pe_offset and pe_offset+pe_size-1. With the partition number you > > find the table name and further info in sysmaster:systabnames. > > > HTH and best regards > > Christian > > -- > > #include <std_disclaimer.h> > > /* The opinions stated above are my own and not > > necessarily those of my employer. */- Hide quoted text - > > > - Show quoted text - Make sure you aren't using systables with fragmented tables for the partnum. The partnum for fragmented tables in systables is 0. You have to look at sysfragments or sysmaster:systabnames