DBUTLTY RETIX produces a small snap dump with a few lines and no other messages. What causes this?

Products

• Datacom
• DATACOM - AD
• CIS
• COMMON SERVICES FOR Z/OS
• 90S SERVICES
• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS
• COMMON PRODUCT SERVICES COMPONENT
• Common Services
• CA ECOMETER SERVER COMPONENT FOC
• Easytrieve Report Generator for Common Services
• INFOCAI MAINTENANCE
• IPC
• UNICENTER JCLCHECK COMMON COMPONENT
• Mainframe VM Product Manager
• CHORUS SOFTWARE MANAGER
• CA ON DEMAND PORTAL
• CA Service Desk Manager - Unified Self Service
• PAM CLIENT FOR LINUX ON MAINFRAME
• MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME
• GRAPHICAL MANAGEMENT INTERFACE
• WEB ADMINISTRATOR FOR TOP SECRET
• Xpertware

Issue/Introduction

I am running a DBUTLTY RETIX and it produces a small snap dump with a few lines and no other messages.

099DF140                  00000018 F7F2F8F8  F0F0F5F6 F0F7C1C6 F7F2F8F8 F0F0F5C6          *        ....7288005607AF72880056*
099DF160 F7F7F4F8                                                                         *7748                            *

What causes this?

 

Environment

Release: DATABB00200-14-Datacom/AD
Component:

Resolution

The DBUTLTY RETIX function will produce a snap dump if there are duplicate values in the table for keys defined as UNIQUE or a Master Key  defined as allowing no duplicates. It dumps the key id followed by the key value.

In the above example the duplicate key is for key id x'18' (24 decimal)

The duplicate value follows the keyid:  7288005607AF72880056F7F7F4F8 

Snap dumps for duplicates will also be produced by the LOAD and MASADD functions.

You need to remove the duplicate rows from the table.

Additional Information

See Reading Snap Dumps for Duplicate Key Values in DocOps