IBM Power Systems

IBM Power Systems

About This Blog

Warm wishes and welcome to all AS400 Administrators and Operators.



This is exclusive blog for iSeries system Administrators working anywhere in the world. Also a place for guys and gals who want to share knowledge pertaining to iSeries. This blog has been designed for exchanging knowledge on AS400 or iSeries server administration and operations.



Wednesday, June 30, 2010

Fixing QAOK* Files in QUSRSYS

To compare the files on the system to a system with the correct logical files and physical files, use the following command:

WRKOBJPDM LIB(QUSRSYS) OBJ(QAOK*) OBJTYPE(*FILE)

The following is a list of things to do to fix the files without restoring QUSRSYS. Ensure there are no locks on the QAOKL03A file. You should do the following:
Note: The user must determine the best method. Involving IBM in this requires a consulting agreement. WRKF command can be used to display and manipulate the needed files.

1. Make a list of the logical files and what physical files they point to.
2. Look at the physical files and determine which ones have data. Make a note of those files.
3. If you have a good logical file pointing to a good physical file, there is no need to do anything.
4. If you have a good logical file pointing to a wrong physical file, do the following:

o If the wrong physical file contains the data, delete the correct named file, and rename the wrong file to the correct file name (the logical file will follow the rename).
o If the correct physical contains the data, type CLRPFM on the wrong file. Then copy the file of the correct physical file to the wrong physical file with the CPYF command. Delete the correct physical file, and rename the wrong physical file to the correct physical file name.
5. If you have a wrong logical file pointing to a good physical file, make a backup of a good logical file, delete the correctly named logical file, rename the wrong logical file to the correct name, and correct the description.
6. If you have a wrong logical file pointing to a wrong physical file, delete both files.

Note:This takes time because you must chart out what the problems are.
You can use the DSPDBR command on a physical file to see what logical file is attached to it.

1 comment: