I have 2000+ tables in DB2 database (AIX) created by a software installation process. All these tables were created in default tablespace (index, lob, etc. in the same tablespace), so, I want to re-arrange these tables to tablespaces with correct page sizes, separate data/index/lob, etc.
I know I can get DDLs and change it for each table manually for all these 2000+ tables, but, I am wondering whether anybody can give me better solution. I thought I could reverse-engineer table DDL from syscat.columns, but, the sql solution seems to cumbersome. Any idea how I can accomplish the re-arrange short-n-sweet? Thanks a lot.
Last edited by rajaraja_cholan; 10-01-13 at 10:38.