Start of change

SYSLIMITS_BASIC view

The SYSLIMITS_BASIC view contains information about limits. This view is built on the QSYS.SYSLIMTBL table along with other system information. It does not return information about the job that logged the limit. This view returns less information than the SYSLIMITS view, but it requires less authorization and typically performs significantly better.

Start of change

Authorization: None required.

End of change

The following table describes the columns in the view. The system name is SYSLIMIT_B. The schema is QSYS2.

Table 1. SYSLIMITS_BASIC view
Column Name System Column Name Data Type Description
LAST_CHANGE_TIMESTAMP LASTCHG TIMESTAMP The timestamp when this row was last changed.
LIMIT_CATEGORY CATEGORY VARCHAR(15) The category for this limit.
  • DATABASE
  • JOURNAL
  • SECURITY
  • MISCELLANEOUS
  • WORK MANAGEMENT
  • FILE SYSTEM
  • SAVE RESTORE
  • CLUSTER
  • COMMUNICATION
LIMIT_TYPE TYPE VARCHAR(7) The type of limit.
  • OBJECT
  • JOB
  • SYSTEM
  • ASP
SIZING_NAME SIZING_NAM VARCHAR(128) Name that corresponds to the sizing ID.
COMMENTS COMMENTS VARCHAR(2000)
Nullable
 Description of the limit.
USER_NAME CURUSER VARCHAR(10) The name of the user in effect when this row was logged.
CURRENT_VALUE CURVAL BIGINT Reported value for this limit.
MAXIMUM_VALUE MAXVAL DECIMAL(21,0)
Nullable
 Maximum value allowed for this limit.
JOB_NAME JOB_NAME VARCHAR(28) The name of the job when this row was logged.

Contains the null value if the job is no longer active.
SYSTEM_SCHEMA_NAME SYS_NAME VARCHAR(10)
Nullable
 The library name for the object.

Contains the null value if there is no library name.
SYSTEM_OBJECT_NAME SYS_ONAME VARCHAR(30)
Nullable
 The object name for this row.

Contains the null value if there is no object name.
SYSTEM_TABLE_MEMBER SYS_MNAME VARCHAR(10)
Nullable
 The member name for an object limit specific to database members.

Contains the null value if this row is not for a member limit.
IFS_PATH_NAME PATHNAME DBCLOB(5000) CCSID 1200
Nullable
 IFS path for the object.

Contains the null value if there is no path.
OBJECT_TYPE OBJTYPE VARCHAR(7)
Nullable
 The IBM® i object type when an object name has been logged in the SYSTEM_SCHEMA_NAME and SYSTEM_OBJECT_NAME columns.

Contains the null value when no object name is specified.
ASP_NUMBER ASPNUM SMALLINT
Nullable
 Contains the ASP number related to this row.

Contains the null value if there is no ASP number.
LIMIT_ID LIMIT_ID INTEGER Unique identifier for this limit. Values are maintained in the SIZING_ID column in the QSYS2.SQL_SIZING table.

Examples

  • Review the consumption of the 'Total number of jobs', relative to the QMAXJOB system value.
    WITH TT(JOB_MAXIMUM)
  AS (SELECT CURRENT_NUMERIC_VALUE
        FROM QSYS2.SYSTEM_VALUE_INFO
        WHERE SYSTEM_VALUE_NAME = 'QMAXJOB')
SELECT LAST_CHANGE_TIMESTAMP AS INCREMENT_TIME, CURRENT_VALUE AS JOB_COUNT, 
     TT.JOB_MAXIMUM, 
     DEC(DEC(CURRENT_VALUE,19,2) / DEC(TT.JOB_MAXIMUM,19,2) * 100,19,2) 
         AS PERCENT_CONSUMED
    FROM QSYS2.SYSLIMITS_BASIC, TT
    WHERE LIMIT_ID = 19000 ORDER BY CURRENT_VALUE DESC;
End of change