Last page of first extent in a partition

Posted in 2014

Andrew Ford — Tue, 02 Dec 2014 17:19:22 — source: IIUG Forums & Mailing Lists

Is there something special about the last page in the first extent of a partition? It is marked as a full data page in the bitmap (bitmap value of 12), but oncheck -pP shows the page to be free and the raw data looks free (0000 0000 ffff ffff). Thanks, Andrew

↪ replying to Andrew Ford

Andrew Ford — Tue, 02 Dec 2014 17:21:17 — source: IIUG Forums & Mailing Lists

Never mind, it looks to be a Partition Free List Page according to the flags in syspaghdr. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Andrew Ford Sent: Tuesday, December 02, 2014 11:19 AM To: ids@iiug.org Subject: Last page of first extent in a partition [34262] Is there something special about the last page in the first extent of a partition? It is marked as a full data page in the bitmap (bitmap value of 12), but oncheck -pP shows the page to be free and the raw data looks free (0000 0000 ffff ffff). Thanks, Andrew **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Andrew Ford

Alexandre Marini — Tue, 02 Dec 2014 17:26:37 — source: IIUG Forums & Mailing Lists

Hi Andrew. What is the engine version? You may be facing an APAR. Did you try to run oncheck -cD on the table? If there is some warning about free spaces in bitmap, you should correct all, and this may fix your issue. If you want the apar I can send you later, ok? Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10 IBM Information Management Informix Technical Professional IBM Certified Developer - Informix Genero BRIUG website administrator Informix independent consultant > To: ids@iiug.org > From: andrew@informix-dba.com > Subject: Last page of first extent in a partition [34262] > Date: Tue, 2 Dec 2014 12:19:24 -0500 > > Is there something special about the last page in the first extent of a > partition? > > It is marked as a full data page in the bitmap (bitmap value of 12), but > oncheck -pP shows the page to be free and the raw data looks free (0000 0000 > ffff ffff).> > Thanks, > > Andrew > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

↪ replying to Alexandre Marini

Andrew Ford — Tue, 02 Dec 2014 17:34:33 — source: IIUG Forums & Mailing Lists

11.70.FC4, but I think what I am looking at is normal behavior. Last page in the first extent of each of the 10 partitions (fragments) associated with the table have this "free" but "full" page and the flags on the page header indicate it is doing something special. No warnings about free spaces in the bitmap so I think I'm good here. Thanks, Andrew -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Alexandre Marini Sent: Tuesday, December 02, 2014 11:27 AM To: ids@iiug.org Subject: RE: Last page of first extent in a partition [34264] Hi Andrew. What is the engine version? You may be facing an APAR. Did you try to run oncheck -cD on the table? If there is some warning about free spaces in bitmap, you should correct all, and this may fix your issue. If you want the apar I can send you later, ok? Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10 IBM Information Management Informix Technical Professional IBM Certified Developer - Informix Genero BRIUG website administrator Informix independent consultant > To: ids@iiug.org > From: andrew@informix-dba.com > Subject: Last page of first extent in a partition [34262] > Date: Tue, 2 Dec 2014 12:19:24 -0500 > > Is there something special about the last page in the first extent of > a partition? > > It is marked as a full data page in the bitmap (bitmap value of 12), > but oncheck -pP shows the page to be free and the raw data looks free > (0000 0000 ffff ffff). > > Thanks, > > Andrew > > > **************************************************************************** *** > Forum Note: Use "Reply" to post a response in the discussion forum. > **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Andrew Ford

Alexandre Marini — Tue, 02 Dec 2014 17:56:37 — source: IIUG Forums & Mailing Lists

Ok, the APAR we've run into was APAR IC98529, just in case you want to take a look, but I think it's not your case. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10 IBM Information Management Informix Technical Professional IBM Certified Developer - Informix Genero BRIUG website administrator Informix independent consultant > To: ids@iiug.org > From: andrew@informix-dba.com > Subject: RE: Last page of first extent in a partition [34265] > Date: Tue, 2 Dec 2014 12:34:34 -0500 > > 11.70.FC4, but I think what I am looking at is normal behavior. Last page in > the first extent of each of the 10 partitions (fragments) associated with > the table have this "free" but "full" page and the flags on the page header > indicate it is doing something special. > > No warnings about free spaces in the bitmap so I think I'm good here. > > Thanks, > > Andrew > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Alexandre Marini > Sent: Tuesday, December 02, 2014 11:27 AM > To: ids@iiug.org > Subject: RE: Last page of first extent in a partition [34264] > > Hi Andrew. > What is the engine version? > You may be facing an APAR. > Did you try to run oncheck -cD on the table? If there is some warning about > free spaces in bitmap, you should correct all, and this may fix your issue. > If you want the apar I can send you later, ok? > > Regards. > > Alexandre Marini > IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10 > > IBM Information Management Informix Technical Professional > > IBM Certified Developer - Informix Genero BRIUG website administrator > Informix independent consultant > > > To: ids@iiug.org > > From: andrew@informix-dba.com > > Subject: Last page of first extent in a partition [34262] > > Date: Tue, 2 Dec 2014 12:19:24 -0500 > > > > Is there something special about the last page in the first extent of > > a partition? > > > > It is marked as a full data page in the bitmap (bitmap value of 12), > > but oncheck -pP shows the page to be free and the raw data looks free > > (0000 0000 ffff ffff). > > > > Thanks, > > > > Andrew > > > > > > > **************************************************************************** > *** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > **************************************************************************** > *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >