Archives of the TeradataForum

Message Posted: Wed, 29 Mar 2006 @ 09:52:04 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi all,

The result of the command ? showfsp ?a ? show an important number of cylinder recoverable. For example in the table XXXX_BILL_INVOICE_DETAIL we have 471 cylinder recoverable and 1222 current cylinder.

In the configuration mini-cylpack is fixed by default at 20,

Is it ok ??

How can we interpret the value of 20 ?

How can we see in the database in a table like software_event_log or hardware_event_log this information without ferret the automatic mini- cylpack ?

     ************************************************************************
     ************************************************************************
     Ferret  ==>
     showfsp -a
     Mon Mar 20, 2006  14:18:03 : showfsp will be started
                                On All AMP vprocs
     Mon Mar 20, 2006  14:18:03 : to find all the tables specified greater than 0 cylinders
     Mon Mar 20, 2006  14:18:03 : which could free up/consume any number of cylinders
     Mon Mar 20, 2006  14:18:03 : only tables with a current FSP greater than 0%
     Mon Mar 20, 2006  14:18:03 : will be considered
     Do you wish to continue based upon this scope?? (Y/N)
     Y
     Mon Mar 20, 2006  14:18:07 : ShowFsp has been started
                                On All AMP vprocs


     vproc  0 (0000)  response
     There are  231 tables larger than 0 cylinders on amp 0
            Database             Table              fsp Recoverable Current
            Name                 Name                %Cylinders   Cylinders
     -----------------  --------------------------  -------------- ---------
     XXX                SAVE_K01_ELAF_CR                    270          2
     XXXX               XXXX_NRC                           4858        139
     XXXX               XXXX_NRC_D                          430          1
     XXXX               SAVE_REFERENCE_FACTURES            5227         59
     XXXX               W_XXXX_ZSUIVIFACTURE                320          1
     XXXX               W_GEODE_BI                          930          1
     boXXXX_dico        OBJ_M_UNIVSLC                       330          1
     boXXXX_dico6       OBJ_X_DOCUMENTS                     720          1
     XXXX               XXXX_ADJ                           5811         21
     XXXX               XXXX_BILL_INVOICE_DETAIL          45471       1222
     XXXX               XXXX_BILL_INVOICE_DETAIL_D          8-1          1
     XXXX               W_GEODE_BID                         8-1         13
     XXXX               XXXX_YYY_HISTO                      200          1
     XXXX               XXXX_BILL_EQUIP_DETAIL_D            130         10
     XXXX               XXXX_DOUBLONS_YYY                   141         46
     boXXXX_dico6       OBJ_A_APPLICATION                   580          1
     BOXXXXUSER         XXXX_infocentre_travail             420          1
     XXXX               UV_XXXX_YYY_S48                     170          1
     XXXX               XXXX_YYY_S49                       1359       2048
     dbcmngr            LogSpool                            500          1
     XXXX               XXXX_YYY_S50                       1329        877
     XXXX_san3          jmbo_point_id_target                170          1
     XXXX               XXXX_YYY_S51                        128        333
     XXXX               XXXX_YYY_S52                        140          9
     XXXX               XXXX_YYY_S1                        1327        826
     XXXX_SAN3          XXXX_nrc                            142         60
     XXXX_SAN3          XXXX_bill_invoice                   140          2
     XXXX_SAN3          save_XXXX_nrc                       142         60
     XXXX               XXXX_YYY_S2                       12119       4612
     XXXX               XXXX_YYY_S3                        1350       1445
     boXXXX_dico6       OBJ_A_MAGICID_sov                   840          1
     XXXX               XXXX_K01_ELAF_CR                    572          4
     XXXX               XXXX_K01_ELAF_CR_D                  260          1
     XXXX               XXXX_YYY_S5                         223         24
     XXXX               XXXX_YYY_S6                      381229       4012
     XXXX               XXXX_YYY_S7                       39157        496
     XXXX               T_XXXX_bpf_tablefinale              470          1
     XXXX               XXXX_YYY_S8                       31104        452

Berrafato Jeanmichel

	<Prev	Next>		<<First	<Prev	Next>	Last>>