onstat -d display negative value

Posted in 2013

Summary

User reported onstat -d displaying a negative free pages value (-2289488) for chunk 34 after partitioning a table on HP-UX 11v2 with IDS 11.50.FC8. Suggested solutions included running oncheck -cr and dropping/recreating the chunk, but the thread shows no confirmed resolution to the issue.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: Storage & Space Management, Stored Procedures & SPL, Platform-Specific Issues

Wiesiek Glod — Fri, 22 Mar 2013 12:35:51 — source: IIUG Forums & Mailing Lists

Hi, OS: HP-UX 11v2 PA-RISC, IDS 11.50.FC8 After I done partitoned table my onstat -d on one chunks display -2289488 , what's wrong ? I done oncheck -cDI database:table_name, restarted instace and no result ... ..... Chunks address chunk/dbs offset size free bpages flags pathname c00000001dc321c0 1 1 0 1048576 951101 PO-B- /opt/ids/.dev/hdev/rootdbs c0000000230c2b50 2 2 0 2097152 97099 PO-B- /opt/ids/.dev/hdev/logdbs ...... c0000000230c77e8 32 5 0 20971520 1261548 PO-B- /opt/ids/.dev/hdev/hmaxdbs24 c0000000230c79d8 33 5 0 20971520 199727 PO-B- /opt/ids/.dev/hdev/hmaxdbs25 c0000000230c7bc8 34 5 0 20971520 -2289488 PO-B- /opt/ids/.dev/hdev/hmaxdbs26 c0000000230c7db8 35 5 0 20971520 10571563 PO-B- /opt/ids/.dev/hdev/hmaxdbs27 .... Best regards -- wkg

↪ replying to Wiesiek Glod

Art Kagel — Fri, 22 Mar 2013 12:51:41 — source: IIUG Forums & Mailing Lists

Try running oncheck -cr Art Art S. Kagel Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Fri, Mar 22, 2013 at 8:35 AM, Wiesiek Glod <wkg@x2.pl> wrote: > Hi, > > OS: HP-UX 11v2 PA-RISC, IDS 11.50.FC8 > After I done partitoned table my onstat -d on one > chunks display -2289488 , what's wrong ? > I done oncheck -cDI database:table_name, restarted > instace and no result ... > > ...... > Chunks > address chunk/dbs offset size free bpages > flags pathname > c00000001dc321c0 1 1 0 1048576 951101 > PO-B- /opt/ids/.dev/hdev/rootdbs > c0000000230c2b50 2 2 0 2097152 97099 > PO-B- /opt/ids/.dev/hdev/logdbs > ....... > c0000000230c77e8 32 5 0 20971520 1261548 > PO-B- /opt/ids/.dev/hdev/hmaxdbs24 > c0000000230c79d8 33 5 0 20971520 199727 > PO-B- /opt/ids/.dev/hdev/hmaxdbs25 > c0000000230c7bc8 34 5 0 20971520 -2289488 > PO-B- /opt/ids/.dev/hdev/hmaxdbs26 > > c0000000230c7db8 35 5 0 20971520 > 10571563 PO-B- /opt/ids/.dev/hdev/hmaxdbs27 > ..... > > Best regards > -- > wkg > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --bcaec54eef8c604ad604d882eadf

↪ replying to Art Kagel

Wiesiek Glod — Fri, 22 Mar 2013 13:15:46 — source: IIUG Forums & Mailing Lists

Hi Art This is the same result ;-/ On Fri, 2013-03-22 at 08:51 -0400, Art Kagel wrote: > Try running oncheck -cr > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Fri, Mar 22, 2013 at 8:35 AM, Wiesiek Glod <wkg@x2.pl> wrote: > > > Hi, > > > > OS: HP-UX 11v2 PA-RISC, IDS 11.50.FC8 > > After I done partitoned table my onstat -d on one > > chunks display -2289488 , what's wrong ? > > I done oncheck -cDI database:table_name, restarted > > instace and no result ... > > > > ...... > > Chunks > > address chunk/dbs offset size free bpages > > flags pathname > > c00000001dc321c0 1 1 0 1048576 951101 > > PO-B- /opt/ids/.dev/hdev/rootdbs > > c0000000230c2b50 2 2 0 2097152 97099 > > PO-B- /opt/ids/.dev/hdev/logdbs > > ....... > > c0000000230c77e8 32 5 0 20971520 1261548 > > PO-B- /opt/ids/.dev/hdev/hmaxdbs24 > > c0000000230c79d8 33 5 0 20971520 199727 > > PO-B- /opt/ids/.dev/hdev/hmaxdbs25 > > c0000000230c7bc8 34 5 0 20971520 -2289488 > > PO-B- /opt/ids/.dev/hdev/hmaxdbs26 > > > > c0000000230c7db8 35 5 0 20971520 > > 10571563 PO-B- /opt/ids/.dev/hdev/hmaxdbs27 > > ..... > > > > Best regards > > -- > > wkg > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --bcaec54eef8c604ad604d882eadf > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > -- wkg

↪ replying to Wiesiek Glod

Mueller, Daniel D. — Fri, 22 Mar 2013 14:09:08 — source: IIUG Forums & Mailing Lists

Is there anything in it yet? Can you drop it and recreate it? Dan -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Wiesiek Glod Sent: Friday, March 22, 2013 9:16 AM To: ids@iiug.org Subject: Re: onstat -d display negative value [29878] Hi Art This is the same result ;-/ On Fri, 2013-03-22 at 08:51 -0400, Art Kagel wrote: > Try running oncheck -cr > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Fri, Mar 22, 2013 at 8:35 AM, Wiesiek Glod <wkg@x2.pl> wrote: > > > Hi, > > > > OS: HP-UX 11v2 PA-RISC, IDS 11.50.FC8 After I done partitoned table > > my onstat -d on one chunks display -2289488 , what's wrong ? > > I done oncheck -cDI database:table_name, restarted instace and no > > result ... > > > > ...... > > Chunks > > address chunk/dbs offset size free bpages flags pathname > > c00000001dc321c0 1 1 0 1048576 951101 > > PO-B- /opt/ids/.dev/hdev/rootdbs > > c0000000230c2b50 2 2 0 2097152 97099 > > PO-B- /opt/ids/.dev/hdev/logdbs > > ....... > > c0000000230c77e8 32 5 0 20971520 1261548 > > PO-B- /opt/ids/.dev/hdev/hmaxdbs24 > > c0000000230c79d8 33 5 0 20971520 199727 > > PO-B- /opt/ids/.dev/hdev/hmaxdbs25 > > c0000000230c7bc8 34 5 0 20971520 -2289488 > > PO-B- /opt/ids/.dev/hdev/hmaxdbs26 > > > > c0000000230c7db8 35 5 0 20971520 > > 10571563 PO-B- /opt/ids/.dev/hdev/hmaxdbs27 ..... > > > > Best regards > > -- > > wkg > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --bcaec54eef8c604ad604d882eadf > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > -- wkg ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Wiesiek Glod

Khaled Bentebal — Fri, 22 Mar 2013 19:34:43 — source: IIUG Forums & Mailing Lists

Hi, Do you get the same thing when running : select * from sysmaster:syschunks What do you get when running: oncheck -pr for that particular chunk. Cordialement, Regards, Khaled Bentebal Directeur Général - ConsultiX Président UGIF - User Group Informix France IIUG - Board of Directors Tél: 33 (0) 1 39 12 18 00 Fax: 33 (0) 1 39 12 18 18 Mobile: 33 (0) 6 07 78 41 97 Email: khaled.bentebal@consult-ix.fr Site Web: www.consult-ix.fr Le 22/03/13 13:35, Wiesiek Glod a écrit : > Hi, > > OS: HP-UX 11v2 PA-RISC, IDS 11.50.FC8 > After I done partitoned table my onstat -d on one > chunks display -2289488 , what's wrong ? > I done oncheck -cDI database:table_name, restarted > instace and no result ... > > ...... > Chunks > address chunk/dbs offset size free bpages > flags pathname > c00000001dc321c0 1 1 0 1048576 951101 > PO-B- /opt/ids/.dev/hdev/rootdbs > c0000000230c2b50 2 2 0 2097152 97099 > PO-B- /opt/ids/.dev/hdev/logdbs > ....... > c0000000230c77e8 32 5 0 20971520 1261548 > PO-B- /opt/ids/.dev/hdev/hmaxdbs24 > c0000000230c79d8 33 5 0 20971520 199727 > PO-B- /opt/ids/.dev/hdev/hmaxdbs25 > c0000000230c7bc8 34 5 0 20971520 -2289488 > PO-B- /opt/ids/.dev/hdev/hmaxdbs26 > > c0000000230c7db8 35 5 0 20971520 > 10571563 PO-B- /opt/ids/.dev/hdev/hmaxdbs27 > ..... > > Best regards

↪ replying to Art Kagel

kern_doe@yahoo.com — Fri, 22 Mar 2013 21:00:15 — source: IIUG Forums & Mailing Lists

I see a dot in the path, is it normal? Not sure if it has any thing to do with your problem... /opt/ids/.dev/hdev/ -------- Original message -------- From: Art Kagel <art.kagel@gmail.com> Date: To: ids@iiug.org Subject: Re: onstat -d display negative value [29877] Try running oncheck -cr Art Art S. Kagel Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Fri, Mar 22, 2013 at 8:35 AM, Wiesiek Glod <wkg@x2.pl> wrote: > Hi, > > OS: HP-UX 11v2 PA-RISC, IDS 11.50.FC8 > After I done partitoned table my onstat -d on one > chunks display -2289488 , what's wrong ? > I done oncheck -cDI database:table_name, restarted > instace and no result ... > > ...... > Chunks > address chunk/dbs offset size free bpages > flags pathname > c00000001dc321c0 1 1 0 1048576 951101 > PO-B- /opt/ids/.dev/hdev/rootdbs > c0000000230c2b50 2 2 0 2097152 97099 > PO-B- /opt/ids/.dev/hdev/logdbs > ....... > c0000000230c77e8 32 5 0 20971520 1261548 > PO-B- /opt/ids/.dev/hdev/hmaxdbs24 > c0000000230c79d8 33 5 0 20971520 199727 > PO-B- /opt/ids/.dev/hdev/hmaxdbs25 > c0000000230c7bc8 34 5 0 20971520 -2289488 > PO-B- /opt/ids/.dev/hdev/hmaxdbs26 > > c0000000230c7db8 35 5 0 20971520 > 10571563 PO-B- /opt/ids/.dev/hdev/hmaxdbs27 > ..... > > Best regards > -- > wkg > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --bcaec54eef8c604ad604d882eadf ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

onstat -d display negative value

Related threads

Glossary

Your privacy choices