From db2mc

Explore all Technology Explorer for IBM DB2 related downloads

IBM_DB2 driver for PHP

IBM DB2 PHP driver for Windows

Technology Explorer for IBM DB2

Explore all Technology Explorer for IBM DB2 packages

Technology Explorer for IBM DB2 v3.5

Downloads

Explore all files

Windows ZIP file	:	Technology_Explorer_v3.5.463.zip
Unix tar.gz file	:	Technology_Explorer_v3.5.463.tar.gz

Change Log v3.3.463

(rev. 463)

• New 9.7 tutorials and feature demonstrations
  • Dynamic Schema Change
  • Created Global Temporary Table
  • Inline Lobs
  • 9.7 Automatic Compression
  • PL SQL Support
  • Truncate Table Command
• Tools->Monitor (DB2 9.7) - new DB2 9.7 monitoring
• Tools->Storage Management (DB2 9.5+)
• Health - Monitoring views have been added
• View->Catalog - new views have been added
• View->Dictionary - views have been added
• View->Configuation->Compatibility - will display the compatibility mode of your DB2 9.7 database
• The table rendering Modula has been replaced to allow for greater expansion and flexibility. You can now have:
  • Dynamic Columns
  • Improved Table display
  • Right clicks on table
  • Advanced data searches
  • Fixed column headers (Not enabled by default on IE due to JavaScript performance)
  • Profile Query view – displays the core query used in the dataset
  • Table refreshes happen inline (no more flickering)
• Table definition files now support multiple Graphs.

Alpha Release - Technology Explorer for IBM DB2 v3.5

Welcome this is first release of the 3.5 branch. This branch is in alpha. The branch is stable, but there are some components such as the graphing package that are still broken.

This release mainly focuses on the rewriting of the table display components to better accommodate extension in future releases and UTF8 character sets. As such the main focus is to enable all feature previously supported. There will be some new features added this release but this is not the primary focus of this release.

That said YOU really should have a look at the new table rendering module.

What new:

• Right click menus within a table. some feature that were previously visible icons have moved under these menus.
  • detailed row view can be accessed by right clicking on the row header
  • column filter or drill down can be accessed by right clicking the cell of the value you wish to filter by

• Advances search features.
• Values are only encoded when absolutely necessary.
• The WITH portion of the Select statement can now be used (and you can define these in the table definition file) these can be added with in the a table definition file by using the following tags:

<commonTableExpressions>
  <inline>a common table expression</inline>
  <externalfile fileName=""/> //a file containing a common table expression
  <externalqueryfile tablename="" columnList="" fileName=""/> // will generate a common table expression like this : tableName(columnList) as ( fileContents )
</commonTableExpressions>
//see here for more information http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.sql.ref.doc/doc/r0000879.html

• and more...

This release has only been tested on Firefox 3 and is know not to work on Internet Explorer (It will just not yet). You will also require v1.8 or new of the PHP IBM_DB2 driver which we are working to get a built windows binary up and accessible.

I am looking for feedback on the new interface. It is possible that is will be a bit slower right now I have not done any rendering optimization though it seems to be just as fast as the old version, if it is significantly slower then the old version please let me know and give me the specification on what you are running. (That said if you want it to be really fast try chrome).

Downloads

Explore all files

Windows ZIP file	:	Technology_Explorer_v3.5.284_alpha.zip
Unix tar.gz file	:	Technology_Explorer_v3.5.284_alpha.tar.gz

Change Log v3.3.284_alpha

(rev. 284)

• first alpha release

Final Release - Technology Explorer for IBM DB2 v3.3

Downloads

Explore all files

Windows ZIP file	:	Technology_Explorer_v3.3.285.zip
Unix tar.gz file	:	Technology_Explorer_v3.3.285.tar.gz

Change Log v3.3.285

(rev. 285)

• Changed navigation icons to eliminate any possibility of IP concerns.

Change Log v3.3.238

(rev. 238)

• Fixed - [ 2671043 ] New connection screen failure
• Temp Fix - [ 2685584 ] Error in handling of numbers in some languages

Change Log v3.3.234

(rev. 234)

• Added - Preferences directory for custom config.php file, new tab link and TE homepage.
• Added - Double click on connection in connection panel will being up connection screen or set it to the default connection
• Added - 2524435 - Federation support in tablecat and other views
• Added - 2638405 - Cursor change request
• Fixed - 2662228 - Set Default Schema Display errors
• Fixed - 2662131 - PHP warnings received on view department table
• Fixed - 2662082 - Fatal error receieved on employee record edit
• Fixed - 2642962 - Dataserver Information PHP warnings
• Fixed - 2642871 - New connection php warning
• Fixed - 2642859 - Connection panel initial display buttons
• Fixed - 2642843 - Removing connection errors
• Fixed - 2642820 - Connection Panel updated information
• Fixed - 2642305 - IE7 - AdHoc Results panel display error
• Fixed - 2641816 - Past tense modification
• Fixed - 2638547 - Sample database – add rows
• Fixed - 2638484 - IE6 & IE7: add bullets to ad-hoc history list
• Fixed - 2638330 - Task Scheduler - Task Details
• Fixed - 2638280 - IE7 - Task Scheduler - New Scheduled Task title bar
• Fixed - 2638270 - Task Scheduler - New Scheduled Task spelling
• Fixed - 2638268 - Safari - Task Scheduler - New Scheduled Task
• Fixed - 2638250 - IE7 - Vertical split panel divider not shown
• Fixed - 2638124 - IE7 - Split panel min/maximize buttons
• Fixed - 2638106 - IE7 - New connection modal form display

Change Log v3.3.1

(rev. 185)

• Fixed - Error where new connection would not show up is the connection file was not writable
• Fixed - Error where Tutorial would not closed
• Added - Global Action scripts
• Added - "actionList_*.xml" files in the action script directory to load global action scripts
• Added - callGlobalAction tag in the action script, this tag works similar to the gotoAction tag, but can only call the top action of the global action script on first call

Change Log v3.3

• Added - Tutorial Source code highlighting
• Added - XML Abstraction layer
• Added - Ad Hoc UTF-8 Compatibility
• Added - Redesigned connection panel
• Added - Multiple database connection can now be registered and quick switched between them
• Added - Added the ability to link to individual tutorial pages from within a tutorial
• Added - Eliminated requirement for ?SCHEMA? in tutorials
• Added - Execute SQL stored procedures through the ad hoc
• Fixed - Page down no longer hides menu
• Fixed - tablecompressionstats.xml fix see: 2500165
• Fixed - Several bug fixes and added features see: 2591794 - Peter Prib

Technology Explorer for IBM DB2 v3.1.67 - RC1 Release

Downloads

Explore all files

Windows ZIP file	:	TechnologyExplorer_for_IBM_DB2_v3.1.67_RC1.zip
Unix tar.gz file	:	TechnologyExplorer_for_IBM_DB2_v3.1.67_RC1.tar.gz

Change Log

• Fixed - title appears below nav menu when XML definition is generated from the views catalog page
• Added - Auto greatened catalog of all table definition file
• Fixed - SESSION_TIMEOUT_IN_MIN would necessarily time out with in the time given
• Fixed - submit button appearing below the visible area on IE7 when adding a new row
• Fixed - floating panel resizing would not handle small areas well
• Fixed - Links in 'enter new row' page
• Fixed - Links located in the information panels
• Fixed - link for tablespace icon
• Fixed - Ad Hoc - text area does not resize after you reload the tab that the Ad hoc is on
• Fixed - Clear results in Ad hoc does not clear result in console
• Fixed - auto-refresh - Monitoring table spaces, utilization
• Added - better error reporting on inserts and updates
• Added - History now preserves post data
• Fixed - IE task scheduler progress bar was not centered
• Fixed - tutorial page navigation menu sizing for tutorial with lots of pages
• Improved - drop schema - message formatting
• Fixed - IE7: XML generation opens extra tab
• Fixed - IE7 ah-hoc save/load centering
• Fixed - display errors with safari floating windows
• Fixed - IE6/7: sql error causes tall title bar permanently become enlarged
• Fixed - Tablespace icon link in Buffer Pools
• Fixed - information buttons
• Fixed - action in detailed view
• Fixed - ad-hoc editor sizing issue - formatting
• Fixed - Ad hoc window sizing issues in chrome
• Fixed - Ad Hoc Run button does not work in Chrome
• Fixed - IE6 & IE7, ad-hoc button display were cut off
• Fixed - corruption of connStore.xml
• Fixed - Ad Hoc Panel - if more then 1 result set is return keep the console on top
• Fixed - Include XML data in generated table definition treat as long data
• Improved - Drop schema action
• Added - XML definition link now includes a comment to indicate the file name and location

DB2 Monitoring Console - The origins of the Technology Explorer

These packages are no longer maintained

[Explore all DB2 Monitoring Console downloads]

Setup Instructions

Explore all Setup Instructions downloads

Documentation

Explore all Documentation downloads