Click4DB is for the moment only available the z/OS® platform.
Click4DB use ODBC driver to connect to your DB2's®. You need a DB2 z/OS® licence from passport Advantages on IBM site. As your queries access DB2 via the DDF, most of them are zIIP eligible.
Click4DB is using some standard stored procedures as delivered in the sample library. Most sites have already those procedures defined and running.
It depends of you PC's speed but most of the customers install Click4DB within a few minutes. At first installation, the only thing to do afterwards is to define the connections (database, ip and port) you want to work with.
No specials privileges are required for the installation process. Click4DB programs and data can be installed in the standard "Program Files" and "ProgramData" folders as well in user defined folders.
Click4DB is intended for z/OS® DB2® System Administrators. As such, it requires the same privilege as those to execute a System Administor job.
Yes. You can join, union data from queries, stored procedures, command outputs and CSV files.
Yes, the limit of your history is based on your available space.
Yes, we can work with Clob columns like "STATEMENT" in SYSIBM.SYSPACKSTMT.
Click4DB selects and agregates data from all the DB2® defined as active connections. An extra column is added in the resultset so it can be used in further manipulation.
No, if you can access them you can compare them without limit. And of course the response time will increase depending on the number of target subsystems and the heaviness of the requests.
Yes, you just have to specify the location of your KeyStoreDB and KeyStash files.