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.