What's new for IBM® i 7.2

The following information was added or updated in this release of the information:

Support for Row and column access controls:
- Row and column access control (RCAC)
- QAQQINI options for RCAC: QAQQINI query options
DB2 for i services outlines many system-provided views, procedures, and functions. DB2 for i Services
IBM i Services outlines many system services that can be accessed through system-provided SQL views, procedures, and functions. IBM i Services
Improved query identification matching advised indexes with existing Plan Cache queries.
- Index advisor
- Displaying index advisor information
Allow for host variable selectivity checks at pseudo open time:
- Reducing the number of open operations
- QAQQINI query options
Controlling queries dynamically with the query options file QAQQINI
Temporary indexes as a source of optimizer statistics: Temporary index
Improved query optimization I/O cost estimates based on IPL determined disk I/O analysis: Single table optimization
Support for Solid State Drives: Solid State Drives
Index advisor column descriptions
Database manager indexes advised system table
New system limit for index size 1.7 Terabytes: QSYS2.Health_Size_Limits ()
Index advice generation now handles OR predicates: Index advice and OR predicates
SQE Plan Cache default auto sizing vs explicit size designation:
- Plan cache
- Accessing the SQL plan cache with SQL stored procedures
EVI INCLUDE supports grouping set queries Recommendations for EVI use

What’s new

The following revisions or additions have been made to the Performance and query optimization documentation since the first 7.2 publication:

April 2019 update
- The maximum table size has been added as a tracked system limit and as a limit that sends alerts: System Health Services, System limit alerts
August 2018 update
- New services
  - GENERATE_SQL_OBJECTS procedure: GENERATE_SQL_OBJECTS procedure
  - JOB_DESCRIPTION_INFO view: JOB_DESCRIPTION_INFO view
  - OUTPUT_QUEUE_ENTRIES_BASIC view: OUTPUT_QUEUE_ENTRIES_BASIC view
- Updated services
  - ACTIVE_JOB_INFO table function optionally returns more detailed information: ACTIVE_JOB_INFO table function
  - NETSTAT_INFO view and NETSTATE_JOB_INFO view return port names from service table entries: NETSTAT_INFO view and NETSTAT_JOB_INFO view
  - PARSE_STATEMENT table function supports some DDL references: PARSE_STATEMENT table function
October 2017 update
- New services
  - ASP_INFO view: ASP_INFO view
  - ASP_VARY_INFO view: ASP_VARY_INFO view
  - JOB_QUEUE_INFO view: JOB_QUEUE_INFO view
  - STACK_INFO table function: STACK_INFO table function
- Updated services
  - DISPLAY_JOURNAL and HISTORY_LOG_INFO include syslog information: DISPLAY_JOURNAL table function and HISTORY_LOG_INFO table function
  - OVERRIDE_QAQQINI procedure has been fully documented: OVERRIDE_QAQQINI procedure
  - System limit notifications: System limit alerts
March 2017 update
- New services
  - AUTHORIZATION_LIST_INFO view: AUTHORIZATION_LIST_INFO view
  - AUTHORIZATION_LIST_USER_INFO view: AUTHORIZATION_LIST_USER_INFO view
  - OBJECT_PRIVILEGES view: OBJECT_PRIVILEGES view
  - MESSAGE_QUEUE_INFO view: MESSAGE_QUEUE_INFO view
  - LICENSE_EXPIRATION_CHECK procedure: LICENSE_EXPIRATION_CHECK procedure
  - SET_PASE_SHELL_INFO procedure: SET_PASE_SHELL_INFO procedure
- Updated services
  - USER_INFO has new columns for supplemental group profile information and the PASE shell: USER_INFO view
  - LICENSE_INFO view has a new column indicating the install status: LICENSE_INFO view
  - RESET_TABLE_INDEX_STATISTICS procedure has a new option to remove rows from the index advice tracking table: RESET_TABLE_INDEX_STATISTICS procedure
November 2016 update
- STATEMENT DETERMINISTIC option has been added for functions: QAQQINI query options
- New services
  - HISTORY_LOG_INFO table function: HISTORY_LOG_INFO table function
  - JOB_INFO table function: JOB_INFO table function
  - PARSE_STATEMENT table function: PARSE_STATEMENT table function
- Updated services
  - DISPLAY_JOURNAL table function honors row and column access control: DISPLAY_JOURNAL table function
  - GET_JOB_INFO table function has new columns for prestart job information: GET_JOB_INFO table function
  - GROUP_PTF_CURRENCY view returns a new value to indicate PTFs will be current with the next IPL: GROUP_PTF_CURRENCY view
  - GROUP_PTF_CURRENCY and GROUP_PTF_DETAILS views have been updated to access a new XML feed: GROUP_PTF_CURRENCY view and GROUP_PTF_DETAILS view
  - OBJECT_STATISTICS table function added an option to efficiently return a list of libraries: OBJECT_STATISTICS table function
April 2016 update
- New services
  - ENVIRONMENT_VARIABLE_INFO view: ENVIRONMENT_VARIABLE_INFO view
  - OUTPUT_QUEUE_INFO view: OUTPUT_QUEUE_INFO view
  - SERVICES_INFO table and DB2 PTF Group level dependency information: SERVICES_INFO table
- Updated services
  - DISPLAY_JOURNAL table function accepts ending values as input parameters to limit the entries returned: DISPLAY_JOURNAL table function
  - NETSTAT_INFO view has been updated to return more information: NETSTAT_INFO view
  - NETSTAT_INTERFACE_INFO view has been updated to return more information: NETSTAT_INTERFACE_INFO view
  - NETSTAT_JOB_INFO view has been updated to return more information: NETSTAT_JOB_INFO view
  - NETSTAT_ROUTE_INFO view has been updated to return more information: NETSTAT_ROUTE_INFO view
  - SERVER_SBS_ROUTING view shows information about more servers: SERVER_SBS_ROUTING view
  - SET_SERVER_SBS_ROUTING procedure allows you to configuring more servers: SET_SERVER_SBS_ROUTING procedure
  - SYSLIMITS view returns more information about each object: SYSLIMITS view
  - An additional limit is tracked: Maximum extended dynamic package size: System Health Services
October 2015 update
- New services
  - GROUP_PTF_DETAILS view: GROUP_PTF_DETAILS view
  - LICENSE_INFO view: LICENSE_INFO view
  - MEDIA_LIBRARY_INFO view: MEDIA_LIBRARY_INFO view
  - MEMORY_POOL table function: MEMORY_POOL table function
  - MEMORY_POOL_INFO view: MEMORY_POOL_INFO view
  - NETSTAT_INFO view: NETSTAT_INFO view
  - NETSTAT_INTERFACE_INFO view: NETSTAT_INTERFACE_INFO view
  - NETSTAT_JOB_INFO view: NETSTAT_JOB_INFO view
  - NETSTAT_ROUTE_INFO view: NETSTAT_ROUTE_INFO view
  - OBJECT_LOCK_INFO view: OBJECT_LOCK_INFO view
  - OUTPUT_QUEUE_ENTRIES table function: OUTPUT_QUEUE_ENTRIES table function
  - OUTPUT_QUEUE_ENTRIES view: OUTPUT_QUEUE_ENTRIES view
  - RECORD_LOCK_INFO view: RECORD_LOCK_INFO view
  - SYSTEM_STATUS table function: SYSTEM_STATUS table function
  - SYSTEM_STATUS_INFO view: SYSTEM_STATUS_INFO view
- Updated services
  - ACTIVE_JOB_INFO table function has been updated to return elapsed time: ACTIVE_JOB_INFO table function
  - DATABASE_MONITOR_INFO view has been updated to describe new filter values: DATABASE_MONITOR_INFO view
  - ENV_SYS_INFO view has been updated to return the total configured memory: ENV_SYS_INFO view
  - GET_JOB_INFO table function has been updated to return the client IP address: GET_JOB_INFO table function
  - SET_SERVER_SBS_ROUTING procedure allows you to configuring the remote command server: SET_SERVER_SBS_ROUTING procedure
May 2015 update
- Additional information was added to QQI1 - Insert unique count in the database monitor 1000 record. For details, see: Database monitor view 1000 - SQL Information
- Additional options were added to the QAQQINI query option Memory_Pool_Preference. For details, see: QAQQINI query options
- CLEAR_PLAN_CACHE procedure. For details, see: CLEAR_PLAN_CACHE
- New services
  - ACTIVE_JOB_INFO table function: ACTIVE_JOB_INFO table function
  - DATABASE_MONITOR_INFO view: DATABASE_MONITOR_INFO view
  - DRDA_AUTHENTICATION_ENTRY_INFO view: DRDA_AUTHENTICATION_ENTRY_INFO view
  - JVM_INFO view: JVM_INFO view
  - SCHEDULED_JOB_INFO view: SCHEDULED_JOB_INFO view
  - SERVER_SBS_ROUTING view: SERVER_SBS_ROUTING view
  - SET_JVM procedure: SET_JVM procedure
  - SET_SERVER_SBS_ROUTING procedure: SET_SERVER_SBS_ROUTING procedure
- Updated services
  - GET_JOB_INFO table function has been updated to return additional SQL information for a job: GET_JOB_INFO table function
  - OBJECT_STATISTICS table function has a new optional parameter to specify the name of the object to return. It will also return the long SQL name for an object and has new columns to return the text, the long schema name, and the SQL type of an object: OBJECT_STATISTICS table function
  - System Health Services has been updated to track index limits: System Health Services
October 2014 update
- Updates to the QAQQINI query options topic
  
  For details, see QAQQINI query options.
- Memory preference controls enhanced for SQL
  For details, see Memory preference controls
- The database monitor topic has been updated: Monitoring your queries using the Database Monitor
- The SQL Plan Cache topic has been updated: Optimizing performance using the Plan Cache
- New services
  - LIBRARY_LIST_INFO view: LIBRARY_LIST_INFO view
  - REPLY_LIST_INFO view: REPLY_LIST_INFO view
  - JOURNAL_INFO view: JOURNAL_INFO view
  - GROUP_PTF_CURRENCY view: GROUP_PTF_CURRENCY view
  - JOBLOG_INFO table function: JOBLOG_INFO table function
- Tracking of additional file system limits
  
  For details, see System Health Services

How to see what's new or changed

To help you see where technical changes have been made, this information uses:

The image to mark where new or changed information begins.
The image to mark where new or changed information ends.

To find other information about what's new or changed this release, see the Memo to users.