Troubleshooting
Problem
This document describes how to determine which objects are marked as overflowed in a user ASP.
Resolving The Problem
In the case where a user ASP has overflowed, it becomes necessary to determine what objects in particular are overflowed and to take proper steps to recover them. An overflowed object is an object that, when the particular user ASP ran out of auxiliary storage, was written into the storage space of the system ASP. The object is still considered to be in the user ASP, but it is marked as overflowed into the system ASP.
Note: In some cases, it is not possible to locate internal objects that have overflowed the ASP. In these cases, a step mode IPL recovery is required.
Recovery requires clearing enough storage in the user ASP to drop below 100% full of the ASP, saving, deleting, and restoring the overflowed objects to the user ASP. It is frequently difficult to locate the objects that are in overflow status. One way to do this involves getting information about all of the objects on the system as indicated here:
| 1. | On an operating system command line, type the following: DSPOBJD OBJ(*ALL/*ALL) DETAIL(*FULL) OUTPUT(*OUTFILE) OUTFILE(OUTFILELIB/OUTFILENAM) Note: OUTFILELIB and OUTFILENAM should be exchanged for more appropriate locations and names. The object library can be limited to the libraries in the user ASP (for time savings), but this might not catch every overflowed object in that ASP. Press the Enter key. |
| 2. | The output file must be queried. If you are familiar with queries, query the file for field ODOASP being set to a 1. The following examples are shown for doing the query: a RUNQRY QRY(*NONE) QRYFILE((OUTFILELIB/OUTFILENAM)) The Overflowed ASP field is at approximately column 790. Look for the value to be a 1. It is easy to miss a 1 when paging down, so option b might be more appropriate, albeit more complex. b Run the WRKQRY command. |
| Work with Queries Type choices, press Enter. Option . . . . . . 1 1=Create, 2=Change, 3=Copy, 4=Delete 5=Display, 6=Print definition 8=Run in batch, 9=Run Query . . . . . . . EXAMPLEQRY Name, F4 for list Library . . . . . OUTFILELIB Name, *LIBL, F4 for list F3=Exit F4=Prompt F5=Refresh F12=Cancel |
| Define the Query Query . . . . . . : EXAMPLEQRY Option . . . . . : CREATE Library . . . . : OUTFILELIB CCSID . . . . . . : 37 Type options, press Enter. Press F21 to select all. 1=Select Opt Query Definition Option 1 Specify file selections Define result fields Select and sequence fields Select records Select sort fields Select collating sequence Specify report column formatting Select report summary functions Define report breaks Select output type and output form Specify processing options F3=Exit F5=Report F12=Cancel F13=Layout F18=Files F21=Select all |
| Specify File Selections Type choices, press Enter. Press F9 to specify an additional file selection. File . . . . . . . . . OUTFILENAM Name, F4 for list Library . . . . . . OUTFILELIB Name, *LIBL, F4 for list Member . . . . . . . . *FIRST Name, *FIRST, F4 for list Format . . . . . . . . OLIDOBJD Name, *FIRST, F4 for list F3=Exit F4=Prompt F5=Report F9=Add file F12=Cancel F13=Layout F24=More keys |
| Define the Query Query . . . . . . : EXAMPLEQRY Option . . . . . : CREATE Library . . . . : OUTFILELIB CCSID . . . . . . : 37 Type options, press Enter. Press F21 to select all. 1=Select Opt Query Definition Option _ > Specify file selections Define result fields 1 Select and sequence fields _ Select records _ Select sort fields _ Select collating sequence _ Specify report column formatting _ Select report summary functions _ Define report breaks _ Select output type and output form _ Specify processing options F3=Exit F5=Report F13=Layout F18=Files F21=Select all Select options, or press F3 to save or run the query. |
| 3. | On the Select and Sequence Fields screen, type a 1 next to ODOBNM, a 2 next to ODLBNM, a 3 next to ODASP, a 4 next to ODOASP, and press the Enter key two times. |
| Define the Query Query . . . . . . : EXAMPLEQRY Option . . . . . : CREATE Library . . . . : OUTFILELIB CCSID . . . . . . : 37 Type options, press Enter. Press F21 to select all. 1=Select Opt Query Definition Option _ > Specify file selections Define result fields > Select and sequence fields 1 Select records _ Select sort fields _ Select collating sequence _ Specify report column formatting _ Select report summary functions _ Define report breaks _ Select output type and output form _ Specify processing options F3=Exit F5=Report F13=Layout F18=Files F21=Select all Select options, or press F3 to save or run the query. |
| Select Records Type comparisons, press Enter. Specify OR to start each new group. Tests: EQ, NE, LE, GE, LT, GT, RANGE, LIST, LIKE, IS, ISNOT... AND/OR Field Test Value (Field, Number, 'Characters', or ...) ODOASP EQ '1' Bottom Field Field Field Field ODDCEN ODOBTP ODOBLK ODOBOW ODDDAT ODOBAT ODOBDM ODSCEN ODDTIM ODOBFR ODCCEN ODSDAT ODLBNM ODOBSZ ODCDAT ODSTIM ODOBNM ODOBTX ODCTIM ODSCMD More... F3=Exit F5=Report F9=Insert F11=Display text F12=Cancel F13=Layout F20=Reorganize F24=More keys |
| 4. | Press F3 to save and run the query. |
| 5. | Take the defaults on the next screen to run interactively (might affect system performance), or change the Run option to a 2 to run in batch. |
Note: If the customer has Interact SQL, or Operations Navigator and not Query/400, to get this same information, run the statement:
select odlbnm, odobnm, ODOBTP, odobat, odobsz, odasp
from outfilelib/outfilenam
where odoasp = '1'
It might be required to change from "outfilelib/outfilenam" to "outfilelib.outfilenam" depending on how the SQL session was configured.
[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"6.1.0"}]
Historical Number
19745440
Was this topic helpful?
Document Information
Modified date:
18 December 2019
UID
nas8N1017750