Unless the "table" is very small it usualy is spread on (nearly) all
volumes. Table records are physically located on pages and each page might
be on different volume. If later the volume is deleted all pages residing
on it are moved to other dbvols.
I am writing "table" because what we see in TSM admin interface is more
similar to views in RDBMSes - read-only representation of one or more real
tables.

Zlatko Krastev
IT Consultant






Justin Bleistein <justin.bleistein AT SUNGARD DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
23.01.2003 20:49
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        tsm db question


Is there anyway to find out like through a "select" statement or something
which O/S db volume a specific table is located in. When a I do a: "q
dbvol" our database is  spread across multiple db volumes/files. It would
just be nice to see what volume a table is actually physically located in
or spread across multiple volumes and which ones? Just a thought. Thanks!.

--Justin Richard Bleistein
Unix Systems Administrator (Sungard eSourcing)
Desk: (856) 866 - 4017
Cell:    (856) 912 - 0861
Email: justin.bleistein AT sungard DOT com