Fill in a range where you want to reorganize the tables for.
It is also possible to fill in one company number or one table.
Reorganize Tables (ttaad4225m000)Use this session to rebuild data and indices and/or to check and rebuild the referential integrity. Rebuild data and indices Rebuilding data and indices is useful for tables on which many delete actions are performed. To use this option, you must select the Data and Indices check box. The data will be temporarily stored in a sequential dump file. Subsequently the data and indices will be rebuilt. Check and rebuild the referential integrity A table field may have a reference to another table. For example, the "Invoice-from Business Partner" (ifbp) field in the Material Costs (tpppc211) table refers to the Business Partners (tccom100) table. If you try to delete a business partner, the system checks whether the business partner is used in other tables. This is done by checking the reference counter for that business partner. If the reference counter is zero, the record is not used anymore and can be deleted. In this session, you can repair these reference counters, check referential integrity and nullify undefined references. Refer to the field help for details. You must repair the reference counters, for example, after running the Création de table à partir du vidage séquentiel (ttaad4227m000) session with the Ignore Referential Integrity Constraints check box selected. The import process sets the reference counters of all imported records to 0. This is a wrong situation, because now you can delete records, even if they are used in other tables. To repair the counters, you must run the current session with the Compteur références réparées check box selected. Executables Internally the session uses the following executables:
For more information on these executables, refer to the Infor10 ERP Enterprise Server (LN) Technical Manual (U8172 US).
Selection Range Company, Package, Table Fill in a range where you want to reorganize the tables for.
It is also possible to fill in one company number or one table. Options Data and Indices Select this check box to rebuild the data and indices of the
selected tables. This is useful for tables on which many delete actions are
performed. Remarque
Path Dumps If this check box is selected, you can specify a
directory where the session stores its temporary dumpfiles. By default $BSE/tmp
is used. Path Dumps The directory where the session stores its temporary
dumpfiles. By default $BSE/tmp is used. Print results (bdbreconfig) If this check box is selected, the session prints a
report that describes, for each table and company, the result of the
reconfiguration. Each line in the report has the following form: <tablename><compnr><space><status code><space><error><space><message text><newline> The following table lists the possible status codes:
For more information on error codes, refer to Chapter 6 "Error Codes" in the Infor10 ERP Enterprise Server (LN) Technical Manual (U8172 US). Note You can only access this field if the Data and Indices check box is selected. Repair Indices Only Recreates the indexes of the selected tables by dropping and
creating them again. The Package Combination of the selected Companies must be
the same as the current Package Combination. Only one of the checkboxes “Data
and Indices” and “Repair Indices only” can be selected. Logging can be found in the logfile: Create Missing Indices Only If this check box is selected,, missing indices are
created. Existing indices are not deleted and recreated, only non existing
indices are created. Compress/Uncompress Data and Indices If this check box is selected, compressed data or
indices in the database become uncompressed; uncompressed data or indices
become compressed. Remarque This takes a substantial amount of time, during which the system must be offline. Therefore you must plan this action carefully. While the session creates the tables and indices anew, the compress status of the tables and indices is also changed. Therefore the processing takes longer. You can use the Compress/Uncompress Data and Indices option to compress or uncompress existing tables. The Optimisation des paramètres de stockage (ttdba0132m000) session also contains a Compresser option. This option determines how new tables are created: compressed or uncompressed. After this option is switched on, and a Convertir en runtime is performed in the Optimisation des paramètres de stockage (ttdba0132m000) session, new tables are created with the compress option. Print results (bdbreconfig) If this check box is selected, the session prints a
report that shows the results of the compress or uncompress action. Reference Integrity Vérifier la validité de la référence If this check box is selected, the Check Validity of
Reference is checked. You can specify the output file in the File for undefined references field. Compteur références réparées To guarantee referential integrity, the LN Database stores
reference counters, which indicate how many times a record is used in a parent
child relation. The parent record can only be deleted if the reference counter
is zero. (Reference counters are only applicable if the Mode Suppression de contrôle référentiel or Mode Mise à jour de contrôle référentiel in the relation is Restricted (with counter). It is essential to repair these reference counters:
Vérifier seulement la référence du parent If this check box is selected, the session repairs only
the reference counters of tables in the selection range: for each record in a
parent table, the session counts the corresponding records in the related child
tables, and subsequently updates the reference counter in the parent table. If this check box is cleared, the session repairs the reference counters for more tables than the ones that are specified in the selection range: counters are repaired for all tables being referred by the child tables of the tables in the selection range. For example: the selection range consists of (parent) table A only. A is referred by the child table B. B however also refers to another parent table C. The session repairs the reference counters for parent tables A and C. For more details, refer to the example below. Example The tttxt001 table has a lot of child tables. One of them is the Material Costs (tpppc211) table. The Material Costs table contains references to multiple tables: not only to tttxt001 (Language Independent Text Data), but also to various other tables, e.g. to tccom100 (Business Partners).
Notes
Fichier références non définies If this check box is selected, undefined references are
logged in a file. You must specify the file name in the following
field. File for undefined references The name of the file in where the session stores the
undefined references.
| |||||||||||