|
Problem IC88635
|
Status: Closed |
AN 'ALTER TABLE, ALTER COLUMN RESTART XXX" DDL STATEMENT IS NOT BEING CAPTURED IN DB2LOOK UNTIL AN ACTUAL VALUE HAS BEEN INSERTE |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
An 'alter table, alter column restart xxx" DDL statement is not
being captured in db2look until an actual value has been
inserted.
How to Reproduce:
------------------
1. db2 "create table test(a integer generated by default as
identity, b integer)"
DB20000I The SQL command completed successfully.
2. db2 "insert into test(a,b) values (400,400),(500,500)"
DB20000I The SQL command completed successfully.
3. db2look -d sample -e -t test -nofed
------------------------------------------------
-- DDL Statements for table "DB297 "."TEST"
------------------------------------------------
CREATE TABLE "DB297 "."TEST" (
"A" INTEGER NOT NULL GENERATED BY DEFAULT AS
IDENTITY
(
START WITH +1
INCREMENT BY +1
MINVALUE +1
MAXVALUE +2147483647
NO CYCLE
CACHE 20
NO ORDER ) ,
"B" INTEGER )
IN "IBMDB2SAMPLEREL" ;
COMMIT WORK;
CONNECT RESET;
TERMINATE;
4. db2 alter table test alter column a restart with 1000
DB20000I The SQL command completed successfully.
5. db2look -d sample -e -t test -nofed
Shows:
------------------------------------------------
CREATE TABLE "DB297 "."TEST" (
"A" INTEGER NOT NULL GENERATED BY DEFAULT AS
IDENTITY
(
START WITH +1
INCREMENT BY +1
MINVALUE +1
MAXVALUE +2147483647
NO CYCLE
CACHE 20
NO ORDER ) ,
"B" INTEGER )
IN "IBMDB2SAMPLEREL" ;
COMMIT WORK;
Note: No restart DDL at this point.
------------------------------------------------
6. But if we insert it picks it up:
$ db2 "insert into test(b) values (4000),(5000)"
DB20000I The SQL command completed successfully.
------------------------------------------------
CREATE TABLE "DB297 "."TEST" (
"A" INTEGER NOT NULL GENERATED BY DEFAULT AS
IDENTITY
(
START WITH +1
INCREMENT BY +1
MINVALUE +1
MAXVALUE +2147483647
NO CYCLE
CACHE 20
NO ORDER ) ,
"B" INTEGER )
IN "IBMDB2SAMPLEREL" ;
ALTER TABLE "DB297 "."TEST" ALTER COLUMN "A" RESTART WITH
1039;
COMMIT WORK;
------------------------------------------------ |
| Problem Summary: |
|
| Local Fix: |
Insert one row before issuing db2look. |
| available fix packs: |
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Comment |
The problem fixed |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 28.11.2012
29.03.2013
29.03.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.2
|
 |
| 10.5.0.2
|
|
