IBM Support

Publish to DB2 fails with SQLSTATE 54010

Troubleshooting


Problem

Table Only Publish in a new container fails with an error message a CREATE TABLE statement will result in a table that will be longer than 4005 Bytes, which is an DB2 database limit. The reported SQLSTATE is 54010.

Symptom

SQLSTATE 54010

Resolving The Problem

Either you need to create a tablespace with a pagesize of 32768 - see IBM document in link below on p. 376:

http://www-db.in.tum.de/~teubnerj/teaching/ss06/arch-dbms/db2s2e81.pdf

or, disable the checkbox Prefix Column Names with Data Type during publish

Related Information

[{"Product":{"code":"SSEH6Q","label":"Cognos Planning for Series 7"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Contributor","Platform":[{"code":"PF033","label":"Windows"}],"Version":"Planning - Contributor 7.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SS9S5U","label":"Cognos 8 Planning"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Contributor","Platform":[{"code":"","label":""}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number

1020665

Document Information

Modified date:
15 June 2018

UID

swg21345595