The USER_STORAGE view contains details about storage by user profile.
The user storage consumption detail is determined by using Retrieve User Information (QSYRUSRI) API.
You must have *OBJOPR and *READ authority to a *USRPRF or it will not be returned. To see information for independent ASPs (iASPs), the iASP must be varied on.
User storage is broken down by SYSBAS and iASPs.
The following table describes the columns in the view. The schema is QSYS2.
|Column Name||System Column Name||Data Type||Description|
|User profile name.|
|Name of the independent ASP or *SYSBAS.|
|The maximum amount of auxiliary storage (in kilobytes) that can be assigned to store permanent objects owned by the user. Contains null if the user does not have a maximum amount of allowed storage.|
|The amount of auxiliary storage (in kilobytes) occupied by the user's owned objects for this ASPGRP.|
SELECT * FROM QSYS2/USER_STORAGE WHERE USER_NAME = ‘SCOTTF’