Changing the limit of the number of SQL errors collected for a single SQLCODE

Document ID : KB000025501
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

How to change the limit on the number of errors collected for a single SQLCODE?

Solution:

This is done within the collection profile by:

  1. Choosing option 4, View/modify profile.

  2. Choosing option 1, View Collection Profiles.

  3. Selecting the appropriate profile.

  4. Specifying 'X' in the View Group Type field.

  5. Specifying the desired number in these fields:
    Max SQL errors retained in a collection interval
    Max SQL errors retained for a single SQLCODE

  6. Hitting PF3 to save this update in the profile.

  7. Use the 'L' line command next to the updated profile on the collection profiles Display Screen and this should then load the modified profile and from that point forward, the new options take over.