Z111 Table Hit Maximum Record Key
- Article Type: General
- Product: Aleph
- Product Version: 16.02
Description:
We're getting a lot of z111 "warnings" in our pc_server_log. When I checked the table, I get the following:
SQL> select max(Z111_rec_key) from z111;
MAX(Z111_
---------
999999999
I'm pretty sure that I need to rebuild the index. My question is this: should we be planning to rebuild this on a regular basis? Or is there some other problem?
Resolution:
The following SQL shows that, despite the high key being 999,999,999, that you actually have only 1,701,387!
SQL> select count(*) from z111
2 ;
COUNT(*)
----------
1701387
So, yes, running p_manage_111 should give you a much lower high key and solve the problem.
(keywords: p-manage-111 manage-111 manage_111)
- Article last edited: 10/8/2013