IBM Support

What's new and changed in IBM Data Studio 4.1.x

Product Documentation


Abstract

The IBM Data Studio 4.1.x releases contain cumulative fixes, enhancements, and new features for both the Data Studio client and the Data Studio web console.

Content

To view whats new and changes in Data Studio, select a version from the following list:

New and changed features in Data Studio 4.1.4

  • Uplifted Eclipse SDK to Eclipse Photon 4.8 and as a result, the following things are enhanced:
    • Useful features from Eclipse are added to Data Studio
    • Performance is enhanced
    • Legacy issues are resolved
    • Shell sharing is ensured with IBM Developer for z/OS, IBM Explorer for z/OS, and Rational Developer for z/OS
  • Enhanced Deployment Manager for easier enterprise deployment
  • Included all the cumulative fixes from previous fix packs.
Important
  • Upgrade scenario from Data Studio 4.1.3 to 4.1.4 is not supported.
  • For links to the most important and frequently used documents of Data Studio 4.1.4, refer to IBM Data Studio 4.1.4 publication library.
New and changed features in Data Studio 4.1.3
  • Uplifted Eclipse SDK to Neon 4.6.3 to ensure shell sharing with InfoSphere Data Architect and IBM Developer for z/OS [IDz].
  • Upgraded Installation Manager 1.7 to 1.8.7.
  • Support of Db2 z/OS v12 for all existing functions in Data Studio.
  • Included all the cumulative fixes from previous fix packs.
Important
Upgrade scenario from Data Studio 4.1.2 to 4.1.3 is not supported.

New and changed features in Data Studio 4.1.2

  • Eclipse SDK Uplift to ensure shell sharing with InfoSphere Data Architect, Rational Application Developer, and Rational Developer for z/OS
  • All Data Studio APAR fixes included in Data Studio 4.1.1 APAR 1 - 5 are included in Data Studio 4.1.2.
  • Enhanced support for BigSQL including connection support, and parser support with specific BigSQL grammar.
  • Deployment Manager enhanced to make enterprise deployment easier.
  • Data Studio can be used with Db2 10.5 fix pack 5 and later databases that employ Native Encryption.
  • Includes all the cumulative fixes from previous fix packs.

New and changed features in Data Studio 4.1.1

  • Support for fix pack 4 for Db2 for Linux, UNIX, and Windows 10.5. This includes:
    • The latest BLU capabilities, such as the ability to alter BLU tables by adding columns
    • Columnar materialized query tables (MQT)
    • Support for Shadow tables (Replication-maintained MQTs)
  • Enhancements for Db2 for z/OS
    • More objects (such as related views) are created when you generate DDL for databases or tablespaces.
    • When you deploy Java stored procedures, you can decide whether or not to refresh Workload Manager (WLM) immediately. This is useful if you have multiple Java stored procedures and only want to refresh WLM once.
  • Navigation improvements
    • This release adds more navigational capabilities to the Data Studio client so that database administrators can find relevant database objects more quickly. When you select an object and open the Show menu for it, new options are available.
      Data object New menu options under "Show"
      Table Show Triggers
      Show Views
      Show UDTs
      Show UDFs
      Show Packages
      View Show Triggers
      Show UDFs
      Show Views
      Alias Show Views
      Trigger Show Views
      Show UDFs
      Index * Show Tablespaces
      Table Space * Show Indexes
      UDF Show Packages
      Stored Procedure Show Packages

      * = only for Db2 for Linux, UNIX, and Windows

  • Db2 client command line processor added to SQL editor
    • In the SQL editor, a new run method was added, called "Db2 Client Command Line Processor”, for Db2 for Linux, UNIX, and Windows. Now data administrators can run Db2 commands and command scripts on remote data sources using a locally installed Db2 Client. You can also move data between the remote system and local storage.
  • Running SQL scripts is now easier
    • A database administrator can now persist and retrieve SQL scripts to and from the file system without creating a new Eclipse project.
    • SQL results can be examined in either a split pane view, which includes both the history and results, or single pane, which includes only the history or the results.
  • Generating scripts for object changes are more reliable
    • The interface for object change management has been streamlined to save time generating change scripts. For example, if you generate DDL and any affected data objects have errors, the errors are displayed so you can fix them.
    • When a table is dropped and recreated, your RUNSTATS profile is preserved.
    • You can now use the following Create or Replace statements
      • CREATE OR REPLACE ALIAS
      • CREATE OR REPLACE VIEW
      • CREATE OR REPLACE NICKNAME
      • CREATE OR REPLACE SEQUENCE
      • CREATE OR REPLACE VARIABLE
      • CREATE OR REPLACE TRIGGER
      • CREATE OR REPLACE MASK
      • CREATE OR REPLACE PERMISSION
      • CREATE OR REPLACE TYPE

      You can use the following Alter DDL statements:

      • ALTER TABLE ADD PARTITION
      • ALTER BUFFERPOOL
      • ALTER TABLE ALTER COLUMN DROP GENERATED
      • ALTER TABLE ALTER COLUMN SET NOT HIDDEN/IMPLICITLY HIDDEN
  • Big SQL for Infosphere Big Insights is now supported
    • Browse and navigate Hadoop tables and show table contents, and create and alter Hadoop tables, views, and constraints
    • Create Big SQL physical data models (PDM)
    • Generate and run DDL from Big SQL PDMs or Hadoop tables
    • Run Data Definition Language (DDL) and Data Manipulation Language (DML) in the SQL editor
    • Use Visual Explain to view the access plans of SQL statements that run against Big SQL
  • Enhancements to the SQL editor
    • SQL and CLP command syntax checking has been updated to the v10.5 Fix Pack 4 level of Db2 for Linux, UNIX, and Windows.
    • SQL in Db2 for z/OS v10 and v11 now accepts IBM Db2 Analytics Accelerator (IDAA) syntax.
    • You can now change the default statement terminator or specify a different statement terminator for the SQL statements in a script that you create in the SQL and XQuery editor using the --#SET TERMINATOR x command.
  • The Object List editor displays more information about data objects
     
    Data object New information displayed
    Table Space Managed By *
    Percentage *
    Data Pages *
    Table Statistics Time
    MQT Regular Table Space *
    Index Table Space *
    Large Table Space *
    Table Space **
    Maintained by **
    Cardinality
    Statistics Time
    Stored Procedure Specific Name
    Fenced *
    Language
    Package Binder *
    Cursor *
    Number of sections *
    Optimization class *
    Explain snapshot *
    Collection ID **

* = only for Db2 for Linux, UNIX, and Windows

** = only for Db2 for z/OS

  • Diagnosing problems is easier in the routine debugger
    One common problem that can occur during debugging is that the system cannot connect to the Db2 server. There are a variety of reasons this can happen, such as a firewall, incorrect configuration of the network, an incorrect network adaptor, and so on. The routine debugger can now diagnose the root cause of the problem and suggest actions to fix it.

[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS62YD","label":"IBM Data Studio"},"ARM Category":[{"code":"a8m0z0000001jGMAAY","label":"rbrw"}],"ARM Case Number":"","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"4.1.1;and future releases"}]

Document Information

Modified date:
24 January 2022

UID

swg27038173