Unarchive error at linux DB2

[Former Member]

Hi MDM guys,we met a problem when we tried to unarchive the Customer repository which shipped by SAP.If someone has experienced the similar situation and had a solution,please kindly tell us.Thanks a lot.

MDM Verison 5.5.62.33

MDM Server:OS:Windows Server 2003

DB Server:OS Linux;DB:IBM DB2 for Linux

Error log:

Error: SQL_ERROR SQLSTATE= 54010, ErrorCode= -670, Msg=[IBM][CLI Driver][DB2/LINUXX8664] SQL0670N The row length of the table exceeded a limit of "32677" bytes. (Table space "".) SQLSTATE=54010

   CREATE TABLE A2i_Relationships (Id INT NOT NULL, Name_L0 VARCHAR(1020) DEFAULT '' NOT NULL, Name_L1 VARCHAR(1020) DEFAULT '' NOT NULL, Name_L2 VARCHAR(1020) DEFAULT '' NOT NULL, Name_L3 VARCHAR(1020) DEFAULT '' NOT NULL, Name_L4 VARCHAR(1020) DEFAULT '' NOT NULL, Name_L5 VARCHAR(1020) DEFAULT '' NOT NULL, Name_L6 VARCHAR(1020) DEFAULT '' NOT NULL, Name_L7 VARCHAR(1020) DEFAULT '' NOT NULL, Name_L8 VARCHAR(1020) DEFAULT '' NOT NULL, Name_L9 VARCHAR(1020) DEFAULT '' NOT NULL, Name_LA VARCHAR(1020) DEFAULT '' NOT NULL, Name_LB VARCHAR(1020) DEFAULT '' NOT NULL, Name_LC VARCHAR(1020) DEFAULT '' NOT NULL, Name_LD VARCHAR(1020) DEFAULT '' NOT NULL, Name_LE VARCHAR(1020) DEFAULT '' NOT NULL, Name_LF VARCHAR(1020) DEFAULT '' NOT NULL, Name_LG VARCHAR(1020) DEFAULT '' NOT NULL, NameIsParent SMALLINT NOT NULL, SubName_L0 VARCHAR(1020) DEFAULT '' NOT NULL, SubName_L1 VARCHAR(1020) DEFAULT '' NOT NULL, SubName_L2 VARCHAR(1020) DEFAULT '' NOT NULL, SubName_L3 VARCHAR(1020) DEFAULT '' NOT NULL, SubName_L4 VARCHAR(1020) DEFAULT '' NOT NULL, SubName_L5 VARCHAR(1020) DEFAULT '' NOT NULL, SubName_L6 VARCHAR(1020) DEFAULT '' NOT NULL, SubName_L7 VARCHAR(1020) DEFAULT '' NOT NULL, SubName_L8 VARCHAR(1020) DEFAULT '' NOT NULL, SubName_L9 VARCHAR(1020) DEFAULT '' NOT NULL, SubName_LA VARCHAR(1020) DEFAULT '' NOT NULL, SubName_LB VARCHAR(1020) DEFAULT '' NOT NULL, SubName_LC VARCHAR(1020) DEFAULT '' NOT NULL, SubName_LD VARCHAR(1020) DEFAULT '' NOT NULL, SubName_LE VARCHAR(1020) DEFAULT '' NOT NULL, SubName_LF VARCHAR(1020) DEFAULT '' NOT NULL, SubName_LG VARCHAR(1020) DEFAULT '' NOT NULL, Position INT NOT NULL, Type INT NOT NULL, ParentTableId INT NOT NULL, ChildTableId INT NOT NULL, HasPosition SMALLINT NOT NULL, HasQuantity SMALLINT NOT NULL, HasRequired SMALLINT NOT NULL)

[Former Member]

Attached DB2 infomation

Tablespace ID = 0

Name = SYSCATSPACE

Type = Database managed space

Contents = All permanent data. Regular table space.

State = 0x0000

Detailed explanation:

Normal

Tablespace ID = 1

Name = TEMPSPACE1

Type = System managed space

Contents = System Temporary data

State = 0x0000

Detailed explanation:

Normal

Tablespace ID = 2

Name = TSS_32K

Type = System managed space

Contents = System Temporary data

State = 0x0000

Detailed explanation:

Normal

Tablespace ID = 3

Name = TSU_32K

Type = System managed space

Contents = User Temporary data

State = 0x0000

Detailed explanation:

Normal

Tablespace ID = 4

Name = TS_MDM

Type = System managed space

Contents = All permanent data. Regular table space.

State = 0x0000

Detailed explanation:

Normal

Tablespace ID = 5

Name = SYSTOOLSPACE

Type = Database managed space

Contents = All permanent data. Large table space.

State = 0x0000

Database code page = 1208

Database page size = 4096

Multi-page file allocation enabled = YES

Buffer pool size (pages) (BUFFPAGE) = 1000

Changed pages threshold (CHNGPGS_THRESH) = 80

Number of asynchronous page cleaners (NUM_IOCLEANERS) = AUTOMATIC

Default prefetch size (pages) (DFT_PREFETCH_SZ) = AUTOMATIC

Track modified pages (TRACKMOD) = OFF

Default tablespace extentsize (pages) (DFT_EXTENT_SZ) = 32

Log pages during index build (LOGINDEXBUILD) = OFF

TBSPACE PAGESIZE

SYSCATSPACE 4096

TEMPSPACE1 4096

TSS_32K 32768

TSU_32K 32768

SYSTOOLSPACE 4096

TS_MDM 32768