Problem when migrating DB from v7 to v8

[Deacon]

Dear all,

I am using DB2 for AIX, I have the following problem when migrating my DB
from DB2 v7.2 to v8.1

I orginally have a table with a CLOB field with logged and not compact
properties. We I use db2look to obtain the structure, the following is the
output:

CREATE TABLE "TEST"."TEST1" (
"ID" CHAR(4) NOT NULL ,
"TRACE" CLOB(4096) LOGGED NOT COMPACT );

When I migrated this DB to DB2 v8.1, when I run the db2look again, the CLOB
field changed to " NOT LOGGED NOT COMPACT" ie.

CREATE TABLE "TEST"."TEST1" (
"ID" CHAR(4) NOT NULL ,
"TRACE" CLOB(4096) NOT LOGGED NOT COMPACT );

However, when I select the table structure from the syscat.columns view in
DB2 v8.1, the LOGGED field is turned ON. ie:

db2 "select substr(TABNAME,1,20), substr(COLNAME,1,20), LOGGED, compact from
syscat.columns

1 2 LOGGED COMPACT
-------------------- -------------------- ------ -------
TEST ID
TEST TRACE Y N
Does anyone knows why there is such a difference?

Thank you !

Deacon

[ssg]

Hi Deacon,

I am the db2look owner. I couldn't reproduce this problem on my
machine, both NT and AIX. Could you please try to create a new table
with CLOB column and run db2look again? Please let me know if you can
recreate the problem.

Thanks.

"Deacon" <de****@hkem.com> wrote in message news:<bv**********@imsp212.netvigator.com>...

Dear all,

I am using DB2 for AIX, I have the following problem when migrating my DB
from DB2 v7.2 to v8.1

I orginally have a table with a CLOB field with logged and not compact
properties. We I use db2look to obtain the structure, the following is the
output:

CREATE TABLE "TEST"."TEST1" (
"ID" CHAR(4) NOT NULL ,
"TRACE" CLOB(4096) LOGGED NOT COMPACT );

When I migrated this DB to DB2 v8.1, when I run the db2look again, the CLOB
field changed to " NOT LOGGED NOT COMPACT" ie.

CREATE TABLE "TEST"."TEST1" (
"ID" CHAR(4) NOT NULL ,
"TRACE" CLOB(4096) NOT LOGGED NOT COMPACT );

However, when I select the table structure from the syscat.columns view in
DB2 v8.1, the LOGGED field is turned ON. ie:

db2 "select substr(TABNAME,1,20), substr(COLNAME,1,20), LOGGED, compact from
syscat.columns

1 2 LOGGED COMPACT
-------------------- -------------------- ------ -------
TEST ID
TEST TRACE Y N
Does anyone knows why there is such a difference?

Thank you !

Deacon

[Serge Rielau]

Has been reproduced by others. Please open an APAR if you want a fix.

Cheers
Serge

[shashi b mannepalli]

If i remember correctly ...there is an open APAR with IBM regarding
this issue. In some platforms(SOLARIS)...db2look will not give good
DB2LOOK output while creating USER TEMPORARY TABLESPACE.

Please check with IBM regarding this...This is a DB2LOOK problem..
they may give you an APAR or a FIXPACK..

cheers...
Shashi Mannepalli
"Deacon" <de****@hkem.com> wrote in message news:<bv**********@imsp212.netvigator.com>...

Dear all,

I am using DB2 for AIX, I have the following problem when migrating my DB
from DB2 v7.2 to v8.1

I orginally have a table with a CLOB field with logged and not compact
properties. We I use db2look to obtain the structure, the following is the
output:

CREATE TABLE "TEST"."TEST1" (
"ID" CHAR(4) NOT NULL ,
"TRACE" CLOB(4096) LOGGED NOT COMPACT );

When I migrated this DB to DB2 v8.1, when I run the db2look again, the CLOB
field changed to " NOT LOGGED NOT COMPACT" ie.

CREATE TABLE "TEST"."TEST1" (
"ID" CHAR(4) NOT NULL ,
"TRACE" CLOB(4096) NOT LOGGED NOT COMPACT );

However, when I select the table structure from the syscat.columns view in
DB2 v8.1, the LOGGED field is turned ON. ie:

db2 "select substr(TABNAME,1,20), substr(COLNAME,1,20), LOGGED, compact from
syscat.columns

1 2 LOGGED COMPACT
-------------------- -------------------- ------ -------
TEST ID
TEST TRACE Y N
Does anyone knows why there is such a difference?

Thank you !

Deacon