Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2008
    Posts
    88

    Unanswered: error while running db2look utility

    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.

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    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.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Jan 2008
    Posts
    88
    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?

  4. #4
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    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.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •