SYSLIMITS view

The SYSLIMITS view contains information about limits. This view is built upon QSYS/SYSLIMTBL along with other system information. If a job is still active, it contains information about the job that logged the limit.

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

Table 1. SYSLIMITS 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 of this limit.
  • DATABASE
  • JOURNAL
  • SECURITY
  • MISCELLANEOUS
  • WORK MANAGEMENT
  • FILE SYSTEM
  • SAVE RESTORE
  • CLUSTER
  • COMMUNICATION
  • UNKNOWN
LIMIT_TYPE TYPE VARCHAR(7) The type of limit.
  • OBJECT
  • JOB
  • SYSTEM
  • ASP
  • UNKNOWN
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.
JOB_STATUS JOB_STATUS CHAR(10)
Nullable
 Status of the job.
ACTIVE_JOB_STATUS AJSTATUS CHAR(4)
Nullable
 The active status of the initial thread of the job.
RUN_PRIORITY RUNPRI INTEGER
Nullable
 The highest run priority allowed for any thread within this job.
SBS_NAME SBS_NAME CHAR(10)
Nullable
 Name of subsystem where job is running.
CPU_USED CPU_USED BIGINT
Nullable
 The amount of CPU time (in milliseconds) that has been currently used by this job.
TEMP_STORAGE_USED_MB TEMPSTG INTEGER
Nullable
 The amount of auxiliary storage (in megabytes) that is currently allocated to this job.
AUX_IO_REQUESTED AUXIO BIGINT
Nullable
 The number of auxiliary I/O requests performed by the job across all routing steps. This includes both database and nondatabase paging.
PAGE_FAULTS PAGEFAULT BIGINT
Nullable
 The number of times an active program referenced an address that was not in main storage during the current routing step of the specified job.
CLIENT_WRKSTNNAME CLIENTWRK CHAR(255)
Nullable
 Value of the SQL CLIENT_WRKSTNNAME special register.
CLIENT_APPLNAME CLIENTAPP CHAR(255)
Nullable
 Value of the SQL CLIENT_APPLNAME special register.
CLIENT_ACCTNG CLIENTACT CHAR(255)
Nullable
 Value of the SQL CLIENT_ACCTNG special register.
CLIENT_PROGRAMID CLIENTPGM CHAR(255)
Nullable
 Value of the SQL CLIENT_PROGRAMID special register.
CLIENT_USERID CLIENTUSER CHAR(255)
Nullable
 Value of the SQL CLIENT_USERID special register.
SQL_STATEMENT_TEXT SQLSTMT VARCHAR(10000)
Nullable
 Statement text of the last SQL statement to run or the SQL statement that is currently running.
SCHEMA_NAME OBJ_SCHEMA VARCHAR(128)
Nullable
 The SQL schema name for this object. If no schema name, contains the null value.
OBJECT_NAME OBJ_NAME VARCHAR(128)
Nullable
 The SQL name for the object. If no object name or if an SQL name could not be returned, contains the null value.
SYSTEM_SCHEMA_NAME SYS_NAME VARCHAR(10)
Nullable
 The library name for the object. If no library name, contains the null value.
SYSTEM_OBJECT_NAME SYS_ONAME VARCHAR(30)
Nullable
 The object name for this row. If no object name, contains the null value.
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.
SQL_OBJECT_TYPE SQLOBJTYPE VARCHAR(9)
Nullable
 The SQL type of the object when an object name has been logged in the SYSTEM_SCHEMA_NAME and SYSTEM_OBJECT_NAME columns. Values are:
  • ALIAS
  • FUNCTION
  • INDEX
  • PACKAGE
  • PROCEDURE
  • ROUTINE
  • SEQUENCE
  • TABLE
  • TRIGGER
  • TYPE
  • VARIABLE
  • VIEW
  • XSR

Contains the null value if the object is not an SQL object or 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.