Online Documentation for SQL Manager for DB2

Version history

 

       Version 2.1

1. Implemented the Project management - with virtual databases that do not require connection to the server:

• Added the Project Interaction Wizard;
• Added the Projects settings;
• Added the Projects tab in the Object Inspector;
• Now all Object editors work with both ordinary database objects and project objects;
• Improved the Visual Database Designer (VDBD): now it creates a project, to which the objects from the connected databases or other projects, or objects created in the VDBD, can be added;
• Added the Execute script as a result of the databases/ projects comparison Wizard;
• Added the possibility to cancel the last actions on objects in the Projects;
• Projects are now supported by the DB2 Manager Wizards, which work with Object metadata: i.e. HTML Report Wizard, Print Metadata Wizard, Duplicate Objects Wizard, etc.

2. Added the Database Comparer Wizard to synchronize database structures.

3. Now XML files of the objects are saved in VDBD diagram.

4. Added the possibility to move tabs along the Open windows panel using a mouse;

5. In the Grant Manager now it possible to select a cell range using the SHIFT key and to apply the privileges to the whole selected range at once;

6. Version control. In the history of the object changes now it is possible to view/compare the executed script or object metadata;

7. In all the wizards at the next opening the value of the "Close the Wizard after successful completion" checkbox is saved;

8. Changed the icons of some services;

 

 Version 2.0.0.1

• Added the Version control (VC) functionality to the Compile Form, SQL Editor, SQL Script, Query Builder and object editors.
• Added VC facilities: Create tag wizard, Check repository wizard, Get change script wizard, Version History.
• Database Registration. The database name can now contain up to 18 characters depending on the OS type.
• When creating a query plan, EXPLAIN tables are now created or recreated in a database if they are absent or incomplete.
• Data Frame, creation of tables. Such default field values as CURRENT DATE, CURRENT TIME, CURRENT TIMESTAMP are processed correctly now.
• Data Frame.

Fixed the errors occurred when counting the number of records returned by some queries.

When closing a frame with a dataset opened for editing, the changes are now canceled.

• DB2 Check Editor. The OK button did not become available after the correct filling of the check body. Fixed now.

• Indices Editor. Sometimes an AV occurred on editing indices. Fixed now.
• DB2 console. Added the possibility to clear the results of execution.
• Package Editor. When creating a new package, optimization profile options were available even if the profile was disabled. Fixed now.
• SQL Editor, SQL Script. The work with comments within the bodies of procedures, functions, views and outside of their bodies is improved.
• Object Inspector. Added the possibility to create SUID procedures from tables and views; views from tables and functions that return tables.
• The Report Designer is now opened in the MDI window.
• The working of Help services in the report editors is fixed.
• Visual Database Designer.

The functioning of the Undo/Redo commands for working with several objects at once is improved.

The shortcuts Ctrl+Z and Shift+Ctrl+Z are added for the Undo and Redo commands.

• Other minor improvements and bugfixes.

 

 

 Version 1.4.0.1

 

Changes for server version 9.7 only

• Tables.

The COMPRESS option is available for tables and indexes.

The DISTRIBUTION tab is added for TABLE and MQTABLE editors.

Table fields can now be renamed.

• Event monitor. New activity types are added.

• User and group privileges.

New privileges can be granted: ACESSCTRL, DATAACCESS, EXPLAIN, SQLADM, WLMADM.

DBADM and SECADM can now be granted to a role or a group.

• Data Types.

Field type selection is extended.

Now it is possible to define the second precision type up to picoseconds for the Timestamp data.

New user types are added: ROW and Cursor.

The DISTINCT and ARRAY types are modified.

• Packages.

The Optimization profile option is added.

The ACESS PLAN REUSE option can now be changed if necessary.

• The RUNSTATS service. The Sampling Options section is added.

• Database and node variables.

New records are added to variables.

The SSL group is added to node variables.

• Aliases. The ALIAS can now refer to MODULE, GLOBAL TEMPORARY TABLE and SEQUENCE.

• Procedures and functions.

Procedure parameters can now contain default values.

BOOLEAN and CURSOR data types can now be used in procedures.

• New objects are added: GLOBAL TEMPORARY TABLE and MODULE

New object are supported with DB Explorer, Dependency Tree, Extract Database, Print Metadata, HTML Report, and Search in metadata tools.

 

 

Changes for all versions

• The Ping Database wizard is added.

• The hint for a connected database now displays an average ping to DB.

• The following new options are added to the procedure and function editors: Parameter CCSID, Savepoint level, Commit rule, Inherit special registers.

• Event Monitor.

Information can now be loaded to database tables.

The Event Monitor editor is significantly modified.

Inactive events are now highlighted in the DB Explorer.

Event monitors can now be launched or stopped through the context menu.

 

 

• DDL of objects which names contained ‘_’ is now formed properly.

• Fixed errors occurred when displaying data.

• If an error occurred on getting global variable’s value, other variables were not displayed in SQL Editor. Fixed now.

• Statement parsing is modified. Both ‘FOR --text-- END FOR’ and ‘FOR --text-- END’ statements are parsed correctly.

• When executing an SQL command, only comments within function and procedure bodies are saved (for server versions older than 9.5).

• When resetting all toolbars and menus, an empty toolbar “Plugins” used to appear. Fixed now.

• Now SQL Manager works with the system registry via API functions.

• Fixed errors occurred when working with GRAPHIC, VARGRAPHIC, LONG_VARGRAPHIC fields.

 

 Version 1.3.0.1

 

• Implemented the possibility to connect to nodes and databases using SSH tunneling - for working with data only (services cannot be run against such connection due to the fact that it is not allowed by the server architecture)
• Added scanning for available hosts at the program startup
• The method of refreshing objects has been modified to increase the performance when running a number of operations
• Several bug-fixes concerning services:

the behavior of services has been changed: they are now correctly stopped upon the forced interruption

several corrections have been made regarding unavailability of certain operations on servers of previous series

a number of services' interface corrections have been made

• Data View:

the number of records fetched from the server is displayed correctly now

several corrections related to work with fields of DateTime, Time and Timestamp data types have been made

• Grant Manager:

now changes made in the tool are first accumulated in a script for further execution instead of being applied immediately upon each change request

the sequence of commands is now executed within a separate thread to avoid the slow down of the application performance when dealing with a large number of changes

• Object Explorer:

added the possibility to close all editors only for the current database

added the possibility to duplicate security objects

editing names in the Windows List of object explorer is not allowed now

the search of security objects in DB Explorer is fixed

• Extract Database:

several corrections are made in the algorithm of extracting database objects with dependencies

now security objects can be extracted as well

• Search in Metadata: the search form is improved; the search speed is increased
• HTML Report: a number of corrections and improvements have been implemented in this tool
• DB2 Console: added the console for executing server commands
• Visual Database Designer:

objects changes are now applied upon pressing 'Compile', like in object editors

added the 'Undo' and 'Redo' operations

now it is possible to save changed diagram objects and work with them without active database connection

now it is possible to select schema(s) for reverse engineering

added tools for formatting diagram objects: setting fonts, colors, etc.

• SQL Script and SQL Editor:

SQL scripts are now executed within a thread

SQL parser has been modified for faster processing of large amounts of SQL text

the Object Explorer tree now displays only objects being operated on

missing labels and graphics have been added to the Object Explorer tree

a number of changes and extensions have been added in syntax highlighter

support of the following server commands has been added to SQL Script: CREATE DATABASE, DROP DATABASE, CONNECT, DISCONNECT, ATTACH, DETACH

it is now possible to remove detached databases from the Object Explorer tree and register the newly created ones

the Object Explorer tree is filled within a separate thread now

• Table Editor: the LOGGED and COMPACT options are added for BLOB fields
• User-Defined Type Editor: fixed an error with possibility to select a data type that is incorrect or unavailable in the current server version
• Export Data, Export as SQL Script: changed the query-forming method - statements ending with 'FETCH FIRST', 'FOR UPDATE', 'FOR READ', 'FOR FETCH', 'OPTIMIZE FOR', 'WITH RR', 'WITH RS', 'WITH CS', 'WITH UR' are processed correctly now
• Other minor improvements and bug-fixes

 

 

 Version 1.2.0.1

 

• Possibility to add/edit/delete wrapper options is implemented
• The Print Metadata procedure is fixed for the following objects: Aliases, BufferPools, PartitionGroups, EventMonitors, MQTables, Nicknames, Sequences, Distinct Types, Structured Types, Wrappers, Groups, Schemas, Servers, UserMappings
• Databases located at the nodes using a port different from 50000 used to be displayed improperly in the Database Explorer. Fixed now
• Added a number of new CLP data manipulation services:

Export

Import

Load

Move

• The default number of records to be loaded to DataFrame after registering a new database is changed from 1 to 1000
• Added the possibility to restrict the time of user logging to the server
• The Activity Monitor which displays the current connections to a database is added
• New table space options are now available when creating a database (for server version 9.5):

Maximum size

Increase size

Automatic resize

File system caching

• Database tables partitioning is supported now (the option is located at different tabs in 8.x and 9.x server versions)
• Databases deleted in other applications were displayed incorrectly when starting SQL Manager. Fixed now
• A number of new options for table indexes are implemented (for server version 8 and 9)
• Automatic capitalization of object names is now available
• Added the possibility to change field parameters for created databases. You can now change the field type (only for compatible types) and size (only increment) and set or reset the Not Null option. Units of measurement can be defined for any BLOB type when setting its field size
• Fields of the GRAPHIC, VARGRAPHIC and LONG VARGRAPHIC types used to be displayed improperly in the data frame. Fixed
• The new XML Editor tab is added to the BLOB editor
• New objects are now available:

Security label component

Security policy

Security label

• Support of the above mentioned objects and the corresponding editors are also added to the Print data, HTML Report and Dependency Tree tools
• Label based access control (LBAC) is implemented on the basis of new objects
• Other minor improvements and bug-fixes

Scroll to top

 

 Version 1.1.0.1

 

• New objects such as Audit Policies, Trusted Contexts, Roles and SQL Variables are supported now and can be edited with corresponding editors
• Grant manager: SECADM (Security Administrator) privilege has been added
• Grant manager: Read and Write privileges for SQL Variables
• Grant manager: The ability to select roles, groups and users for editing privileges from the drop-down list
• Role Editor has been added
• User Editor / Group Editor / Role Editor: SECADM (Security Administrator) privilege has been added
• User Editor / Group Editor / Role Editor: the Ancestors tab is added which allows selecting a role to inherit the privileges for the object being edited
• User Editor / Group Editor / Role Editor: privileges implicitly defined within the Grants tab are highlighted orange
• User Editor / Group Editor / Role Editor: new tab for defining Read and Write privileges for SQL Variables added
• SQL Script: commands for creating, modifying and dropping the new objects are now parsed and highlighted
• SQL Editor: the Variable Value View panel is added
• Extract Database: new objects support added
• DB Explorer: the Search in metadata feature is implemented
• DB Explorer: hints display Unicode now
• Object Templates: incorrect application of templates on creating new objects has been fixed
• New data types support (XML, DECFLOAT, VARBINARY, LONGVARBINARY) in Table Editor, UDS Type Editor and UD Editor
• Arrays are currently supported in UD Editor
• Data Grid: change in the method of work in asynchronous work mode
• Data Grid: Support for XML data type similar to the one for BLOB is implemented
• Data Grid: DECFLOAT type support
• Editor Options: highlighting and Quick Code have been moved to the Display section
• Editor Options: the Default Settings style has been added (only border settings are applied)
• The Save Options wizard saves data in a separate thread now
• Icons are added in the Service menu
• Other minor improvements and bug-fixes

Scroll to top

 

 Version 1.0.0.1

 

• Node Properties dialog is added. The dialog allows one to view and edit a number of the DB2 Node variables and Node connection info configuration parameters for the current instance and current session which can be changed to optimize server performance
• Database Properties dialog is added. The dialog allows one to view/edit a number of the DB2 database variables which can be changed to optimize server performance
• Print Metadata: a report on the table now includes field descriptions
• Visual Database Designer: optimized the method of diagram refreshing during reverse engineering
• Creating and editing database reports is now available for limited access users
• DB Explorer: the ability to rename database groups added

Scroll to top

 

 First public release

 

Basic features:

• Rapid database management and navigation
• Easy management of all DB2 objects (including create/edit/drop operations)
• Advanced data management and manipulation tools
• Impressive data export and import capabilities
• Effective security management
• Excellent visual and text tools for query building
• Report designer with clear in use report construction wizard
• Powerful Visual Database Designer
• New state-of-the-art graphical user interface

and more...

Scroll to top

 

 

---