I'm trying to export documents from ICA 3.0 into a DB2 (Express C 10.1) DB.
I'm exporting just a couple of fields with simple names in the fact table, in order to check the configuration procedure,
but I always get the following error.
FFQEY0402E Table UBIS.EXPORT_METADATA cannot be created. Check if any invalid characters are used for schema, table, or column name. SQL Error Code:-286, SQL Status Code:42727, SQL Message Code:DB2 SQL Error: SQLCODE=-286, SQLSTATE=42727, SQLERRMC=8192;DB2INST1, DRIVER=4.13.111.
The main table (and some others) of the export schema is regularly created.
The error is on the EXPORT_METADATA table, but I have no controls on the column names of this EXPORT_METADATA table.
Do you have any suggestion in order to bypass the problem?
This topic has been locked.
Pinned topic Error exporting docs into DB2 database
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
bfoyle 060001WDQ360 Posts
Re: Error exporting docs into DB2 database2013-01-23T19:02:21ZThis is the accepted answer. This is the accepted answer.We don't explicitly test with ExpressC but we didn't add support for DB2 10.1 until ICA 3.0 fixpack 1 so (assuming that the ExpressC codebase 10.1 was DB2 10.1, which sounds reasonable) I would start by making sure you have the ICA fixpack.
SystemAdmin 110000D4XK197 Posts
Re: Error exporting docs into DB2 database2013-01-25T01:08:25ZThis is the accepted answer. This is the accepted answer.Hi qaetanoS,
I have found in the past that when trying to export to DB2, I need to ensure Table Spaces and Buffer Pools are adequately sized. The defaults are sometimes too small for the operations to take place. I would suggest creating larger User and Temporary Table Spaces / Buffer Pools and then try the export again.
myutaka 0600010PXJ11 Posts
Re: Error exporting docs into DB2 database2013-02-27T09:26:43ZThis is the accepted answer. This is the accepted answer.Hi
Could you try to create a database with large pagesize?
CREATE DB <database_name> PAGESIZE <size>
e.g.) CREATE DB adb PAGESIZE 8192