CA Gen Host Encyclopedia Installation jobs fail with Sqlcode -104

Products

• Gen
• Gen - Host Encyclopedia

Issue/Introduction

Host Encyclopedia installation jobs fail with SQLCODE of -104 when the underlying Db2 subsystem is setup in Unicode Encoding Scheme.

 DSNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL ". 4.". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: <ERR_STMT> <WNG_STMT>

Environment

Release:8.6

Component: CA Gen Host Encyclopedia

Resolution

The SQL Errors -104 are typically caused when there is a mismatch of Encoding Schemes while execution of SQL queries i.e. when the incoming data/the creation of the objects ENCODING Scheme doesn’t match with the Db2 Subsystem default Encoding scheme.

For 8.6, this will be addressed soon.

Additional Information

Illegal Symbol errors while execution of the bind jobs (Installation jobs of HE CEJOB*). Few examples of the errors are shown below:

 SET CURRENT SQLID = 'XXXX';

-

 SQLERROR ON   SET      COMMAND, PREPARE  FUNCTION

  RESULT OF SQL STATEMENT:

  DSNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL ". 4.". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: <ERR_STMT> <WNG_STMT> TRANSFER

           GET SQL SAVEPOINT HOLD FREE

  DSNT418I SQLSTATE   = 42601 SQLSTATE RETURN CODE

  DSNT415I SQLERRP    = DSNHPARS SQL PROCEDURE DETECTING ERROR

  DSNT416I SQLERRD    = 3  0  0  -1  1  502 SQL DIAGNOSTIC INFORMATION

  DSNT416I SQLERRD    = X'00000003'  X'00000000'  X'00000000'  X'FFFFFFFF'  X'00000001'  X'000001F6' SQL DIAGNOSTIC

           INFORMATION

   SET CURRENT SQLID = 'XXXX';

-

   CREATE DATABASE XXXXXX

     STOGROUP SYSDEFLT

     BUFFERPOOL BP0;

-

 SQLERROR ON   CREATE   COMMAND, PREPARE  FUNCTION

  RESULT OF SQL STATEMENT:

  DSNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL ".O>O9ÚÚO¾àa.". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: <ERR_STMT> <WNG_STMT>

           TRANSFER GET SQL SAVEPOINT HOLD FRE

  DSNT418I SQLSTATE   = 42601 SQLSTATE RETURN CODE

  DSNT415I SQLERRP    = DSNHPARS SQL PROCEDURE DETECTING ERROR

  DSNT416I SQLERRD    = 3  0  0  -1  1  502 SQL DIAGNOSTIC INFORMATION

  DSNT416I SQLERRD    = X'00000003'  X'00000000'  X'00000000'  X'FFFFFFFF'  X'00000001'  X'000001F6' SQL DIAGNOSTIC

 -

   COMMIT;

-

 SQLERROR ON   COMMIT   COMMAND, PREPARE  FUNCTION

  RESULT OF SQL STATEMENT:

  DSNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL "COMMITR". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: <ERR_STMT> <WNG_STMT>

           TRANSFER GET SQL SAVEPOINT HOLD FREE

  DSNT418I SQLSTATE   = 42601 SQLSTATE RETURN CODE

  DSNT415I SQLERRP    = DSNHPARS SQL PROCEDURE DETECTING ERROR

  DSNT416I SQLERRD    = 3  0  0  -1  1  502 SQL DIAGNOSTIC INFORMATION

  DSNT416I SQLERRD    = X'00000003'  X'00000000'  X'00000000'  X'FFFFFFFF'  X'00000001'  X'000001F6' SQL DIAGNOSTIC

           INFORMATION