db2rhist.asc

来自「这是我的数据库课程设计」· ASC 代码 · 共 34 行

31995BE6:000000000000216C:0000000000000000:0000000000000000:00000009:00000001:00000009:00000001:00000009:00000000:00000000:00000000: :09010000:0000000A:00000101000000:000000D9:                                                                               
                                                                                                                                                                                                                                                               
                                                                                                                                                                                                                                                               
                                                                                                                                                                                                                                                               
7F456829:0000:00000001:000003EE:09010000:A:00000019:00000000:00000000:00000000:00000001:00000000:000000D9:                                                                                                                                                     
A:P:-:20071230203911   :20071230203911:-           :-           :000000000000:-                       :-:                                                                                                                                                      
CREATE TABLESPACE, ID = 3                                                                                                                                                                                                                                      
00000005:DMS01
CREATE  REGULAR  TABLESPACE DMS01 PAGESIZE 4 K  MANAGED BY DATABASE  USING ( FILE 'E:\dms\dms01' 5120 ) EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE 16 TRANSFERRATE 0.14 BUFFERPOOL  IBMDEFAULTBP  DROPPED TABLE RECOVERY ON
79426D2A:0000:00000002:000003EE:09010000:A:00000019:00000000:00000000:00000000:00000001:00000000:000000D9:                                                                                                                                                     
A:P:-:20071230203941   :20071230203941:-           :-           :000000000000:-                       :-:                                                                                                                                                      
CREATE TABLESPACE, ID = 4                                                                                                                                                                                                                                      
00000005:DMS02
CREATE  REGULAR  TABLESPACE DMS02 PAGESIZE 4 K  MANAGED BY DATABASE  USING ( FILE 'E:\dms\dms02' 5120 ) EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE 16 TRANSFERRATE 0.14 BUFFERPOOL  IBMDEFAULTBP  DROPPED TABLE RECOVERY ON
7B4D6E25:0000:00000003:000003EE:09010000:A:00000019:00000000:00000000:00000000:00000001:00000000:000000D9:                                                                                                                                                     
A:P:-:20071230204006   :20071230204006:-           :-           :000000000000:-                       :-:                                                                                                                                                      
CREATE TABLESPACE, ID = 5                                                                                                                                                                                                                                      
00000005:DMS03
CREATE  REGULAR  TABLESPACE DMS03 PAGESIZE 4 K  MANAGED BY DATABASE  USING ( FILE 'E:\dms\dms03' 5120 ) EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE 16 TRANSFERRATE 0.14 BUFFERPOOL  IBMDEFAULTBP  DROPPED TABLE RECOVERY ON
48452549:0000:00000004:0000039A:09010000:A:00000019:00000000:00000000:00000000:00000001:00000000:0000007E:                                                                                                                                                     
A:P:-:20071231121054   :20071231121054:-           :-           :000000000000:-                       :-:                                                                                                                                                      
CREATE TABLESPACE, ID = 6                                                                                                                                                                                                                                      
0000000C:SYSTOOLSPACE
CREATE TABLESPACE SYSTOOLSPACE IN IBMCATGROUP MANAGED BY DATABASE USING (FILE 'SYSTOOLSPACE' 32 M) AUTORESIZE YES EXTENTSIZE 4
4B7B4F68:0000:00000005:0000035D:09010000:A:00000019:00000000:00000000:00000000:00000001:00000000:00000048:                                                                                                                                                     
A:P:-:20071231121300   :20071231121300:-           :-           :000000000000:-                       :-:                                                                                                                                                      
CREATE TABLESPACE, ID = 7                                                                                                                                                                                                                                      
00000005:SMS01
Create regular tablespace sms01 Managed by system using ('d:\sms\sms01')
2753EA04:0000:00000006:00000420:09010000:A:00000019:00000000:00000000:00000000:00000001:000000C3:00000048:                                                                                                                                                     
A:P:-:20071231121326   :20071231121326:-           :-           :000000000000:-                       :-:                                                                                                                                                      
CREATE TABLESPACE, ID = 0                                                                                                                                                                                                                                      
00000005:SMS01
SQLCA   0000000136-00000006010010SMS01