UBS Log Tracker, release 2.1 is available now. The new release makes a point of its user friendliness. The ISPF based user interface has been completely redesigned, following CUA guidelines, thus streamlining ULT4DB2′s appearance and look-and-feel with the other UBS Hainer products. The idea behind the product’s new user guidance gears to allow intuitive creation of new log tracking tasks. Meanwhile the experienced user is still able to work ‘batch-oriented’ and profits from ULT4DB2′s optimized restart capacities.

Enhanced Data Propagation
Data propagation has two components: initial load and continuous propagation. After first providing the entire data volume to the target environment (initial load), the continuous propagation process must start seamlessly – and further propagations must always continue seamlessly exactly where the previous propagation chunk ended. Start and re-synchronization of data propagation and auditing are now automated extensively in ULT4DB2.

More Versatility
A ULT4DB2 task is now represented by a job chain. This makes it much simpler to reenact single working steps. The new history function documents every usage of ULT4DB2, including all options, data base objects, and files that have been used.

New User Interface
The user interface has been completely redesigned. Now, even for inexperienced users, it is much easier to create log tracking tasks. For each working mode – propagation, auditing, correction (un-do, re-do), undrop, analysis – there is a specifically adjusted user guidance that leads to creating the job chain for the desired log tracking function. The generated JCL is enabled to be executed in a job scheduler, of course.

Facilitated Undrop
Although thankfully rare, ‘un-dropping’ an accidentially deleted DB2 table space is not a trivial task. Most DB2 administrators are not familiar with this complex task and so the efficient help provided by the above mentioned revamped user interface will be surely welcome.

Definitions at One Single Place
Now it is sufficient to keep ULT4DB2′s task definitions in one single place, i.e. in one single DB2 subsystem.

General Log Analysis
Former ULT4DB2 releases always expected the user to specify DB2 object names and analyzed the log, based on such object selections. Now it is also possible to specify a time interval, inspect the log for events during the interval and – for example – thus determine DB2 tables that have been modified during that time frame.

The IDUG DB2 Tech Conference in Orlando, Florida is just around the corner! Meet UBS Hainer from April 29th – May 3rd, 2013, at booth 318.

Don’t miss our speaker slot on Wednesday, May 1st, at 1.00 pm. One of our seasoned DB2 mainframe developers will be holding a presentation on DB2 Data Management for z/OS and how different environments can be supplied with fresh data quickly, efficiently and automatically while saving resources. DB2 and IMS subsystem cloning, test data provision, in flight copies, anonymization are a few of the topics that our speaker will cover.

The presentation will be held by our in house z/OS DB2 expert Kai Stroh. Kai specializes in creating innovative new applications and utilities for DB2 – working onsite and remotely with international clients worldwide. He knows his way around DB2 dumps and the differences you need to consider when moving data and definitions across DB2 versions as well as inhouse DB2 subsystems.

‘Ask the developer’: We offer private one hour slots Monday through Friday during non-exhibit times. Email Susanne Tursman (s.tursman@ubs-hainer.com) to book your Q&A session now and find out how to improve your specific Copy/Clone/Migrate/TDM projects.

IDUG Orlando at a Glance:

Vendor: UBS Hainer / ESAi
Booth: 318
Speaker slot: Wednesday, the 1st of May, 1.00 pm
Personal sessions: Every morning during non-exhibit hours

Please join us for our free Webinar and learn why companies like Home Depot, Volkswagen, Audi, Lincoln Financial and many others opted for the BCV solution.

The requirement to copy DB2 data has become an increasing concern in recent years. Whether providing test data for quality assurance or for application development, there is a need for an efficient and reliable tool to do the job.

Test and QA teams need up-to-date test data at an affordable price, but at the same time, they also need flexibility in regards to automatic adaption, conversion, renaming and DDL deviation handling.

With BCV5, we designed a tool to copy large amounts of DB2 data quickly and efficiently within a DB2 group or from sysplex to sysplex. BCV5 is commonly used to copy test data from a production environment to environments that serve quality assurance, acceptance testing and throughput capacity loading. Its high efficiency rating and low CPU time consumption allow it to be used both in ad-hoc daily work and on a nightly basis, without impacting critical operational windows. Once a copy task is defined it may be executed at any time under BCV5′s control or fully automated under an in-house scheduler.

BCV5 offers unmatched functionality, ease of use and savings of up to 90% in the areas of:

• Elapsed wall-clock time
• CPU time
• Staff time and effort

z/OS Library Validation and Software Asset Management

“Find out what’s needed. If you don’t use it, get rid of it”- still clichés in today’s computer budget meetings. With P-Tracker you have a software monitoring tool for z/OS mainframe systems that not only tells you which software products and inhouse modules have been truly accessed but how much they’re being used and by whom.

P-Tracker will ensure every module of every product and application you identify to it is monitored for usage on your z/OS system and sub-systems (CICS, IMS, ..). And you’ll know who’s using it. Knowing which modules are used means you know which features are used in your current systems, and which systems are obsolete.

If your job is to continue to reduce mainframe software costs at your organization, or look at options regarding system replacement costs, then P-Tracker automates the delivery of the current usage information you need to be in charge of negotiations:

• P-Tracker detects and identifies software products your installation isn’t using anymore, so you can cancel rental or maintenance on them, and cease supporting them.
• P-Tracker identifies the users of lightly used products, so you can find out if their software needs can be met in other ways.
• P-Tracker helps you find software that’s installed on the wrong system, so that you can remove it.
• P-Tracker finds all modules that are used to ensure that you will convert the right modules and features when migrating to new systems

We hope you find this product covers all areas required by your own internal review/audit. Should you or any of your staff have any queries please do not hesitate to contact us.

To learn more about P Tracker benefits, request your product demo or order a trial evaluation. See panel to your right for more information and product links.

Log Processing made simple The DB2 Log provides valuable information that can be of use in many regards. For example to replicate or propagate data to other databases, to repair corrupted data or processing errors, to ‘undrop’ data, for performance and quality analysis and, last but not least, for review and audit. Often it is necessary to know, who changed what? ULT4DB2 generates best practice audit reports and allows for ad hoc analysis.

ULT4DB2 – Superior Reporting ULT4DB2 Reports honour arbitrary grouping, i. e. users may specify any combination of the following variables to group and filter the report data: User ID, Plan, Logical Unit of Work, Unit of Recovery, Database, Tablespace, Table. Selection Patterns as well as Start and End Log Scan time are displayed in the report header. The user may also specify the report title.

Example REPORT “My Report” GROUP BY ( USER , PLAN , LUW , UR , DATABASE , TABLESPACE ) PLAN Q* A* C* D* U* W* K* DATABASE S86*;

ULT4DB2 is known as an easy to use Log Analysis and Log Tracking Tool for DB2 z/OS. It is equally suitable for Data Propagation to other systems or platforms, for Auditing and for Data Correction.

Database administration, application development and maintenance programmers use ULT4DB2 to repair the result of an incorrect program execution, a wrongly scheduled job or other user errors. Auditors and administrators deploy ULT4DB2 to determine update sequences. Data centers replace expensive data propagator tools because ULT4DB2 offers reduced CPU consumption and reasonable license conditions. Database administrators use ULT4DB2 to analyze update frequencies and idle times.

ULT4DB2 provides a user friendly ISPF interface to make life easy. Different types of users (DBAs, auditors, system and application programmers) can use this flexible tool for a wide range of functions.

ULT4DB2 makes dealing with one or hundreds of tables a simple procedure. It provides a number of flexible functions to select and treat many objects simultaneously. Intuitive templates make enforcing naming standards an error free task.

To learn more about ULT4DB2 benefits request your product demo or order a free trial.