IBM Support

IBM i 7.2 - TR4 Enhancements

News


Abstract

IBM i 7.2 - TR4 Enhancements

Content

You are in: IBM i Technology Updates > IBM i 7.2 - TR4 Enhancements

Db2 for i Enhancements

Db2 for i Functional Enhancements

SQL Scalar Functions

Db2 for i built-in Global Variables

Db2 for i Performance Enhancements

Inlining support for User Defined Table Functions (UDTFs)

Db2 for i Security Enhancements

Guardium enhancements for tracking Change Profile

Db2 for i Database Management Enhancements

Fair lock option - PREVENT_ADDITIONAL_CONFLICTING_LOCKS

No lock option - ALLOW_DDL_CHANGES_WHILE_OPEN

Add columns to QSYS2.SYSPROGRAMSTMTSTAT for SQL dependency level and IBM i Service dependency level

Detail about the lock holder on SQL0913 failures

 

New IBM i Services

QSYS2.ENVIRONMENT_VARIABLE_INFO

QSYS2.OUTPUT_QUEUE_INFO

QSYS2.SERVICES_INFO

Enhanced IBM i Services

QSYS2.DISPLAY_JOURNAL()

QSYS2.OBJECT_STATISTICS()

QSYS2.NETSTAT_INFO

QSYS2.NETSTAT_INTERFACE_INFO

QSYS2.NETSTAT_JOB_INFO

QSYS2.NETSTAT_ROUTE_INFO

QSYS2.SET_SERVER_SBS_ROUTING()

QSYS2.SERVER_SBS_ROUTING

QSYS2.SYSLIMITS


Core Operating System Updates

  • BRMS 
    • Libraries to omit (OMITLIB) and Objects to omit (OMITOBJ) parameters have been added to Restore Library using BRM (RSTLIBBRM) command
    • Objects to omit (OMITOBJ) parameter has been added to Restore Object using BRM (RSTOBJBRM) command.
  • Save / Restore
  • Independent ASPs
    • Reduced Vary On time
 

Hardware

 

Application Development 

 

PowerVC for i

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

Document Information

Modified date:
20 October 2021

UID

ibm11274278