Unsupported ccsid error during introspection in DB2 zOS

Unsupported ccsid error during introspection in DB2 zOS

book

Article ID: KB0079944

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization TDV All Versions

Description

If the introspection fails in DB2 Z/OS with Unsupported ccsid, encoding, or locale: "Cp290“ error, than please follow below mentioned steps to resolve he same.

 

ERROR [IntrospectResourcesTask Introspect Datasource] 2018-04-20 16:42:24.622 +0900 TaskManager - Task failed: IntrospectResourcesTask Introspect Datasource

[ibm][db2][jcc][10275][10041] Unsupported ccsid, encoding, or locale: "Cp290".

  at com.compositesw.server.task.TaskWithResults.run(TaskWithResults.java:87)

  at com.compositesw.server.task.TaskManager$TaskRunner.run(TaskManager.java:146)

  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

  at java.lang.Thread.run(Thread.java:745)

Caused by: [ibm][db2][jcc][10275][10041] Unsupported ccsid, encoding, or locale: "Cp290".

  at com.compositesw.cdms.datasource.introspect.task.IntrospectResourcesTask.doTaskWithResultsRun(IntrospectResourcesTask.java:176)

  at com.compositesw.server.task.TaskWithResults.run(TaskWithResults.java:77)

  ... 4 more

Issue/Introduction

If the introspection fails in DB2 Z/OS with Unsupported ccsid, encoding, or locale: "Cp290“ error, than please follow below mentioned steps to resolve he same.

Resolution

1.Download IBM's charsets.jar file.
2.Replace existing TDV’s charsets.jar under Root\jre\lib with IBM’s jar file downloaded.
3.Restart TDV server.
4.Now you will be able to introspect successfully.