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

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.

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.