Kbase 251: How to get index name & file based on an index number
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
How to get index name & file based on an index number
900607-SLK01
INTRODUCTION: Date Last Modified: 8/24/90
=============
This Product Services Technical Library Entry gives a sample program
that you can use to locate the name of an index in the PROGRESS
metaschema if you already know the index number (either previously
displayed in an error or as the result of a proutil dbanalysis).
WHY YOU NEED TO DO THIS:
========================
Many times, PROGRESS error messages regarding index trouble will refer
to an index number instead of the index name. The output of the
PROGRESS utility dbanalys and the ixanalys (Index Summary) also refer
to the index number. The following procedure shows how to use that
number to get the index name and file it belongs to.
PROCEDURAL APPROACH:
====================
Log into PROGRESS and in the editor, type:
FOR EACH _index where _index._idx-num = <your index number>:
FOR EACH _file OF _index:
DISPLAY _index-name _file-name.
END.
END.
Note: You should substitute <your index number> with the index number
shown in the error message or dbanalys/ixanalys output.
Based on the error message explanation in on-line help or discussions
with a PROGRESS Software Technical Support Representative, you may
then want to use the index name and file name to rebuild the problem
index using the 'idxbuild' option on proutil (Progress Utilities).
UNIX: proutil <dbname> -C idxbuild
DOS: same as UNIX
VMS: progress/utilities=idxbuild <dbname>
BTOS: Utility Name -C idxbuild <dbname>
ONLINE PROCEDURES OR UTILITIES:
===============================
None
REFERENCES TO WRITTEN DOCUMENTATION:
====================================
System Administration (Version 5) - Chapter on proutil idxbuild
(Index Rebuild Utility)
Progress Software Technical Support Note # 251