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.

Earl report against DB2 database results in SQL FLAG:- SQLCODE hex: FFFFB10E, dec: -20210

book

Article ID: 241407

calendar_today

Updated On:

Products

Earl

Issue/Introduction

DSNTRACE DD shows SQLCODE=-20210 after a SQL call

Earl output shows:

SQL name    SQL SELECT FAILED                    
SQL FLAG:- SQLCODE   hex: FFFFB10E, dec:    -20210
 
Problem is noticed during the execution of a Earl report. Not during the actual BIND. Typical user will be unaware the report needs addressed until the error occurs.
 
 
 

Environment

Earl current release

DB2 12 and above

Resolution

The SQL return code during the Earl report is because a REBIND was not completed and is the impacting the Earl report.

The solution is to BIND the DBRM(s) again using the ENCODING(EBCDIC) option.

For Example:

BIND   PLAN(CAISSQL2)   MEM(CAISSQL2)  +

            ACTION(REPLACE)   RETAIN ENCODING(EBCDIC)