Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Concept of Auxiliary tables in DB2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
d_pansare

New User


Joined: 25 Apr 2009
Posts: 20
Location: Pune

PostPosted: Mon Aug 10, 2009 11:57 am    Post subject: Concept of Auxiliary tables in DB2
Reply with quote

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
View user's profile Send private message

sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Mon Aug 10, 2009 2:52 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Identify top 30 big tables or indexes... ashek15 DB2 0 Fri Jun 16, 2017 10:01 am
No new posts Data replication from multiple Db2 ta... kishpra DB2 9 Mon Mar 27, 2017 9:58 pm
No new posts SPUFI -- Joining 3 tables – data in... Sysaron DB2 2 Wed Mar 08, 2017 4:18 am
No new posts To know activities on db2 tables ashek15 DB2 4 Fri Mar 03, 2017 11:23 pm
No new posts ERM-Diagram of SysIBM-Catalog-Tables Auryn DB2 2 Fri Feb 17, 2017 6:22 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us