List of Contributions

Guido Verbraak

Contact Details

My Content

1 to 9 of 9 total
Posted By Guido Verbraak Thu March 14, 2024 04:23 AM
Found In Egroup: Db2 for z/OS & Db2ZAI
\ view thread
Hi, You need the JDBC Db2 connect license file for connecting to Db2 z/OS unless you have the Db2 connect license applied on the Db2 z/OS level. If there is no license, on the server side or client side, you will not be able to connect. Met vriendelijke groet/kind regards. Guido Verbraak Managing ...
Posted By Guido Verbraak Tue January 24, 2023 05:16 AM
Found In Egroup: Global Data Management Forum
\ view thread
Hi Raj, You can certainly do that but you have a number of considerations regarding recovery/restore and data consistency. (in flight transactions), file system layout etc. I would recommend to explore the regular Db2 backup/restore functionality first and then consider backup methods that are kind ...
Posted By Guido Verbraak Tue August 24, 2021 03:32 AM
Found In Egroup: InfoSphere Optim
\ view thread
Hi Qiong, Yes it works. I have a Windows 2019 Server with the entire Optim stack up and running. This is in a kind of sandbox setting, but in normal operation I have not encountered any issues. It is indeed not officially supported yet Guido Verbraak ------------------------------ Guido Verbraak ...
Posted By Guido Verbraak Tue December 01, 2020 03:19 AM
Found In Egroup: Db2
\ view thread
Hi, That behavior is strange indeed. What you could do is: Relocate the archivelog location to a mounted volume in docker so you do not blow up your container, just to mitigate the issue. After that you could try to take a backup and prune afterwards to see if that will help. I see auto_backup ...
Posted By Guido Verbraak Thu September 24, 2020 03:28 AM
Found In Egroup: Db2
\ view thread
Hi, the link was changed to a technote, it now also includes the shell script https://www.ibm.com/support/pages/node/6334641 ------------------------------ Guido Verbraak ------------------------------
Posted By Guido Verbraak Thu August 13, 2020 05:10 AM
Found In Egroup: Db2
\ view thread
Hi Ben, The driver versions are important for the functionality that they facilitate. If you would for instance use only insert/update/delete/select etc, you could probably work with an older driver. It is not recommended of course. However, if you want to start using new functionality that has come ...
Posted By Guido Verbraak Wed July 01, 2020 04:02 AM
Found In Egroup: Db2
\ view thread
Hello Guy, To me it seems you could use mon_get_activity to capture both the statement and the connection information by utilizing the fields CLIENT_ACCTNG CLIENT_APPLNAME CLIENT_USERID CLIENT_WRKSTNNAME. If that does not deliver enough info you could consider joining it with mon_get_connection ...
Posted By Guido Verbraak Fri January 24, 2020 02:59 AM
Found In Egroup: Db2
\ view thread
Hello, If you want to retrieve memory information you can have a look at the MON_GET monitor functions that come with Db2. They have an SQL interface and are very easy to use and to interpret. MON_GET_MEMORY_SET and MON_GET_MEMORY_POOL. ------------------------------ Guido Verbraak IBM ...
Posted By Guido Verbraak Tue July 02, 2019 09:18 AM
Found In Egroup: Integrated Analytics System
\ view thread
On the IIAS, column storage is the default storage method. That method has data compression enabled by default and is not an option that can be switched on/off or changed in behavior. The compression is a mix of compression algorithms and methods. ------------------------------ Guido Verbraak IBM ...