Excessive CAT fields prevent update of ADM or HOL pattern record

Description:  

An ADM record can no longer be edited. Looking at the record with util f/4 shows that it has thousands of CAT fields. Why? And how to solve the problem?

Resolution:  

Each update of a record produces a CAT field. For ADM or HOL pattern records, this means that CAT fields can add up very quickly.

Run manage-13 (the Delete CAT fields job) in order to reduce the number of CAT fields.

Be aware:

p-manage-13 does not work when parameter "Number of fields to keep" is set to "1".
You have to enter not less than "2". The job keeps always the first and the last CAT field.

If this doesn't solve the problem run SQL (see below) to locate long ADM records and then use manage-21 (Global change) to delete the CAT fields from these records.

We suggest that you periodically run this SQL in *all* of your doc libraries (bib, ADM, HOL) to locate records which are at or nearing the doc record-size limits. (45,000 bytes in version 15.2-up.)

SQL> select Z00_DOC_NUMBER, Z00_DATA_LEN from z00 where Z00_DATA_LEN > 42000;

• Article last edited: 13-May-2016