IPv6 Database Issues

Migration Considerations › IPv6 Database Issues

IPv6 Database Issues

Note: If you have not implemented IPv6 or are migrating from r11.7, disregard this section.

Although the database column name and item type definitions for the ReportCenter database have not changed, some existing character columns have lengthened in the RESOURCE table definition supplied. This change is to fit TCP/IP Version 6 IP addresses.

If your enterprise includes z/OS IPv6 resources and you are migrating from r11 through r11.6, expand these column lengths; otherwise, full IPv6 addresses are truncated if necessary, before being stored in the database.

RESOURCE Table Column Name	Expanded Length for IPv6
RLEVEL	39 characters
RSUBELEMENT	52 characters
RADDRESS	39 characters
RRELATED1	39 characters
RRELATED2	39 characters

Use your DBMS-specific utilities to expand these columns.

Example: Expand Column Length Using ALTER TABLE Function

This example shows how to expand DB2 column lengths using the ALTER TABLE function.

ALTER TABLE NMDB.RESOURCE
      ALTER COLUMN RLEVEL0
      SET DATA TYPE CHAR(39);
ALTER TABLE NMDB.RESOURCE
      ALTER COLUMN RSUBELEMENT
      SET DATA TYPE CHAR(52);
ALTER TABLE NMDB.RESOURCE
      ALTER COLUMN RADDRESS
      SET DATA TYPE CHAR(39);
ALTER TABLE NMDB.RESOURCE
      ALTER COLUMN RRELATED1
      SET DATA TYPE CHAR(39);
ALTER TABLE NMDB.RESOURCE
      ALTER COLUMN RRELATED2
      SET DATA TYPE CHAR(39);