Mittwoch, 16 of April of 2014


Useful and free of charg tools for the z/OS Platform – not only for DB2 users:

IBM Optimization Service Center for DB2 for z/OS 

IBM Optimization Service Center for DB2 for z/OS (IBM OSC) is a workstation tool for monitoring and tuning the SQL statements that run on your DB2 9 for z/OS and DB2 for z/OS Version 8 subsystems and data sharing groups. IBM OSC provides a subset of the full suite of powerful features that are available in IBM DB2 Optimization Expert for z/OS. The most recent fix pack for IBM OSC includes support for DB2 for z/OS Version 8 subsystems (compatibility and new-function modes), support for DB2 data sharing environments, and an improved user-experience.


(Free IBM Site pre-registration required!)

IBM Data Studio Version 3.1.1 

IBM Data Studio is a no-charge offering that consists of three components: the Data Studio full client, the Data Studio administration client, and the Data Studio web console:

  • The Data Studio full client provides an integrated development environment for database administration and routine and Java application development that can be installed with other IBM software products so that they can share a common environment.
  • The Data Studio administration client is an alternative to the full client that provides a small-footprint, stand-alone integrated development environment for database administration and non-Java routine development.
  • The Data Studio web console provides health and availability monitoring features and job creation and management tools for your databases.

See also .

IBM z/OS Unix Tools and Toys

z/OS Unix Tools and Toys are freely downloadable open source unix application and other applications developed for z/OS Unix. Most packages are free (some are pointers to third party packages which may not be free). There are no warranties of any kind, and there is no service or technical support available for these from IBM.

DB2 for z/OS Exchange 

Looking for free tools, providing your tools to the community: Visit IBM’s Developer’s Exchange Site:

ISPF Query Tool 

Cardett’s free ISPF query tool for DB2 z/OS.


IBM DB2 z/OS Memory Usage Tool: The MEMU2 REXX (free download) was created to help users identify the virtual storage used by the transactions in their workload. It runs as a simple batch job, waking up periodically (default 5 minutes), and writing the IFCID225 virtual storage trace information to a line in an comma delimited output data set. And don’t miss the article DBM1 Virtual Storage – How to use MEMU2.


IBM TASID is a tool developed internally within IBM to monitor activity on a z/OS system. Note that some options may not operate correctly on all z/OS systems. All available documentation is contained in the help panels, which you can access by entering the HELP function key on any panel within TASID.

CICS Time Machine 

IBM SupportPac CH15, the CICS Time Machine, is a tool that makes it easier for you to test time dependent CICS applications. This version supports CICS TS V3.1, V3.2, and V4.1.

Free Store Clock Utility 

This IBM JavaScript tool converts internal store clock values to human readable date and time values (dd/mm/yyyy and Julian date).

Open Source Projects 

IBM’s registry of open source projects.

IBM CICS Explorer 

Free ,common, intuitive, Eclipse-based environment for architects, developers, administrators, system programmers, and operators. Looking for new ways to accelerate the transfer of knowledge, skills, and best practice to the next generation of technical staff/experts? Need to maintain productivity and protect service-levels? CICS Explorer and System z lead the way to platform simplification.

IBM’s MQ Explorer 

… is a free graphical configuration tool built on Eclipse which enables you to remotely explore and configure all WebSphere MQ objects and resources, including Java Message Service (JMS), and publish and subscribe. MQ Explorer can remotely connect to queue managers on any supported platform – enabling your entire messaging backbone to be viewed, explored and altered from one place. MQ Explorer runs on Windows and Linux (x86 and x86_64) systems. It does not need to be deployed with a WebSphere MQ client or server, and can be installed on as many machines as you require.

TRSMAIN / AMATERSE file compression 

In z/OS Release 1.9 the TRSMAIN program has been added to the BCP element of z/OS, and it has been redesigned to support large format sequential data sets. This program has also been rewritten to follow IBM programming conventions. The new utility is called AMATERSE.

Users accessing DB2 for z/OS databases on Linux/Unix/Windows workstations, don’t miss to visit also this page.