Comment 8 for bug 1274962

Revision history for this message
Guy Groulx (guy-groulx) wrote : Re: EXECUTE.BATCH hangs for a long time doing updates or deletes

DROP TABLE TRAFODION.MXOLTP.TBL500;
CREATE TABLE TRAFODION.MXOLTP.TBL500
  (
    CNT INT UNSIGNED NO DEFAULT NOT NULL
  , COL1 INT UNSIGNED NO DEFAULT NOT NULL
  , COL2 INT UNSIGNED NO DEFAULT NOT NULL
  , COL3 INT UNSIGNED NO DEFAULT NOT NULL
  , COL4 INT UNSIGNED NO DEFAULT NOT NULL
  , COL5 INT UNSIGNED NO DEFAULT NOT NULL
  , COL6 INT UNSIGNED NO DEFAULT NOT NULL
  , COL7 INT UNSIGNED NO DEFAULT NOT NULL
  , COL10 CHAR(468) NO DEFAULT NOT NULL
  , PRIMARY KEY (CNT ASC)
  ) SALT USING 20 PARTITIONS
  ;
exit

The update command used is in the code above.
    up_col1 = 11;
    up_col2 = 22;