The userID length supported by DB2 Universal Database has been increased from 8 characters to 30 characters for some operating systems. The following list shows the Version 7 level of support for:
All DB2 Universal Database Version 7 servers running Windows 32-bit operating systems support userIDs of up to 30 characters. All DB2 Universal Database Version 7 clients support userIDs of up to 30 characters. For example, any Version 7 client can connect to a Version 7 Windows 32-bit server with a 30 byte userID. But a Version 7 client with 30 byte userID can not connect to a non-Windows 32 bit server.
All DB2 Universal Database Version 7 support authIDs of up to 30 characters.
All DB2 Universal Database Version 7 support schema names of up to 30 characters.
See the Quick Beginnings for your operating system for more information. You should also review the following sections.
Pre-Version 7 servers do not support userIDs, authIDs, and schemas that are longer than 8 characters. Version 7 applications that are designed to exploit the >8 character support will fail when connecting with down-level DB2 servers.
The length of userID and schema names supported by replication has been increased from 8 characters to 18 characters. See the Replication Guide and Reference for more information.
OS/390 supports only 8-character userIDs and authIDs. Similar length restrictions apply to the schema name in any statements being sent to the host.
OS/400 supports only 10-character userIDs and authIDs. Similar length restrictions apply to the schema name in any statements being sent to the host.
Version 7 databases with a schema name greater than 8 characters cannot be imported or exported with pre-Version 7 code because truncation occurs.
Existing stored procedures that assume that userIDs, authIDs, and schema names are limited to 8 characters should be examined. Unexpected behavior might occur if these stored procedures are used in a Version 7 environment.