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.6 IBM i 7.5 IBM i 7.4 IBM i 7.3
Application Services
QSYS2.ACTIVATION_GROUP_INFO() Table function Base Base SF99704 Level 20 SF99703 Level 28
QSYS2.ADD_USER_INDEX_ENTRY() Procedure Base Base SF99704 Level 20 Not Supported
QSYS2.ADD_USER_INDEX_ENTRY_BINARY() Procedure Base Base SF99704 Level 20 Not Supported
QSYS2.BINDING_DIRECTORY_INFO View Base Base SF99704 Level 20 SF99703 Level 28
QSYS2.BOUND_MODULE_INFO View Base Base SF99704 Level 4 SF99703 Level 16
QSYS2.BOUND_SRVPGM_INFO View Base Base SF99704 Level 4 SF99703 Level 16
QSYS2.CHANGE_USER_SPACE() Procedure Base Base SF99704 Level 20 Not Supported
QSYS2.CHANGE_USER_SPACE_BINARY() Procedure Base Base SF99704 Level 20 Not Supported
QSYS2.CHANGE_USER_SPACE_ATTRIBUTES() Procedure Base Base SF99704 Level 20 Not Supported
QSYS2.CLEAR_DATA_QUEUE() Procedure Base Base SF99704 Level 4 SF99703 Level 16
QSYS2.COMMAND_INFO View Base SF99950 Level 3 SF99704 Level 23 Not Supported
QSYS2.CREATE_USER_INDEX() Procedure Base Base SF99704 Level 20 Not Supported
QSYS2.CREATE_USER_SPACE() Procedure Base Base SF99704 Level 20 Not Supported
QSYS2.DATA_AREA_INFO() Table function Base Base Base SF99703 Level 15
QSYS2.DATA_AREA_INFO View Base Base Base SF99703 Level 15
QSYS2.DATA_QUEUE_ENTRIES() Table function Base Base SF99704 Level 10 SF99703 Level 22
QSYS2.DATA_QUEUE_INFO View Base Base SF99704 Level 4 SF99703 Level 16
QSYS2.DB_TRANSACTION_INFO View Base Base
Enhanced: SF99950 Level 5
SF99704 Level 7
Enhanced: SF99704 Level 10
Enhanced: SF99704 Level 26
SF99703 Level 18
Enhanced: SF99703 Level 22
QSYS2.DB_TRANSACTION_JOURNAL_INFO Table function Base SF99950 Level 5 SF99704 Level 26 Not Supported
QSYS2.DB_TRANSACTION_OBJECT_INFO Table function Base SF99950 Level 7 SF99704 Level 28 Not Supported
QSYS2.DB_TRANSACTION_RECORD_INFO Table function Base SF99950 Level 7 SF99704 Level 28 Not Supported
QSYS2.ENVIRONMENT_VARIABLE_INFO View Base Base Base Base
QSYS2.EXIT_POINT_INFO View Base Base SF99704 Level 10 SF99703 Level 22
QSYS2.EXIT_PROGRAM_INFO View Base Base SF99704 Level 10 SF99703 Level 22
QSYS2.PROGRAM_EXPORT_IMPORT_INFO View Base Base SF99704 Level 4 SF99703 Level 16
QSYS2.PROGRAM_RESOLVED_IMPORTS Table function Base Not Supported Not Supported Not Supported
QSYS2.PROGRAM_INFO View Base Base
Enhanced: SF99950 Level 4
SF99704 Level 4
Enhanced: SF99704 Level 25
SF99703 Level 16
QSYS2.QCMDEXC() Procedure Base Base Base Base
QSYS2.QCMDEXC() Scalar function Base Base SF99704 Level 13 SF99703 Level 24
QSYS2.RECEIVE_DATA_QUEUE() Table function Base Base SF99704 Level 4 SF99703 Level 16
QSYS2.REMOVE_USER_INDEX_ENTRY() Table function Base Base SF99704 Level 20 Not Supported
QSYS2.REMOVE_USER_INDEX_ENTRY_BINARY() Table function Base Base SF99704 Level 20 Not Supported
QSYS2.SEND_DATA_QUEUE() Procedure Base Base SF99704 Level 4 SF99703 Level 16
QSYS2.SEND_DATA_QUEUE_BINARY() Procedure Base Base SF99704 Level 4 SF99703 Level 16
QSYS2.SEND_DATA_QUEUE_UTF8() Procedure Base Base SF99704 Level 4 SF99703 Level 16
QSYS2.SERVICES_INFO Table Base Base Base Base
QSYS2.SET_PASE_SHELL_INFO() Procedure Base Base Base SF99703 Level 4
QSYS2.STACK_INFO() Table function Base Base
Enhanced: SF99950 Level 4
Base
Enhanced: SF99704 Level 25
SF99703 Level 7
QSYS2.USER_INDEX_ENTRIES() Table function Base Base SF99704 Level 13 SF99703 Level 24
QSYS2.USER_INDEX_INFO View Base Base SF99704 Level 13 SF99703 Level 24
QSYS2.USER_SPACE() Table function Base Base SF99704 Level 13 SF99703 Level 24
QSYS2.USER_SPACE_INFO View Base Base SF99704 Level 13 SF99703 Level 24
QSYS2.VERIFY_NAME Scalar function Base SF99950 Level 9 Not Supported Not Supported
QSYS2.WATCH_DETAIL() Table function Base Base SF99704 Level 10 SF99703 Level 22
QSYS2.WATCH_INFO View Base Base SF99704 Level 10 SF99703 Level 22
SYSTOOLS.ERRNO_INFO Scalar function Base SF99950 Level 7 SF99704 Level 28 Not Supported
SYSTOOLS.GENERATE_SPREADSHEET Scalar function Base SF99950 Level 5
Enhanced: SF99950 Level 7
SF99704 Level 26
Enhanced: SF99704 Level 28
Not Supported
SYSTOOLS.GETENV Scalar function Base SF99950 Level 7 SF99704 Level 28 Not Supported
SYSTOOLS.LPRINTF() Procedure Base Base
Enhanced: SF99950 Level 5
Enhanced: SF99950 Level 8
SF99704 Level 4
Enhanced: SF99704 Level 26
Enhanced: SF99704 Level 29
Not Supported
SYSTOOLS.PUTENV Scalar function Base SF99950 Level 7 SF99704 Level 28 Not Supported
SYSTOOLS.SEND_EMAIL Scalar function Base SF99950 Level 5
Enhanced: SF99950 Level 7
Enhanced: SF99950 Level 8
SF99704 Level 26
Enhanced: SF99704 Level 28
Enhanced: SF99704 Level 29
Not Supported
SYSTOOLS.SPLIT() Table function Base Base Base
Enhanced: SF99704 Level 10
SF99703 Level 15
Enhanced: SF99703 Level 22
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 Base
QSYS2.SAVE_FILE_INFO View Base SF99950 Level 4 SF99704 Level 25 Not Supported
QSYS2.SAVE_FILE_OBJECTS() Table function Base SF99950 Level 4 SF99704 Level 25 Not Supported
QSYS2.SAVE_FILE_OBJECTS View Base SF99950 Level 4 SF99704 Level 25 Not Supported
QSYS2.TAPE_CARTRIDGE_INFO View Base SF99950 Level 4 SF99704 Level 25 Not Supported
Communication Services
QSYS2.ACTIVE_DB_CONNECTIONS() Table function Base Base
Enhanced: SF99950 Level 3
SF99704 Level 4
Enhanced: SF99704 Level 23
SF99703 Level 16
QSYS2.ADD_TIME_SERVER() Procedure Base Base Base Not Supported
QSYS2.CHANGE_OBJECTCONNECT() Procedure Base SF99950 Level 3 SF99704 Level 23 Not Supported
QSYS2.DNS_LOOKUP() Table function Base Base SF99704 Level 20 SF99703 Level 28
QSYS2.DNS_LOOKUP_IP() Scalar function Base SF99950 Level 4 SF99704 Level 25 Not Supported
QSYS2.HTTP_SERVER_INFO View Base Base SF99704 Level 7 SF99703 Level 18
QSYS2.NETSTAT_INFO View Base Base Base Base
Enhanced: SF99703 Level 11
QSYS2.NETSTAT_INTERFACE_INFO View Base Base Base Base
QSYS2.NETSTAT_JOB_INFO View Base Base Enhanced
Enhanced: SF99950 Level 5
Base
Enhanced: SF99704 Level 26
Base
Enhanced: SF99703 Level 11
QSYS2.NETSTAT_ROUTE_INFO View Base Base Base Base
QSYS2.NETWORK_ATTRIBUTE_INFO View Base SF99950 Level 4 SF99704 Level 25 Not Supported
QSYS2.OBJECTCONNECT_INFO View Base SF99950 Level 3 SF99704 Level 23 Not Supported
QSYS2.RDB_ENTRY_INFO View Base SF99950 Level 4 SF99704 Level 25 Not Supported
QSYS2.REMOVE_TIME_SERVER() Procedure Base Base Base Not Supported
QSYS2.SERVER_SBS_CONFIGURATION View Base Base SF99704 Level 4 SF99703 Level 16
QSYS2.SERVER_SBS_ROUTING View Base Enhanced Base Enhanced Base Base
QSYS2.SET_SERVER_SBS_ROUTING() Procedure Base Enhanced Base Enhanced Base
Enhanced:
SF99704 Level 4
Base
Enhanced: SF99703 Level 16
QSYS2.TCPIP_INFO View Base Base Base Base
QSYS2.TELNET_SERVER_ATTRIBUTES View Base Base Not Supported Not Supported
QSYS2.TIME_PROTOCOL_INFO View Base Base Base Not Supported
SYSIBMADM.ENV_SYS_INFO View Base Base Base Base
SYSTOOLS.PING Table function Base SF99950 Level 5 SF99704 Level 26 Not Supported
Configuration Services
QSYS2.ADD_ISCSI_TARGET Procedure Base Base Base Base
QSYS2.CHANGE_IOP Procedure Base Base Base Base
QSYS2.CHANGE_ISCSI_TARGET Procedure Base Base Base Base
QSYS2.HARDWARE_RESOURCE_INFO() Table function Base SF99950 Level 3 SF99704 Level 23 Not Supported
QSYS2.HARDWARE_RESOURCE_INFO View Base SF99950 Level 3 SF99704 Level 23 Not Supported
QSYS2.ISCSI_INFO View Base Base Base Base
QSYS2.REMOVE_ISCSI_TARGET Procedure Base Base Base Base
QSYS2.SERVICE_TOOLS_SERVER_INFO View Base SF99950 Level 8 SF99704 Level 29 Not Supported
SYSTOOLS.CONFIGURATION_STATUS View Base SF99950 Level 8 SF99704 Level 29 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.COMPARE_IFS() Table function Base SF99950 Level 7
Enhanced: SF99950 Level 8
SF99704 Level 28
Enhanced: SF99704 Level 29
Not Supported
QSYS2.IFS_JOB_INFO() Table function Base Base SF99704 Level 4 SF99703 Level 16
QSYS2.IFS_OBJECT_LOCK_INFO() Table function Base Base SF99704 Level 4 SF99703 Level 16
QSYS2.IFS_OBJECT_PRIVILEGES() Table function Base Base SF99704 Level 7 SF99703 Level 18
QSYS2.IFS_OBJECT_REFERENCES_INFO() Table function Base Base SF99704 Level 4 SF99703 Level 16
QSYS2.IFS_OBJECT_STATISTICS() Table function Base Base
Enhanced: SF99950 Level 4
SF99704 Level 4
Enhanced: SF99704 Level 13
SF99703 Level 16
Enhanced: SF99703 Level 24
QSYS2.IFS_READ() Table function Base Base SF99704 Level 10 SF99703 Level 22
QSYS2.IFS_READ_BINARY() Table function Base Base SF99704 Level 10 SF99703 Level 22
QSYS2.IFS_READ_UTF8() Table function Base Base SF99704 Level 10 SF99703 Level 22
QSYS2.IFS_WRITE() Procedure Base Base SF99704 Level 10 SF99703 Level 22
QSYS2.IFS_WRITE_BINARY() Procedure Base Base SF99704 Level 10 SF99703 Level 22
QSYS2.IFS_WRITE_UTF8() Procedure Base Base SF99704 Level 10 SF99703 Level 22
QSYS2.SERVER_SHARE_INFO View Base Base Enhanced SF99704 Level 10 SF99703 Level 22
SYSTOOLS.IFS_ACCESS Scalar function Base SF99950 Level 8 SF99704 Level 29 Not Supported
SYSTOOLS.IFS_PATH Scalar function Base SF99950 Level 9 Not Supported Not Supported
SYSTOOLS.IFS_RENAME Scalar function Base SF99950 Level 5 SF99704 Level 26 Not Supported
SYSTOOLS.IFS_UNLINK Scalar function Base SF99950 Level 7 SF99704 Level 28 Not Supported
Java Services
QSYS2.JVM_INFO() Table function SF99950 Level 4 SF99704 Level 25 Not Supported Not Supported
QSYS2.JVM_INFO View Base Base
Enhanced:
SF99950 Level 4
Base
Enhanced:
SF99704 Level 25
Base
QSYS2.SET_JVM() Procedure Base Base Base Base
Journal Services
QSYS2.ASSOCIATE_JOURNAL_RECEIVER() Table function Base Base SF99704 Level 20 SF99703 Level 28
QSYS2.AUDIT_JOURNAL_DATA_MART_INFO View Base SF99950 Level 7
Enhanced: SF99950 Level 8
SF99704 Level 28
Enhanced: SF99704 Level 29
Not Supported
QSYS2.DISPLAY_JOURNAL() Table function Base 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
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
QSYS2.JOURNAL_INFO View Base Base Base Base
QSYS2.JOURNAL_RECEIVER_INFO View Base Base SF99704 Level 20 SF99703 Level 28
QSYS2.JOURNALED_OBJECTS View Base Base SF99704 Level 10 SF99703 Level 22
QSYS2.MANAGE_AUDIT_JOURNAL_DATA_MART Procedure Base SF99950 Level 7
Enhanced: SF99950 Level 8
SF99704 Level 28
Enhanced: SF99704 Level 29
Not Supported
QSYS2.REMOTE_JOURNAL_INFO View Base Base SF99704 Level 20 SF99703 Level 28
QSYS2.SMAPP_ACCESS_PATHS View Base SF99950 Level 4 SF99704 Level 25 Not Supported
SYSTOOLS Audit journal entry services Table functions Base Enhanced Base
Enhanced: SF99950 Level 3
Enhanced: SF99950 Level 4
Enhanced: SF99950 Level 5
Enhanced: SF99950 Level 7
Enhanced: SF99950 Level 8
Enhanced: SF99950 Level 9
SF99704 Level 13
Enhanced: SF99704 Level 15
Enhanced: SF99704 Level 20
Enhanced: SF99704 Level 23
Enhanced: SF99704 Level 25
Enhanced: SF99704 Level 26
Enhanced: SF99704 Level 28
Enhanced: SF99704 Level 29
SF99703 Level 24
Enhanced: SF99703 Level 26
Enhanced: SF99703 Level 28
SYSTOOLS.DELETE_OLD_JOURNAL_RECEIVERS Procedure Base SF99950 Level 9 Not Supported Not Supported
Librarian Services
QSYS2.JOURNAL_INHERIT_RULES View Base Base SF99704 Level 10 SF99703 Level 22
QSYS2.LIBRARY_INFO() Table  function Base Base SF99704 Level 7
Enhanced: SF99704 Level 10
SF99703 Level 18
Enhanced: SF99703 Level 22
QSYS2.LIBRARY_LIST_INFO View Base Base Base Base
QSYS2.OBJECT_STATISTICS() Table function Base Base Enhanced Base
Enhanced: SF99704 Level 4
Enhanced: SF99704 Level 13
Base
Enhanced: SF99703 Level 3
Enhanced: SF99703 Level 16
Enhanced: SF99703 Level 24
QSYS2.SYSTEM_OBJECT_TYPES Table Base SF99950 Level 7 SF99704 Level 28 Not Supported
Message Handling Services
QSYS2.HISTORY_LOG_INFO() Table function Base Base
Enhanced: SF99950 Level 3
Base
Enhanced: SF99704 Level 23
SF99703 Level 3
Enhanced: SF99703 Level 7
QSYS2.JOBLOG_INFO() Table function Base Base
Enhanced: SF99950 Level 8
Base  
Enhanced: SF99704 Level 20
Enhanced: SF99704 Level 29
Base
Enhanced: SF99703 Level 18
Enhanced: SF99703 Level 28
QSYS2.MESSAGE_FILE_DATA View Base Base Base SF99703 Level 15
QSYS2.MESSAGE_QUEUE_INFO() Table function Base Base SF99704 Level 13 SF99703 Level 24
QSYS2.MESSAGE_QUEUE_INFO View Base Base Base SF99703 Level 4
QSYS2.REPLY_LIST_INFO View Base Base Base Base
QSYS2.SEND_MESSAGE() Procedure Base Base SF99704 Level 13 SF99703 Level 24
SYSTOOLS.REPLY_INQUIRY_MESSAGES Scalar function Base SF99950 Level 5 SF99704 Level 26 Not Supported
Performance Services
QSYS2.COLLECTION_SERVICES_INFO View Base Base SF99704 Level 15 SF99703 Level 26
PowerHA Services
Details at this link: PowerHA Services
Product Services
QSYS2.LICENSE_INFO View Base Base Base Base
Enhanced: SF99703 Level 4
QSYS2.SOFTWARE_PRODUCT_INFO View Base Base SF99704 Level 10 SF99703 Level 22
SYSTOOLS.CHECK_PRODUCT_OPTIONS Table function Base SF99950 Level 7 SF99704 Level 28 Not Supported
SYSTOOLS.LICENSE_EXPIRATION_CHECK() Procedure Base Base Base SF99703 Level 4
PTF Services
QSYS2.ELECTRONIC_SERVICE_AGENT_INFO View Base Base SF99704 Level 20 SF99703 Level 28
QSYS2.GROUP_PTF_INFO View Base Base Base Base
QSYS2.PTF_INFO View Base Base
Enhanced: SF99950 Level 4
Enhanced: SF99950 Level 5
Base
Enhanced: SF99704 Level 25
Enhanced: SF99704 Level 26
Base
SYSTOOLS.DEFECTIVE_PTF_CURRENCY View Base SF99950 Level 4 SF99704 Level 25 Not Supported
SYSTOOLS.FIRMWARE_CURRENCY View Base Base
Enhanced: SF99950 Level 8
Base
Enhanced: SF99704 Level 13
Enhanced: SF99704 Level 29
SF99703 Level 15
Enhanced: SF99703 Level 24
SYSTOOLS.GROUP_PTF_CURRENCY View Base Base Base
Enhanced: SF99704 Level 10
Base
Enhanced: SF99703 Level 3
Enhanced: SF99703 Level 22
SYSTOOLS.GROUP_PTF_DETAILS View Base Enhanced Base
Enhanced: SF99950 Level 9
Base
Enhanced: SF99704 Level 10
Enhanced: SF99704 Level 30
Base
Enhanced: SF99703 Level 3
Enhanced: SF99703 Level 22
SYSTOOLS.PTF_COVER_LETTER Table function Base SF99950 Level 5 SF99704 Level 26 Not Supported
Security Services
QSYS2.AUTHORITY_COLLECTION View Base Base Base Base
QSYS2.AUTHORITY_COLLECTION_DLO View Base Base Base Not Supported
QSYS2.AUTHORITY_COLLECTION_FSOBJ View Base Base Base Not Supported
QSYS2.AUTHORITY_COLLECTION_IFS View Base SF99950 Level 9 Not Supported Not Supported
QSYS2.AUTHORITY_COLLECTION_LIBRARIES View Base Base Base Not Supported
QSYS2.AUTHORITY_COLLECTION_OBJECT View Base Base Base Not Supported
QSYS2.AUTHORIZATION_LIST_INFO View Base Base Base SF99703 Level 4
QSYS2.AUTHORIZATION_LIST_USER_INFO View Base Base Base SF99703 Level 4
QSYS2.CERTIFICATE_INFO()
 
Table function Base Base SF99704 Level 7
Enhanced: SF99704 Level 13
SF99703 Level 18
Enhanced: SF99703 Level 24
QSYS2.CHANGE_TOTP_KEY() Table function Base Not Supported Not Supported Not Supported
QSYS2.CHECK_PASSWORD() Table function Base Base Not Supported Not Supported
QSYS2.CHECK_TOTP() Scalar function Base Not Supported Not Supported Not Supported
QSYS2.DRDA_AUTHENTICATION_ENTRY_INFO View Base Base Base Base
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.KERBEROS_KEYTAB_ENTRIES Table function Base Not Supported Not Supported Not Supported
QSYS2.OBJECT_OWNERSHIP View Base Base SF99704 Level 4 SF99703 Level 16
QSYS2.OBJECT_PRIVILEGES() Table function Base Base SF99704 Level 7
SF99703 Level 18
QSYS2.OBJECT_PRIVILEGES View Base Base Base
Enhanced: SF99704 Level 7
SF99703 Level 4
Enhanced: SF99703 Level 15
Enhanced: SF99703 Level 16
Enhanced: SF99703 Level 18
QSYS2.SECURITY_INFO View Base Enhanced Base Enhanced SF99704 Level 13
Enhanced: SF99704 Level 15
SF99703 Level 24
Enhanced: SF99703 Level 26
QSYS2.SQL_CHECK_AUTHORITY() Scalar function Base Base Base Base
QSYS2.SQL_CHECK_FUNCTION_USAGE() Scalar function Base Base SF99704 Level 20 SF99703 Level 28
QSYS2.SQL_CHECK_SPECIAL_AUTHORITY() Scalar function Base Base SF99704 Level 20 SF99703 Level 28
QSYS2.USER_INFO View Base Enhanced Base Enhanced Base
Enhanced: SF99704 Level 7
Enhanced: SF99704 Level 13
Base
Enhanced: SF99703 Level 4
Enhanced: SF99703 Level 24
QSYS2.USER_INFO_BASIC View Base Enhanced Base Enhanced
Enhanced: SF99950 Level 5
SF99704 Level 13 SF99703 Level 24
SYSPROC.SET_COLUMN_ATTRIBUTE() Procedure Base Base Base Base
SYSTOOLS.ADD_VALIDATION_LIST_ENTRY() Scalar function Base SF99950 Level 8 SF99704 Level 29 Not Supported
SYSTOOLS.CHANGE_USER_PROFILE() Table function Base Base
Enhanced: SF99950 Level 5
SF99704 Level 13
Enhanced: SF99704 Level 26
SF99703 Level 24
SYSTOOLS.CHANGE_VALIDATION_LIST_ENTRY() Scalar function Base SF99950 Level 8 SF99704 Level 29 Not Supported
SYSTOOLS.REMOVE_VALIDATION_LIST_ENTRY() Scalar function Base SF99950 Level 8 SF99704 Level 29 Not Supported
SYSTOOLS.SPECIAL_AUTHORITY_DATA_MART Table Base SF99950 Level 7 SF99704 Level 28 Not Supported
Spool Services
QSYS2.OUTPUT_QUEUE_ENTRIES() Table function Base Base
Enhanced: SF99950 Level 3
Base
Enhanced: SF99704 Level 23
Base
QSYS2.OUTPUT_QUEUE_ENTRIES View Base Base
Enhanced: SF99950 Level 3
Base
Enhanced: SF99704 Level 23
Base
QSYS2.OUTPUT_QUEUE_ENTRIES_BASIC View Base Base Base SF99703 Level 11
QSYS2.OUTPUT_QUEUE_INFO View Base Base
Enhanced: SF99950 Level 3
Base
Enhanced: SF99704 Level 23
Base
QSYS2.SPOOLED_FILE_INFO() Table function Base Base SF99704 Level 20 SF99703 Level 28
SYSTOOLS.DELETE_OLD_SPOOLED_FILES() Procedure Base Base SF99704 Level 7 SF99703 Level 18
SYSTOOLS.GENERATE_PDF() Scalar function Base Base SF99704 Level 13
Enhanced: SF99704 Level 20
SF99703 Level 24
Enhanced: SF99703 Level 28
SYSTOOLS.PRINTER_FILE_INFO View Base SF99950 Level 7 SF99704 Level 28 Not Supported
SYSTOOLS.SPOOLED_FILE_DATA() Table function Base Base Base SF99703 Level 15
Storage Services
QSYS2.ADD_DEVICE_LOCKING_POLICY Procedure Base SF99950 Level 3 SF99704 Level 23 Not Supported
QSYS2.ASP_INFO View Base 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
QSYS2.ASP_JOB_INFO View Base Base Base SF99703 Level 15
QSYS2.ASP_VARY_INFO View Base Base Base SF99703 Level 7
QSYS2.CHANGE_DEVICE_LOCKING_POLICY Procedure Base SF99950 Level 3 SF99704 Level 23 Not Supported
QSYS2.CHANGE_DISK_PATHS Procedure Base SF99950 Level 3
Enhanced: SF99950 Level 5
SF99704 Level 23
Enhanced: SF99704 Level 26
SF99703 Level 18
QSYS2.CREATE_LOCKING_POLICY Procedure Base SF99950 Level 3 SF99704 Level 23 Not Supported
QSYS2.DELETE_LOCKING_POLICY Procedure Base SF99950 Level 3 SF99704 Level 23 Not Supported
QSYS2.FACTORY_RESET_DEVICE Procedure Base SF99950 Level 3 SF99704 Level 23 Not Supported
QSYS2.LOCKING_POLICY_INFO View Base SF99950 Level 3 SF99704 Level 23 Not Supported
QSYS2.NVME_INFO View Base Base SF99704 Level 13
Enhanced: SF99704 Level 15
Not Supported
QSYS2.REMOVE_DEVICE_LOCKING_POLICY Procedure Base SF99950 Level 3 SF99704 Level 23 Not Supported
QSYS2.SYSDISKSTAT() Table function Base Enhanced Base
Enhanced: SF99950 Level 3
Enhanced: SF99950 Level 4
Enhanced: SF99950 Level 7
Enhanced: SF99950 Level 9
SF99704 Level 10
Enhanced: SF99704 Level 13
Enhanced: SF99704 Level 15
Enhanced: SF99704 Level 23
Enhanced: SF99704 Level 25
Enhanced: SF99704 Level 28
Enhanced: SF99704 Level 30
SF99703 Level 22
Enhanced: SF99703 Level 24
QSYS2.SYSDISKSTAT View Base Enhanced Base
Enhanced: SF99950 Level 3
Enhanced: SF99950 Level 4
Enhanced: SF99950 Level 7
Enhanced: SF99950 Level 9
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
Enhanced: SF99704 Level 28
Enhanced: SF99704 Level 30
Base
Enhanced: SF99703 Level 22
Enhanced: SF99703 Level 24
QSYS2.SYSTMPSTG View Base Base Base Base
QSYS2.UNLOCK_DEVICE Procedure Base SF99950 Level 3 SF99704 Level 23 Not Supported
QSYS2.USER_STORAGE View Base Base Enhanced Base
Enhanced: SF99704 Level 10
Base
System Health Services
System limits Base Enhanced Base
Enhanced: SF99950 Level 5
Enhanced: SF99950 Level 8
Base Enhanced
Enhanced: SF99704 Level 15
Enhanced: SF99704 Level 26
Enhanced: SF99704 Level 29
Base
Enhanced: SF99703 Level 15
Enhanced: SF99703 Level 26
QSYS2.PROCESS_SYSTEM_LIMITS_ALERTS Procedure Base Base Base SF99703 Level 15
QSYS2.SYSLIMTBL Table Base Base Base Base
Enhanced: SF99703 Level 7
Enhanced: SF99703 Level 15
QSYS2.SYSLIMITS View Base Base Base Base
Enhanced: SF99703 Level 7
Enhanced: SF99703 Level 15
QSYS2.SYSLIMITS_BASIC View Base Base SF99704 Level 10 SF99703 Level 22
Work Management Services
QSYS2.ACTIVE_JOB_INFO() Table function Base Enhanced Base
Enhanced: SF99950 Level 3
Enhanced: SF99950 Level 8
Enhanced: SF99950 Level 9
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
Enhanced: SF99704 Level 29
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
QSYS2.ADD_TRACKED_JOB_QUEUE Procedure Base SF99950 Level 3 SF99704 Level 23 Not Supported
QSYS2.AUTOSTART_JOB_INFO View Base Base SF99704 Level 7 SF99703 Level 18
QSYS2.CLEAR_TRACKED_JOB_QUEUE Procedure Base SF99950 Level 3
Enhanced: SF99950 Level 7
SF99704 Level 23
Enhanced: SF99704 Level 28
Not Supported
QSYS2.COMMUNICATIONS_ENTRY_INFO View Base Base SF99704 Level 10 SF99703 Level 22
QSYS2.GET_JOB_INFO() Table function Base Base Base Base
Enhanced: SF99703 Level 3
Enhanced: SF99703 Level 15
QSYS2.JOB_DESCRIPTION_INFO View Base Base Base SF99703 Level 11
QSYS2.JOB_INFO() Table function Base Enhanced Base
Enhanced: SF99950 Level 9
Base
Enhanced: SF99704 Level 13
Enhanced: SF99704 Level 30
SF99703 Level 3
Enhanced: SF99703 Level 22
QSYS2.JOB_LOCK_INFO() Table function Base Base SF99704 Level 7 SF99703 Level 18
QSYS2.JOB_QUEUE_INFO View Base Base Base SF99703 Level 7
QSYS2.MEMORY_POOL() Table function Base Base Base Base
QSYS2.MEMORY_POOL_INFO View Base Base Base Base
QSYS2.OBJECT_LOCK_INFO View Base Base Base Base
QSYS2.OPEN_FILES() Table function Base Base SF99704 Level 10 SF99703 Level 22
QSYS2.PRESTART_JOB_INFO View Base Base SF99704 Level 7 SF99703 Level 18
QSYS2.PRESTART_JOB_STATISTICS() Table function Base Base SF99704 Level 7 SF99703 Level 18
QSYS2.RECORD_LOCK_INFO View Base Base Base Base
QSYS2.REMOVE_TRACKED_JOB_QUEUE Procedure Base SF99950 Level 3
Enhanced: SF99950 Level 5
SF99704 Level 23
Enhanced: SF99704 Level 26
SF99703 Level 18
QSYS2.ROUTING_ENTRY_INFO View Base Base SF99704 Level 7 SF99703 Level 18
QSYS2.SCHEDULED_JOB_INFO View Base Base Enhanced Base Base
QSYS2.SUBSYSTEM_INFO View Base Base SF99704 Level 7 SF99703 Level 18
QSYS2.SUBSYSTEM_POOL_INFO View Base Base SF99704 Level 7 SF99703 Level 18
QSYS2.SYSTEM_ACTIVITY_INFO() Table function Base Base SF99704 Level 20 SF99703 Level 28
QSYS2.SYSTEM_STATUS() Table function Base Base
Enhanced: SF99950 Level 3
Enhanced: SF99950 Level 4
Enhanced: SF99950 Level 5
Enhanced: SF99950 Level 8
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
Enhanced: SF99704 Level 29
Base
Enhanced: SF99703 Level 16
Enhanced: SF99703 Level 18
Enhanced: SF99703 Level 22
QSYS2.SYSTEM_STATUS_INFO View Base Base
Enhanced: SF99950 Level 3
Enhanced: SF99950 Level 4
Enhanced: SF99950 Level 5
Enhanced: SF99950 Level 8
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
Enhanced: SF99704 Level 29
Base
Enhanced: SF99703 Level 16
Enhanced: SF99703 Level 18
Enhanced: SF99703 Level 22
QSYS2.SYSTEM_STATUS_INFO_BASIC View Base Base
Enhanced: SF99950 Level 5
Enhanced: SF99950 Level 8
SF99704 Level 10
Enhanced: SF99704 Level 26
Enhanced: SF99704 Level 29
SF99703 Level 22
QSYS2.SYSTEM_VALUE_INFO View Base Base
Enhanced: SF99950 Level 5
Base
Enhanced: SF99704 Level 26
Base
QSYS2.TRACKED_JOB_INFO Table function Base SF99950 Level 3 SF99704 Level 23 Not Supported
QSYS2.TRACKED_JOB_QUEUES View Base SF99950 Level 3 SF99704 Level 23 Not Supported
QSYS2.WORKLOAD_GROUP_INFO View Base Base SF99704 Level 15 SF99703 Level 26
QSYS2.WORKSTATION_INFO View Base Base SF99704 Level 7 SF99703 Level 18
SYSTOOLS.END_JOBS Procedure Base SF99950 Level 8 SF99704 Level 29 Not Supported
SYSTOOLS.ENDED_JOB_INFO Table function Base SF99950 Level 5 SF99704 Level 26 Not Supported
SYSTOOLS.JOB_QUEUE_ENTRIES View Base SF99950 Level 5 SF99704 Level 26 Not Supported
SYSTOOLS.POWER_SCHEDULE_INFO View Base Enhanced SF99950 Level 8
Enhanced: SF99950 Level 9
SF99704 Level 29 Not Supported

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

[{"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB68","label":"Power HW"}}]

Document Information

Modified date:
08 April 2025

UID

ibm11119123