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 ServiceIBM i 7.6IBM i 7.5IBM i 7.4IBM i 7.3
Application Services
QSYS2.ACTIVATION_GROUP_INFO()Table functionBaseBaseSF99704 Level 20SF99703 Level 28
QSYS2.ADD_USER_INDEX_ENTRY()ProcedureBaseBaseSF99704 Level 20Not Supported
QSYS2.ADD_USER_INDEX_ENTRY_BINARY()ProcedureBaseBaseSF99704 Level 20Not Supported
QSYS2.BINDING_DIRECTORY_INFOViewBaseBaseSF99704 Level 20SF99703 Level 28
QSYS2.BOUND_MODULE_INFOViewBaseBaseSF99704 Level 4SF99703 Level 16
QSYS2.BOUND_SRVPGM_INFOViewBaseBaseSF99704 Level 4SF99703 Level 16
QSYS2.CHANGE_USER_SPACE()ProcedureBaseBaseSF99704 Level 20Not Supported
QSYS2.CHANGE_USER_SPACE_BINARY()ProcedureBaseBaseSF99704 Level 20Not Supported
QSYS2.CHANGE_USER_SPACE_ATTRIBUTES()ProcedureBaseBaseSF99704 Level 20Not Supported
QSYS2.CLEAR_DATA_QUEUE()ProcedureBaseBaseSF99704 Level 4SF99703 Level 16
QSYS2.COMMAND_INFOViewBaseSF99950 Level 3SF99704 Level 23Not Supported
QSYS2.CREATE_USER_INDEX()ProcedureBaseBaseSF99704 Level 20Not Supported
QSYS2.CREATE_USER_SPACE()ProcedureBaseBaseSF99704 Level 20Not Supported
QSYS2.DATA_AREA_INFO()Table functionBaseBaseBaseSF99703 Level 15
QSYS2.DATA_AREA_INFOViewBaseBaseBaseSF99703 Level 15
QSYS2.DATA_QUEUE_ENTRIES()Table functionBaseBaseSF99704 Level 10SF99703 Level 22
QSYS2.DATA_QUEUE_INFOViewBaseBaseSF99704 Level 4SF99703 Level 16
QSYS2.DB_TRANSACTION_INFOViewBase

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_INFOTable functionBaseSF99950 Level 5SF99704 Level 26Not Supported
QSYS2.DB_TRANSACTION_OBJECT_INFOTable functionBaseSF99950 Level 7SF99704 Level 28Not Supported
QSYS2.DB_TRANSACTION_RECORD_INFOTable functionBaseSF99950 Level 7SF99704 Level 28Not Supported
QSYS2.ENVIRONMENT_VARIABLE_INFOViewBaseBaseBaseBase
QSYS2.EXIT_POINT_INFOViewBaseBaseSF99704 Level 10SF99703 Level 22
QSYS2.EXIT_PROGRAM_INFOViewBaseBaseSF99704 Level 10SF99703 Level 22
QSYS2.PROGRAM_EXPORT_IMPORT_INFOViewBaseBaseSF99704 Level 4SF99703 Level 16
QSYS2.PROGRAM_RESOLVED_ACTIVATIONS()Table functionSF99960 Level 2SF99950 Level 11Not SupportedNot Supported
QSYS2.PROGRAM_RESOLVED_IMPORTSTable functionBaseNot SupportedNot SupportedNot Supported
QSYS2.PROGRAM_INFOViewBase

Base

 

Enhanced: SF99950 Level 4

SF99704 Level 4

 

Enhanced: SF99704 Level 25

SF99703 Level 16
QSYS2.QCMDEXC()ProcedureBaseBaseBaseBase
QSYS2.QCMDEXC()Scalar function

Base

 

Enhanced: SF99960 Level 3

Base

 

Enhanced: SF99950 Level 12

SF99704 Level 13SF99703 Level 24
QSYS2.RECEIVE_DATA_QUEUE()Table functionBaseBaseSF99704 Level 4SF99703 Level 16
QSYS2.REMOVE_USER_INDEX_ENTRY()Table functionBaseBaseSF99704 Level 20Not Supported
QSYS2.REMOVE_USER_INDEX_ENTRY_BINARY()Table functionBaseBaseSF99704 Level 20Not Supported
QSYS2.SEND_DATA_QUEUE()ProcedureBaseBaseSF99704 Level 4SF99703 Level 16
QSYS2.SEND_DATA_QUEUE_BINARY()ProcedureBaseBaseSF99704 Level 4SF99703 Level 16
QSYS2.SEND_DATA_QUEUE_UTF8()ProcedureBaseBaseSF99704 Level 4SF99703 Level 16
QSYS2.SERVICES_INFOTableBaseBaseBaseBase
QSYS2.SET_PASE_SHELL_INFO()ProcedureBaseBaseBaseSF99703 Level 4
QSYS2.STACK_INFO()Table functionBase

Base

 

Enhanced: SF99950 Level 4

Base

 

Enhanced: SF99704 Level 25

SF99703 Level 7
QSYS2.USER_INDEX_ENTRIES()Table functionBaseBaseSF99704 Level 13SF99703 Level 24
QSYS2.USER_INDEX_INFOViewBaseBaseSF99704 Level 13SF99703 Level 24
QSYS2.USER_SPACE()Table functionBaseBaseSF99704 Level 13SF99703 Level 24
QSYS2.USER_SPACE_INFOViewBaseBaseSF99704 Level 13SF99703 Level 24
QSYS2.VERIFY_NAME()Scalar functionBaseSF99950 Level 9Not SupportedNot Supported
QSYS2.WATCH_DETAIL()Table functionBaseBaseSF99704 Level 10SF99703 Level 22
QSYS2.WATCH_INFOViewBaseBaseSF99704 Level 10SF99703 Level 22
SYSTOOLS.CHECK_COMMAND_SYNTAX()Scalar functionSF99960 Level 3SF99950 Level 12Not SupportedNot Supported
SYSTOOLS.ERRNO_INFO()Scalar functionBaseSF99950 Level 7SF99704 Level 28Not Supported
SYSTOOLS.EVEN() Scalar functionSF99960 Level 2SF99950 Level 11Not SupportedNot Supported
SYSTOOLS.GENERATE_SPREADSHEET()Scalar function

Base

 

Enhanced: SF99960 Level 2

 

Enhanced: SF99960 Level 3

SF99950 Level 5

 

Enhanced: SF99950 Level 7

 

Enhanced: SF99950 Level 11

 

Enhanced: SF99950 Level 12

SF99704 Level 26

 

Enhanced: SF99704 Level 28

Not Supported
SYSTOOLS.GETENV()Scalar functionBaseSF99950 Level 7SF99704 Level 28Not Supported
SYSTOOLS.LPRINTF()ProcedureBase

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 functionSF99960 Level 2SF99950 Level 11Not SupportedNot Supported
SYSTOOLS.OVERRIDE_INFOViewSF99960 Level 2SF99950 Level 11Not SupportedNot Supported
SYSTOOLS.OVERRIDE_INFO_ALLViewSF99960 Level 3SF99950 Level 12Not SupportedNot Supported
SYSTOOLS.PUTENV()Scalar functionBaseSF99950 Level 7SF99704 Level 28Not Supported
SYSTOOLS.SEND_EMAIL()Scalar functionBase

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 functionBaseBase

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_INFOViewBaseBaseBaseBase
QSYS2.SAVE_FILE_INFOViewBaseSF99950 Level 4SF99704 Level 25Not Supported
QSYS2.SAVE_FILE_OBJECTS()Table functionBaseSF99950 Level 4SF99704 Level 25Not Supported
QSYS2.SAVE_FILE_OBJECTSViewBaseSF99950 Level 4SF99704 Level 25Not Supported
QSYS2.TAPE_CARTRIDGE_INFOViewBaseSF99950 Level 4SF99704 Level 25Not Supported
Communication Services
QSYS2.ACTIVE_DB_CONNECTIONS()Table functionBase

Base

 

Enhanced: SF99950 Level 3

SF99704 Level 4

 

Enhanced: SF99704 Level 23

SF99703 Level 16
QSYS2.ADD_TIME_SERVER()ProcedureBaseBaseBaseNot Supported
QSYS2.CHANGE_OBJECTCONNECT()ProcedureBaseSF99950 Level 3SF99704 Level 23Not Supported
QSYS2.DNS_LOOKUP()Table functionBaseBaseSF99704 Level 20SF99703 Level 28
QSYS2.DNS_LOOKUP_IP()Scalar functionBaseSF99950 Level 4SF99704 Level 25Not Supported
QSYS2.HTTP_SERVER_INFOViewBaseBaseSF99704 Level 7SF99703 Level 18
QSYS2.NETSTAT_INFOViewBaseBaseBase

Base

 

Enhanced: SF99703 Level 11

QSYS2.NETSTAT_INTERFACE_INFOViewBaseBaseBaseBase
QSYS2.NETSTAT_JOB_INFOViewBase

Base Enhanced

 

Enhanced: SF99950 Level 5

Base

 

Enhanced: SF99704 Level 26

Base

 

Enhanced: SF99703 Level 11

QSYS2.NETSTAT_ROUTE_INFOViewBaseBaseBaseBase
QSYS2.NETWORK_ATTRIBUTE_INFOViewBaseSF99950 Level 4SF99704 Level 25Not Supported
QSYS2.OBJECTCONNECT_INFOViewBaseSF99950 Level 3SF99704 Level 23Not Supported
QSYS2.RDB_ENTRY_INFOViewBaseSF99950 Level 4SF99704 Level 25Not Supported
QSYS2.REMOVE_TIME_SERVER() ProcedureBaseBaseBaseNot Supported
QSYS2.SERVER_SBS_CONFIGURATIONViewBaseBaseSF99704 Level 4SF99703 Level 16
QSYS2.SERVER_SBS_ROUTINGViewBase EnhancedBase EnhancedBaseBase
QSYS2.SET_SERVER_SBS_ROUTING()ProcedureBase EnhancedBase Enhanced

Base

 

Enhanced:
SF99704 Level 4

Base

 

Enhanced: SF99703 Level 16

QSYS2.TCPIP_INFOViewBaseBaseBaseBase
QSYS2.TELNET_SERVER_ATTRIBUTESViewBaseBaseNot SupportedNot Supported
QSYS2.TIME_PROTOCOL_INFO ViewBaseBaseBaseNot Supported
SYSIBMADM.ENV_SYS_INFOViewBaseBaseBaseBase
SYSTOOLS.PING()Table functionBaseSF99950 Level 5SF99704 Level 26Not Supported
Configuration Services
QSYS2.ADD_ISCSI_TARGET()ProcedureBaseBaseBaseBase
QSYS2.ADD_SERVICE_TOOLS_SERVER_CONFIGURATION_ENTRY()ProcedureSF99960 Level 3Not SupportedNot SupportedNot Supported
QSYS2.CHANGE_IOP()ProcedureBaseBaseBaseBase
QSYS2.CHANGE_ISCSI_TARGET()ProcedureBaseBaseBaseBase
QSYS2.CHANGE_SERVICE_TOOLS_SERVER()ProcedureSF99960 Level 2SF99950 Level 10SF99704 Level 31Not Supported
QSYS2.CHANGE_SERVICE_TOOLS_SERVER_CONFIGURATION_ENTRY()ProcedureSF99960 Level 3Not SupportedNot SupportedNot Supported
QSYS2.EKM_INFO()Table functionSF99960 Level 3Not SupportedNot SupportedNot Supported
QSYS2.HARDWARE_RESOURCE_INFO()Table functionBaseSF99950 Level 3SF99704 Level 23Not Supported
QSYS2.HARDWARE_RESOURCE_INFOViewBaseSF99950 Level 3SF99704 Level 23Not Supported
QSYS2.ISCSI_INFOViewBaseBaseBaseBase
QSYS2.REMOVE_ISCSI_TARGET()ProcedureBaseBaseBaseBase
QSYS2.REMOVE_SERVICE_TOOLS_SERVER_CONFIGURATION_ENTRY()ProcedureSF99960 Level 3Not SupportedNot SupportedNot Supported
QSYS2.SERVICE_TOOLS_SERVER_CONFIGURATION_ENTRY_INFOViewSF99960 Level 3Not SupportedNot SupportedNot Supported
QSYS2.SERVICE_TOOLS_SERVER_INFOViewBaseSF99950 Level 8SF99704 Level 29Not Supported
QSYS2.SFP_TRANSCEIVER_INFOViewSF99960 Level 2SF99950 Level 11SF99704 Level 29Not Supported
SYSTOOLS.CONFIGURATION_STATUSViewBaseSF99950 Level 8SF99704 Level 29Not 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 functionBase

SF99950 Level 7

 

Enhanced: SF99950 Level 8

SF99704 Level 28

 

Enhanced: SF99704 Level 29

Not Supported
QSYS2.IFS_JOB_INFO()Table functionBaseBaseSF99704 Level 4SF99703 Level 16
QSYS2.IFS_OBJECT_LOCK_INFO()Table functionBaseBaseSF99704 Level 4SF99703 Level 16
QSYS2.IFS_OBJECT_PRIVILEGES()Table functionBaseBaseSF99704 Level 7SF99703 Level 18
QSYS2.IFS_OBJECT_REFERENCES_INFO()Table functionBaseBaseSF99704 Level 4SF99703 Level 16
QSYS2.IFS_OBJECT_STATISTICS()Table functionBase

Base

 

Enhanced: SF99950 Level 4

SF99704 Level 4

 

Enhanced: SF99704 Level 13

SF99703 Level 16

 

Enhanced: SF99703 Level 24

QSYS2.IFS_READ()Table functionBaseBaseSF99704 Level 10SF99703 Level 22
QSYS2.IFS_READ_BINARY()Table functionBaseBaseSF99704 Level 10SF99703 Level 22
QSYS2.IFS_READ_UTF8()Table functionBaseBaseSF99704 Level 10SF99703 Level 22
QSYS2.IFS_WRITE()ProcedureBaseBaseSF99704 Level 10SF99703 Level 22
QSYS2.IFS_WRITE_BINARY()ProcedureBaseBaseSF99704 Level 10SF99703 Level 22
QSYS2.IFS_WRITE_UTF8()ProcedureBaseBaseSF99704 Level 10SF99703 Level 22
QSYS2.SERVER_SHARE_INFOView

Base

 

Enhanced: SF99960 Level 2

Base EnhancedSF99704 Level 10SF99703 Level 22
SYSTOOLS.IFS_ACCESS()Scalar functionBaseSF99950 Level 8SF99704 Level 29Not Supported
SYSTOOLS.IFS_PATH()Scalar functionBaseSF99950 Level 9Not SupportedNot Supported
SYSTOOLS.IFS_RENAME()Scalar functionBaseSF99950 Level 5SF99704 Level 26Not Supported
SYSTOOLS.IFS_UNLINK()Scalar functionBaseSF99950 Level 7SF99704 Level 28Not Supported
Java Services
QSYS2.JVM_INFO()Table functionBaseSF99950 Level 4SF99704 Level 25Not Supported
QSYS2.JVM_INFOViewBase

Base

 

Enhanced:
SF99950 Level 4

Base

 

Enhanced:
SF99704 Level 25

Base
QSYS2.SET_JVM()ProcedureBaseBaseBaseBase
Journal Services
QSYS2.ASSOCIATE_JOURNAL_RECEIVER()Table functionBaseBaseSF99704 Level 20SF99703 Level 28
QSYS2.AUDIT_JOURNAL_DATA_MART_INFOViewBase

SF99950 Level 7

 

Enhanced: SF99950 Level 8

SF99704 Level 28

 

Enhanced: SF99704 Level 29

Not Supported
QSYS2.CREATE_DATA_JOURNAL_READER()Table functionSF99960 Level 3SF99950 Level 12Not SupportedNot Supported
QSYS2.DISPLAY_JOURNAL()Table functionBase

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_INFOViewSF99960 Level 2SF99950 Level 11Not SupportedNot Supported
QSYS2.JOURNAL_INFOViewBaseBaseBaseBase
QSYS2.JOURNAL_RECEIVER_INFOViewBaseBaseSF99704 Level 20SF99703 Level 28
QSYS2.JOURNALED_OBJECTSViewBaseBaseSF99704 Level 10SF99703 Level 22
QSYS2.MANAGE_AUDIT_JOURNAL_DATA_MART()ProcedureBase

SF99950 Level 7

 

Enhanced: SF99950 Level 8

SF99704 Level 28

 

Enhanced: SF99704 Level 29

Not Supported
QSYS2.REMOTE_JOURNAL_INFOViewBaseBaseSF99704 Level 20SF99703 Level 28
QSYS2.SMAPP_ACCESS_PATHSViewBaseSF99950 Level 4SF99704 Level 25Not Supported
SYSTOOLS Audit journal entry servicesTable functions

Base Enhanced

 

Enhanced: SF99960 Level 2

 

Enhanced: SF99960 Level 3

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

 

Enhanced: SF99950 Level 12

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()ProcedureBaseSF99950 Level 9Not SupportedNot Supported
Librarian Services
QSYS2.JOURNAL_INHERIT_RULESViewBaseBaseSF99704 Level 10SF99703 Level 22
QSYS2.LIBRARY_INFO()Table  functionBaseBase

SF99704 Level 7

 

Enhanced: SF99704 Level 10

SF99703 Level 18

 

Enhanced: SF99703 Level 22

QSYS2.LIBRARY_LIST_INFOViewBaseBaseBaseBase
QSYS2.OBJECT_STATISTICS()Table functionBaseBase 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_TYPESTableBaseSF99950 Level 7SF99704 Level 28Not Supported
Message Handling Services
QSYS2.HISTORY_LOG_INFO()Table functionBase

Base

 

Enhanced: SF99950 Level 3

Base

 

Enhanced: SF99704 Level 23

SF99703 Level 3

 

Enhanced: SF99703 Level 7

QSYS2.JOBLOG_INFO()Table function

Base

 

Enhanced: SF99960 Level 3

Base

 

Enhanced: SF99950 Level 8

 

Enhanced: SF99950 Level 12

Base  

 

Enhanced: SF99704 Level 20

 

Enhanced: SF99704 Level 29

Base

 

Enhanced: SF99703 Level 18

 

Enhanced: SF99703 Level 28

QSYS2.MESSAGE_FILE_DATAViewBaseBaseBaseSF99703 Level 15
QSYS2.MESSAGE_QUEUE_INFO()Table functionBaseBaseSF99704 Level 13SF99703 Level 24
QSYS2.MESSAGE_QUEUE_INFOViewBaseBaseBaseSF99703 Level 4
QSYS2.REPLY_LIST_INFOViewBaseBaseBaseBase
QSYS2.SEND_MESSAGE()Procedure

Base

 

Enhanced: SF99960 Level 2

Base

 

Enhanced: SF99950 Level 11

SF99704 Level 13SF99703 Level 24
SYSTOOLS.REPLY_INQUIRY_MESSAGES()Scalar functionBaseSF99950 Level 5SF99704 Level 26Not Supported
Performance Services
QSYS2.COLLECTION_SERVICES_INFOViewBaseBaseSF99704 Level 15SF99703 Level 26
PowerHA Services
Details at this link: PowerHA Services     
Product Services
QSYS2.LICENSE_INFOViewBaseBaseBase

Base

 

Enhanced: SF99703 Level 4

QSYS2.SOFTWARE_PRODUCT_INFOViewBaseBaseSF99704 Level 10SF99703 Level 22
SYSTOOLS.CHECK_PRODUCT_OPTIONS()Table functionBaseSF99950 Level 7SF99704 Level 28Not Supported
SYSTOOLS.LICENSE_EXPIRATION_CHECK()ProcedureBaseBaseBaseSF99703 Level 4
Problem Management Services
SYSTOOLS.PROBLEM_INFOViewSF99960 Level 2SF99950 Level 11Not SupportedNot Supported
PTF Services
QSYS2.ELECTRONIC_SERVICE_AGENT_INFOViewBaseBaseSF99704 Level 20SF99703 Level 28
QSYS2.GROUP_PTF_INFOView

Base

 

Enhanced: SF99960 Level 2

BaseBaseBase
QSYS2.PTF_INFOViewBase

Base

 

Enhanced: SF99950 Level 4

 

Enhanced: SF99950 Level 5

Base

 

Enhanced: SF99704 Level 25

 

Enhanced: SF99704 Level 26

Base
SYSTOOLS.DEFECTIVE_PTF_CURRENCYViewBaseSF99950 Level 4SF99704 Level 25Not Supported
SYSTOOLS.FIRMWARE_CURRENCYViewBase

Base

 

Enhanced: SF99950 Level 8

Base

 

Enhanced: SF99704 Level 13

 

Enhanced: SF99704 Level 29

SF99703 Level 15

 

Enhanced: SF99703 Level 24

SYSTOOLS.GROUP_PTF_CURRENCYView

Base

 

Enhanced: SF99960 Level 2

Base

Base

 

Enhanced: SF99704 Level 10

Base

 

Enhanced: SF99703 Level 3

 

Enhanced: SF99703 Level 22

SYSTOOLS.GROUP_PTF_CURRENCY_LOCAL()Table functionSF99960 Level 3SF99950 Level 12Not SupportedNot Supported
SYSTOOLS.GROUP_PTF_DETAILSViewBase 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 functionBaseSF99950 Level 5SF99704 Level 26Not Supported
Security Services
QSYS2.AUTHORITY_COLLECTIONView

Base

 

Enhanced: SF99960 Level 2

Base

 

Enhanced: SF99950 Level 11

BaseBase
QSYS2.AUTHORITY_COLLECTION_DLOView

Base

 

Enhanced: SF99960 Level 2

Base

 

Enhanced: SF99950 Level 11

BaseNot Supported
QSYS2.AUTHORITY_COLLECTION_FSOBJView

Base

 

Enhanced: SF99960 Level 2

Base

 

Enhanced: SF99950 Level 11

BaseNot Supported
QSYS2.AUTHORITY_COLLECTION_IFSViewBaseSF99950 Level 9Not SupportedNot Supported
QSYS2.AUTHORITY_COLLECTION_LIBRARIESView

Base

 

Enhanced: SF99960 Level 2

Base

 

Enhanced: SF99950 Level 11

BaseNot Supported
QSYS2.AUTHORITY_COLLECTION_OBJECTView

Base

 

Enhanced: SF99960 Level 2

Base

 

Enhanced: SF99950 Level 11

BaseNot Supported
QSYS2.AUTHORIZATION_LIST_INFOViewBaseBaseBaseSF99703 Level 4
QSYS2.AUTHORIZATION_LIST_USER_INFOViewBaseBaseBaseSF99703 Level 4
QSYS2.CERTIFICATE_INFO()
 		Table functionBaseBase

SF99704 Level 7

 

Enhanced: SF99704 Level 13

SF99703 Level 18

 

Enhanced: SF99703 Level 24

QSYS2.CERTIFICATE_USAGE_INFOViewSF99960 Level 2SF99950 Level 11Not SupportedNot Supported
QSYS2.CHANGE_TOTP_KEY()Table functionBaseNot SupportedNot SupportedNot Supported
QSYS2.CHECK_PASSWORD()Table functionBaseBaseNot SupportedNot Supported
QSYS2.CHECK_TOTP()Scalar functionBaseNot SupportedNot SupportedNot Supported
QSYS2.DRDA_AUTHENTICATION_ENTRY_INFOViewBaseBaseBaseBase
QSYS2.FUNCTION_INFOViewBaseBaseBaseBase
QSYS2.FUNCTION_USAGEViewBaseBaseBaseBase
QSYS2.GROUP_PROFILE_ENTRIESViewBaseBaseBaseBase
QSYS2.KERBEROS_KEYTAB_ENTRIES()Table functionBaseNot SupportedNot SupportedNot Supported
QSYS2.OBJECT_OWNERSHIPViewBaseBaseSF99704 Level 4SF99703 Level 16
QSYS2.OBJECT_PRIVILEGES()Table functionBaseBaseSF99704 Level 7
 

SF99703 Level 18

QSYS2.OBJECT_PRIVILEGESViewBaseBase

Base

 

Enhanced: SF99704 Level 7

SF99703 Level 4

 

Enhanced: SF99703 Level 15

 

Enhanced: SF99703 Level 16

 

Enhanced: SF99703 Level 18

QSYS2.SECURITY_INFOViewBase EnhancedBase Enhanced

SF99704 Level 13

 

Enhanced: SF99704 Level 15

SF99703 Level 24

 

Enhanced: SF99703 Level 26

QSYS2.SQL_CHECK_AUTHORITY()Scalar functionBaseBaseBaseBase
QSYS2.SQL_CHECK_FUNCTION_USAGE()Scalar functionBaseBaseSF99704 Level 20SF99703 Level 28
QSYS2.SQL_CHECK_SPECIAL_AUTHORITY()Scalar functionBaseBaseSF99704 Level 20SF99703 Level 28
QSYS2.USER_INFOViewBase EnhancedBase Enhanced

Base

 

Enhanced: SF99704 Level 7

 

Enhanced: SF99704 Level 13

Base

 

Enhanced: SF99703 Level 4

 

Enhanced: SF99703 Level 24

QSYS2.USER_INFO_BASICViewBase Enhanced

Base Enhanced

 

Enhanced: SF99950 Level 5

SF99704 Level 13SF99703 Level 24
SYSPROC.SET_COLUMN_ATTRIBUTE()ProcedureBaseBaseBaseBase
SYSTOOLS.ADD_VALIDATION_LIST_ENTRY()Scalar functionBaseSF99950 Level 8SF99704 Level 29Not Supported
SYSTOOLS.CHANGE_USER_PROFILE()Table functionBase

Base

 

Enhanced: SF99950 Level 5

SF99704 Level 13

 

Enhanced: SF99704 Level 26

SF99703 Level 24
SYSTOOLS.CHANGE_VALIDATION_LIST_ENTRY()Scalar functionBaseSF99950 Level 8SF99704 Level 29Not Supported
SYSTOOLS.CVE_INFO()Table functionSF99960 Level 3SF99950 Level 12Not SupportedNot Supported
SYSTOOLS.REMOVE_VALIDATION_LIST_ENTRY()Scalar functionBaseSF99950 Level 8SF99704 Level 29Not Supported
SYSTOOLS.SPECIAL_AUTHORITY_DATA_MARTTableBaseSF99950 Level 7SF99704 Level 28Not Supported
SYSTOOLS.USER_DRDA_AUTHENTICATION_ENTRIES()Table functionSF99960 Level 2SF99950 Level 11Not SupportedNot Supported
Spool Services
QSYS2.OUTPUT_QUEUE_ENTRIES()Table functionBase

Base

 

Enhanced: SF99950 Level 3

Base

 

Enhanced: SF99704 Level 23

Base
QSYS2.OUTPUT_QUEUE_ENTRIESViewBase

Base

 

Enhanced: SF99950 Level 3

Base

 

Enhanced: SF99704 Level 23

Base
QSYS2.OUTPUT_QUEUE_ENTRIES_BASICViewBaseBaseBaseSF99703 Level 11
QSYS2.OUTPUT_QUEUE_INFOViewBase

Base

 

Enhanced: SF99950 Level 3

Base

 

Enhanced: SF99704 Level 23

Base
QSYS2.SPOOLED_FILE_INFO()Table functionBaseBaseSF99704 Level 20SF99703 Level 28
SYSTOOLS.DELETE_OLD_SPOOLED_FILES()ProcedureBaseBaseSF99704 Level 7SF99703 Level 18
SYSTOOLS.GENERATE_PDF()Scalar functionBaseBase

SF99704 Level 13

 

Enhanced: SF99704 Level 20

SF99703 Level 24

 

Enhanced: SF99703 Level 28

 
SYSTOOLS.PRINTER_FILE_INFOViewBaseSF99950 Level 7SF99704 Level 28Not Supported
SYSTOOLS.SPOOLED_FILE_DATA()Table functionBaseBaseBaseSF99703 Level 15
Storage Services
QSYS2.ADD_DEVICE_LOCKING_POLICY()ProcedureBaseSF99950 Level 3SF99704 Level 23Not Supported
QSYS2.ASP_INFOView

Base

 

Enhanced: SF99960 Level 3

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_INFOViewBaseBaseBaseSF99703 Level 15
QSYS2.ASP_VARY_INFOViewBaseBaseBaseSF99703 Level 7
QSYS2.CHANGE_DEVICE_LOCKING_POLICY()ProcedureBaseSF99950 Level 3SF99704 Level 23Not 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()ProcedureBaseSF99950 Level 3SF99704 Level 23Not Supported
QSYS2.DELETE_LOCKING_POLICY()ProcedureBaseSF99950 Level 3SF99704 Level 23Not Supported
QSYS2.FACTORY_RESET_DEVICE()ProcedureBaseSF99950 Level 3SF99704 Level 23Not Supported
QSYS2.GEOGRAPHIC_MIRRORING_INFOViewSF99960 Level 3SF99950 Level 12Not SupportedNot Supported
QSYS2.LOCKING_POLICY_INFOViewBaseSF99950 Level 3SF99704 Level 23Not Supported
QSYS2.NVME_INFOViewBaseBase

SF99704 Level 13

 

Enhanced: SF99704 Level 15

Not Supported
QSYS2.REMOVE_DEVICE_LOCKING_POLICY()ProcedureBaseSF99950 Level 3SF99704 Level 23Not Supported
QSYS2.SYSDISKSTAT()Table function

Base Enhanced

 

Enhanced: SF99960 Level 3

Base

 

Enhanced: SF99950 Level 3

 

Enhanced: SF99950 Level 4

 

Enhanced: SF99950 Level 7

 

Enhanced: SF99950 Level 9

 

Enhanced: SF99950 Level 12

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.SYSDISKSTATView

Base Enhanced

 

Enhanced: SF99960 Level 3

Base

 

Enhanced: SF99950 Level 3

 

Enhanced: SF99950 Level 4

 

Enhanced: SF99950 Level 7

 

Enhanced: SF99950 Level 9

 

Enhanced: SF99950 Level 12

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.SYSTMPSTGViewBaseBaseBaseBase
QSYS2.UNLOCK_DEVICE()ProcedureBaseSF99950 Level 3SF99704 Level 23Not Supported
QSYS2.USER_STORAGEViewBaseBase 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()ProcedureBaseBaseBaseSF99703 Level 15
QSYS2.SYSLIMTBLTableBaseBaseBase

Base

 

Enhanced: SF99703 Level 7

 

Enhanced: SF99703 Level 15

QSYS2.SYSLIMITSViewBaseBaseBase

Base

 

Enhanced: SF99703 Level 7

 

Enhanced: SF99703 Level 15

QSYS2.SYSLIMITS_BASICViewBaseBaseSF99704 Level 10SF99703 Level 22
Work Management Services
QSYS2.ACTIVE_JOB_INFO()Table functionBase 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()ProcedureBaseSF99950 Level 3SF99704 Level 23Not Supported
QSYS2.AUTOSTART_JOB_INFOViewBaseBaseSF99704 Level 7SF99703 Level 18
QSYS2.CLEAR_TRACKED_JOB_QUEUE()ProcedureBase

SF99950 Level 3

 

Enhanced: SF99950 Level 7

SF99704 Level 23

 

Enhanced: SF99704 Level 28

Not Supported
QSYS2.COMMUNICATIONS_ENTRY_INFOViewBaseBaseSF99704 Level 10SF99703 Level 22
QSYS2.GET_JOB_INFO()Table functionBaseBaseBase

Base

 

Enhanced: SF99703 Level 3

 

Enhanced: SF99703 Level 15

QSYS2.JOB_DESCRIPTION_INFOViewBaseBaseBaseSF99703 Level 11
QSYS2.JOB_INFO()Table functionBase 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 functionBaseBaseSF99704 Level 7SF99703 Level 18
QSYS2.JOB_QUEUE_INFOViewBaseBaseBaseSF99703 Level 7
QSYS2.MEMORY_POOL()Table functionBaseBaseBaseBase
QSYS2.MEMORY_POOL_INFOViewBaseBaseBaseBase
QSYS2.OBJECT_LOCK_INFOView

Base

 

Enhanced: SF99960 Level 2

Base

 

Enhanced: SF99950 Level 11

BaseBase
QSYS2.OPEN_FILES()Table functionBaseBaseSF99704 Level 10SF99703 Level 22
QSYS2.PRESTART_JOB_INFOViewBaseBaseSF99704 Level 7SF99703 Level 18
QSYS2.PRESTART_JOB_STATISTICS()Table functionBaseBaseSF99704 Level 7SF99703 Level 18
QSYS2.RECORD_LOCK_INFOView

Base

 

Enhanced: SF99960 Level 2

Base

 

Enhanced: SF99950 Level 11

BaseBase
QSYS2.REMOVE_TRACKED_JOB_QUEUE()ProcedureBase

SF99950 Level 3

 

Enhanced: SF99950 Level 5

SF99704 Level 23

 

Enhanced: SF99704 Level 26

SF99703 Level 18
QSYS2.ROUTING_ENTRY_INFOViewBaseBaseSF99704 Level 7SF99703 Level 18
QSYS2.SCHEDULED_JOB_INFOView

Base

 

Enhanced: SF99960 Level 3

Base Enhanced

 

Enhanced: SF99950 Level 12

BaseBase
QSYS2.SUBSYSTEM_INFOViewBaseBaseSF99704 Level 7SF99703 Level 18
QSYS2.SUBSYSTEM_POOL_INFOViewBaseBaseSF99704 Level 7SF99703 Level 18
QSYS2.SYSTEM_ACTIVITY_INFO()Table functionBaseBaseSF99704 Level 20SF99703 Level 28
QSYS2.SYSTEM_STATUS()Table function

Base

 

Enhanced: SF99960 Level 3

Base

 

Enhanced: SF99950 Level 3

 

Enhanced: SF99950 Level 4

 

Enhanced: SF99950 Level 5

 

Enhanced: SF99950 Level 8

 

Enhanced: SF99950 Level 12

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_INFOView

Base

 

Enhanced: SF99960 Level 3

Base

 

Enhanced: SF99950 Level 3

 

Enhanced: SF99950 Level 4

 

Enhanced: SF99950 Level 5

 

Enhanced: SF99950 Level 8

 

Enhanced: SF99950 Level 12

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_BASICView

Base

 

Enhanced: SF99960 Level 3

Base

 

Enhanced: SF99950 Level 5

 

Enhanced: SF99950 Level 8

 

Enhanced: SF99950 Level 12

SF99704 Level 10

 

Enhanced: SF99704 Level 26

 

Enhanced: SF99704 Level 29

SF99703 Level 22

 
QSYS2.SYSTEM_VALUE_INFOViewBase

Base

 

Enhanced: SF99950 Level 5

Base

 

Enhanced: SF99704 Level 26

Base
QSYS2.TRACKED_JOB_INFO()Table functionBaseSF99950 Level 3SF99704 Level 23Not Supported
QSYS2.TRACKED_JOB_QUEUESViewBaseSF99950 Level 3SF99704 Level 23Not Supported
QSYS2.WORKLOAD_GROUP_INFOViewBaseBaseSF99704 Level 15SF99703 Level 26
QSYS2.WORKSTATION_INFOViewBaseBaseSF99704 Level 7SF99703 Level 18
SYSTOOLS.END_JOBS()ProcedureBaseSF99950 Level 8SF99704 Level 29Not Supported
SYSTOOLS.ENDED_JOB_INFO()Table functionBaseSF99950 Level 5SF99704 Level 26Not Supported
SYSTOOLS.JOB_NAME()Scalar functionSF99960 Level 3SF99950 Level 12Not SupportedNot Supported
SYSTOOLS.JOB_NAME_DETAILS()Table functionSF99960 Level 3SF99950 Level 12Not SupportedNot Supported
SYSTOOLS.JOB_NUMBER()Scalar functionSF99960 Level 3SF99950 Level 12Not SupportedNot Supported
SYSTOOLS.JOB_QUEUE_ENTRIESViewBaseSF99950 Level 5SF99704 Level 26Not Supported
SYSTOOLS.JOB_USER()Scalar functionSF99960 Level 3SF99950 Level 12Not SupportedNot Supported
SYSTOOLS.POWER_SCHEDULE_INFOViewBase Enhanced

SF99950 Level 8

 

Enhanced: SF99950 Level 9

SF99704 Level 29Not 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:
29 June 2026

UID

ibm11119123

Page Feedback