Background documentationData Carrier Type Locate this document in the navigation structure

 

Loader uses a data carrier to physically store the data stream outside the database during export/import. With the syntax element mediumtype_spec you can specify the type of the data carrier for the data stream in import and export commands.

Structure

Syntax Syntax

  1. <mediumtype_spec> ::=
      FILE
    | PIPE
    | TAPE [<ebid_spec>]
    
    <ebid_spec> ::=
      EBID '<literal>'
End of the code.

Loader differentiates between the data carrier types for the data stream specified in mediumtype_spec. If you do not specify a data carrier type, Loader uses the file system (FILE) as the data carrier for the data stream.

FILE

Data carrier for the data stream is the file system.

PIPE

Data carrier for the data stream is a pipe.

TAPE

(Relevant for EXPORT DB only): Data carrier for the data stream is a tape. Communication with the tape uses a third-party backup tool.

TAPE [<ebid_spec>]

(Relevant for IMPORT DB only): Data carrier for the data stream is a tape. Communication with the tape uses a third-party backup tool. With EBID '<literal>'you specify the external backup ID of the data stream to be imported.

Using Third-Party Backup Tools: Data carrier type TAPE is supported when you export/import the entire database and/or the entire database catalog (EXPORT/IMPORT DB). In these cases the third-party backup tool set for the Loader session is used for exporting/importing.