|
View previous topic :: View next topic
|
| Author |
Message |
d_pansare
New User
Joined: 25 Apr 2009
Posts: 20
Location: Pune
|
|
|
|
Hi All
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. |
|
| Back to top |
|
 |
sushanth bobby
Senior Member
Joined: 29 Jul 2008
Posts: 1020
Location: India
|
|
|
|
d_pansare,
| Quote: |
| 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. |
Insert the data into the base table, DB2 will take care of the rest.
| Quote: |
| 2. What will happen when row is deleted from base table. Will it delete the corresponding row from Auks table. |
Delete from base table, DB2 will do the rest.
| Quote: |
| 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. |
Do it as a separate task.
Refer to utility reference manual.
Sushanth |
|
| Back to top |
|
|
|
|
