IBM 000-8697 Manual do Utilizador Página 585

  • Descarregar
  • Adicionar aos meus manuais
  • Imprimir
  • Página
    / 702
  • Índice
  • MARCADORES
  • Avaliado. / 5. Com base em avaliações de clientes
Vista de página 584
Utilities 7-107
tbunload: Transfer Binary Data in Page Units
tbunload: Transfer Binary Data in Page Units
Thetbunload utility writesadatabase or tabletotape.The program unloads
thedata in binary indisk-pageunits,making it moreefficientthandbexport.
The tape created by tbunload is read using the tbload utility. The machine
receiving the data and the machine used to create the tape must share the
same page size (specified as
BUFFSIZE in the configuration file).
The logging mode is not preserved when a database is unloaded with
tbunload.After you load thedatabasewithtbload,youcan make adatabase
ANSI-complaint after it is loaded through the
DB-Monitor Logical-Logs
menu, Databases option. You can add logging to a database either through
DB-Monitor (same option) or by executing tbtape.
To unload a database, you must have DBA privileges for the database. To
unload a table, you musteither ownthe tableor have DBA privileges forthe
database in which the table resides.
If you unload a table, only the data and index pages that are associated with
thetableareunloaded.Accessprivileges defined for thetableandsynonyms
or views associated with the table are not unloaded to tape.
The tbunload utility unloads page images. If you load the pages to another
machine that stores numeric data types differently than your current
machine (for example,withthe most significantbytelast insteadoffirst), the
contents of the data page could be misinterpreted.
Duringtheunloadoperation,thenewdatabaseortableislockedexclusively.
An error is returned if an exclusive lock cannot be obtained.
Vista de página 584
1 2 ... 580 581 582 583 584 585 586 587 588 589 590 ... 701 702

Comentários a estes Manuais

Sem comentários