Hi guys,
i done column analysis for table location.
if i delete a datasource contain table location from my project.
will info analyzer clear all analysis information for that particular table in IADB database?
Is there any other way to clear the analysis information.
Regards
info server :deleting a datasource
info server :deleting a datasource
vairamuthu
-
- Premium Member
- Posts: 145
- Joined: Fri Sep 21, 2007 9:35 am
- Location: Boston
i hope from "Table management" tab we can delete the reference table which stores frequency information in DB2.
I deleted the reference tables belong to larger table but there is no change in database because db2 clear the table physically and reserve the tablespace .
When i done column analysis on other tables. the size of db2 remain the same . i hope it uses the reserved tablespace.
When you delete it wont shrink the tablespace which is created...it just reserved and use it for future analysis...
Do you have any other view on this ..please post it here
thanks aruna and istsaur for you replies..
I deleted the reference tables belong to larger table but there is no change in database because db2 clear the table physically and reserve the tablespace .
When i done column analysis on other tables. the size of db2 remain the same . i hope it uses the reserved tablespace.
When you delete it wont shrink the tablespace which is created...it just reserved and use it for future analysis...
Do you have any other view on this ..please post it here
thanks aruna and istsaur for you replies..
vairamuthu