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 Getting list of tables defined under ... kishpra DB2 2 Wed Aug 24, 2016 10:36 am
No new posts ISPF Tables Creation newsysprg TSO/ISPF 6 Wed Jul 13, 2016 2:21 pm
No new posts New DB2 tables creation kishpra DB2 3 Tue Feb 02, 2016 7:00 pm
No new posts JCL overriding concept s.saranya srinivasan JCL & VSAM 14 Wed Oct 07, 2015 4:07 pm
No new posts TABLES/MS from Specialized Solutions ... Gary Jacek COBOL Programming 0 Thu Sep 03, 2015 12:08 am


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