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

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)