IBM Support

IBM i Services (SQL)

News


Abstract

IBM i Services (SQL)

Content

You are in: IBM i Technology Updates > Db2 for i - Technology Updates > IBM i  Services (SQL)
 
IBM i Service
Type of Service IBM i 7.5 IBM i 7.4 IBM i 7.3
IBM i 7.2
Application Services
QSYS2.ACTIVATION_GROUP_INFO() Table function Base SF99704 Level 20 SF99703 Level 28 Not Supported
QSYS2.ADD_USER_INDEX_ENTRY() Procedure Base SF99704 Level 20 Not Supported Not Supported
QSYS2.ADD_USER_INDEX_ENTRY_BINARY() Procedure Base SF99704 Level 20 Not Supported Not Supported
QSYS2.BINDING_DIRECTORY_INFO View Base SF99704 Level 20 SF99703 Level 28 Not Supported
QSYS2.BOUND_MODULE_INFO View Base SF99704 Level 4 SF99703 Level 16 Not Supported
QSYS2.BOUND_SRVPGM_INFO View Base SF99704 Level 4 SF99703 Level 16 Not Supported
QSYS2.CHANGE_USER_SPACE() Procedure Base SF99704 Level 20 Not Supported Not Supported
QSYS2.CHANGE_USER_SPACE_BINARY() Procedure Base SF99704 Level 20 Not Supported Not Supported
QSYS2.CHANGE_USER_SPACE_ATTRIBUTES() Procedure Base SF99704 Level 20 Not Supported Not Supported
QSYS2.CLEAR_DATA_QUEUE() Procedure Base SF99704 Level 4 SF99703 Level 16 Not Supported
QSYS2.COMMAND_INFO View SF99950 Level 3 SF99704 Level 23 Not Supported Not Supported
QSYS2.CREATE_USER_INDEX() Procedure Base SF99704 Level 20 Not Supported Not Supported
QSYS2.CREATE_USER_SPACE() Procedure Base SF99704 Level 20 Not Supported Not Supported
QSYS2.DATA_AREA_INFO() Table function Base Base SF99703 Level 15 Not Supported
QSYS2.DATA_AREA_INFO View Base Base SF99703 Level 15 Not Supported
QSYS2.DATA_QUEUE_ENTRIES() Table function Base SF99704 Level 10 SF99703 Level 22 Not Supported
QSYS2.DATA_QUEUE_INFO View Base SF99704 Level 4 SF99703 Level 16 Not Supported
QSYS2.DB_TRANSACTION_INFO View Base
Enhanced: SF99950 Level 5
SF99704 Level 7
Enhanced: SF99704 Level 10
Enhanced: SF99704 Level 26
SF99703 Level 18
Enhanced: SF99703 Level 22
Not Supported
QSYS2.DB_TRANSACTION_JOURNAL_INFO Table function SF99950 Level 5 SF99704 Level 26 Not Supported Not Supported
QSYS2.ENVIRONMENT_VARIABLE_INFO View Base Base Base SF99702 Level 11
QSYS2.EXIT_POINT_INFO View Base SF99704 Level 10 SF99703 Level 22 Not Supported
QSYS2.EXIT_PROGRAM_INFO View Base SF99704 Level 10 SF99703 Level 22 Not Supported
QSYS2.PROGRAM_EXPORT_IMPORT_INFO View Base SF99704 Level 4 SF99703 Level 16 Not Supported
QSYS2.PROGRAM_INFO View Base
Enhanced: SF99950 Level 4
SF99704 Level 4
Enhanced: SF99704 Level 25
SF99703 Level 16 Not Supported
QSYS2.QCMDEXC() Procedure Base Base Base Base
QSYS2.QCMDEXC() Scalar function Base SF99704 Level 13 SF99703 Level 24 Not Supported
QSYS2.RECEIVE_DATA_QUEUE() Table function Base SF99704 Level 4 SF99703 Level 16 Not Supported
QSYS2.REMOVE_USER_INDEX_ENTRY() Table function Base SF99704 Level 20 Not Supported Not Supported
QSYS2.REMOVE_USER_INDEX_ENTRY_BINARY() Table function Base SF99704 Level 20 Not Supported Not Supported
QSYS2.SEND_DATA_QUEUE() Procedure Base SF99704 Level 4 SF99703 Level 16 Not Supported
QSYS2.SEND_DATA_QUEUE_BINARY() Procedure Base SF99704 Level 4 SF99703 Level 16 Not Supported
QSYS2.SEND_DATA_QUEUE_UTF8() Procedure Base SF99704 Level 4 SF99703 Level 16 Not Supported
QSYS2.SERVICES_INFO Table Base Base Base SF99702 Level 11
QSYS2.SET_PASE_SHELL_INFO() Procedure Base Base SF99703 Level 4 SF99702 Level 16
QSYS2.STACK_INFO() Table function Base
Enhanced: SF99950 Level 4
Base
Enhanced: SF99704 Level 25
SF99703 Level 7 SF99702 Level 19
QSYS2.USER_INDEX_ENTRIES() Table function Base SF99704 Level 13 SF99703 Level 24 Not Supported
QSYS2.USER_INDEX_INFO View Base SF99704 Level 13 SF99703 Level 24 Not Supported
QSYS2.USER_SPACE() Table function Base SF99704 Level 13 SF99703 Level 24 Not Supported
QSYS2.USER_SPACE_INFO View Base SF99704 Level 13 SF99703 Level 24 Not Supported
QSYS2.WATCH_DETAIL() Table function Base SF99704 Level 10 SF99703 Level 22 Not Supported
QSYS2.WATCH_INFO View Base SF99704 Level 10 SF99703 Level 22 Not Supported
SYSTOOLS.GENERATE_SPREADSHEET Scalar function SF99950 Level 5 SF99704 Level 26 Not Supported Not Supported
SYSTOOLS.LPRINTF() Procedure Base
Enhanced: SF99950 Level 5
SF99704 Level 4
Enhanced: SF99704 Level 26
SF99703 Level 18 SF99703 Level 16 Not Supported
SYSTOOLS.SEND_EMAIL Scalar function SF99950 Level 5 SF99704 Level 26 Not Supported Not Supported
SYSTOOLS.SPLIT() Table function Base Base
Enhanced: SF99704 Level 10
SF99703 Level 15
Enhanced: SF99703 Level 22
Not Supported
Backup and Recovery Services
Details for Backup, Recovery, and Media Services (BRMS) Services available  at this link: BRMS Services
QSYS2.MEDIA_LIBRARY_INFO View Base Base Base SF99702 Level 9
QSYS2.SAVE_FILE_INFO View SF99950 Level 4 SF99704 Level 25 Not Supported Not Supported
QSYS2.SAVE_FILE_OBJECTS() Table function SF99950 Level 4 SF99704 Level 25 Not Supported Not Supported
QSYS2.SAVE_FILE_OBJECTS View SF99950 Level 4 SF99704 Level 25 Not Supported Not Supported
QSYS2.TAPE_CARTRIDGE_INFO View SF99950 Level 4 SF99704 Level 25 Not Supported Not Supported
Communication Services
QSYS2.ACTIVE_DB_CONNECTIONS() Table function Base
Enhanced: SF99950 Level 3
SF99704 Level 4
Enhanced: SF99704 Level 23
SF99703 Level 16 Not Supported
QSYS2.ADD_TIME_SERVER() Procedure Base Base Not Supported Not Supported
QSYS2.CHANGE_OBJECTCONNECT() Procedure SF99950 Level 3 SF99704 Level 23 Not Supported Not Supported
QSYS2.DNS_LOOKUP() Table function Base SF99704 Level 20 SF99703 Level 28 Not Supported
QSYS2.DNS_LOOKUP_IP() Scalar function SF99950 Level 4 SF99704 Level 25 Not Supported Not Supported
QSYS2.HTTP_SERVER_INFO View Base SF99704 Level 7 SF99703 Level 18 Not Supported
QSYS2.NETSTAT_INFO View Base Base Base
Enhanced: SF99703 Level 11
SF99702 Level 9
Enhanced: SF99702 Level 11
Enhanced: SF99702 Level 23
QSYS2.NETSTAT_INTERFACE_INFO View Base Base Base SF99702 Level 9
Enhanced: SF99702 Level 11
QSYS2.NETSTAT_JOB_INFO View Base Enhanced
Enhanced: SF99950 Level 5
Base
Enhanced: SF99704 Level 26
SF99703 Level 18 Base
Enhanced: SF99703 Level 11
SF99702 Level 9
Enhanced: SF99702 Level 11
Enhanced: SF99702 Level 23
QSYS2.NETSTAT_ROUTE_INFO View Base Base Base SF99702 Level 9
Enhanced: SF99702 Level 11
QSYS2.NETWORK_ATTRIBUTE_INFO View SF99950 Level 4 SF99704 Level 25 Not Supported Not Supported
QSYS2.OBJECTCONNECT_INFO View SF99950 Level 3 SF99704 Level 23 Not Supported Not Supported
QSYS2.RDB_ENTRY_INFO View SF99950 Level 4 SF99704 Level 25 Not Supported Not Supported
QSYS2.REMOVE_TIME_SERVER() Procedure Base Base Not Supported Not Supported
QSYS2.SERVER_SBS_CONFIGURATION View Base SF99704 Level 4 SF99703 Level 16 Not Supported
QSYS2.SERVER_SBS_ROUTING View Base Enhanced Base Base SF99702 Level 5
Enhanced: SF99702 Level 9
Enhanced: SF99702 Level 11
QSYS2.SET_SERVER_SBS_ROUTING() Procedure Base Enhanced Base
Enhanced:
SF99704 Level 4
Base
Enhanced: SF99703 Level 16
SF99702 Level 5
Enhanced: SF99702 Level 9
Enhanced: SF99702 Level 11
QSYS2.TCPIP_INFO View Base Base Base Base
QSYS2.TELNET_SERVER_ATTRIBUTES View Base Not Supported Not Supported Not Supported
QSYS2.TIME_PROTOCOL_INFO View Base Base Not Supported Not Supported
SYSIBMADM.ENV_SYS_INFO View Base Base Base Base
Enhanced: SF99702 Level 9
SYSTOOLS.PING Table function SF99950 Level 5 SF99704 Level 26 Not Supported Not Supported
Configuration Services
QSYS2.HARDWARE_RESOURCE_INFO() Table function SF99950 Level 3 SF99704 Level 23 Not Supported Not Supported
QSYS2.HARDWARE_RESOURCE_INFO View SF99950 Level 3 SF99704 Level 23 Not Supported Not Supported
HTTP functions
Details at this link: HTTP functions
IBM Db2 Mirror for i Services
Details at this link: Db2 Mirror Services (SQL)
IFS Services
QSYS2.IFS_JOB_INFO() Table function Base SF99704 Level 4 SF99703 Level 16 Not Supported
QSYS2.IFS_OBJECT_LOCK_INFO() Table function Base SF99704 Level 4 SF99703 Level 16 Not Supported
QSYS2.IFS_OBJECT_PRIVILEGES() Table function Base SF99704 Level 7 SF99703 Level 18 Not Supported
QSYS2.IFS_OBJECT_REFERENCES_INFO() Table function Base SF99704 Level 4 SF99703 Level 16 Not Supported
QSYS2.IFS_OBJECT_STATISTICS() Table function Base
Enhanced: SF99950 Level 4
SF99704 Level 4
Enhanced: SF99704 Level 13
SF99703 Level 16
Enhanced: SF99703 Level 24
Not Supported
QSYS2.IFS_READ() Table function Base SF99704 Level 10 SF99703 Level 22 Not Supported
QSYS2.IFS_READ_BINARY() Table function Base SF99704 Level 10 SF99703 Level 22 Not Supported
QSYS2.IFS_READ_UTF8() Table function Base SF99704 Level 10 SF99703 Level 22 Not Supported
QSYS2.IFS_WRITE() Procedure Base SF99704 Level 10 SF99703 Level 22 Not Supported
QSYS2.IFS_WRITE_BINARY() Procedure Base SF99704 Level 10 SF99703 Level 22 Not Supported
QSYS2.IFS_WRITE_UTF8() Procedure Base SF99704 Level 10 SF99703 Level 22 Not Supported
QSYS2.SERVER_SHARE_INFO View Base Enhanced SF99704 Level 10 SF99703 Level 22 Not Supported
SYSTOOLS.IFS_RENAME Scalar function SF99950 Level 5 SF99704 Level 26 Not Supported Not Supported
Java Services
QSYS2.JVM_INFO() Table function SF99950 Level 4 SF99704 Level 25 Not Supported Not Supported
QSYS2.JVM_INFO View Base
Enhanced:
SF99950 Level 4
Base
Enhanced:
SF99704 Level 25
Base SF99702 Level 5
QSYS2.SET_JVM() Procedure Base Base Base SF99702 Level 5
Journal Services
QSYS2.ASSOCIATE_JOURNAL_RECEIVER() Table function Base SF99704 Level 20 SF99703 Level 28 Not Supported
QSYS2.DISPLAY_JOURNAL() Table function Base
Enhanced: SF99950 Level 5
Base
Enhanced: SF99704 Level 7
Enhanced: SF99704 Level 10
Enhanced: SF99704 Level 13
Enhanced: SF99704 Level 15
Enhanced: SF99704 Level 26
SF99703 Level 18 Base
Enhanced: SF99703 Level 3
Enhanced: SF99703 Level 7
Enhanced: SF99703 Level 18
Enhanced: SF99703 Level 22
Enhanced: SF99703 Level 24
Enhanced: SF99703 Level 26
Base
Enhanced: SF99702 Level 11
Enhanced: SF99702 Level 14
Enhanced: SF99702 Level 19
QSYS2.JOURNAL_INFO View Base Base Base SF99702 Level 3
QSYS2.JOURNAL_RECEIVER_INFO View Base SF99704 Level 20 SF99703 Level 28 Not Supported
QSYS2.JOURNALED_OBJECTS View Base SF99704 Level 10 SF99703 Level 22 Not Supported
QSYS2.REMOTE_JOURNAL_INFO View Base SF99704 Level 20 SF99703 Level 28 Not Supported
QSYS2.SMAPP_ACCESS_PATHS View SF99950 Level 4 SF99704 Level 25 Not Supported Not Supported
SYSTOOLS Audit journal entry services Table functions Base
Enhanced: SF99950 Level 3
Enhanced: SF99950 Level 4
Enhanced: SF99950 Level 5
SF99704 Level 13
Enhanced: SF99704 Level 15
Enhanced: SF99704 Level 20
Enhanced: SF99704 Level 23
Enhanced: SF99704 Level 25
Enhanced: SF99704 Level 26
SF99703 Level 24
Enhanced: SF99703 Level 26
Enhanced: SF99703 Level 28
Not Supported
Librarian Services
QSYS2.JOURNAL_INHERIT_RULES View Base SF99704 Level 10 SF99703 Level 22 Not Supported
QSYS2.LIBRARY_INFO() Table  function Base SF99704 Level 7
Enhanced: SF99704 Level 10
SF99703 Level 18
Enhanced: SF99703 Level 22
Not Supported
QSYS2.LIBRARY_LIST_INFO View Base Base Base SF99702 Level 3
QSYS2.OBJECT_STATISTICS() Table function Base Enhanced Base
Enhanced: SF99704 Level 4
Enhanced: SF99704 Level 13
Base
Enhanced: SF99703 Level 3
Enhanced: SF99703 Level 16
Enhanced: SF99703 Level 24
Base
Enhanced: SF99702 Level 5
Enhanced: SF99702 Level 9
Enhanced: SF99702 Level 14
Message Handling Services
QSYS2.HISTORY_LOG_INFO() Table function Base
Enhanced: SF99950 Level 3
Base
Enhanced: SF99704 Level 23
SF99703 Level 3
Enhanced: SF99703 Level 7
SF99702 Level 14
Enhanced: SF99702 Level 19
QSYS2.JOBLOG_INFO() Table function Base Base  
Enhanced: SF99704 Level 20
Base
Enhanced: SF99703 Level 18
Enhanced: SF99703 Level 28
SF99702 Level 3
QSYS2.MESSAGE_FILE_DATA View Base Base SF99703 Level 15 Not Supported
QSYS2.MESSAGE_QUEUE_INFO() Table function Base SF99704 Level 13 SF99703 Level 24 Not Supported
QSYS2.MESSAGE_QUEUE_INFO View Base Base SF99703 Level 4 SF99702 Level 16
QSYS2.REPLY_LIST_INFO View Base Base Base SF99702 Level 3
QSYS2.SEND_MESSAGE() Procedure Base SF99704 Level 13 SF99703 Level 24 Not Supported
SYSTOOLS.REPLY_INQUIRY_MESSAGES Scalar function SF99950 Level 5 SF99704 Level 26 Not Supported Not Supported
Performance Services
QSYS2.COLLECTION_SERVICES_INFO View Base SF99704 Level 15 SF99703 Level 26 Not Supported
PowerHA Services
Details at this link: PowerHA Services
Product Services
QSYS2.LICENSE_INFO View Base Base Base
Enhanced: SF99703 Level 4
SF99702 Level 9
Enhanced: SF99702 Level 16
QSYS2.SOFTWARE_PRODUCT_INFO View Base SF99704 Level 10 SF99703 Level 22 Not Supported
SYSTOOLS.LICENSE_EXPIRATION_CHECK() Procedure Base Base SF99703 Level 4 SF99702 Level 16
PTF Services
QSYS2.ELECTRONIC_SERVICE_AGENT_INFO View Base SF99704 Level 20 SF99703 Level 28 Not Supported
QSYS2.GROUP_PTF_INFO View Base Base Base Base
QSYS2.PTF_INFO View Base
Enhanced: SF99950 Level 4
Enhanced: SF99950 Level 5
Base
Enhanced: SF99704 Level 25
Enhanced: SF99704 Level 26
SF99703 Level 18 Base Base
SYSTOOLS.DEFECTIVE_PTF_CURRENCY View SF99950 Level 4 SF99704 Level 25 Not Supported Not Supported
SYSTOOLS.FIRMWARE_CURRENCY View Base Base
Enhanced: SF99704 Level 13
SF99703 Level 15
Enhanced: SF99703 Level 24
Not Supported
SYSTOOLS.GROUP_PTF_CURRENCY View Base Base
Enhanced: SF99704 Level 10
Base
Enhanced: SF99703 Level 3
Enhanced: SF99703 Level 22
SF99702 Level 3
Enhanced: SF99702 Level 14
SYSTOOLS.GROUP_PTF_DETAILS View Base Base
Enhanced: SF99704 Level 10
Base
Enhanced: SF99703 Level 3
Enhanced: SF99703 Level 22
SF99702 Level 9
Enhanced: SF99702 Level 14
SYSTOOLS.PTF_COVER_LETTER Table function SF99950 Level 5 SF99704 Level 26 Not Supported Not Supported
Security Services
QSYS2.AUTHORITY_COLLECTION View Base Base Base Not Supported
QSYS2.AUTHORITY_COLLECTION_DLO View Base Base Not Supported Not Supported
QSYS2.AUTHORITY_COLLECTION_FSOBJ View Base Base Not Supported Not Supported
QSYS2.AUTHORITY_COLLECTION_LIBRARIES View Base Base Not Supported Not Supported
QSYS2.AUTHORITY_COLLECTION_OBJECT View Base Base Not Supported Not Supported
QSYS2.AUTHORIZATION_LIST_INFO View Base Base SF99703 Level 4 SF99702 Level 16
QSYS2.AUTHORIZATION_LIST_USER_INFO View Base Base SF99703 Level 4 SF99702 Level 16
QSYS2.CERTIFICATE_INFO()
 
Table function Base SF99704 Level 7
Enhanced: SF99704 Level 13
SF99703 Level 18
Enhanced: SF99703 Level 24
Not Supported
QSYS2.CHECK_PASSWORD() Table function Base Not Supported Not Supported Not Supported
QSYS2.DRDA_AUTHENTICATION_ENTRY_INFO View Base Base Base SF99702 Level 5
QSYS2.FUNCTION_INFO View Base Base Base Base
QSYS2.FUNCTION_USAGE View Base Base Base Base
QSYS2.GROUP_PROFILE_ENTRIES View Base Base Base Base
QSYS2.OBJECT_OWNERSHIP View Base SF99704 Level 4 SF99703 Level 16 Not Supported
QSYS2.OBJECT_PRIVILEGES() Table function Base SF99704 Level 7
SF99703 Level 18
Not Supported
QSYS2.OBJECT_PRIVILEGES View Base Base
Enhanced: SF99704 Level 7
SF99703 Level 4
Enhanced: SF99703 Level 15
Enhanced: SF99703 Level 16
Enhanced: SF99703 Level 18
SF99702 Level 16
QSYS2.SECURITY_INFO View Base Enhanced SF99704 Level 13
Enhanced: SF99704 Level 15
SF99703 Level 24
Enhanced: SF99703 Level 26
Not Supported
QSYS2.SQL_CHECK_AUTHORITY() Scalar function Base Base Base Base
QSYS2.SQL_CHECK_FUNCTION_USAGE() Scalar function Base SF99704 Level 20 SF99703 Level 28 Not Supported
QSYS2.SQL_CHECK_SPECIAL_AUTHORITY() Scalar function Base SF99704 Level 20 SF99703 Level 28 Not Supported
QSYS2.USER_INFO View Base Enhanced Base
Enhanced: SF99704 Level 7
Enhanced: SF99704 Level 13
Base
Enhanced: SF99703 Level 4
Enhanced: SF99703 Level 24
Base
Enhanced: SF99702 Level 16
QSYS2.USER_INFO_BASIC View Base Enhanced
Enhanced: SF99950 Level 5
SF99704 Level 13 SF99703 Level 24 Not Supported
SYSPROC.SET_COLUMN_ATTRIBUTE() Procedure Base Base Base Base
SYSTOOLS.CHANGE_USER_PROFILE() Table function Base
Enhanced: SF99950 Level 5
SF99704 Level 13
Enhanced: SF99704 Level 26
SF99703 Level 18 SF99703 Level 24 Not Supported
Spool Services
QSYS2.OUTPUT_QUEUE_ENTRIES() Table function Base
Enhanced: SF99950 Level 3
Base
Enhanced: SF99704 Level 23
Base SF99702 Level 9
QSYS2.OUTPUT_QUEUE_ENTRIES View Base
Enhanced: SF99950 Level 3
Base
Enhanced: SF99704 Level 23
Base SF99702 Level 9
QSYS2.OUTPUT_QUEUE_ENTRIES_BASIC View Base Base SF99703 Level 11 SF99702 Level 23
QSYS2.OUTPUT_QUEUE_INFO View Base
Enhanced: SF99950 Level 3
Base
Enhanced: SF99704 Level 23
Base SF99702 Level 11
QSYS2.SPOOLED_FILE_INFO() Table function Base SF99704 Level 20 SF99703 Level 28 Not Supported
SYSTOOLS.DELETE_OLD_SPOOLED_FILES() Procedure Base SF99704 Level 7 SF99703 Level 18 Not Supported
SYSTOOLS.GENERATE_PDF() Scalar function Base SF99704 Level 13
Enhanced: SF99704 Level 20
SF99703 Level 24
Enhanced: SF99703 Level 28
Not Supported
SYSTOOLS.SPOOLED_FILE_DATA() Table function Base Base SF99703 Level 15 Not Supported
Storage Services
QSYS2.ADD_DEVICE_LOCKING_POLICY Procedure SF99950 Level 3 SF99704 Level 23 Not Supported Not Supported
QSYS2.ASP_INFO View Base
Enhanced: SF99950 Level 3
Enhanced: SF99950 Level 4
Base
Enhanced: SF99704 Level 23
Enhanced: SF99704 Level 25
SF99703 Level 7
Enhanced: SF99703 Level 15
SF99702 Level 19
QSYS2.ASP_JOB_INFO View Base Base SF99703 Level 15 Not Supported
QSYS2.ASP_VARY_INFO View Base Base SF99703 Level 7 SF99702 Level 19
QSYS2.CHANGE_DEVICE_LOCKING_POLICY Procedure SF99950 Level 3 SF99704 Level 23 Not Supported Not Supported
QSYS2.CHANGE_DISK_PATHS Procedure SF99950 Level 3
Enhanced: SF99950 Level 5
SF99704 Level 23
Enhanced: SF99704 Level 26
SF99703 Level 18 Not Supported Not Supported
QSYS2.CREATE_LOCKING_POLICY Procedure SF99950 Level 3 SF99704 Level 23 Not Supported Not Supported
QSYS2.DELETE_LOCKING_POLICY Procedure SF99950 Level 3 SF99704 Level 23 Not Supported Not Supported
QSYS2.FACTORY_RESET_DEVICE Procedure SF99950 Level 3 SF99704 Level 23 Not Supported Not Supported
QSYS2.LOCKING_POLICY_INFO View SF99950 Level 3 SF99704 Level 23 Not Supported Not Supported
QSYS2.NVME_INFO View Base SF99704 Level 13
Enhanced: SF99704 Level 15
Not Supported Not Supported
QSYS2.REMOVE_DEVICE_LOCKING_POLICY Procedure SF99950 Level 3 SF99704 Level 23 Not Supported Not Supported
QSYS2.SYSDISKSTAT() Table function Base
Enhanced: SF99950 Level 3
Enhanced: SF99950 Level 4
SF99704 Level 10
Enhanced: SF99704 Level 13
Enhanced: SF99704 Level 15
Enhanced: SF99704 Level 23
Enhanced: SF99704 Level 25
SF99703 Level 22
Enhanced: SF99703 Level 24
Not Supported
QSYS2.SYSDISKSTAT View Base
Enhanced: SF99950 Level 3
Enhanced: SF99950 Level 4
Base
Enhanced: SF99704 Level 7
Enhanced: SF99704 Level 10
Enhanced: SF99704 Level 13
Enhanced: SF99704 Level 15
Enhanced: SF99704 Level 23
Enhanced: SF99704 Level 25
Base
Enhanced: SF99703 Level 22
Enhanced: SF99703 Level 24
Base
QSYS2.SYSTMPSTG View Base Base Base Base
QSYS2.UNLOCK_DEVICE Procedure SF99950 Level 3 SF99704 Level 23 Not Supported Not Supported
QSYS2.USER_STORAGE View Base Enhanced Base
Enhanced: SF99704 Level 10
Base Base
System Health Services
QSYS2.PROCESS_SYSTEM_LIMITS_ALERTS Procedure Base Base SF99703 Level 15 SF99702 Level 17
QSYS2.SYSLIMTBL Table Base Base Base
Enhanced: SF99703 Level 7
Enhanced: SF99703 Level 15
Base
Enhanced: SF99702 Level 3
Enhanced: SF99702 Level 5
Enhanced: SF99702 Level 11
Enhanced: SF99702 Level 19
QSYS2.SYSLIMITS View Base Base Base
Enhanced: SF99703 Level 7
Enhanced: SF99703 Level 15
Base
Enhanced: SF99702 Level 3
Enhanced: SF99702 Level 5
Enhanced: SF99702 Level 11
Enhanced: SF99702 Level 19
QSYS2.SYSLIMITS_BASIC View Base SF99704 Level 10 SF99703 Level 22 Not Supported
Work Management Services
QSYS2.ACTIVE_JOB_INFO() Table function Base
Enhanced: SF99950 Level 3
Base
Enhanced: SF99704 Level 7
Enhanced: SF99704 Level 10
Enhanced: SF99704 Level 13
Enhanced: SF99704 Level 15
Enhanced: SF99704 Level 20
Enhanced: SF99704 Level 23
Base
Enhanced: SF99703 Level 11
Enhanced: SF99703 Level 18
Enhanced: SF99703 Level 22
Enhanced: SF99703 Level 24
Enhanced: SF99703 Level 26
Enhanced: SF99703 Level 28
SF99702 Level 5
Enhanced: SF99702 Level 9
Enhanced: SF99702 Level 23
QSYS2.ADD_TRACKED_JOB_QUEUE Procedure SF99950 Level 3 SF99704 Level 23 Not Supported Not Supported
QSYS2.AUTOSTART_JOB_INFO View Base SF99704 Level 7 SF99703 Level 18 Not Supported
QSYS2.CLEAR_TRACKED_JOB_QUEUE Procedure SF99950 Level 3 SF99704 Level 23 Not Supported Not Supported
QSYS2.COMMUNICATIONS_ENTRY_INFO View Base SF99704 Level 10 SF99703 Level 22 Not Supported
QSYS2.GET_JOB_INFO() Table function Base Base Base
Enhanced: SF99703 Level 3
Enhanced: SF99703 Level 15
Base
Enhanced: SF99702 Level 5
Enhanced: SF99702 Level 9
Enhanced: SF99702 Level 14
QSYS2.JOB_DESCRIPTION_INFO View Base Base SF99703 Level 11 SF99702 Level 23
QSYS2.JOB_INFO() Table function Base Base
Enhanced: SF99704 Level 13
SF99703 Level 3
Enhanced: SF99703 Level 22
SF99702 Level 14
QSYS2.JOB_LOCK_INFO() Table function Base SF99704 Level 7 SF99703 Level 18 Not Supported
QSYS2.JOB_QUEUE_INFO View Base Base SF99703 Level 7 SF99702 Level 19
QSYS2.MEMORY_POOL() Table function Base Base Base SF99702 Level 9
QSYS2.MEMORY_POOL_INFO View Base Base Base SF99702 Level 9
QSYS2.OBJECT_LOCK_INFO View Base Base Base SF99702 Level 9
QSYS2.OPEN_FILES() Table function Base SF99704 Level 10 SF99703 Level 22 Not Supported
QSYS2.PRESTART_JOB_INFO View Base SF99704 Level 7 SF99703 Level 18 Not Supported
QSYS2.PRESTART_JOB_STATISTICS() Table function Base SF99704 Level 7 SF99703 Level 18 Not Supported
QSYS2.RECORD_LOCK_INFO View Base Base Base SF99702 Level 9
QSYS2.REMOVE_TRACKED_JOB_QUEUE Procedure SF99950 Level 3
Enhanced: SF99950 Level 5
SF99704 Level 23
Enhanced: SF99704 Level 26
SF99703 Level 18 Not Supported Not Supported
QSYS2.ROUTING_ENTRY_INFO View Base SF99704 Level 7 SF99703 Level 18 Not Supported
QSYS2.SCHEDULED_JOB_INFO View Base Enhanced Base Base SF99702 Level 5
QSYS2.SUBSYSTEM_INFO View Base SF99704 Level 7 SF99703 Level 18 Not Supported
QSYS2.SUBSYSTEM_POOL_INFO View Base SF99704 Level 7 SF99703 Level 18 Not Supported
QSYS2.SYSTEM_ACTIVITY_INFO() Table function Base SF99704 Level 20 SF99703 Level 28 Not Supported
QSYS2.SYSTEM_STATUS() Table function Base
Enhanced: SF99950 Level 3
Enhanced: SF99950 Level 4
Enhanced: SF99950 Level 5
Base
Enhanced: SF99704 Level 4
Enhanced: SF99704 Level 7
Enhanced: SF99704 Level 10
Enhanced: SF99704 Level 23
Enhanced: SF99704 Level 25
Enhanced: SF99704 Level 26
SF99703 Level 18 Base
Enhanced: SF99703 Level 16
Enhanced: SF99703 Level 18
Enhanced: SF99703 Level 22
SF99702 Level 9
QSYS2.SYSTEM_STATUS_INFO View Base
Enhanced: SF99950 Level 3
Enhanced: SF99950 Level 4
Enhanced: SF99950 Level 5
Base
Enhanced: SF99704 Level 4
Enhanced: SF99704 Level 7
Enhanced: SF99704 Level 10
Enhanced: SF99704 Level 23
Enhanced: SF99704 Level 25
Enhanced: SF99704 Level 26
SF99703 Level 18 Base
Enhanced: SF99703 Level 16
Enhanced: SF99703 Level 18
Enhanced: SF99703 Level 22
SF99702 Level 9
QSYS2.SYSTEM_STATUS_INFO_BASIC View Base
Enhanced: SF99950 Level 5
SF99704 Level 10
Enhanced: SF99704 Level 26
SF99703 Level 18 SF99703 Level 22
Not Supported
QSYS2.SYSTEM_VALUE_INFO View Base
Enhanced: SF99950 Level 5
Base
Enhanced: SF99704 Level 26
SF99703 Level 18 Base Base
QSYS2.TRACKED_JOB_INFO Table function SF99950 Level 3 SF99704 Level 23 Not Supported Not Supported
QSYS2.TRACKED_JOB_QUEUES View SF99950 Level 3 SF99704 Level 23 Not Supported Not Supported
QSYS2.WORKLOAD_GROUP_INFO View Base SF99704 Level 15 SF99703 Level 26 Not Supported
QSYS2.WORKSTATION_INFO View Base SF99704 Level 7 SF99703 Level 18 Not Supported
SYSTOOLS.ENDED_JOB_INFO Table function SF99950 Level 5 SF99704 Level 26 Not Supported Not Supported
SYSTOOLS.JOB_QUEUE_ENTRIES View SF99950 Level 5 SF99704 Level 26 Not Supported Not Supported

The documentation for these services can be found here:   IBM i Services

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]

Document Information

Modified date:
05 October 2023

UID

ibm11119123