partition 'testdbs:informix.TBLSpace' no more page

Posted in 2018

MARK WORRAD — Tue, 17 Jul 2018 05:31:03 — source: IIUG Forums & Mailing Lists

I received the following message in online.log WARNING: partition 'testdbs:informix.TBLSpace': no more pages I resolved the issue by adding another dbspace and moving databases to that new dbsapce. What i cant figure out is how to determine how many pages i have available now as i would like to monitor this so it does not happen again

↪ replying to MARK WORRAD

LUIS MARQUES — Tue, 17 Jul 2018 13:15:46 — source: IIUG Forums & Mailing Lists

What is the result of "oncheck -pe testdbs | grep TBLSpace" for the "testdbs" dbspace? Either the TBLSpace reached the maximum number of pages for a partition (not likely) or the dbspace run out of free pages.

Glossary

dbspace