IBM 000-8697 Manual do Utilizador descarregar pdf (Página 519)

100

101

Utilities 7-41

Option Descriptions

If inconsistencies are detected and OnLine is in quiescent mode, you are

prompted for conﬁrmation to repair theproblem index. If you specify the-y

(yes) option, indexes are automatically repaired. If you specify the -n (no)

option, only the problem is reported. No prompting occurs.

Index rebuilding can be time-consuming if you use tbcheck. Processing is

usuallyfasterifyouuse the DROP INDEX andCREATE INDEXSQLstatements

to drop the index and re-create it.

The -cI option performs the same checks as -ci but extends the consistency

checking to include the rowids associated with the key values. The same -ci

repair options are available with -cI.

tbcheck -cI -n stores5:customer

-cr Option

The -cr option checks each of the root dbspace reserved pages as follows:

■ It validates the contents of the $INFORMIXDIR/etc/$TBCONFIG ﬁle

with the PAGE_CONFIG reserved page.

■ It ensuresthatallchunks can beopened, that chunksdonotoverlap,

and that chunk sizes are correct.

■ It checks all logical and physical log pages for consistency.

If you have changed the value of a conﬁguration parameter (either through

DB-Monitor or by editing the conﬁguration ﬁle) and you have not yet reini-

tialized sharedmemory, tbcheck -crdetectsthe inconsistency andreturnsan

error message.

Refertopage 2-95foracomplete listoftherootdbspace reservedpages.(The

-pr option performs the same checks and also displays the reserved-page

information as it checks the reserved pages.)

tbcheck -cr

-n Option

The-n option is usedwiththeindexrepairoptions(-ci,-cI, -pk, -pK,-pl,and

-pL) to indicate that no repair should be performed, even if errors are

detected.

1 2 ... 514 515 516 517 518 519 520 521 522 523 524 ... 701 702

Comentários a estes Manuais

Sem comentários

IBM 000-8697 Manual do Utilizador Página 519

Comentários a estes Manuais

Manuais e produtos relacionados com Software de bases de dados IBM 000-8697