• 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