-
Purpose
- Load Empty Table with no secondary indexes
- Execute on Channel,network attached and NCR server
- Checkpoints for restart
-
2 Phase Loading
- Acquisition Phase (Phase1)
- Application and Insert Phase (Phase2)
- Error table on both the phases
- Status of run is displayed
-
Restrictions
- Can load only one empty table by 1 FL job
- Can accomodate 15 FL/FE/ML script at one time
-
Cannot load table with Referential integrity,secondary indexes, JI, Hash indexes and triggers
- Can load table with soft referential integrity
- Duplicate rows cannot be loaded on multiset table
(Use multiload to load duplicates on multiset)
- If amp goes down, FL cannot restarted until it is back online
- Don't use fastload input file from NFS mount
-
2 PHASE Loading
-
Acquisition Phase
- Step 1: FL is executed, sends blocks of records to PE session
- Step 2: PE receives records block and send to AMP via BYNET
- Step 3: AMP receives block of records in memory
- Step 4: AMP rehashes each record and redistribute through Message passing Layer (PDE and BYNET)
- Step 5: Message passing layer passes records to appropriate AMP based on row hash value and store it in memory
- Step 6: when enough rows collected to fill block, then written to the disk
-
Insert or Application phase
- Step 1: Fast load receives 'END Loading' statement
- Step 2: Send request to PE for phase 2
- Step 3: PE broadcast about start of Phase 2 to all amp
- Step 4: AMP reads its block from disk
- Step 5: Data record is sorted based on row has sequence
- Step 6: Write sorted records back to disk
- Step 7:If fallback is defined, fallback rows are added
-
Supported Input format
- Binary
- Formatted
- Unformatted
- Text
- Variable-length text