List of Contributions

+1 Regards, Ivan ------------------------------ Ivan Milojevic Comtrade System Integration Belgrade ------------------------------

Hi, Can someone clarify how Db2 Warehose (on Premise) manages client connections in case of node failover? As per documentation, it seems if we dont use HAProxy load balancer for IBM Db2 Warehouse between DB2WH and client, Db2 warehouse cannot reroute and restart client connections automatically to new ...

Larry, check if you have fully qualified hostname in server hosts file. Maybe instance creation failed because of that. It should be like for eg.: 192.0.2.214 Db2whblu1.example.com Db2whblu1 Then, restart server and try to redeploy container from scratch. Regards, Ivan ------------------------------ ...

Well, considering you are on iias, don't experiment more. There is no reason not to open SR and ask support for right approach for your demands. Also, i presume that schema level backup will be integrated as backup option in web console in one of next updates. Regards, Ivan ------------------------------ ...

Hi Frank, We are running couple dev & test of environments on VM - SMP architecture and 3.3.0 version. For some lets say "real" dwh workloads, 64G memory and 8cpu is a must for SMP. Didn't had any big issues except sorting memory overflows for complex joins, but that is not a big deal (happens on ...

Hi Ricardo, I don't have IIAS but Db2 Warehouse on premises, which is basically is the same. In my case, i have created dedicated os user "db2admin" for admin tasks that must be performed from OS, but maybe this can help you to figure out best approach for your environments/policies. Basically, if you ...

Hi, After changing some Spark configuration files (worker memory tuning etc..), i want to restart the Spark service to see the effect. I need to restart only Spark service, not Db2. What is the proper way to do this. Db2 Warehouse is on premise v3.3.0-db2wh-linux Rhel 7.5. Thx, Ivan ------------------------------ ...