Skip to content

Instantly share code, notes, and snippets.

@nakunaru

nakunaru/DEMP

Created June 7, 2012 09:14
Show Gist options
  • Save nakunaru/2887775 to your computer and use it in GitHub Desktop.
Save nakunaru/2887775 to your computer and use it in GitHub Desktop.
Download ZIP
サイズがバラバラなコンテナーを持つ表スペースの/DTSFの結果
Raw
DEMP
______________________________________________________________________________
_______ DART _______
D a t a b a s e A n a l y s i s a n d R e p o r t i n g T o o l
IBM DB2 NT
______________________________________________________________________________
DART (V9.1) Report:
2012-06-07-17.58.07.500000
Database Name: SAMPLE
Report name: SAMPLE.RPT
Old report back-up: SAMPLE.BAK
Database Subdirectory: D:\DB2\NODE0000\SQL00002
Operational Mode: Database Inspection Only (INSPECT)
______________________________________________________________________________
------------------------------------------------------------------------------
Action option: DEMP
Table-object-ID: 4; Tablespace-ID: 16
Connecting to Buffer Pool Services...
DART formatted EMP page dump:
-----------------------------
Traversing extent map for:
Object ID: 4
Table space: 16
Pool specific info:
-------------------
Name = UNBTBS
Pool extent size = 4
# of containers = 3
Container names:
D:\DB2\NODE0000\SQL00002\unb1.dat
D:\DB2\NODE0000\SQL00002\unb2.dat
D:\DB2\NODE0000\SQL00002\unb3.dat
Object specific mapping info:
-----------------------------
DAT extent anchor: 12
Traversing extent map for object type: 0
Pool: 16, Object: 4 EMP page class: 64,
EMP pool page: 12, # entries: 28
Page LSN = 0004 C14E 81F6
Pool relative page #'s :
16 20 24 28 32
36 40 44 48 52
56 60 64 68 72
76 80 84 88 92
96 100 104 108 112
116 120 124
INX extent anchor: 0
XDA extent anchor: 0
LF extent anchor: 0
LOB extent anchor: 0
LOBA extent anchor: 0
BKM extent anchor: 0
______________________________________
The requested DB2DART processing has completed successfully!
All operation completed without error;
no problems were detected in the database.
______________________________________
Complete DB2DART report found in:
D:\PROGRA~1\IBM\SQLLIB\DB2\DART0000\SAMPLE.RPT
_______ D A R T P R O C E S S I N G C O M P L E T E _______
Raw
DTSF.RPT
______________________________________________________________________________
_______ DART _______
D a t a b a s e A n a l y s i s a n d R e p o r t i n g T o o l
IBM DB2 NT
______________________________________________________________________________
DART (V9.1) Report:
2012-06-07-18.00.18.609000
Database Name: SAMPLE
Report name: SAMPLE.RPT
Database Subdirectory: D:\DB2\NODE0000\SQL00002
Operational Mode: Database Inspection Only (INSPECT)
______________________________________________________________________________
------------------------------------------------------------------------------
Action option: DTSF
Connecting to Buffer Pool Services...
Storage group file (automatic storage) report phase start.
Header version: 0
Header flavour: 1
Number of storage groups: 1
Checksum: 0x5401050b
Storage group ID: 0
Storage group name: DBSTORAGE
Flavour: 2
Version: 5
State flags: 0x0000000000000000
Last LSN: 0x0000000000000000
Initial LSN: 0x0000000000000000
Checksum: 0x13122a0d
Number of storage paths: 1
Storage path # 0: D:
Storage group file (automatic storage) report phase end.
Tablespace file report phase start.
Tablespace information for current database:
--------------------------------------------
Number of defined tablespaces: 17
High water mark of used pools: 16
Number of disabled tablespaces: 0
Individual tablespace details:
-------------------------------
Information for Tablespace ID: 0
-------------------------------------
Tablespace name: SYSCATSPACE
Table space flags (HEX): 3102
Table space type: Database Managed Space (DMS), Automatic Storage, Auto-Resize
Page size: 4096
Extent size: 4
Prefetch size: 4
Version: 21
Tablespace state: 0
Number of quiescers: 0
Storage Group ID: 0
Usable pages in tablespace: 16380
Total pages in tablespace: 16384
Initial Size: 33554432 bytes
Increment : -4096 bytes
Maximum Size: None
Last Resize: None
Last Resize Failed: No
SMP page for first free extent: 4
SMP page for last allocated tablespace extent. 7
SMP extent number of the last initialized SMP extent: 0
High Water Mark: 9488
Number of containers associated with this tablespace: 1
Container list:
Total Useable Container Container
# Pages Pages Type Name
=== ======== ======== ============== ============================
0 16384 16380 striped file D:\DB2\NODE0000\SAMPLE\T0000000\C0000000.CAT
Container checksum for disk space: 1512375489
Number of ranges in the map: 1
Size of the map: 1
Map entry size: 52
Current map:
MaxPage MaxExtent StartStripe EndStripe Adj Containers
[ 0] -1 -1 0 -1 0 1 (0)
Map checksum for disk space: -2
LSN (Log Sequence Number) for life...
lsn: 0000 0000 000C
lsnword: 00 00 C00
LSN (Log Sequence Number) for load pending...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for load recovery...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for begin...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for end...
lsn: 0000 0000 0000
lsnword: 00 00 00
Backup end time : 1320973893
Backup log rec found status : 0x00000010
SQLB_BACKUP_END_REC_FOUND
Bufferpool ID in SPCS file: 1
Bufferpool ID at DART runtime: 4096
Information for Tablespace ID: 1
-------------------------------------
Tablespace name: TEMPSPACE1
Table space flags (HEX): 1111
Table space type: System Managed Space (SMS), Automatic Storage
Page size: 4096
Extent size: 32
Prefetch size: 32
Version: 325
Tablespace state: 0
Number of quiescers: 0
Storage Group ID: 0
Usable pages in tablespace: 0
Total pages in tablespace: 0
Initial Size: 0 bytes
Increment : 0 bytes
Maximum Size: 0 bytes
Last Resize: None
Last Resize Failed: No
SMP page for first free extent: 0
SMP page for last allocated tablespace extent. 0
SMP extent number of the last initialized SMP extent: 0
High Water Mark: 0
Number of containers associated with this tablespace: 1
Container list:
Container #0, D:\DB2\NODE0000\SAMPLE\T0000001\C0000000.TMP
Container checksum for disk space: 1579691067
Number of ranges in the map: 0
Size of the map: 0
Map entry size: 52
Map checksum for disk space: 0
LSN (Log Sequence Number) for life...
lsn: 0000 0000 0398
lsnword: 00 00 FFFF9803
LSN (Log Sequence Number) for load pending...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for load recovery...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for begin...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for end...
lsn: 0000 0000 0000
lsnword: 00 00 00
Backup end time : 1320973893
Backup log rec found status : 0x00000010
SQLB_BACKUP_END_REC_FOUND
Bufferpool ID in SPCS file: 1
Bufferpool ID at DART runtime: 4096
Information for Tablespace ID: 2
-------------------------------------
Tablespace name: USERSPACE1
Table space flags (HEX): 3122
Table space type: Database Managed Space (DMS), Automatic Storage, Auto-Resize
Page size: 4096
Extent size: 32
Prefetch size: 32
Version: 20
Tablespace state: 0
Number of quiescers: 0
Storage Group ID: 0
Usable pages in tablespace: 8160
Total pages in tablespace: 8192
Initial Size: 33554432 bytes
Increment : -4096 bytes
Maximum Size: None
Last Resize: None
Last Resize Failed: No
SMP page for first free extent: 32
SMP page for last allocated tablespace extent. 63
SMP extent number of the last initialized SMP extent: 0
High Water Mark: 5440
Number of containers associated with this tablespace: 1
Container list:
Total Useable Container Container
# Pages Pages Type Name
=== ======== ======== ============== ============================
0 8192 8160 striped file D:\DB2\NODE0000\SAMPLE\T0000002\C0000000.LRG
Container checksum for disk space: 1228278749
Number of ranges in the map: 1
Size of the map: 1
Map entry size: 52
Current map:
MaxPage MaxExtent StartStripe EndStripe Adj Containers
[ 0] -1 -1 0 -1 0 1 (0)
Map checksum for disk space: -2
LSN (Log Sequence Number) for life...
lsn: 0000 0000 0590
lsnword: 00 00 FFFF9005
LSN (Log Sequence Number) for load pending...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for load recovery...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for begin...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for end...
lsn: 0000 0000 0000
lsnword: 00 00 00
Backup end time : 1320973893
Backup log rec found status : 0x00000010
SQLB_BACKUP_END_REC_FOUND
Bufferpool ID in SPCS file: 1
Bufferpool ID at DART runtime: 4096
Information for Tablespace ID: 3
-------------------------------------
Tablespace name: IBMDB2SAMPLEREL
Table space flags (HEX): 3122
Table space type: Database Managed Space (DMS), Automatic Storage, Auto-Resize
Page size: 4096
Extent size: 32
Prefetch size: 32
Version: 79
Tablespace state: 0
Number of quiescers: 0
Storage Group ID: 0
Usable pages in tablespace: 491488
Total pages in tablespace: 491520
Initial Size: 33554432 bytes
Increment : -4096 bytes
Maximum Size: None
Last Resize: None
Last Resize Failed: No
SMP page for first free extent: 32
SMP page for last allocated tablespace extent. 63
SMP extent number of the last initialized SMP extent: 0
High Water Mark: 4480
Number of containers associated with this tablespace: 1
Container list:
Total Useable Container Container
# Pages Pages Type Name
=== ======== ======== ============== ============================
0 491520 491488 striped file D:\DB2\NODE0000\SAMPLE\T0000003\C0000000.LRG
Container checksum for disk space: 1228393437
Number of ranges in the map: 1
Size of the map: 1
Map entry size: 52
Current map:
MaxPage MaxExtent StartStripe EndStripe Adj Containers
[ 0] -1 -1 0 -1 0 1 (0)
Map checksum for disk space: -2
LSN (Log Sequence Number) for life...
lsn: 0000 00C1 FB1F
lsnword: 00 FFFFC100 1FFB
LSN (Log Sequence Number) for load pending...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for load recovery...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for begin...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for end...
lsn: 0000 0000 0000
lsnword: 00 00 00
Backup end time : 1320973893
Backup log rec found status : 0x00000010
SQLB_BACKUP_END_REC_FOUND
Bufferpool ID in SPCS file: 1
Bufferpool ID at DART runtime: 4096
Information for Tablespace ID: 4
-------------------------------------
Tablespace name: TEST_SP
Table space flags (HEX): 0122
Table space type: Database Managed Space (DMS)
Page size: 4096
Extent size: 10
Prefetch size: 10
Version: 17
Tablespace state: 0
Number of quiescers: 0
Storage Group ID: 0
Usable pages in tablespace: 90
Total pages in tablespace: 100
Initial Size: 0 bytes
Increment : 0 bytes
Maximum Size: 0 bytes
Last Resize: None
Last Resize Failed: No
SMP page for first free extent: 10
SMP page for last allocated tablespace extent. 19
SMP extent number of the last initialized SMP extent: 0
High Water Mark: 30
Number of containers associated with this tablespace: 1
Container list:
Total Useable Container Container
# Pages Pages Type Name
=== ======== ======== ============== ============================
0 100 90 striped file d:\data\test_sp.dat
Container checksum for disk space: 1649056114
Number of ranges in the map: 1
Size of the map: 1
Map entry size: 52
Current map:
MaxPage MaxExtent StartStripe EndStripe Adj Containers
[ 0] 89 8 0 8 0 1 (0)
Map checksum for disk space: 88
LSN (Log Sequence Number) for life...
lsn: 0000 00FA 0796
lsnword: 00 FFFFFA00 FFFF9607
LSN (Log Sequence Number) for load pending...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for load recovery...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for begin...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for end...
lsn: 0000 0000 0000
lsnword: 00 00 00
Backup end time : 1320973893
Backup log rec found status : 0x00000010
SQLB_BACKUP_END_REC_FOUND
Bufferpool ID in SPCS file: 1
Bufferpool ID at DART runtime: 4096
Information for Tablespace ID: 5
-------------------------------------
Tablespace name: SYSTOOLSPACE
Table space flags (HEX): 3122
Table space type: Database Managed Space (DMS), Automatic Storage, Auto-Resize
Page size: 4096
Extent size: 4
Prefetch size: 4
Version: 14
Tablespace state: 0
Number of quiescers: 0
Storage Group ID: 0
Usable pages in tablespace: 8188
Total pages in tablespace: 8192
Initial Size: 33554432 bytes
Increment : -4096 bytes
Maximum Size: None
Last Resize: None
Last Resize Failed: No
SMP page for first free extent: 4
SMP page for last allocated tablespace extent. 7
SMP extent number of the last initialized SMP extent: 0
High Water Mark: 152
Number of containers associated with this tablespace: 1
Container list:
Total Useable Container Container
# Pages Pages Type Name
=== ======== ======== ============== ============================
0 8192 8188 striped file D:\DB2\NODE0000\SAMPLE\T0000005\C0000000.LRG
Container checksum for disk space: 1228098497
Number of ranges in the map: 1
Size of the map: 1
Map entry size: 52
Current map:
MaxPage MaxExtent StartStripe EndStripe Adj Containers
[ 0] -1 -1 0 -1 0 1 (0)
Map checksum for disk space: -2
LSN (Log Sequence Number) for life...
lsn: 0000 0138 B589
lsnword: 00 3801 FFFF89B5
LSN (Log Sequence Number) for load pending...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for load recovery...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for begin...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for end...
lsn: 0000 0000 0000
lsnword: 00 00 00
Backup end time : 1320973893
Backup log rec found status : 0x00000010
SQLB_BACKUP_END_REC_FOUND
Bufferpool ID in SPCS file: 1
Bufferpool ID at DART runtime: 4096
Information for Tablespace ID: 6
-------------------------------------
Tablespace name: SYSTOOLSTMPSPACE
Table space flags (HEX): 1141
Table space type: System Managed Space (SMS), Automatic Storage
Page size: 4096
Extent size: 4
Prefetch size: 4
Version: 293
Tablespace state: 0
Number of quiescers: 0
Storage Group ID: 0
Usable pages in tablespace: 0
Total pages in tablespace: 0
Initial Size: 0 bytes
Increment : 0 bytes
Maximum Size: 0 bytes
Last Resize: None
Last Resize Failed: No
SMP page for first free extent: 0
SMP page for last allocated tablespace extent. 0
SMP extent number of the last initialized SMP extent: 0
High Water Mark: 0
Number of containers associated with this tablespace: 1
Container list:
Container #0, D:\DB2\NODE0000\SAMPLE\T0000006\C0000000.UTM
Container checksum for disk space: 1127623995
Number of ranges in the map: 0
Size of the map: 0
Map entry size: 52
Map checksum for disk space: 0
LSN (Log Sequence Number) for life...
lsn: 0000 013A 6CBD
lsnword: 00 3A01 FFFFBD6C
LSN (Log Sequence Number) for load pending...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for load recovery...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for begin...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for end...
lsn: 0000 0000 0000
lsnword: 00 00 00
Backup end time : 1320973893
Backup log rec found status : 0x00000010
SQLB_BACKUP_END_REC_FOUND
Bufferpool ID in SPCS file: 1
Bufferpool ID at DART runtime: 4096
Information for Tablespace ID: 7
-------------------------------------
Tablespace name: SPMTBS
Table space flags (HEX): 2122
Table space type: Database Managed Space (DMS), Auto-Resize
Page size: 4096
Extent size: 4
Prefetch size: 4
Version: 65
Tablespace state: 0
Number of quiescers: 0
Storage Group ID: -1
Usable pages in tablespace: 526092
Total pages in tablespace: 526096
Initial Size: 0 bytes
Increment : -4096 bytes
Maximum Size: None
Last Resize: None
Last Resize Failed: No
SMP page for first free extent: 4
SMP page for last allocated tablespace extent. 512003
SMP extent number of the last initialized SMP extent: 4
High Water Mark: 520428
Number of containers associated with this tablespace: 1
Container list:
Total Useable Container Container
# Pages Pages Type Name
=== ======== ======== ============== ============================
0 526096 526092 striped file D:\DB2\NODE0000\SQL00002\spmtbs.dat
Container checksum for disk space: 272843550
Number of ranges in the map: 1
Size of the map: 1
Map entry size: 52
Current map:
MaxPage MaxExtent StartStripe EndStripe Adj Containers
[ 0] -1 -1 0 -1 0 1 (0)
Map checksum for disk space: -2
LSN (Log Sequence Number) for life...
lsn: 0001 3A78 D2AD
lsnword: 100 783A FFFFADD2
LSN (Log Sequence Number) for load pending...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for load recovery...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for begin...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for end...
lsn: 0000 0000 0000
lsnword: 00 00 00
Backup end time : 0
Backup log rec found status : 0x00000010
SQLB_BACKUP_END_REC_FOUND
Bufferpool ID in SPCS file: 1
Bufferpool ID at DART runtime: 4096
Information for Tablespace ID: 8
-------------------------------------
Tablespace name: MAP2
Table space flags (HEX): 2122
Table space type: Database Managed Space (DMS), Auto-Resize
Page size: 4096
Extent size: 8
Prefetch size: 16
Version: 5
Tablespace state: 0
Number of quiescers: 0
Storage Group ID: -1
Usable pages in tablespace: 9776
Total pages in tablespace: 9792
Initial Size: 0 bytes
Increment : -4096 bytes
Maximum Size: None
Last Resize: None
Last Resize Failed: No
SMP page for first free extent: 8
SMP page for last allocated tablespace extent. 15
SMP extent number of the last initialized SMP extent: 0
High Water Mark: 264
Number of containers associated with this tablespace: 2
Container list:
Total Useable Container Container
# Pages Pages Type Name
=== ======== ======== ============== ============================
0 4896 4888 striped file D:\DB2\NODE0000\SQL00002\map2_1.dat
1 4896 4888 striped file D:\DB2\NODE0000\SQL00002\map2_2.dat
Container checksum for disk space: 990444234
Number of ranges in the map: 1
Size of the map: 1
Map entry size: 56
Current map:
MaxPage MaxExtent StartStripe EndStripe Adj Containers
[ 0] -1 -1 0 -1 0 2 (0,1)
Map checksum for disk space: -4
LSN (Log Sequence Number) for life...
lsn: 0000 9A8A 81B0
lsnword: 00 FFFF8A9A FFFFB081
LSN (Log Sequence Number) for load pending...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for load recovery...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for begin...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for end...
lsn: 0000 0000 0000
lsnword: 00 00 00
Backup end time : 0
Backup log rec found status : 0x00000010
SQLB_BACKUP_END_REC_FOUND
Bufferpool ID in SPCS file: 1
Bufferpool ID at DART runtime: 4096
Information for Tablespace ID: 9
-------------------------------------
Tablespace name: TBS8K
Table space flags (HEX): 2122
Table space type: Database Managed Space (DMS), Auto-Resize
Page size: 8192
Extent size: 2
Prefetch size: 2
Version: 28
Tablespace state: 0
Number of quiescers: 0
Storage Group ID: -1
Usable pages in tablespace: 107494
Total pages in tablespace: 107496
Initial Size: 0 bytes
Increment : -8192 bytes
Maximum Size: None
Last Resize: None
Last Resize Failed: No
SMP page for first free extent: 2
SMP page for last allocated tablespace extent. 64833
SMP extent number of the last initialized SMP extent: 1
High Water Mark: 105036
Number of containers associated with this tablespace: 1
Container list:
Total Useable Container Container
# Pages Pages Type Name
=== ======== ======== ============== ============================
0 107496 107494 striped file D:\DB2\NODE0000\SQL00002\tbs8k.dat
Container checksum for disk space: 1494682723
Number of ranges in the map: 1
Size of the map: 1
Map entry size: 52
Current map:
MaxPage MaxExtent StartStripe EndStripe Adj Containers
[ 0] -1 -1 0 -1 0 1 (0)
Map checksum for disk space: -2
LSN (Log Sequence Number) for life...
lsn: 0002 2707 67BE
lsnword: 200 727 FFFFBE67
LSN (Log Sequence Number) for load pending...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for load recovery...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for begin...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for end...
lsn: 0000 0000 0000
lsnword: 00 00 00
Backup end time : 0
Backup log rec found status : 0x00000010
SQLB_BACKUP_END_REC_FOUND
Bufferpool ID in SPCS file: 2
Bufferpool ID at DART runtime: 4097
Information for Tablespace ID: 10
-------------------------------------
Tablespace name: CON2TBS
Table space flags (HEX): 0122
Table space type: Database Managed Space (DMS)
Page size: 4096
Extent size: 4
Prefetch size: 8
Version: 3
Tablespace state: 0
Number of quiescers: 0
Storage Group ID: 0
Usable pages in tablespace: 192
Total pages in tablespace: 200
Initial Size: 0 bytes
Increment : 0 bytes
Maximum Size: 0 bytes
Last Resize: None
Last Resize Failed: No
SMP page for first free extent: 4
SMP page for last allocated tablespace extent. 7
SMP extent number of the last initialized SMP extent: 0
High Water Mark: 12
Number of containers associated with this tablespace: 2
Container list:
Total Useable Container Container
# Pages Pages Type Name
=== ======== ======== ============== ============================
0 100 96 striped file D:\DB2\NODE0000\SQL00002\con2_1.dat
1 100 96 striped file D:\DB2\NODE0000\SQL00002\con2_2.dat
Container checksum for disk space: 152447542
Number of ranges in the map: 1
Size of the map: 1
Map entry size: 56
Current map:
MaxPage MaxExtent StartStripe EndStripe Adj Containers
[ 0] 191 47 0 23 0 2 (0,1)
Map checksum for disk space: 132
LSN (Log Sequence Number) for life...
lsn: 0001 2D06 81B6
lsnword: 100 62D FFFFB681
LSN (Log Sequence Number) for load pending...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for load recovery...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for begin...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for end...
lsn: 0000 0000 0000
lsnword: 00 00 00
Backup end time : 0
Backup log rec found status : 0x00000010
SQLB_BACKUP_END_REC_FOUND
Bufferpool ID in SPCS file: 1
Bufferpool ID at DART runtime: 4096
Information for Tablespace ID: 11
-------------------------------------
Tablespace name: TBS16K
Table space flags (HEX): 2122
Table space type: Database Managed Space (DMS), Auto-Resize
Page size: 16384
Extent size: 2
Prefetch size: 2
Version: 71
Tablespace state: 0
Number of quiescers: 0
Storage Group ID: -1
Usable pages in tablespace: 140262
Total pages in tablespace: 140264
Initial Size: 0 bytes
Increment : -16384 bytes
Maximum Size: None
Last Resize: None
Last Resize Failed: No
SMP page for first free extent: 2
SMP page for last allocated tablespace extent. 130369
SMP extent number of the last initialized SMP extent: 1
High Water Mark: 140028
Number of containers associated with this tablespace: 1
Container list:
Total Useable Container Container
# Pages Pages Type Name
=== ======== ======== ============== ============================
0 140264 140262 striped file D:\DB2\NODE0000\SQL00002\tbs16k.dat
Container checksum for disk space: 1432193375
Number of ranges in the map: 1
Size of the map: 1
Map entry size: 52
Current map:
MaxPage MaxExtent StartStripe EndStripe Adj Containers
[ 0] -1 -1 0 -1 0 1 (0)
Map checksum for disk space: -2
LSN (Log Sequence Number) for life...
lsn: 0002 4E16 872D
lsnword: 200 164E 2D87
LSN (Log Sequence Number) for load pending...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for load recovery...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for begin...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for end...
lsn: 0000 0000 0000
lsnword: 00 00 00
Backup end time : 0
Backup log rec found status : 0x00000010
SQLB_BACKUP_END_REC_FOUND
Bufferpool ID in SPCS file: 3
Bufferpool ID at DART runtime: 4098
Information for Tablespace ID: 12
-------------------------------------
Tablespace name: TBS32K
Table space flags (HEX): 2122
Table space type: Database Managed Space (DMS), Auto-Resize
Page size: 32768
Extent size: 2
Prefetch size: 2
Version: 266
Tablespace state: 0
Number of quiescers: 0
Storage Group ID: -1
Usable pages in tablespace: 270310
Total pages in tablespace: 270312
Initial Size: 0 bytes
Increment : -32768 bytes
Maximum Size: None
Last Resize: None
Last Resize Failed: No
SMP page for first free extent: 2
SMP page for last allocated tablespace extent. 261441
SMP extent number of the last initialized SMP extent: 1
High Water Mark: 270026
Number of containers associated with this tablespace: 1
Container list:
Total Useable Container Container
# Pages Pages Type Name
=== ======== ======== ============== ============================
0 270312 270310 striped file D:\DB2\NODE0000\SQL00002\tbs32k.dat
Container checksum for disk space: 1465649499
Number of ranges in the map: 1
Size of the map: 1
Map entry size: 52
Current map:
MaxPage MaxExtent StartStripe EndStripe Adj Containers
[ 0] -1 -1 0 -1 0 1 (0)
Map checksum for disk space: -2
LSN (Log Sequence Number) for life...
lsn: 0002 CF3D 0394
lsnword: 200 3DCF FFFF9403
LSN (Log Sequence Number) for load pending...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for load recovery...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for begin...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for end...
lsn: 0000 0000 0000
lsnword: 00 00 00
Backup end time : 0
Backup log rec found status : 0x00000010
SQLB_BACKUP_END_REC_FOUND
Bufferpool ID in SPCS file: 4
Bufferpool ID at DART runtime: 4099
Information for Tablespace ID: 13
-------------------------------------
Tablespace name: CHECKIND1
Table space flags (HEX): 2122
Table space type: Database Managed Space (DMS), Auto-Resize
Page size: 4096
Extent size: 2
Prefetch size: 2
Version: 3
Tablespace state: 0
Number of quiescers: 0
Storage Group ID: -1
Usable pages in tablespace: 998
Total pages in tablespace: 1000
Initial Size: 0 bytes
Increment : -4096 bytes
Maximum Size: None
Last Resize: None
Last Resize Failed: No
SMP page for first free extent: 2
SMP page for last allocated tablespace extent. 3
SMP extent number of the last initialized SMP extent: 0
High Water Mark: 6
Number of containers associated with this tablespace: 1
Container list:
Total Useable Container Container
# Pages Pages Type Name
=== ======== ======== ============== ============================
0 1000 998 striped file D:\DB2\NODE0000\SQL00002\ckeckind1.dat
Container checksum for disk space: 1718553669
Number of ranges in the map: 1
Size of the map: 1
Map entry size: 52
Current map:
MaxPage MaxExtent StartStripe EndStripe Adj Containers
[ 0] -1 -1 0 -1 0 1 (0)
Map checksum for disk space: -2
LSN (Log Sequence Number) for life...
lsn: 0004 BE99 B5E8
lsnword: 400 FFFF99BE FFFFE8B5
LSN (Log Sequence Number) for load pending...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for load recovery...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for begin...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for end...
lsn: 0000 0000 0000
lsnword: 00 00 00
Backup end time : 0
Backup log rec found status : 0x00000010
SQLB_BACKUP_END_REC_FOUND
Bufferpool ID in SPCS file: 1
Bufferpool ID at DART runtime: 4096
Information for Tablespace ID: 14
-------------------------------------
Tablespace name: TABTBSP
Table space flags (HEX): 0102
Table space type: Database Managed Space (DMS)
Page size: 4096
Extent size: 4
Prefetch size: 4
Version: 2
Tablespace state: 0
Number of quiescers: 0
Storage Group ID: 0
Usable pages in tablespace: 96
Total pages in tablespace: 100
Initial Size: 0 bytes
Increment : 0 bytes
Maximum Size: 0 bytes
Last Resize: None
Last Resize Failed: No
SMP page for first free extent: 4
SMP page for last allocated tablespace extent. 7
SMP extent number of the last initialized SMP extent: 0
High Water Mark: 32
Number of containers associated with this tablespace: 1
Container list:
Total Useable Container Container
# Pages Pages Type Name
=== ======== ======== ============== ============================
0 100 96 striped file D:\DB2\NODE0000\SQL00002\tabdbsp.dat
Container checksum for disk space: 1248211824
Number of ranges in the map: 1
Size of the map: 1
Map entry size: 52
Current map:
MaxPage MaxExtent StartStripe EndStripe Adj Containers
[ 0] 95 23 0 23 0 1 (0)
Map checksum for disk space: 94
LSN (Log Sequence Number) for life...
lsn: 0004 C10F 12BE
lsnword: 400 FC1 FFFFBE12
LSN (Log Sequence Number) for load pending...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for load recovery...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for begin...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for end...
lsn: 0000 0000 0000
lsnword: 00 00 00
Backup end time : 0
Backup log rec found status : 0x00000010
SQLB_BACKUP_END_REC_FOUND
Bufferpool ID in SPCS file: 1
Bufferpool ID at DART runtime: 4096
Information for Tablespace ID: 15
-------------------------------------
Tablespace name: INDTBSP
Table space flags (HEX): 0102
Table space type: Database Managed Space (DMS)
Page size: 4096
Extent size: 4
Prefetch size: 4
Version: 3
Tablespace state: 0
Number of quiescers: 0
Storage Group ID: 0
Usable pages in tablespace: 96
Total pages in tablespace: 100
Initial Size: 0 bytes
Increment : 0 bytes
Maximum Size: 0 bytes
Last Resize: None
Last Resize Failed: No
SMP page for first free extent: 4
SMP page for last allocated tablespace extent. 7
SMP extent number of the last initialized SMP extent: 0
High Water Mark: 12
Number of containers associated with this tablespace: 1
Container list:
Total Useable Container Container
# Pages Pages Type Name
=== ======== ======== ============== ============================
0 100 96 striped file D:\DB2\NODE0000\SQL00002\indtbsp.dat
Container checksum for disk space: 1516256365
Number of ranges in the map: 1
Size of the map: 1
Map entry size: 52
Current map:
MaxPage MaxExtent StartStripe EndStripe Adj Containers
[ 0] 95 23 0 23 0 1 (0)
Map checksum for disk space: 94
LSN (Log Sequence Number) for life...
lsn: 0004 BF55 0A08
lsnword: 400 55BF 80A
LSN (Log Sequence Number) for load pending...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for load recovery...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for begin...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for end...
lsn: 0000 0000 0000
lsnword: 00 00 00
Backup end time : 0
Backup log rec found status : 0x00000010
SQLB_BACKUP_END_REC_FOUND
Bufferpool ID in SPCS file: 1
Bufferpool ID at DART runtime: 4096
Information for Tablespace ID: 16
-------------------------------------
Tablespace name: UNBTBS
Table space flags (HEX): 0122
Table space type: Database Managed Space (DMS)
Page size: 4096
Extent size: 4
Prefetch size: 12
Version: 3
Tablespace state: 0
Number of quiescers: 0
Storage Group ID: 0
Usable pages in tablespace: 128
Total pages in tablespace: 140
Initial Size: 0 bytes
Increment : 0 bytes
Maximum Size: 0 bytes
Last Resize: None
Last Resize Failed: No
SMP page for first free extent: 4
SMP page for last allocated tablespace extent. 7
SMP extent number of the last initialized SMP extent: 0
High Water Mark: 128
Number of containers associated with this tablespace: 3
Container list:
Total Useable Container Container
# Pages Pages Type Name
=== ======== ======== ============== ============================
0 80 76 striped file D:\DB2\NODE0000\SQL00002\unb1.dat
1 40 36 striped file D:\DB2\NODE0000\SQL00002\unb2.dat
2 20 16 striped file D:\DB2\NODE0000\SQL00002\unb3.dat
Container checksum for disk space: 202385520
Number of ranges in the map: 3
Size of the map: 3
Map entry size: 60
Current map:
MaxPage MaxExtent StartStripe EndStripe Adj Containers
[ 0] 47 11 0 3 0 3 (0,1,2)
[ 1] 87 21 4 8 0 2 (0,1)
[ 2] 127 31 9 18 0 1 (0)
Map checksum for disk space: 16
LSN (Log Sequence Number) for life...
lsn: 0004 C149 01B4
lsnword: 400 49C1 FFFFB401
LSN (Log Sequence Number) for load pending...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for load recovery...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for begin...
lsn: 0000 0000 0000
lsnword: 00 00 00
LSN (Log Sequence Number) for end...
lsn: 0000 0000 0000
lsnword: 00 00 00
Backup end time : 0
Backup log rec found status : 0x00000010
SQLB_BACKUP_END_REC_FOUND
Bufferpool ID in SPCS file: 1
Bufferpool ID at DART runtime: 4096
Tablespace file report phase end.
______________________________________
The requested DB2DART processing has completed successfully!
All operation completed without error;
no problems were detected in the database.
______________________________________
Complete DB2DART report found in:
D:\PROGRA~1\IBM\SQLLIB\DB2\DART0000\SAMPLE.RPT
_______ D A R T P R O C E S S I N G C O M P L E T E _______
Raw
extentmapgenerator
# coding: UTF-8
import sys
import os
import re
# Information for Tablespace ID: 16
# -------------------------------------
#
# Tablespace name: UNBTBS
# Table space flags (HEX): 0122
# Table space type: Database Managed Space (DMS)
# Page size: 4096
# Extent size: 4
# Prefetch size: 12
# Version: 3
# Tablespace state: 0
# Number of quiescers: 0
# Storage Group ID: 0
# Usable pages in tablespace: 128
# Total pages in tablespace: 140
# Initial Size: 0 bytes
# Increment : 0 bytes
# Maximum Size: 0 bytes
# Last Resize: None
# Last Resize Failed: No
# SMP page for first free extent: 4
# SMP page for last allocated tablespace extent. 7
# SMP extent number of the last initialized SMP extent: 0
# High Water Mark: 128
# Number of containers associated with this tablespace: 3
# Container list:
# Total Useable Container Container
# # Pages Pages Type Name
# === ======== ======== ============== ============================
# 0 80 76 striped file D:\DB2\NODE0000\SQL00002\unb1.dat
# 1 40 36 striped file D:\DB2\NODE0000\SQL00002\unb2.dat
# 2 20 16 striped file D:\DB2\NODE0000\SQL00002\unb3.dat
# Container checksum for disk space: 202385520
# Number of ranges in the map: 3
# Size of the map: 3
# Map entry size: 60
# Current map:
# MaxPage MaxExtent StartStripe EndStripe Adj Containers
# [ 0] 47 11 0 3 0 3 (0,1,2)
# [ 1] 87 21 4 8 0 2 (0,1)
# [ 2] 127 31 9 18 0 1 (0)
#
""" 引数チェック """
# usage: <script_name> <DEMP_report_file> <DTSF_report_file>
if len(sys.argv) < 3:
print "error: Illegal argument."
print "usage: <script_name> <DTSF_report_file> <DEMP_report_file>"
sys.exit(1)
if not os.path.isfile(sys.argv[1]):
print "error: File not fund"
print sys.argv[1], " is not found"
sys.exit(1)
if not os.path.isfile(sys.argv[2]):
print "error: File not fund"
print sys.argv[2], " is not found"
sys.exit(1)
""" レポートファイル読み込み """
# DEMP
emp = []
data = []
with open(sys.argv[1]) as demp:
mode = "d" # mode=d:表エクステント mode=i:索引エクステント
for line in demp:
# 表/索引モード切替
r = re.compile("INX extent anchor")
pos = r.search(line)
if not pos == None:
mode = "i"
# 表スペースID (tablespace_id)
r = re.compile("\s+Table space:\s*\d+")
pos = r.search(line)
if not pos == None:
r = re.compile("\d+")
pos = r.search(pos.group())
tablespace_id = pos.group().strip()
print tablespace_id
# EMPページ番号 (emp_page_id)
r = re.compile("\s+EMP pool page:\s*\d+")
pos = r.search(line)
if not pos == None:
r = re.compile("\d+")
pos = r.search(pos.group())
emp.append(pos.group())
print pos.group()
# DATAページ番号 (data_page_id)
r = re.compile("\s+\d+")
pos = r.match(line)
if not pos == None:
r = re.compile("\s+")
pos = r.split(line.strip())
for i in pos:
data.append(i)
print data
# variables
extent_size = 4
cont0 = [0,80,'unb1.dat']
cont1 = [0,40,'unb2.dat']
cont2 = [0,20,'unb3.dat']
containers = [cont0, cont1, cont2]
stripe_group0 = [0, 47, 11, 0, 3, [0,1,2]]
stripe_group1 = [1, 87, 21, 4, 8, [0,1]]
stripe_group2 = [2, 127, 31, 9, 18, [0]]
stripe_groups = [stripe_group0, stripe_group1, stripe_group2]
extent_map = []
extent_id = 0
start_extent_id = 0
end_extent_id = 0
for stripe_group in stripe_groups: # stripe_groupsのループ
# group毎のループ
count = 0 # ループ回数
for stripe in stripe_groups:
# 終了extent
end_extent_id = stripe[2]+1
# コンテナーリスト [0,1,2]etc...
stripe_containers = stripe[5]
# コンテナー数
num_of_stripe_containers = len(stripe_containers)
# エクステント数分ループ
for i in range(start_extent_id, end_extent_id):
container_id = stripe_group[5][count%num_of_stripe_containers]
# [エクステントID, 開始ページ番号, コンテナーID]
extent = [extent_id, extent_id*extent_size, stripe_containers[container_id]]
extent_map.append(extent)
extent_id += 1
start_extent_id = i
count += 1
for e in extent_map:
if e[2] == 0:
print ""
print e,
else:
print e,
Raw
setup
db2 "create large tablespace unbtbs managed by database using(file 'unb1.dat' 80, file 'unb2.dat' 40, file 'unb3.dat' 20) extentsize 4"
db2 "create table unbtab(a int, b int, c varchar(2000)) in unbtbs index in unbtbs"
db2 "insert into unbtab values(333,333,'a')"
db2 "update unbtab set c = replace(c, 'a', 'aaaaaaaaaa')"
db2 "update unbtab set c = replace(c, 'a', 'aaaaaaaaaa')"
db2 "update unbtab set c = replace(c, 'a', 'aaaaaaaaaa')"
db2 "insert into unbtab select * from unbtab"
db2 "insert into unbtab select * from unbtab"
db2 "insert into unbtab select * from unbtab"
db2 "insert into unbtab select * from unbtab"
db2 "insert into unbtab select * from unbtab"
db2 "insert into unbtab select * from unbtab"
db2 "insert into unbtab select * from unbtab"
db2 "insert into unbtab select * from unbtab"
db2 "insert into unbtab select * from unbtab fetch first 10 rows only"
db2 "insert into unbtab select * from unbtab fetch first 10 rows only"
db2 "insert into unbtab select * from unbtab fetch first 10 rows only"
db2 "insert into unbtab select * from unbtab fetch first 10 rows only"
db2 "insert into unbtab select * from unbtab fetch first 10 rows only"
db2 "insert into unbtab select * from unbtab fetch first 10 rows only"
db2 "insert into unbtab select * from unbtab fetch first 10 rows only"
db2 terminate
db2dart sample /DEMP /OI 4 /TSI 16
db2dart sample /DTSF
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment