How can I view the physical files corresponding to the db2 tablespace ?, View db2
How can I view the physical files corresponding to the db2 tablespace? Refer to the following:
[db2inst1@db MYDB]$ db2 connect to mydb
Database Connection Information
Database server = DB2/LINUXX8664 9.7.0
SQL authorization ID = DB2INST1
Local database alias = MYDB
[db2inst1@db MYDB]$ db2 list tablespaces show detail
Tablespaces for Current Database
Tablespace ID = 0
Name = SYSCATSPACE
Type = Database managed space
Contents = All permanent data. Regular table space.
State = 0x0000
Detailed explanation:
Normal
Total pages = 32768
Useable pages = 32764
Used pages = 28932
Free pages = 3832
High water mark (pages) = 28932
Page size (bytes) = 4096
Extent size (pages) = 4
Prefetch size (pages) = 4
Number of containers = 1
Tablespace ID = 1
Name = TEMPSPACE1
Type = System managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal
Total pages = 1
Useable pages = 1
Used pages = 1
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 4096
Extent size (pages) = 32
Prefetch size (pages) = 32
Number of containers = 1
Tablespace ID = 2
Name = USERSPACE1
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0000
Detailed explanation:
Normal
Total pages = 24576
Useable pages = 24544
Used pages = 10560
Free pages = 13984
High water mark (pages) = 17280
Page size (bytes) = 4096
Extent size (pages) = 32
Prefetch size (pages) = 32
Number of containers = 1
Minimum recovery time = 2014-02-23-07.48.09.000000
Tablespace ID = 3
Name = SYSTOOLSPACE
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0000
Detailed explanation:
Normal
Total pages = 8192
Useable pages = 8188
Used pages = 184
Free pages = 8004
High water mark (pages) = 184
Page size (bytes) = 4096
Extent size (pages) = 4
Prefetch size (pages) = 4
Number of containers = 1
Tablespace ID = 4
Name = SDCSM_TABLE_SPACE
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0000
Detailed explanation:
Normal
Total pages = 22528
Useable pages = 22512
Used pages = 21840
Free pages = 672
High water mark (pages) = 21840
Page size (bytes) = 32768
Extent size (pages) = 16
Prefetch size (pages) = 16
Number of containers = 1
Minimum recovery time = 2014-02-23-07.48.48.000000
Tablespace ID = 5
Name = SYSTOOLSTMPSPACE
Type = System managed space
Contents = User Temporary data
State = 0x0000
Detailed explanation:
Normal
Total pages = 1
Useable pages = 1
Used pages = 1
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 32768
Extent size (pages) = 16
Prefetch size (pages) = 16
Number of containers = 1
Tablespace ID = 6
Name = MYSYSTEMP
Type = System managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal
Total pages = 1
Useable pages = 1
Used pages = 1
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 32768
Extent size (pages) = 32
Prefetch size (pages) = 32
Number of containers = 1
Minimum recovery time = 2012-03-02-08.15.37.000000
[db2inst1@db MYDB]$ db2pd -tablespaces -db mydb
Database Partition 0 -- Database MYDB -- Active -- Up 0 days 00:14:13
Tablespace Configuration:
...
Containers:
Address TspId ContainNum Type TotalPgs UseablePgs PathID StripeSet Container
0x00002AFEBFBC6080 0 0 File 32768 32764 0 0 /db2data/db2inst1/db2inst1/NODE0000/MYDB/T0000000/C0000000.CAT
0x00002AFEBFBC7780 1 0 Path 1 1 0 0 /db2data/db2inst1/db2inst1/NODE0000/MYDB/T0000001/C0000000.TMP
0x00002AFEBFBC9A40 2 0 File 24576 24544 0 0 /db2data/db2inst1/db2inst1/NODE0000/MYDB/T0000002/C0000000.LRG
0x00002AFEBFBC9CE0 3 0 File 8192 8188 0 0 /db2data/db2inst1/db2inst1/NODE0000/MYDB/T0000003/C0000000.LRG
0x00002AFEC495FEE0 4 0 File 22528 22512 0 0 /db2data/db2inst1/db2inst1/NODE0000/MYDB/T0000004/C0000000.LRG
0x00002AFEC49615E0 5 0 Path 1 1 0 0 /db2data/db2inst1/db2inst1/NODE0000/MYDB/T0000005/C0000000.UTM
0x00002AFEC4964D00 6 0 Path 1 1 - 0 /db2data/db2inst1/NODE0000/SQL00001/mysystemp
[db2inst1@db MYDB]$