Troubleshooting
Problem
Application jobs fail with error message MCH2804 Tried to go larger than storage limit for object &1 for a User Profile, however when you create the PRTPRFINT report the user profile does not show as being full.
Cause
A user profile as of current releases has maximum 50 million number of indexes for the ASP and an additional 50 million for each additional iASP on the System. The PRTPRFINT report shows the percentage full for the SUM of all entries.
For example, a user profile has used all of the available number of indexes in the iASPs but only it only has a few entries on the ASP will show the profile as being 52% full.
Resolving The Problem
With the release of the following PTFs, there are two new functions that will allow you to get a warning and a more accurate count for the profile.
v7r2m0: MF68098 (pre-reqs MF68059)
v7r3m0: MF68099 (pre-reqs MF68060)
v7r4m0: MF68101
v7r3m0: MF68099 (pre-reqs MF68060)
v7r4m0: MF68101
1. A new VLOG 0B00 3009 will be created when a profile extension exceeds 90% of the limit, the 0B00 3009 vlog will be identify the profile name, IASP# (in hex), and current entry counts (in hex):
USER PROFILE EXTENSION NEARLY FULL
USER PROFILE NAME
DUMP ITEM
EA146B9D6C FF9000 DISK UNIT 0001 DISK PAGE 00731939
EA146B9D6C FF9600 E3C5E2E3D7D9C6F1 * TESTPRF1*
EA146B9D6C FF9620 4040404040404040 4040404040404040 404040404040 * *
ASP NUMBER
DUMP ITEM
+0000 0023 *.. *
OWNED OBJ CNT
DUMP ITEM
+0000 02F00000 *.0.. *
AUTH OBJ CNT
DUMP ITEM
+0000 00000001 *.... *
AUTH USER CNT
DUMP ITEM
+0000 00000000 *.... *
PRIM GRP CNT
DUMP ITEM
+0000 00000000 *.... *
A Watch can be created to monitor for the VLOG and when detected it could notify the administrators of the system that a user profile is approaching the maximum number of entries.
2. A new Advanced Analysis native macro AUINTERNALS can be used to get the percentage full for the ASP and each additional iASP.
The native macro can be run from SST Advanced Analysis to find profile extensions that are close to the limit.
From STRSST:
- 1. Start a service tool
- 4. Display/Alter/Dump
- 1. Display/Alter storage
- 2. Licensed Internal Code (LIC) data
- 14. Advanced analysis
- Select AUINTERNALS by putting 1 beside it and hit enter
- In the options field, fill in: ENTRYCOUNTS ALL FILTER 90
- Hit enter
- 1. Start a service tool
- 4. Display/Alter/Dump
- 1. Display/Alter storage
- 2. Licensed Internal Code (LIC) data
- 14. Advanced analysis
- Select AUINTERNALS by putting 1 beside it and hit enter
- In the options field, fill in: ENTRYCOUNTS ALL FILTER 90
- Hit enter
This will produce output like the following, showing any profile extensions that are above 90% of the limit. "FILTER 90" can be changed to a different percentage, or it can be omitted to dump the counts for all profile extensions on all currently varied-on IASPs.
Running macro: AUINTERNALS ENTRYCOUNTS ALL FILTER 90
----------------------------------------------------------------------------
Information for SYSBAS
User | Pct | Total | Owned Objs| Auth Objs | Auth Users| Pri Groups
----------------------------------------------------------------------------
TESTPRF1 * 98% 49283075 49283073 1 1 0
----------------------------------------------------------------------------
----------------------------------------------------------------------------
Information for IASP 35
User | Pct | Total | Owned Objs| Auth Objs | Auth Users| Pri Groups
----------------------------------------------------------------------------
TESTPRF2 * 93% 46976207 46976203 1 3 0
----------------------------------------------------------------------------
----------------------------------------------------------------------------
Information for SYSBAS
User | Pct | Total | Owned Objs| Auth Objs | Auth Users| Pri Groups
----------------------------------------------------------------------------
TESTPRF1 * 98% 49283075 49283073 1 1 0
----------------------------------------------------------------------------
----------------------------------------------------------------------------
Information for IASP 35
User | Pct | Total | Owned Objs| Auth Objs | Auth Users| Pri Groups
----------------------------------------------------------------------------
TESTPRF2 * 93% 46976207 46976203 1 3 0
----------------------------------------------------------------------------
Document Location
Worldwide
[{"Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000000CHyAAM","label":"Security"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.2.0;7.3.0;7.4.0"}]
Was this topic helpful?
Document Information
Modified date:
21 June 2022
UID
ibm16415909