error while running db2look utility

azs0309 · #1 (**permalink**) 02-04-08, 02:41

Hi all,

I am getting an error while running db2look utility. It is unable to generate DDL for only one table. when i run it it runs for all the table and when it encounters that particualr table, it gives an error and . Th error message I am getting is ------------------------------------------------
-- DDL Statements for table "AGREEMENT"."APHDPE"
------------------------------------------------
The db2look utility could not generate table DDL rc = 64
The db2look utility is now terminating
SQL0901N The SQL statement failed because of a non-severe system error.
Subsequent SQL statements can be processed. (Reason "sqlr_create_table_ddl():
structure type in table AGREEMENTNc .APHDPEGR".) SQLSTATE=58004

I have several structured type table but its give error on only this one and this table is non structured. I am working on Solaris and db2v8.1 fix pak 13

has anyone encountered this error ever. Or this is a bug in this fixpak.

stolze · #2 (**permalink**) 02-04-08, 04:33

Have you tried the latest FixPak already?

In any case, a SQL0901 is always a bug. You should contact IBM support to get this resolved because we can't do anything - except, maybe, figuring out a work-around.

azs0309 · #3 (**permalink**) 02-04-08, 04:48

Thanks for replying stolze, the workaround i have thought of is to get the structure from describe table and get the foreign key relationship from the catalog tables. or use the db2move (with 1 row) to to create the table on the other system.
Can you advise if I am doing right, I just want to move these table to another tablespace?

stolze · #4 (**permalink**) 02-04-08, 06:20

If you just want to move data to another table space, I would do something like this:

Code:

CREATE TABLE new_table LIKE old_table IN target_ts

INSERT INTO new_table SELECT * FROM old_table

DROP TABLE old_table

You should also check foreign keys, triggers, and any other objects that may have dependencies on the table you want to move.

Internet Services

Web Development

Digital Marketing

Consumer Tech