Download Relational Database Fast Load User Guide

Transcript
Relational Database Fast Load with Empty Input File
C.5. Execution Result of XRLOAD
The following runstream illustrates the executed result of XRLOAD:
@XRUTL.XRLOAD,E
UDSSRC,SAVEFILE.SAVEJCL
XRLOAD 5R2-1A01*00 PROCESSOR 04/16/01
13:36:41
Please enter LOAD COMMAND followed by a semicolon (;)
1. LOAD INTERNAL FILE "DATAF" SORTED YES INTO SCH.TBL
2. ;
***** XRLOAD END *****
@MSG
**** XRLOAD START ****
@ABS.JETLOAD UDSSRC,SAVEFILE,SAVEJCL,ALL
JETLOAD start at 04/16/01 13:36:45
The total number of rows loaded is
0
Information of storage-area "rsm-data-only "
Schema name
SCH
Storage-area name
STOPKD
The total data page is
0 on this B-tree
The last page number is
1 on this B-tree
Information of storage-area "rsm-index-only"
Schema name
SCH
Storage-area name
STOPKI
The total index page is
0 on this B-tree
The last page number is
1 on this B-tree
This B-tree level is
0
The total number of rows loaded is
0
Information of storage-area "rsm-index-only"
Schema name
SCH
Storage-area name
STOIX1
The total data page is
0 on this B-tree
The total index page is
0 on this B-tree
The last page number is
1 on this B-tree
This B-tree level is
0
The total number of rows loaded is
0
Information of storage-area "rsm-index-only"
Schema name
SCH
Storage-area name
STOIX2
The total data page is
0 on this B-tree
The total index page is
0 on this B-tree
The last page number is
1 on this B-tree
This B-tree level is
0
JETLOAD
end
at 04/16/01 13:36:46
@PMD,ED
@MSG
**** XRLOAD STORAGE-AREA INITIALIZE PROCESS END ****
@MSG
**** XRLOAD END ****
7847 4889–007
C–3