What's new for IBM i 7.3
The following information was added or updated in this release of the information:
- Support for System-period temporal tables: System-period temporal tables
- Support for EVI RRN probe: Encoded vector index RRN probe
- Index advice for EVI RRN probe: Index advice for Encoded Vector Index RRN Probe Plans
- Support for Window temporary result objects and window scans: Window
- Support for Temporary indexed lists: Temporary Indexed List
- Support for temporary index list scan and index merge: Temporary Indexed List scan and Index Merge
- SQL plan cache properties topic: SQL plan cache properties has been updated.
- Indexes and column statistics topic: Indexes and column statistics has been updated.
- Start database monitor (STRDBMON) command topic: Start Database Monitor (STRDBMON) command has been updated.
- Environmental attributes that you can modify through the QAQQINI file : Controlling queries dynamically with the query options file QAQQINI has been updated.
- QAQQINI query options has been updated.
- Database monitor records that have additions in 7.3:
- New services
- AUTHORITY_COLLECTION view: AUTHORITY_COLLECTION view
- 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
- OBJECT_STATISTICS table function has been updated to return more information: OBJECT_STATISTICS table function
- PTF_INFO view has been updated to return more information: PTF_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
- USER_INFO view has new columns for authority collection details: USER_INFO view
- SYSLIMITS view returns more information about each object: SYSLIMITS view
- An additional limit is tracked: Maximum extended dynamic package size: System Health Services
What’s new since the first 7.3 publication
The following revisions or additions have been
made to the Performance and query optimization documentation since
the first 7.3 publication:
- May 2022 update
- Query Supervisor example exit programs written in CL: Query Supervisor example exit programs
- New services
- ACTIVATION_GROUP_INFO table function: ACTIVATION_GROUP_INFO table function
- ASSOCIATE_JOURNAL_RECEIVER table function: ASSOCIATE_JOURNAL_RECEIVER table function
- AUDIT_JOURNAL_JS, AUDIT_JOURNAL_OM, and AUDIT_JOURNAL_ST table functions return entry specific data: AUDIT_JOURNAL_JS table function, AUDIT_JOURNAL_OM table function, and AUDIT_JOURNAL_ST table function
- BINDING_DIRECTORY_INFO view: BINDING_DIRECTORY_INFO view
- DNS_LOOKUP table function: DNS_LOOKUP table function
- ELECTRONIC_SERVICE_AGENT_INFO view: ELECTRONIC_SERVICE_AGENT_INFO view
- JOURNAL_RECEIVER_INFO view: JOURNAL_RECEIVER_INFO view
- MTI_INFO table function: MTI_INFO table function
- REMOTE_JOURNAL_INFO view: REMOTE_JOURNAL_INFO view
- SPOOLED_FILE_INFO table function: SPOOLED_FILE_INFO table function
- SQL_CHECK_FUNCTION_USAGE scalar function: SQL_CHECK_FUNCTION_USAGE scalar function
- SQL_CHECK_SPECIAL_AUTHORITY scalar function: SQL_CHECK_SPECIAL_AUTHORITY scalar function
- SYSTEM_ACTIVITY_INFO table function: SYSTEM_ACTIVITY_INFO table function
- Updated services
- ACTIVE_JOB_INFO table function can return a WORK subset of data: ACTIVE_JOB_INFO table function
- GENERATE_PDF scalar function supports *LAST option: GENERATE_PDF scalar function
- GENERATE_SQL and GENERATE_SQL_OBJECTS procedures have a new option for generating comments for tables: GENERATE_SQL procedure and GENERATE_SQL_OBJECTS procedure
- JOBLOG_INFO table function returns the qualified job name: JOBLOG_INFO table function
- SYSTEM_STATUS table function, SYSTEM_STATUS_INFO view, and SYSTEM_STATUS_INFO_BASIC view no
longer return information for the AVERAGE_CPU_RATE, AVERAGE_CPU_UTILIZATION,
MINIMUM_CPU_UTILIZATION, and MAXIMUM_CPU_UTILIZATION columns due to performance concerns. This
information is now returned through the SYSTEM_ACTIVITY_INFO table function.
These columns can be can be explicitly requested by using an environment variable switch.
ADDENVVAR ENVVAR(QIBM_DB2_SYSTEM_STATUS_INFO) VALUE(FULL) LEVEL(*JOB)
SYSTEM_STATUS table function, SYSTEM_STATUS_INFO view, and SYSTEM_STATUS_INFO_BASIC view
- September 2021 update
- New system limits global variables provide the ability to remove rows from the system limits table by the age of rows, in days: QIBM_SYSTEM_LIMITS global variables
- New services
- ACTIVE_QUERY_INFO table function returns information about active SQL Query Engine (SQE) queries: ACTIVE_QUERY_INFO table function
- AUDIT_JOURNAL_CD, AUDIT_JOURNAL_CO, AUDIT_JOURNAL_CP, AUDIT_JOURNAL_DO, AUDIT_JOURNAL_EV, AUDIT_JOURNAL_GR, AUDIT_JOURNAL_SV table functions return the entry specific data for audit journal entries: Audit journal entry services
- COLLECTION_SERVICES_INFO returns the configuration properties for Collection Services: COLLECTION_SERVICES_INFO view
- SYSFILES view returns database file information: SYSFILES view
- WORKLOAD_GROUP_INFO view returns information about workload groups: WORKLOAD_GROUP_INFO view
- Updated services
- ACTIVE_JOB_INFO includes a column for the workload group: ACTIVE_JOB_INFO table function
- DISPLAY_JOURNAL table function adds a column with a new name to return the current user value: DISPLAY_JOURNAL table function
- PARSE_STATEMENT returns the procedure name for a CALL statement: PARSE_STATEMENT table function
- SECURITY_INFO view returns additional security-related system values: SECURITY_INFO view
- April 2021 update
- The Query Supervisor allows real time monitoring of resources used by queries: Query Supervisor
- New services
- AUDIT_JOURNAL_AF, AUDIT_JOURNAL_CA, AUDIT_JOURNAL_OW, AUDIT_JOURNAL_PW table functions return the entry specific data for audit journal entries: Audit journal entry services
- CHANGE_USER_PROFILE table function allows some user profile attributes to be changed: CHANGE_USER_PROFILE table function
- END_IDLE_SQE_THREADS procedure ends SQE threads not being used by a job: END_IDLE_SQE_THREADS procedure
- GENERATE_PDF scalar function generates a PDF from a spooled file: GENERATE_PDF scalar function
- MESSAGE_QUEUE_INFO table function allows filtering of the messages in a message queue: MESSAGE_QUEUE_INFO table function
- QCMDEXC scalar function executes a CL command from within a query: QCMDEXC scalar function
- SECURITY_INFO view provides system security settings: SECURITY_INFO view
- SEND_MESSAGE procedure sends an informational message to the QSYSOPR message queue: SEND_MESSAGE procedure
- USER_INDEX_INFO view returns the attributes of a *USRIDX: USER_INDEX_INFO view
- USER_INDEX_ENTRIES table function returns the contents of a *USRIDX: USER_INDEX_ENTRIES table function
- USER_INFO_BASIC view is a faster version of USER_INFO, with fewer columns: USER_INFO_BASIC view
- USER_SPACE_INFO view returns the attributes of a *USRSPC: USER_SPACE_INFO view
- USER_SPACE table function returns the content of a *USRSPC object: USER_SPACE table function
- Updated services
- ACTIVE_JOB_INFO and JOB_INFO table functions return individual columns for the parts of a qualified job name: ACTIVE_JOB_INFO table function and JOB_INFO table function
- CLEAR_PLAN_CACHE procedure allows a plan for a query to be cleared: CLEAR_PLAN_CACHE procedure
- DISPLAY_JOURNAL table function returns more SYSLOG information: DISPLAY_JOURNAL table function
- DUMP_PLAN_CACHE procedure allows a specific plan to be dumped: DUMP_PLAN_CACHE procedure
- DUMP_PLAN_CACHE_TOPN procedure supports additional categories of plans to be dumped: DUMP_PLAN_CACHE_TOPN procedure
- FIRMWARE_CURRENCY view includes information shown by the DSPFMWSTS command: FIRMWARE_CURRENCY view
- GENERATE_SQL and GENERATE_SQL_OBJECTS procedures write output to a stream file: GENERATE_SQL procedure and GENERATE_SQL_OBJECTS procedure
- IFS_OBJECT_STATISTICS table function return the symbolic link for an object: IFS_OBJECT_STATISTICS table function
- OBJECT_STATISTICS table function supports a generic object name: OBJECT_STATISTICS table function
- SYSDISKSTAT view and SYSDISKSTAT table function have additional information about SSDs, including remaining lifetime: SYSDISKSTAT view and SYSDISKSTAT table function
- USER_INFO view indicates whether the user profile is disabled for IBM i NetServer use: USER_INFO view
- System limit alerting is instrumented for the maximum number of spooled files limit. In addition, global variables can be used to set the alerting level percent for each limit: System limit alerts
- October 2020 update
- The SELECTIVITY clause allows predicate selectivity values to be assigned within a query: Use SELECTIVITY to supply missing information
- New services
- COMMUNICATIONS_ENTRY_INFO view: COMMUNICATIONS_ENTRY_INFO view
- DATA_QUEUE_ENTRIES table function: DATA_QUEUE_ENTRIES table function
- EXIT_POINT_INFO view: EXIT_POINT_INFO view
- EXIT_PROGRAM_INFO view: EXIT_PROGRAM_INFO view
- IFS_READ table function: IFS_READ, IFS_READ_BINARY, and IFS_READ_UTF8 table functions
- IFS_WRITE procedure: IFS_WRITE, IFS_WRITE_BINARY, and IFS_WRITE_UTF8 procedures
- JOURNAL_INHERIT_RULES view: JOURNAL_INHERIT_RULES view
- JOURNALED_OBJECTS view: JOURNALED_OBJECTS view
- OPEN_FILES table function: OPEN_FILES table function
- RELATED_OBJECTS table function: RELATED_OBJECTS table function
- SERVER_SHARE_INFO view: SERVER_SHARE_INFO view
- SOFTWARE_PRODUCT_INFO view: SOFTWARE_PRODUCT_INFO view
- SYSLIMITS_BASIC view: SYSLIMITS_BASIC view
- WATCH_DETAIL table function: WATCH_DETAIL table function
- WATCH_INFO view: WATCH_INFO view
-
Updated services
- ACTIVE_JOB_INFO table function returns a column about open files: ACTIVE_JOB_INFO table function
- ANALYZE_CATALOG table function has an option to return cross reference server status: ANALYZE_CATALOG table function
- DB_TRANSACTION_INFO view returns additional columns for pending changes: DB_TRANSACTION_INFO view
- DISPLAY_JOURNAL table function allows multiple object names and a fully qualified job name as input parameters, and returns more SYSLOG information: DISPLAY_JOURNAL table function
- GROUP_PTF_DETAILS and GROUP_PTF_CURRENCY views return dates as a date data type column: GROUP_PTF_DETAILS view and GROUP_PTF_CURRENCY view
- LIBRARY_INFO table function has a new detailed information parameter and returns additional journal columns: LIBRARY_INFO table function
- SPLIT table function has an escape character parameter: SPLIT table function
- SYSDISKSTAT view has additional information added, including statistics. The new SYSDISKSTAT table function allows the statistics to be reset: SYSDISKSTAT view and SYSDISKSTAT table function
- SYSTEM_STATUS table function and SYSTEM_STATUS_INFO view return job table information and system-wide journal information. A new view, SYSTEM_STATUS_INFO_BASIC does not return the job table columns: SYSTEM_STATUS table function, SYSTEM_STATUS_INFO view, and SYSTEM_STATUS_INFO_BASIC view
- SYSTOOLS services are documented
- DELETE_OLD_SPOOLED_FILES procedure: DELETE_OLD_SPOOLED_FILES procedure
- LPRINTF procedure: LPRINTF procedure
- VALIDATE_DATA table functions: VALIDATE_DATA, VALIDATE_DATA_FILE, and VALIDATE_DATA_LIBRARY table functions
- April 2020 update
-
New services
- ANALYZE_CATALOG table function: ANALYZE_CATALOG table function
- AUTOSTART_JOB_INFO view: AUTOSTART_JOB_INFO view
- CERTIFICATE_INFO table function: CERTIFICATE_INFO table function
- DB_TRANSACTION_INFO view: DB_TRANSACTION_INFO view
- HTTP_SERVER_INFO view: HTTP_SERVER_INFO view
- IFS_OBJECT_STATISTICS table function: IFS_OBJECT_STATISTICS table function
- JOB_LOCK_INFO table function: JOB_LOCK_INFO table function
- LIBRARY_INFO table function: LIBRARY_INFO table function
- PRESTART_JOB_INFO view: PRESTART_JOB_INFO view
- PRESTART_JOB_STATISTICS table function: PRESTART_JOB_STATISTICS table function
- ROUTING_ENTRY_INFO view: ROUTING_ENTRY_INFO view
- SUBSYSTEM_INFO view: SUBSYSTEM_INFO view
- SUBSYSTEM_POOL_INFO view: SUBSYSTEM_POOL_INFO view
- WORKSTATION_INFO view: WORKSTATION_INFO view
-
Updated services
- ACTIVE_JOB_INFO table function returns enhanced job type: ACTIVE_JOB_INFO table function
- DISPLAY_JOURNAL table function returns more SYSLOG information: DISPLAY_JOURNAL table function
- JOBLOG_INFO table function returns message key: JOBLOG_INFO table function
- OBJECT_PRIVILEGES table function has been documented: OBJECT_PRIVILEGES table function
- OBJECT_PRIVILEGES view has 2 new columns: OBJECT_PRIVILEGES view
- OVERRIDE_QAQQINI procedure allows optional parameters: OVERRIDE_QAQQINI procedure
- SYSTEM_STATUS table function and SYSTEM_STATUS_INFO view return additional columns: SYSTEM_STATUS table function and SYSTEM_STATUS_INFO view
- USER_INFO view has new columns: USER_INFO view
-
- October 2019 update
- New option to suppress alter table inquiry message. QAQQINI query options
-
New services
- ACTIVE_DB_CONNECTIONS table function: ACTIVE_DB_CONNECTIONS table function
- DATA_QUEUE_INFO view: DATA_QUEUE_INFO view
- SEND_DATA_QUEUE procedure: SEND_DATA_QUEUE, SEND_DATA_QUEUE_BINARY, and SEND_DATA_QUEUE_UTF8 procedures
- RECEIVE_DATA_QUEUE table function: RECEIVE_DATA_QUEUE table function
- CLEAR_DATA_QUEUE procedure: CLEAR_DATA_QUEUE procedure
- BOUND_MODULE_INFO view: BOUND_MODULE_INFO view
- BOUND_SRVPGM_INFO view: BOUND_SRVPGM_INFO view
- PROGRAM_EXPORT_IMPORT_INFO view: PROGRAM_EXPORT_IMPORT_INFO view
- PROGRAM_INFO view: PROGRAM_INFO view
- IFS_JOB_INFO table function: IFS_JOB_INFO table function
- IFS_OBJECT_LOCK_INFO table function: IFS_OBJECT_LOCK_INFO table function
- IFS_OBJECT_REFERENCES_INFO table function: IFS_OBJECT_REFERENCES_INFO table function
- IFS_OBJECT_STATISTICS table function: IFS_OBJECT_STATISTICS table function
- OBJECT_OWNERSHIP view: OBJECT_OWNERSHIP view
- SERVER_SBS_CONFIGURATION view: SERVER_SBS_CONFIGURATION view
- SWAP_DYNUSRPRF procedure: SWAP_DYNUSRPRF procedure
-
Updated services
- OBJECT_PRIVILEGES view: OBJECT_PRIVILEGES view
- OBJECT_STATISTICS table function returns additional columns: OBJECT_STATISTICS table function
- Support for server routing by IP address added to SET_SERVER_SBS_ROUTING: SET_SERVER_SBS_ROUTING procedure
- SYSTEM_STATUS table function and SYSTEM_STATUS_INFO view return additional columns: SYSTEM_STATUS table function and SYSTEM_STATUS_INFO view
- JOBLOG_INFO table function has optional error handling parameter: JOBLOG_INFO table function
- April 2019 update
-
New services
- ASP_JOB_INFO view: ASP_JOB_INFO view
- DATA_AREA_INFO view and table function: DATA_AREA_INFO view, DATA_AREA_INFO table function
- FIRMWARE_CURRENCY view: FIRMWARE_CURRENCY view
- MESSAGE_FILE_DATA view: MESSAGE_FILE_DATA view
- SPLIT table function: SPLIT table function
- SPOOLED_FILE_DATA table function: SPOOLED_FILE_DATA table function
- The HTTP functions in SYSTOOLS have been documented: HTTP function overview
-
Updated services
- 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
- ASP_INFO returns the relational database name for SYSBASE: ASP_INFO view
- GET_JOB_INFO returns additional columns: GET_JOB_INFO table function
- OBJECT_PRIVILEGES view returns authorization list: OBJECT_PRIVILEGES view
- PARSE_STATEMENT table function supports DROP statements and returns information about referential constraints: PARSE_STATEMENT table function
- WLM_SET_CLIENT_INFO procedure uses defaults for unspecified parameters: WLM_SET_CLIENT_INFO procedure
-
- 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 NETSTAT_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
What’s new since the first 7.2 publication
The following revisions or additions have been
made to the Performance and query optimization documentation since
the first 7.2 publication:
- 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 procedure
- 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.