MVSFORUMS.com

[pzmohanty]

hi all,

What exactly is an Auxiliary table in DB2 & when it is used????

Thanx in advnc.

P.R.Mohanty

[kolusu]

pzmohanty,

Auxiliary table is a special kind of table that holds only large object data. For LOB data, the table space is called a LOB table space, and a table is called an auxiliary table. If your base table is nonpartitioned, you must create one LOB table space and one auxiliary table for each LOB column. If your base table is partitioned, you must create one LOB table space and one auxiliary table for each LOB column. For example, you must create three LOB table spaces and three auxiliary tables for each LOB column if your base table has three partitions. Create these objects using the CREATE LOB TABLESPACE and CREATE AUXILIARY TABLE statements.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu