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:
- IBM Data Studio 4.1.4 (client only)
- IBM Data Studio 4.1.3 (client only)
- IBM Data Studio 4.1.2 (client only)
- IBM Data Studio 4.1.1 (client and web console)
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.
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
- 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.
- 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.
Related Information
[{"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"}]
Was this topic helpful?
Document Information
Modified date:
24 January 2022
UID
swg27038173