I would like to get more in depth information about Auxiliary tables. As of now all I know is auxiliary tables are required if table contains column of data type Large Object (LOB). Auxiliary tables are created on these base tables and pointer is placed in base table. So ultimately actual LOB column data is saved in Auxiliary table and not in respective LOB column of base table.
I wanted some more information for following points. Can anyone tell me about these things or let me know the links where I can get more insight?
1. When I want to insert some large object in LOB column then whether I shall insert in into base table or Auxiliary table. If it is just base table then how it will be inserted in Auks table.
2. What will happen when row is deleted from base table. Will it delete the corresponding row from Auks table.
3. When I run rerig, all the unused space will be reclaimed in case of base table. How the same processing can be done for Auks table.
4. Can I run Load, unload, rerig etc utilities for Auks tables.
Please note that I looking for this information which is specific or relevant to Db2 v8. It would be really great if you can share your expertise on this topic.