How can I view the physical files corresponding to the db2 tablespace ?, View db2

Source: Internet
Author: User
Tags db2 connect db2 connect to prefetch

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]$ 
 



Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.