Problem handling

 

The primary strategy for capturing and reporting error information for the distributed database function is called first failure data capture (FFDC).

The purpose of FFDC support is to provide accurate information about errors that are detected in the distributed data management (DDM) component of the i5/OS^® operating system from which an Authorized Program Analysis Report (APAR) can be created. By means of this function, key structures and the DDM data stream are automatically dumped to a spooled file. The first 1024 bytes of the error information are also logged in the system error log. This automatic dumping of error information about the first occurrence of an error means that the failure does not need to be re-created to be reported by the customer. FFDC is active in both the application requester and application server functions of the i5/OS DDM component. However, for the FFDC data to be logged, the system value QSFWERRLOG must be set to *LOG.

Not all negative SQLCODEs are dumped; only those that can be used to produce an APAR are dumped. For more information about handling problems on distributed relational database operations, see the Distributed Database Problem Determination Guide SC26-4782.

When an SQL error is detected, an SQLCODE with a corresponding SQLSTATE is returned in the SQLCA.

 

Parent topic:

Distributed relational database function and SQL

 

Related reference

SQL messages and codes