ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

PDA DSNT404I SQLCODE = 100, NOT FOUND:  ROW NOT FOUND FOR FETCH, UPDATE

book

Article ID: 199032

calendar_today

Updated On:

Products

Database Analyzer for DB2 for z/OS Database Management for DB2 for z/OS - Utilities Suite

Issue/Introduction

SQL Code +100  while processing Action for Indexes with national characters. 

The error information is as below, 

Index      - PROD.H745LISÄ - Selected                                   1:18:38
  Processing Action - S3815.ICOPY                                       1:18:38
     ==> Warning - unconditional action invoked                         1:18:38
DSNT404I SQLCODE = 100, NOT FOUND:  ROW NOT FOUND FOR FETCH, UPDATE, OR
         DELETE, OR THE RESULT OF A QUERY IS AN EMPTY TABLE             1:18:38
DSNT418I SQLSTATE   = 02000 SQLSTATE RETURN CODE                        1:18:38
DSNT415I SQLERRP    = DSNXRFFL SQL PROCEDURE DETECTING ERROR            1:18:38
DSNT416I SQLERRD    = -110  0  0  -1  0  0 SQL DIAGNOSTIC INFORMATION   1:18:38
DSNT416I SQLERRD    = X'FFFFFF92'  X'00000000'  X'00000000'             1:18:38
         X'FFFFFFFF'  X'00000000'  X'00000000' SQL DIAGNOSTIC           1:18:38
         INFORMATION                                                    1:18:38
Execution stopped - fatal error encounter - Reason Code 117             1:18:38

Environment

Release : 20.0

Component : CA Database Analyzer for DB2 for z/OS

Resolution

Rebounding the PDA packages resolved the problem.