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_ACTIVATIONS() | Table function | SF99960 Level 2 | SF99950 Level 11 | Not Supported | Not Supported |
| 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.EVEN() | Scalar function | SF99960 Level 2 | SF99950 Level 11 | Not Supported | Not Supported |
| SYSTOOLS.GENERATE_SPREADSHEET() | Scalar function | Base Enhanced: SF99960 Level 2 | SF99950 Level 5 Enhanced: SF99950 Level 7 Enhanced: SF99950 Level 11 | 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.ODD() | Scalar function | SF99960 Level 2 | SF99950 Level 11 | Not Supported | Not Supported |
| SYSTOOLS.OVERRIDE_INFO | View | SF99960 Level 2 | SF99950 Level 11 | Not Supported | 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.CHANGE_SERVICE_TOOLS_SERVER() | Procedure | SF99960 Level 2 | SF99950 Level 10 | SF99704 Level 31 | Not Supported |
| 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 |
| QSYS2.SFP_TRANSCEIVER_INFO | View | SF99960 Level 2 | SF99950 Level 11 | 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 Enhanced: SF99960 Level 2 | 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 | Base | SF99950 Level 4 | SF99704 Level 25 | 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_CODE_INFO | View | SF99960 Level 2 | SF99950 Level 11 | Not Supported | Not Supported |
| 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 Enhanced: SF99960 Level 2 | 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 Enhanced: SF99950 Level 11 | 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 Enhanced: SF99960 Level 2 | Base Enhanced: SF99950 Level 11 | 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 |
| Problem Management Services | |||||
| SYSTOOLS.PROBLEM_INFO | View | SF99960 Level 2 | SF99950 Level 11 | Not Supported | Not Supported |
| PTF Services | |||||
| QSYS2.ELECTRONIC_SERVICE_AGENT_INFO | View | Base | Base | SF99704 Level 20 | SF99703 Level 28 |
| QSYS2.GROUP_PTF_INFO | View | Base Enhanced: SF99960 Level 2 | 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 Enhanced: SF99960 Level 2 | 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 Enhanced: SF99960 Level 2 | Base Enhanced: SF99950 Level 11 | Base | Base |
| QSYS2.AUTHORITY_COLLECTION_DLO | View | Base Enhanced: SF99960 Level 2 | Base Enhanced: SF99950 Level 11 | Base | Not Supported |
| QSYS2.AUTHORITY_COLLECTION_FSOBJ | View | Base Enhanced: SF99960 Level 2 | Base Enhanced: SF99950 Level 11 | Base | Not Supported |
| QSYS2.AUTHORITY_COLLECTION_IFS | View | Base | SF99950 Level 9 | Not Supported | Not Supported |
| QSYS2.AUTHORITY_COLLECTION_LIBRARIES | View | Base Enhanced: SF99960 Level 2 | Base Enhanced: SF99950 Level 11 | Base | Not Supported |
| QSYS2.AUTHORITY_COLLECTION_OBJECT | View | Base Enhanced: SF99960 Level 2 | Base Enhanced: SF99950 Level 11 | 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.CERTIFICATE_USAGE_INFO | View | SF99960 Level 2 | SF99950 Level 11 | Not Supported | Not Supported |
| 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 |
| SYSTOOLS.USER_DRDA_AUTHENTICATION_ENTRIES() | Table function | SF99960 Level 2 | SF99950 Level 11 | Not Supported | 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 Enhanced: SF99950 Level 11 | Base Enhanced: SF99704 Level 23 Enhanced: SF99704 Level 25 Enhanced: SF99704 Level 31 | 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 Enhanced: SF99960 Level 2 | 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 Enhanced: SF99960 Level 2 | Base Enhanced: SF99950 Level 11 | 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 Enhanced: SF99960 Level 2 | Base Enhanced: SF99950 Level 11 | 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"}}]
Was this topic helpful?
Document Information
Modified date:
07 October 2025
UID
ibm11119123