List of Contributions

Ivan Milojevic

Comtrade System Integration

Contact Details

Comtrade System Integration

My Content

1 to 17 of 17 total

RE: Db2 with Pacemaker in ASYNC mode issue

Posted By Ivan Milojevic Wed March 06, 2024 09:42 AM
Found In Egroup: Db2 \ view thread
I'm not sure that someone would just decide to complicate this kind of setup just because of ASYNC mode. But thanks for the suggestion anyway. ------------------------------ Ivan Milojevic Comtrade System Integration Belgrade ------------------------------

RE: Db2 with Pacemaker in ASYNC mode issue

Posted By Ivan Milojevic Wed March 06, 2024 08:47 AM
Found In Egroup: Db2 \ view thread
On the other hand, it is not realistic for me that Pacemaker as a cluster resource manager that strategically replaces TSAMP has this kind of restriction, because in a real life scenario it is almost impossible for SYNC or NEARSYNC modes to be the only ones used on production systems where in fact SYNC ...

RE: Db2 with Pacemaker in ASYNC mode issue

Posted By Ivan Milojevic Wed March 06, 2024 08:18 AM
Found In Egroup: Db2 \ view thread
Thanks, i probably missed that because I was focusing on the Pacemaker restrictions: https://www.ibm.com/docs/en/db2/11.5?topic=pacemaker-restrictions But i found this somehow unclear because of mentioned defect document (advise to Upgrade to Db2 11.5.8 or later) and because a was able to change sync ...

RE: Db2 with Pacemaker in ASYNC mode issue

Posted By Ivan Milojevic Wed March 06, 2024 07:47 AM
Found In Egroup: Db2 \ view thread
Well, there are several other documents that point to the defect like this one. This one is newest i think: https://www.ibm.com/mysupport/s/defect/aCI3p000000k9fo/dt145604?language=en_US But the point is that we already on 11.5 fp 9 (my mistake, I put fp 8 in the subject, but we are actually on ...

Db2 with Pacemaker in ASYNC mode issue

Posted By Ivan Milojevic Wed March 06, 2024 06:45 AM
Found In Egroup: Db2 \ view thread
Hi, Using HADR setup with Pacemaker on Db2 11.5.8 on Sles 15 SP4. Everything works fine when using SYNC or NEARSYNC sync mode. But, Pacemaker automation not working in scenario when sync mode is changed to ASYNC. db2diag.log shows errors like (for eg when performing TAKEOVER from primary on standby): ...

RE: DMC documentation - download db2 repository database with restricted option for DMC

Posted By Ivan Milojevic Fri January 26, 2024 10:51 AM
Found In Egroup: Db2 \ view thread
Cintia, thank you a lot :) ------------------------------ Ivan Milojevic Comtrade System Integration Belgrade ------------------------------

RE: DMC documentation - download db2 repository database with restricted option for DMC

Posted By Ivan Milojevic Fri January 26, 2024 10:30 AM
Found In Egroup: Db2 \ view thread
Hi Cintia, Thanks for clarification. Any chance to provide direct link to Db2 restricted license download on fixcentral. Somehow i cannot find it using fixcentral search engine. Also, it would be nice to have this info updated in DMC documentation. Regards, Ivan ------------------------------ ...

DMC documentation - download db2 repository database with restricted option for DMC

Posted By Ivan Milojevic Fri January 26, 2024 10:05 AM
Found In Egroup: Db2 \ view thread
Hi, In DMC documentation in part for creating repository database there is a note where it is said that you can download a restricted Db2 Standard edition: Creating a repository database Note: If your Db2 Data Management Console repository database is hosted by a Db2 server, you can download ...

RE: DB2 BLU migration and best practices documentation

Posted By Ivan Milojevic Wed February 23, 2022 05:22 AM
Found In Egroup: Db2 \ view thread
Hi Largou, One thing you should really take in account considering you are on big dwh database: A column-organized table cannot be a: range-partitioned table multi-dimensional clustered table typed table https://www.ibm.com/docs/en/db2/11.1?topic=to-restrictions-limitations-unsupported ...

RE: Published Release Notes for Optim Distributed 11.7

Posted By Ivan Milojevic Wed February 23, 2022 03:16 AM
Found In Egroup: InfoSphere Optim \ view thread
Hi, Anyone? When do the release notes for 11.7 be published or can someone from IBM share product roadmap? Tnx Ivan ------------------------------ Ivan Milojevic Comtrade System Integration Belgrade ------------------------------

RE: Shape the future of Warehouse on Cloud by participating in a user research study!

Posted By Ivan Milojevic Wed October 30, 2019 04:46 AM
Found In Egroup: Db2 \ view thread
+1 Regards, Ivan ------------------------------ Ivan Milojevic Comtrade System Integration Belgrade ------------------------------

Db2 Warehouse / IIAS auto client failover/reroute

Posted By Ivan Milojevic Wed July 03, 2019 05:37 AM
Found In Egroup: Db2 \ view thread
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 ...

RE: DB2 Warehouse Docker Install Fails

Posted By Ivan Milojevic Sun March 24, 2019 02:38 PM
Found In Egroup: Db2 \ view thread
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 ------------------------------ ...

RE: Backup with LDAP Admin user defined in admin group

Posted By Ivan Milojevic Fri March 22, 2019 05:10 AM
Found In Egroup: Integrated Analytics System \ view thread
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 ------------------------------ ...

RE: Backup with LDAP Admin user defined in admin group

Posted By Ivan Milojevic Thu March 21, 2019 07:00 AM
Found In Egroup: Integrated Analytics System \ view thread
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 ...

RE: Backup with LDAP Admin user defined in admin group

Posted By Ivan Milojevic Thu March 21, 2019 05:35 AM
Found In Egroup: Integrated Analytics System \ view thread
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, ...

Spark.

Posted By Ivan Milojevic Fri March 15, 2019 09:48 AM
Found In Egroup: Db2 \ view thread
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 ----- ...