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.4 IBM i 7.3
IBM i 7.2
Application Services
QSYS2.BOUND_MODULE_INFO View SF99704 Level 4 SF99703 Level 16 Not Supported
QSYS2.BOUND_SRVPGM_INFO View SF99704 Level 4 SF99703 Level 16 Not Supported
QSYS2.CLEAR_DATA_QUEUE() Procedure SF99704 Level 4 SF99703 Level 16 Not Supported
QSYS2.DATA_AREA_INFO() Table function Base SF99703 Level 15 Not Supported
QSYS2.DATA_AREA_INFO View Base SF99703 Level 15 Not Supported
QSYS2.DATA_QUEUE_INFO View SF99704 Level 4 SF99703 Level 16 Not Supported
QSYS2.DB_TRANSACTION_INFO View SF99704 Level 7 SF99703 Level 18 Not Supported
QSYS2.ENVIRONMENT_VARIABLE_INFO View Base SF99702 Level 11
QSYS2.PROGRAM_EXPORT_IMPORT_INFO View SF99704 Level 4 SF99703 Level 16 Not Supported
QSYS2.PROGRAM_INFO View SF99704 Level 4 SF99703 Level 16 Not Supported
QSYS2.QCMDEXC() Procedure Base Base Base
QSYS2.RECEIVE_DATA_QUEUE() Table function SF99704 Level 4 SF99703 Level 16 Not Supported
QSYS2.SEND_DATA_QUEUE() Procedure SF99704 Level 4 SF99703 Level 16 Not Supported
QSYS2.SEND_DATA_QUEUE_BINARY() Procedure SF99704 Level 4 SF99703 Level 16 Not Supported
QSYS2.SEND_DATA_QUEUE_UTF8() Procedure SF99704 Level 4 SF99703 Level 16 Not Supported
QSYS2.SERVICES_INFO Table Base Base Introduced: SF99702 Level 11
QSYS2.SET_PASE_SHELL_INFO() Procedure Base SF99703 Level 4 SF99702 Level 16
QSYS2.STACK_INFO() Table function Base SF99703 Level 7 SF99702 Level 19
SYSTOOLS.SPLIT() Table function Base SF99703 Level 15 Not Supported
Communication Services
QSYS2.ACTIVE_DB_CONNECTIONS() Table function SF99704 Level 4 SF99703 Level 16 Not Supported
QSYS2.ADD_TIME_SERVER() Procedure Base Not Supported Not Supported
QSYS2.HTTP_SERVER_INFO View SF99704 Level 7 SF99703 Level 18 Not Supported
QSYS2.NETSTAT_INFO View Base

Base

Enhanced: SF99703 Level 11

SF99702 Level 9

Enhanced: SF99702 Level 11

Enhanced: SF99702 Level 23

QSYS2.NETSTAT_INTERFACE_INFO View Base Base

SF99702 Level 9

Enhanced: SF99702 Level 11

QSYS2.NETSTAT_JOB_INFO View Base

Enhanced: SF99703 Level 11

SF99702 Level 9

Enhanced: SF99702 Level 11

Enhanced: SF99702 Level 23

QSYS2.NETSTAT_ROUTE_INFO View Base Base

SF99702 Level 9

Enhanced: SF99702 Level 11

QSYS2.REMOVE_TIME_SERVER() Procedure Base Not Supported Not Supported
QSYS2.SERVER_SBS_CONFIGURATION View SF99704 Level 4 SF99703 Level 16 Not Supported
QSYS2.SERVER_SBS_ROUTING View Base

Base

SF99702 Level 5
Enhanced: SF99702 Level 9

Enhanced: SF99702 Level 11

QSYS2.SET_SERVER_SBS_ROUTING() Procedure 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
QSYS2.TIME_PROTOCOL_INFO View Base Not Supported Not Supported
SYSIBMADM.ENV_SYS_INFO View Base Base Base
Enhanced: SF99702 Level 9
IFS Services
QSYS2.IFS_JOB_INFO() Table function SF99704 Level 4 SF99703 Level 16 Not Supported
QSYS2.IFS_OBJECT_LOCK_INFO() Table function SF99704 Level 4 SF99703 Level 16 Not Supported
QSYS2.IFS_OBJECT_PRIVILEGES() Table function SF99704 Level 7 SF99703 Level 18 Not Supported
QSYS2.IFS_OBJECT_REFERENCES_INFO() Table function SF99704 Level 4 SF99703 Level 16 Not Supported
QSYS2.IFS_OBJECT_STATISTICS() Table function SF99704 Level 4 SF99703 Level 16 Not Supported
Java Services
QSYS2.JVM_INFO View Base Base SF99702 Level 5
QSYS2.SET_JVM() Procedure Base Base SF99702 Level 5
Journal Services
QSYS2.DISPLAY_JOURNAL() Table function
Base
Enhanced: SF99704 Level 7

Enhanced: SF99703 Level 3

Enhanced: SF99703 Level 7

Enhanced: SF99703 Level 18

Base

Enhanced: SF99702 Level 11

Enhanced: SF99702 Level 14

Enhanced: SF99702 Level 19

QSYS2.JOURNAL_INFO View Base Base SF99702 Level 3
Librarian Services
QSYS2.LIBRARY_INFO() Table  function SF99704 Level 7 SF99703 Level 18 Not Supported
QSYS2.LIBRARY_LIST_INFO View Base Base SF99702 Level 3
QSYS2.OBJECT_STATISTICS() Table function Enhanced:
SF99704 Level 4

Base

Enhanced: SF99703 Level 3

Enhanced:
SF99703 Level 16

Base
Enhanced: SF99702 Level 5
Enhanced: SF99702 Level 9

Enhanced: SF99702 Level 14

Message Handling Services
QSYS2.HISTORY_LOG_INFO() Table function Base

SF99703 Level 3

Enhanced: SF99703 Level 7

SF99702 Level 14

Enhanced: SF99702 Level 19

QSYS2.JOBLOG_INFO() Table function Base
 
Base
Enhanced: SF99703 Level 18
SF99702 Level 3
QSYS2.MESSAGE_FILE_DATA View Base SF99703 Level 15 Not Supported
QSYS2.MESSAGE_QUEUE_INFO View Base SF99703 Level 4 SF99702 Level 16
QSYS2.REPLY_LIST_INFO View Base Base SF99702 Level 3
Product Services
QSYS2.LICENSE_INFO View Base

Enhanced: SF99703
Level 4

SF99702 Level 9

Enhanced: SF99702
Level 16

SYSTOOLS.LICENSE_EXPIRATION_CHECK() Procedure Base SF99703 Level 4 SF99702 Level 16
PTF Services
QSYS2.GROUP_PTF_INFO View Base Base Base
QSYS2.PTF_INFO View Base Base Base
SYSTOOLS.FIRMWARE_CURRENCY View Base SF99703 Level 15 Not Supported
SYSTOOLS.GROUP_PTF_CURRENCY View Base

Enhanced: SF99703 Level 3

SF99702 Level 3

Enhanced: SF99702 Level 14

SYSTOOLS.GROUP_PTF_DETAILS View Base

Enhanced: SF99703 Level 3

SF99702 Level 9

Enhanced: SF99702 Level 14

Security Services
QSYS2.AUTHORITY_COLLECTION View Base Base Not Supported
QSYS2.AUTHORITY_COLLECTION_DLO View Base Not Supported Not Supported
QSYS2.AUTHORITY_COLLECTION_FSOBJ View Base Not Supported Not Supported
QSYS2.AUTHORITY_COLLECTION_LIBRARIES View Base Not Supported Not Supported
QSYS2.AUTHORITY_COLLECTION_OBJECT View Base Not Supported Not Supported
QSYS2.AUTHORIZATION_LIST_INFO View Base SF99703 Level 4 SF99702 Level 16
QSYS2.AUTHORIZATION_LIST_USER_INFO View Base SF99703 Level 4 SF99702 Level 16
QSYS2.CERTIFICATE_INFO()
 
Table function SF99704 Level 7 SF99703 Level 18 Not Supported
QSYS2.DRDA_AUTHENTICATION_ENTRY_INFO View Base Base SF99702 Level 5
QSYS2.FUNCTION_INFO View Base Base Base
QSYS2.FUNCTION_USAGE View Base Base Base
QSYS2.GROUP_PROFILE_ENTRIES View Base Base Base
QSYS2.OBJECT_OWNERSHIP View SF99704 Level 4 SF99703 Level 16 Not Supported
QSYS2.OBJECT_PRIVILEGES() Table function  
SF99704 Level 7
SF99703 Level 18
Not Supported
QSYS2.OBJECT_PRIVILEGES View

Base

Enhanced:
SF99704 Level 7

SF99703 Level 4

Enhanced:
SF99703 Level 15

Enhanced:
SF99703 Level 16

Enhanced: SF99703 Level 18

SF99702 Level 16
QSYS2.SQL_CHECK_AUTHORITY() Scalar function Base Base Base
QSYS2.USER_INFO View
Base
Enhanced: SF99704 Level 7

Base

Enhanced: SF99703 Level 4

Base

Enhanced: SF99702 Level 16

SYSPROC.SET_COLUMN_ATTRIBUTE() Procedure Base Base Base
Spool Services
QSYS2.OUTPUT_QUEUE_ENTRIES View Base Base SF99702 Level 9
QSYS2.OUTPUT_QUEUE_ENTRIES_BASIC View Base SF99703 Level 11 SF99702 Level 23
QSYS2.OUTPUT_QUEUE_ENTRIES() Table function Base Base SF99702 Level 9
QSYS2.OUTPUT_QUEUE_INFO View Base Base Introduced: SF99702 Level 11
SYSTOOLS.SPOOLED_FILE_DATA() Table function Base SF99703 Level 15 Not Supported
Storage Services
QSYS2.ASP_INFO View Base

SF99703 Level 7

Enhanced:
SF99703 Level 15

SF99702 Level 19
QSYS2.ASP_JOB_INFO View Base SF99703 Level 15 Not Supported
QSYS2.ASP_VARY_INFO View Base SF99703 Level 7 SF99702 Level 19
QSYS2.MEDIA_LIBRARY_INFO View Base Base SF99702 Level 9
QSYS2.SYSDISKSTAT View
Base
Enhanced: SF99704 Level 7
Base Base
QSYS2.SYSTMPSTG View Base Base Base
QSYS2.USER_STORAGE View Base Base Base
System Health Services
QSYS2.SYSLIMTBL Table Base

Enhanced: SF99703 Level 7

Enhanced:
SF99703 Level 15

Introduced: Base
Enhanced: SF99702 Level 3
Enhanced: SF99702 Level 5

Enhanced: SF99702 Level 11

Enhanced: SF99702 Level 19

QSYS2.SYSLIMITS View Base

Enhanced: SF9970 Level 7

Enhanced:
SF99703 Level 15

Introduced: Base
Enhanced: SF99702 Level 3
Enhanced: SF99702 Level 5

Enhanced: SF99702 Level 11

Enhanced: SF99702 Level 19

Work Management Services
QSYS2.ACTIVE_JOB_INFO() Table function
Base
Enhanced: SF99704 Level 7

Enhanced: SF99703 Level 11

Enhanced: SF99703 Level 18

SF99702 Level 5
Enhanced: SF99702 Level 9

Enhanced: SF99702 Level 23

QSYS2.AUTOSTART_JOB_INFO View SF99704 Level 7 SF99703 Level 18 Not Supported
QSYS2.GET_JOB_INFO() Table function Base

Enhanced: SF99703 Level 3
 

Enhanced:
SF99703 Level 15

Introduced: Base
Enhanced: SF99702 Level 5
Enhanced: SF99702 Level 9

Enhanced: SF99702 Level 14

QSYS2.JOB_DESCRIPTION_INFO View Base

SF99703 Level 11

SF99702 Level 23

QSYS2.JOB_INFO() Table function Base SF99703 Level 3 SF99702 Level 14
QSYS2.JOB_LOCK_INFO() Table function SF99704 Level 7 SF99703 Level 18 Not Supported
QSYS2.JOB_QUEUE_INFO View Base SF99703 Level 7 SF99702 Level 19
QSYS2.MEMORY_POOL() Table function Base Base SF99702 Level 9
QSYS2.MEMORY_POOL_INFO View Base Base SF99702 Level 9
QSYS2.OBJECT_LOCK_INFO View Base Base SF99702 Level 9
QSYS2.PRESTART_JOB_INFO View SF99704 Level 7 SF99703 Level 18 Not Supported
QSYS2.PRESTART_JOB_STATISTICS() Table function SF99704 Level 7 SF99703 Level 18 Not Supported
QSYS2.RECORD_LOCK_INFO View Base Base SF99702 Level 9
QSYS2.ROUTING_ENTRY_INFO View SF99704 Level 7 SF99703 Level 18 Not Supported
QSYS2.SCHEDULED_JOB_INFO View Base Base SF99702 Level 5
QSYS2.SUBSYSTEM_INFO View SF99704 Level 7 SF99703 Level 18 Not Supported
QSYS2.SUBSYSTEM_POOL_INFO View SF99704 Level 7 SF99703 Level 18 Not Supported
QSYS2.SYSTEM_STATUS() Table function Enhanced:
SF99704 Level 4


Enhanced: SF99704 Level 7

Base

Enhanced:
SF99703 Level 16

Enhanced: SF99703 Level 18

SF99702 Level 9
QSYS2.SYSTEM_STATUS_INFO View Enhanced:
SF99704 Level 4


Enhanced: SF99704 Level 7

Base

Enhanced:
SF99703 Level 16

Enhanced: SF99703 Level 18

SF99702 Level 9
QSYS2.SYSTEM_VALUE_INFO View Base Base Base
QSYS2.WORKSTATION_INFO View SF99704 Level 7 SF99703 Level 18 Not Supported

The documentation for these services can be found in Knowledge Center:

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB08","label":"Cognitive Systems"}}]

Document Information

Modified date:
11 April 2020

UID

ibm11119123