db2 List tablespaces show detail: Tablespaces for Current Database Tablespace ID = 0 Name &...
显示全部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 = 57344
Useable pages = 57340
Used pages = 53856
Free pages = 3484
High water mark (pages) = 53856
Page size (bytes) = 4096
Extent size (pages) = 4
Prefetch size (pages) = 24
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) = 192
Number of containers = 1
Tablespace ID = 2
Name = USERSPACE1
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0800
Detailed explanation:
Backup in progress
Total pages = 20701184
Useable pages = 20701152
Used pages = 19141728
Free pages = 1559424
High water mark (pages) = 20695968
Page size (bytes) = 4096
Extent size (pages) = 32
Prefetch size (pages) = 192
Number of containers = 1
Minimum recovery time = 2013-11-14-04.02.22.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 = 316
Free pages = 7872
High water mark (pages) = 316
Page size (bytes) = 4096
Extent size (pages) = 4
Prefetch size (pages) = 24
Number of containers = 1
Minimum recovery time = 2011-01-10-07.24.27.000000
Tablespace ID = 4
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) = 4096
Extent size (pages) = 4
Prefetch size (pages) = 24
Number of containers = 1
Tablespace ID = 5
Name = DWSPACE
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0000
Detailed explanation:
Normal
Total pages = 590848
Useable pages = 590816
Used pages = 564192
Free pages = 26624
High water mark (pages) = 564192
Page size (bytes) = 32768
Extent size (pages) = 32
Prefetch size (pages) = 192
Number of containers = 1
Minimum recovery time = 2013-11-01-08.02.08.000000
Tablespace ID = 6
Name = TEMPDWSPACE
Type = System managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal
Total pages = 90
Useable pages = 90
Used pages = 90
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 32768
Extent size (pages) = 64
Prefetch size (pages) = 384
Number of containers = 1
Tablespace ID = 7
Name = IDXSPACE
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0000
Detailed explanation:
Normal
Total pages = 189440
Useable pages = 189408
Used pages = 188672
Free pages = 736
High water mark (pages) = 188672
Page size (bytes) = 32768
Extent size (pages) = 32
Prefetch size (pages) = 192
Number of containers = 1
Minimum recovery time = 2010-12-25-09.25.45.000000
收起