MFCATNML Utility

This command-line utility normalizes the SQL URLs of catalog entries.

Run MFCATNML against an existing catalog before doing an incompatible upgrade from Enterprise Developer, Enterprise Server, or Enterprise Test Server version 7.0.

Important: Before running MFCATNML, we strongly recommend that you back up your existing catalog.

You may execute MFCATNML against the database-hosted catalog, or you can download the catalog from the database and run MFCATNML locally.

Set the following environment variables before running MFCATNML:

ES_DB_FH=Y
MFSYSCAT=full path and filename of the catalog to be updated
Syntax
mfcatnml [-q] [-s] [-d]
Parameters
-q
Performs the normalization process in quiet mode, meaning that normalized datasets are not listed. When omitted, all normalized datasets are listed.
-s
Stops processing when it fails to normalize an entry. When omitted, normalization proceeds with the remaining catalog entries after a failure.
-d
Excludes processing of cataloged spool files if they are on disk.