IDS Forum

Re: Advice sought

Posted By: MALCOLM WEALLANS
Date: Monday, 20 January 2003, at 5:32 a.m.

In Response To: Advice sought (Malcolm Garbett )

Malcolm,
It appears you made the basic error of creating a table IN dbspacename. By default the table should alswys be created in the same dbspace as the original dbspace. That is best achieved by leaving out the IN dbspace clause.

To correct the problem I would recommend either a dbexport/dbimport of the offending database with the -ss option to retain extent sizes etc, or doing the same thing manually through dbschema -ss, unload, drop database, crate database in correct dbspace, rebuild tables from dbschema output, reload tables, recreate indexes from the dbschema output.
The manual method might be faster especially if there are TEXT or BYTE dataatypes.

I would also advise that you might consider creating a TEMP dbspace. This will improve log utilisation when doing SELECT ... ORDER BY statements which create temporary tables. Currently these are logged, whereas temp dbspaces are not.

Hope this helps

Malcolm

Messages In This Thread

• Advice sought
  Malcolm Garbett -- Friday, 17 January 2003, at 6:08 a.m.
  • Re: Advice sought
    Martin Fuerderer -- Friday, 17 January 2003, at 9:29 a.m.
  • Re: Advice sought
    ART KAGEL, BLOOMBERG/ 65E 55TH -- Friday, 17 January 2003, at 12:28 p.m.
  • Re: Advice sought
    MALCOLM WEALLANS -- Monday, 20 January 2003, at 5:32 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.