CREATE TABLE m1(
  x1 INTEGER NOT NULL primary key,
  x2 INTEGER NOT NULL,
  x3 VARCHAR ( 100 )
);

INSERT INTO m1 values
  ( 0 , 1 ,'aaa'),
  ( 1 , 1 ,'aaa'),
  ( 2 , 1 ,'aaa'),
  ( 3 , 1 ,'aaa'),
  ( 4 , 1 ,'aaa'),
  ( 5 , 1 ,'aaa'),
  ( 6 , 1 ,'aaa'),
  ( 7 , 1 ,'aaa'),
  ( 8 , 1 ,'aaa'),
  ( 9 , 1 ,CAST(NULL AS VARCHAR( 10 )))
;
create index mxx on m1(x3);
runstats on table vvm.m1 with distribution and detailed indexes all; 

CONNECT TO TICKPROC;
CALL SYSPROC.ALTOBJ ( 'APPLY_CONTINUE_ON_ERROR', 'CREATE TABLE VVM.M1 ( X1 INTEGER  NOT NULL , X2 INTEGER  NOT NULL , X3 VARCHAR (100)  NOT NULL   ) IN USER16 ', - 1 , ? );
;
CONNECT RESET;

DROP INDEX "VVM"."MXX";
RENAME TABLE "VVM"."M1" TO T20050905_162653;
SET SESSION AUTHORIZATION VVM      ALLOW ADMINISTRATION;
CREATE TABLE VVM.M1 ( X1 INTEGER  NOT NULL , X2 INTEGER  NOT NULL , X3 VARCHAR ( 100 )  NOT NULL   ) IN USER16;
ALTER TABLE "VVM     "."M1" 
	ADD PRIMARY KEY
		("X1");
SET SESSION AUTHORIZATION VVM      ALLOW ADMINISTRATION;
CREATE INDEX "VVM     "."MXX" ON "VVM     "."M1" 
		("X3" ASC);
UPDATE SYSSTAT.TABLES
SET CARD= 10 ,
    NPAGES= 1 ,
    FPAGES= 1 ,
    OVERFLOW= 0 ,
    ACTIVE_BLOCKS= 0 
WHERE TABNAME = 'M1' AND TABSCHEMA = 'VVM     ';
UPDATE SYSSTAT.TABLES
SET CARD= 10 ,
    NPAGES= 1 ,
    FPAGES= 1 ,
    OVERFLOW= 0 ,
    ACTIVE_BLOCKS= 0 
WHERE TABNAME = 'M1' AND TABSCHEMA = 'VVM     ';
SET COLCARD= 10 ,
    NUMNULLS= 0 ,
    SUB_COUNT=- 1 ,
    SUB_DELIM_LENGTH=- 1 ,
    HIGH2KEY='8',
    LOW2KEY='1',
    AVGCOLLEN= 4 
WHERE COLNAME = 'X1' AND TABNAME = 'M1' AND TABSCHEMA = 'VVM';

UPDATE SYSSTAT.INDEXES
SET NLEAF= 1 ,
    NLEVELS= 1 ,
    FIRSTKEYCARD= 2 ,
    FIRST2KEYCARD=- 1 ,
    FIRST3KEYCARD=- 1 ,
    FIRST4KEYCARD=- 1 ,
    FULLKEYCARD= 2 ,
    CLUSTERFACTOR=- 1 , 000000 ,
    CLUSTERRATIO= 100 ,
    SEQUENTIAL_PAGES= 0 ,
    DENSITY= 0 ,
    AVERAGE_SEQUENCE_GAP= 0 , 000000 ,
    AVERAGE_SEQUENCE_FETCH_GAP=- 1 , 000000 ,
    AVERAGE_SEQUENCE_PAGES= 0 , 000000 ,
    AVERAGE_SEQUENCE_FETCH_PAGES=- 1 , 000000 ,
    AVERAGE_RANDOM_PAGES= 1 , 000000 ,
    AVERAGE_RANDOM_FETCH_PAGES=- 1 , 000000 ,
    NUMRIDS= 10 ,
    NUMRIDS_DELETED= 0 ,
    NUM_EMPTY_LEAFS= 0 
WHERE INDNAME = 'MXX' AND INDSCHEMA = 'VVM     '
      AND TABNAME = 'M1' AND TABSCHEMA = 'VVM'

LOAD FROM CSR20050905_162653 OF CURSOR  MESSAGES "C:\SQLLIB\DB2\tmp\T20050905_162653"  REPLACE INTO "VVM"."M1" ( "X1", "X2", "X3" ) FOR EXCEPTION "VVM"."T20050905_162653_EXCEPTION"  STATISTICS YES  NONRECOVERABLE  INDEXING MODE REBUILD

SQL1193I  The utility is beginning to load data from the SQL statement "SELECT 
"X1" ,  "X2" ,  "X3"  FROM "VVM"."T20050905_162653" ".

SQL3500W  The utility is beginning the "LOAD" phase at time "05.09.2005 
16:27:23.614340".

SQL3519W  Begin Load Consistency Point. Input record count = "0".

SQL3520W  Load Consistency Point was successful.

SQL3116W  The field value in row "10" and column "3" is missing, but the 
target column is not nullable.

SQL3185W  The previous error occurred while processing data from row "10" of 
the input file.

SQL3110N  The utility has completed processing.  "10" rows were read from the 
input file.

SQL3519W  Begin Load Consistency Point. Input record count = "10".

SQL3520W  Load Consistency Point was successful.

SQL3515W  The utility has finished the "LOAD" phase at time "05.09.2005 
16:27:24.477014".

SQL3500W  The utility is beginning the "BUILD" phase at time "05.09.2005 
16:27:24.532538".

SQL3213I  The indexing mode is "REBUILD".

SQL3515W  The utility has finished the "BUILD" phase at time "05.09.2005 
16:27:25.033297".

SQL3107W  There is at least one warning message in the message file.