HPE Ianus

Version 5.1.2

Ianus is a multi-purpose, generalized, data comparison and movement tool, capable of:

• Comparing heterogeneous RDBMS tables content
• Comparing heterogeneous RDBMS stored procedures output (resultsets & parameters)
• Comparing data files content
• Copying tables across heterogeneous RDBMSs
• Copying and converting files with layout safe conversion
• Dumping and formatting files
• Submit jobs to JES subsystems
• Execute user defined tasks
• Execute PowerShell scripts

Follow this link for the documentation.

Changes

5.1.2 - 2025-03-11-15-59-02

• fixed ianus.sh for correct casing
• CLOB support

5.2.2

• general setting for explicitlayoutconversion

5.1.1 - 2024-11-04-09-21-05

• fixed bug with DB2 VARBINARY and bit data codepage
• improved charasbinary mechanism with proper codepage

5.1.0 - 2024-10-11-10-04-47

• Implemented internal SORT routine (MFSORT no longer required)
• Implemented BINARY and VARBINARY data types for DB2

5.0.1 - 2024-06-25-16-12-00

• Added support for MFES pre-V9 (MFES Classic) JCL submit

5.0.0 - 2024-06-21-10-18-56

• Upgraded to .NET 8
• Changed WIN vs LINUX binaries generation mechanism
• MFES native API replaced by MFES REST API
• fixed PGSQL stored procedures management
• Added containerized version
• Added support for MARS catalog and VSAM files

4.1.5 - 2024-05-09-14-10-24

• implemented FLOATING POINT conversion
• fixed codepage IBM1145 (corrected � for ASCII to EBCDIC)

4.1.4 - 2024-02-23-17-18-39

• fixed packed comparison mechanism

4.1.3 - 2024-02-23-16-21-45

• added Compare by Collate in FileCompare task
• added extra traces for key comparisons

4.1.2 - 2024-02-08-10-38-15

• added DB2 z/OS ROWID management

4.1.1 - 2024-01-29-14-42-29

• added check on layouts length
• added experimental support for DB2 REAL, DOUBLE/FLOAT, CLOB, BLOB
• added auto cast to TIMESTAMP for DB2 TIMESTAMP WITH TIMEZONE (TIMESTZ)

4.1.0 - 2023-11-17-07-53-58

• implemented key based comparison for files
• implemented differences tracking in the tracking DB
• implemented Tracking DB over PgSQL

4.0.18 - 2023-10-18-12-26-15

• extended oracle varchar workaround to HEX column encoding

4.0.17 - 2023-10-10-19-10-04

• CLOB are managed as VARCHAR for the sake of Oracle workarounds

4.0.16 - 2023-10-02-17-31-54

• added explicitconversionmode to layouts

4.0.15 - 2023-09-04-16-37-20

• fixed length management in tablecopy charasbinary mode for convert

4.0.14 - 2023-09-04-12-56-35

• added direct charasbinary mode to tablecopy convert

4.0.13 - 2023-07-27-10-28-58

• added order to tablecopy

4.0.11 - 2023-07-10-10-46-56

• added path attribute to cobol layout element
• added PGSQL database for listcat processing
• added error and warning thresholds to execute task
• added db2timestampfix to tablecopy and tablecompare

4.0.10 - 2023-05-29-07-29-05

• site licenses

4.0.9 - 2023-05-26-09-25-34

• added converterstohex to table copy and load
• several fixes to column converter handling

4.0.8 - 2023-04-18-15-27-55

• oraemptyvarcharfix enabled for NULLABLE VARCHAR columns too on hybrid copy

4.0.7 - 2023-04-17-17-06-10

• oraemptyvarcharfix enabled for NULLABLE VARCHAR columns too

4.0.5 - 2023-03-27-10-02-56

• automatic CAST to BIT DATA / BINARY type for columns converted with layout
• multiple matcher scripts for columns converted with layout

4.0.4 - 2023-03-01-17-11-15

• fixed unhandled default for delete attribute in tablecopy
• added destination partition name option for oracle bulkcopy (in tablecopy and tableload)
• added execute task
• fixed NULL management for tablecopy with charasbinary

4.0.3 - 2023-02-08-15-48-53

• added warning when layout columns are not of BIT DATA

4.0.2 - 2022-11-21-14-20-49

• fixed bug for tableunload with NULLable columns

4.0.1 - 2022-11-07-07-53-06

• tableload/unload added DSNTIAUL and UNLOAD formats, NOPAD and headerlen attributes
• added SYSPUNCH management to tableload
• added layout (single & multiple) based column conversion and comparison in tablecopy, tablecompare, tableload and tableunload
• updated DB2 & PostgreSQL drivers

4.0.0 - 2022-09-15-06-46-25

• upgraded to .NET 6
• repository endianness default set to big

3.13.3 - 2022-08-02-10-14-08

• RESOURCE added to Oracle reserved words list

3.13.2 - 2022-07-11-07-41-48

• LEVEL added to Oracle reserved words list
• row count made optional on tablecompare task

3.13.1 - 2022-06-15-07-59-10

• ZONED signed configured at repo level or via layout or directives

3.13.0 - 2022-06-15-07-11-12

• fixed ZONED sign management to match SIGN(EBCDIC)
• added PATH extraction in listcat task
• more traces for MFES jcl submit
• fixed database purge jobs command

3.12.4 - 2022-04-28-10-16-40

• changed ILayoutMatch interface to pass the repository encoding
• added option to make JCL submit operation synchronous
• fixed bug with PICTURE clause ZZZ,ZZZ,ZZ0
• fixed bug with MIXED char padding

3.12.3 - 2022-03-29-15-58-34

• added maxwarnings option to filecopy

3.12.2 - 2022-03-28-18-20-31

• added checktabs feature to copycheck
• fixed COBOL layout comma management in picture clause
• added listcat task
• increase performance of license verification mechanism and reduced start-up time
• added warneverydbcserror option to filecopy/filecompare
• enhanced log mode task

3.12.1 - 2022-03-16-18-00-00

• added -l command line option

3.12.0 - 2022-03-16-16-02-21

• improved file I/O performance
• added file buffer size tuning mechanism
• changed logs configuration mode and added task log mode

3.11.2 - 2022-03-15-11-06-38

• added originating tasks in the report
• added suffixindex option to foreach task
• added additional traces for pre/post actions

3.11.1 - 2022-03-11-12-05-11

• implemented hybridasync mode for tablecopy
• fixed bug with exactmatch in foreach/generate tasks

3.11.0 - 2022-03-09-09-55-40

• updated DB2 data Provider
• added exactmatch option to foreach

3.10.3 - 2022-02-17-12-45-21

• implemented edited picture format "----9"

3.10.2 - 2022-02-15-15-58-48

• warnings for malformed/wrong DBCS sequences implemented for file operations too
• job abort get correctly tracked in case of CTRL-C

3.10.1 - 2022-02-10-18-33-05

• fixed package incompatibility causing XLSX report generation to fail

3.10.0 - 2022-02-09-11-49-45

• added tracking database query mechanism
• improved tracking database data model (WARNING: requires database changes)
• added dedicated report for generate task
• changed default log file layout

3.9.19 - 2022-01-26-09-27-12

• fixed bug with pre/post actions

3.9.18 - 2022-01-25-11-49-11

• added removeemptylines option to generate task

@3.9.17 - 2022-01-18-10-10-05@

• improved DBCS error logs

@3.9.16 - 2022-01-12-08-59-26@

• added exclusion mechanism for charasbinary
• changed DBCS error logging mechanism

3.9.15 - 2021-12-17-05-30-29

• fixed bug for the comparison Oracle DECIMAL columns with 10 to 15 digits
• fixed UNICODE whitespace trimming for filecompare
• added whitespace management options for filecompare

3.9.14 - 2021-12-06-08-46-43

• added delete mode for tablecopy

3.9.13 - 2021-12-03-06-37-20

• fixed exception in case of malformed MIXED data
• added count option for tablecopy

3.9.12 - 2021-11-25-09-06-45

• synchronized access to environment resources

3.9.11 - 2021-11-24-13-43-25

• reorganized DBCS conversion traces in tablecopy

3.9.10 - 2021-11-24-12-05-09

• "correct" mode added for dbcs error management
• added mechanism to tablecopy to log all columns in case of error loading a row
• added option --disable-multi-thread

3.9.9 - 2021-11-18-16-34-15

• fixed bug with bitdatacodepage in multithreaded mode

3.9.8 - 2021-11-18-07-56-39

• added charasbinary conversion and comparison mode

3.9.7 - 2021-10-26-09-24-30

• added directive enabled in COBOL layouts
• added support for resource type collection in generate and foreach tasks

3.9.6 - 2021-10-21-17-19-52

• fixed unpredictable behavior of occurs clauses in filecompare

3.9.5 - 2021-10-20-12-08-55

• added resources faciltiy
• added resources task
• fixed minor encoding issues
• extended API set for UserFields

3.9.4 - 2021-10-18-14-17-10

• Fixed ColumnMatcher plugin management at configuration level
• extended API for Codepage cloning
• fixed MIXED data to UNICODE conversion routine

3.9.3 - 2021-10-06-12-04-20

• extended API set for custom tasks

3.9.1 - 2021-10-05-11-03-28

• added numeric validation for filecopy
• implemented batchsize management for hybrid tablecopy
• memory check job option added

3.9.1 - 2021-10-01-08-03-03

• added pad mode setting for mixed data file copy/conversion
• changed pad mode default to shift-out for mixed data file copy/conversion

3.9.0 - 2021-09-23-17-22-47

• added ColumnMatcher plugins for tablescan task
• added User Fields for files
• change ColumnConverter and ColumnComparator interfaces

3.8.10 - 2021-09-03-10-15-35

• fixed variable record length read routines to avoid abort on malformed RDW
• added task methods for powershell actions and tasks
• changed powershell action return code mechanism

3.8.9 - 2021-08-31-11-20-03

• fixed synchronization between resource release and and post actions
• added '-' and '.' picture formats

3.8.8 - 2021-08-30-10-14-30

• added repository output option to generate task
• added support for COBOL layouts made only of an elementary 01 level field
• added copycheck task
• COBOL layout parsing support for INDEXED BY
• forcesosionencapsulated option added for mergeencapsulateddbcs

3.8.7 - 2021-08-05-10-35-27

• improved include diagnostics

3.8.6 - 2021-08-04-11-07-11

• implement stoponloaderror for foreach task

3.8.5 - 2021-08-04-09-32-29

• task jcl action remove temporary JCL

3.8.4 - 2021-08-03-17-12-33

• added MFES extensions to distribution package

3.8.3 - 2021-08-03-13-12-33

• converter definition forces bulk tablecopy to default to hybrid

3.8.2 - 2021-08-03-08-34-10

• improved diagnostics for foreach task
• improved foreach inetrpolation mechanism
• added command line option sto disable task actions
• minor bug fixes

3.8.1 - 2021-07-27-13-11-19

• IMS verificationtask enahnced
• Implemented automatic transformation of encapsulated DBCS fields in filecopy
• Added column converter plugin
• Layout name forced as layout also for COBOL layouts

3.8.0 - 2021-06-24-13-09-12

• updated MIXED data conversion routine
• implemented field (REDEFINES) enablement for filecopy/filecompare
• implemented first/last record as text

3.7.8 - 2021-06-14-07-37-56

• added IMS export copy and verification task
• implemented repository type for collection based tasks
• added skipinvalid parameter to filecopy task

3.7.7 - 2021-05-07-11-01-16

• added additional for file related tasks

3.7.6 - 2021-05-05-14-00-29

• tablecopy defaulting to hybrid when mode=bulk and data replace active
• fixed bug on mixed chars file comparison
• added diagnostic for inner exceptions on filecopy and filecompare

3.7.5 - 2021-05-03-04-52-44

• order mode "all" for tablecompare
• pre/post actions

3.7.4 - 2021-04-13-14-52-46

• cache mechanism for remote file repos
• diagnostics improved in tablescan

3.7.3 - 2021-04-08-14-37-39

• ebcdicbinaries option renamed to bitdatacodepage
• added tablescan task

3.7.1 - 2021-04-01-14-06-35

• minor fix to job progress monitor

3.7.0 - 2021-04-01-07-17-17

• implemented max parallel task control
• oracle truncate fixed for reserved names
• added SYDATE to list of DB2 reserved names
• added IDENTITY management
• added dashboard and progress monitors
• standardized job identification (db, xls, log)
• foreach tasks changed to add tasks right after itself

3.6.1 - 2021-03-24-17-01-14

• minor fixes to diagnostic messages
• fixed bug on oracle reserved names quoting routine
• minor fix to tablecopy and tablecompare XLS report
• added "first only" option to tablecopy

3.6.0 - 2021-03-23-12-13-21

• added index mode for order clause on tablecompare
• added ifdef/ifndef step conditions
• added workaround for Oracle zero length VARCHARs
• extended support for environment variable to all task elements and attributes

3.5.2 - 2021-03-15-15-43-45

• fixed reserved words management for columns in the tablecompare query
• added row number in row differences log entries

3.5.0 - 2021-03-15-10-26-05

• added checks on DBCS fields definition
• added database reporting details for recently added tasks
• fixed XLS reporting issues with disabled tasks
• added support for Oracle and DB2 as Ianus tracking database
• added configurable COLLATE clause

3.4.2 - 2021-03-05-10-11-13

• simplified DBCS traces

3.4.1 - 2021-03-05-05-52-53

• implemented DBCS table definition as value pairs

3.4.0 - 2021-03-02-07-21-49

• added generate task
• fixed excel import task

3.3.0 - 2021-01-11-11-52-44

• added fileformat task
• added skip and count to filecopy
• added text, mixed and dbcs mode to filecopy
• added binary mode to filecompare
• implemented field tagging in COBOL layouts

3.2.0 - 2020-12-02-06-55-14

• upgraded to .NET 5.0
• New license key mechanism added
• Bulk copy in tablecopy task with DB2 and Oracle targets
• Bulk copy in tableload task with SQL Server, DB2 and Oracle Targets

3.1.0 - 2020-11-17-10-43-42

• Pluggable codepages
• DBCS (shfted and non shifted) fields support for data file
• Support for GRAPHIC, NCHAR & NVARCHAR columns
• added fileedit task
• added tableload/tableunload tasks
• added directory type collection for foreach task
• added filedump task

3.0.1 - 2020-10-14-14-24-49

• (internal restructuring)

3.0.0 - 2020-05-06-11-29-56

• Migrated to .NET core 3.1
• PowerShell task upgraded for PowerShell 6
• Removed IANUSSEE

2.0.0.0 - 2019.06.04 10.59.10

• added license control mechanism

1.8.1.0 - 2019.03.21 11.22.48

• fixed large packed decimal fields display routine
• fixed IsLowValue method on file layout AbstractField
• diffslimit parameter added to comparison tasks
• append parameter added to filecopy task

1.8.0.0 - 2017.10.19 09.07.12

• PostgreSQL support added

1.7.4.0 - 2017.05.09 10.51.16

• DB2 table keys retrieving process changed

1.7.3.0 - 2017.01.19 06.43.53

• Fixed VARCHAR(MAX) parameters bug

1.7.2.0 - 2017.01.10 08.55.56

• fixed bug on OCCURS management for COBOL layouts
• added trimcolumnandparametersnames parameter to database definition

1.7.1.0 - 2016.12.15 05.32.14

• fixed bug in OCCURS management

1.7.0.0 - 2016.11.04 08.23.28

• added possibility to create user tasks
• added setenv task
• added sql task
• added excel task
• added comparecharstrimmed option to filecompare
• fixed erroneous representation of large zoned fields (PIC 9(13))

1.6.2.0 - 2016.10.10 14.09.10

• fixed stored procs rollback management bug

1.6.1.0 - 2016.10.04 09.53.23

• added offset/length based key definition for sort in filecompare/filecopy
• minor fixes to COBOL layout parser

1.6.0.0 - 2016.09.05 09.50.28

• added file sort mechanism to filecompare and filecopy
• added trailing NULL/SPACE character management for database comparisons

1.5.1.0 - 2016.08.30 11.58.53

• enhanced TIMESTAMP vs CHAR/VARCHAR comparison to handle also partial input (ie DATEs)

1.5.0.0 - 2016.08.30 08.42.55

• added order option to tablecompare
• added user comparators to tablecompare and spcompare
• transaction management on spcompare
• interface IRowComparatore refactored to IRecordComparator
• added comparsion between TIMESTAMP and CHAR/VARCHAR (not FOR BIT DATA) in tablecompare/spcompare
• auto switch to parallel compare when all PKs are excluded from comparison

1.4.4.0 - 2016.07.30 07.55.30

• added stopon option

1.4.3.0 - 2016.07.29 13.21.34

• fixed issue with sys.procedures case

1.4.2.0 - 2016.07.28 12.08.09

• added filecopy task
• added powershell task
• added environment variables interpolation in configuration file

1.4.1.0 - 2016.07.22 12.36.52

• added excel job report
• minor bug fixes

1.4.0.0 - 2016.07.20 05.20.24

• added stored procedures resultsets management options (sort, ignore)
• added foreach task generator
• added store and success options to jclsubmit (removed threshold)
• fixed precision loss on copy to DATETIME2
• added tablecopy bulk mode for SQL Server
• added switch to enable/disable sort of tablecopy input
• added support for MFES Classic JCL submit
• added userscript task

1.3.3.0 - 2016.07.07 19.14.36

• User's Guide updated

1.3.2.0 - 2016.07.07 19.07.18

• fixed system tables access for stored procedures on DB2 for z/OS
• minor fix to BINARY (BIT DATA) data comparison

1.3.1.0 - 2016.07.07 15.10.22

• added database default collate option
• added database default ebcdicbinaries option
• Support for IBM Data Driver 11.1

1.3.0.0 - 2016.06.24 08.34.29

• parallel tasks execution (multi-threading)
• JES interaction at JESINTERFACELEVEL=2
• minor refactoring of Ianus API

1.2.2.0 - 2016.06.10 11.55.39

• support for IBM JES submit
• fixes for zOS file repositories

1.2.1.0 - 2016.06.08 10.36.24

• support for DB2 over SQL linked server
• binary (BIT DATA) columns EBCDIC to ASCII conversion
• system queries logging

1.2.0.0 - 2016.04.27 13.11.02

• COBOL layouts management
• External comparison plug-in
• MFES for .NET JCL interface
• JCL Submit Task for MFES for .NET

1.1.0.0 - 2015.12.04 11.16.53

• Upgraded to .NET 4.6.1

1.0.4.0 - 2015.10.07 12.27.20

• Added User's Guide
• Minor improvements to the log configuration

1.0.1.0 - 2015.10.07 12.08.12

• Added TableCopy task
• Other minor improvements and fixes

1.0.0.0 - 2015.09.24 12.39.09

• First official release
• Database comparison
• Stored procedures comparison
• Files comparison
• Remote repositories via FTP