IBM 000-8697 Instrukcja Użytkownika Pobierz pdf (Strona 487)

100

101

Utilities 7-9

Contents of the Schema File

The .sql ﬁle contains the SQL statements needed to re-create the exported

database, as well as some additional ownership and privilege information.

The schema ﬁle does not retain all the information that might have been

included in the original statements used to create the database and tables.

The following information is omitted:

■ Initial and next extent values

■ Lock mode

■ Dbspace where the table should reside

■ Blobspace where a blob column should reside

■ Logging mode of the database, if there is one

Initialornextextent sizesarenotretainedinthe .sql ﬁlestatements.Ifyoudo

not edit the.sql ﬁle CREATE TABLE statements beforeyou run dbimport,the

tableswill be createdwith the defaultextentsizesof eight pages.Ifyou want

to change the extent sizes after the database is imported, use the ALTER

TABLE

statement.

Thelock mode ofthetableis not retainedinthe .sql ﬁlestatements.Ifyou do

not edit the.sql ﬁle CREATE TABLE statements beforeyou run dbimport,the

table will becreatedwiththe defaultlockmode, which is page-levellocking.

If you want to change the lock mode after the database is imported, use the

ALTER TABLE statement.

The logging mode is not retained in the .sql ﬁle. You can specify any one of

three options when you import the database using dbimport:

■ ANSI-compliant database with unbuffered logging

■ Unbuffered logging

■ Buffered logging

If you wantto changethe loggingmode ofthe databaseand donot specifya

logging option in the dbimport command line, you can make the change

from DB-Monitor after the database is imported. Refer to page 7-14 for more

details about starting logging from the dbimport command line.

1 2 ... 482 483 484 485 486 487 488 489 490 491 492 ... 701 702

Komentarze do niniejszej Instrukcji

Brak uwag

IBM 000-8697 Instrukcja Użytkownika Strona 487

Komentarze do niniejszej Instrukcji

Powiązane produkty i podręczniki dla Oprogramowanie bazy danych IBM 000-8697