Starting from version 8.0 Mainframe DB2 supports 128 bytes for table/owner/index names and 30 bytes for column names. Currentrly in MFE 3.1 the SYSTEM, TUTORIAL and MAINTAIN locations are DB2 Version 6 compatible. It is not possible to perform DDL in which the table/owner/index/column names are more than18 bytes.

Longer names for tables, owners, indexes and columns are supported in both XDB V8 and V9 engines. However, the location must also be able to support longer names. If your client is using V8 or V9 engine with any of the older locations, then the server will limit the names to 18 characters. If a new location is created, then the new location will have the NAME column VARCHAR(128) in the table SYSIBM.SYSCOLUMNS and the server will allow longer names.