search

MicrosoftDocs / azure-docs

Open source documentation of Microsoft Azure
https://docs.microsoft.com/azure
Creative Commons Attribution 4.0 International
10.29k stars 21.47k forks source link

Unable to create DB2 pureScale instance #36614

Closed Jatinder-Luthra closed 5 years ago

Jatinder-Luthra commented 5 years ago

Error while DB2 Instance creation step, while running this

/data2/db2bits/server_dec/db2setup -r /root/db2server.rsp -l /tmp/db2setup_000.log -t /tmp/db2setup_000.trc

I tried the solution in https://github.com/Azure/db2-on-azure/blob/master/doc/archive/KB_archive.md but it still gives the same error.

Installing DB2 file sets :.......Success Installing or updating DB2 HA scripts for IBM Tivoli System Automation for Multiplatforms (Tivoli SA MP) :.......Success Installing or updating DB2 Cluster Scripts for IBM Spectrum Scale (GPFS) :.......Success Compiling GPL :.......Success Executing control tasks :.......Success Updating global registry :.......Success Updating the db2ls and db2greg link :.......Success Setting default global profile registry variables :.......Success Register NTP :.......Success Initializing instance list :.......Success Initiating the remote host list :.......Success

ERROR: A reachable IP address could not be automatically determined that did not belong to one of the hosts in the DB2 pureScale instance. There may be a problem with the network adapters gateway IP address or with the hosts network connection. Verify connectivity for the hosts and manually edit the configuration file /var/ct/cfg/netmon.cf on each host to include an IP on the network outside of the DB2 pureScale instance that can be reached by the ping command so that DB2 may ensure network connectivity. Hosts: "d0 d1 cf0 cf1". The format of /var/ct/cfg/netmon.cf lines is as follows: !REQD eth1 9.26.123.245 Configuring DB2 instances :.......Failure Registering DB2 Update Service :.......Success Updating global profile registry :.......Success WARNING: A minor error occurred while installing "DB2 Server Edition " on this computer. Some features may not function correctly.

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

Karishma-Tiwari-MSFT commented 5 years ago

Thanks for the question. We are currently investigating and will update you shortly.

Karishma-Tiwari-MSFT commented 5 years ago

@EdPrice-MSFT @njray Can either of you please share your insights to help with this customer issue? Thanks. :)

njray commented 5 years ago

@Karishma-Tiwari-MSFT — this GitHub repo goes with an article (it's linked from here: https://docs.microsoft.com/en-us/azure/virtual-machines/linux/deploy-ibm-db2-purescale-azure). The author of the content was Larry Mead (larryme@microsoft.com). He might have ideas about what's going on for this customer.

Jatinder-Luthra commented 5 years ago

Thanks Karishma and Nanette.

Looking forward to get some help on this issue.

JATINDER LUTHRA Principal Consultant O: 678.394.4242 Delphix.com

From: Nanette Ray notifications@github.com Reply-To: MicrosoftDocs/azure-docs reply@reply.github.com Date: Friday, August 9, 2019 at 4:50 PM To: MicrosoftDocs/azure-docs azure-docs@noreply.github.com Cc: Jatinder-Luthra jatinder.luthra@delphix.com, Author author@noreply.github.com Subject: Re: [MicrosoftDocs/azure-docs] Unable to create DB2 pureScale instance (#36614)

@Karishma-Tiwari-MSFT — this GitHub repo goes with an article (it's linked from here: https://docs.microsoft.com/en-us/azure/virtual-machines/linux/deploy-ibm-db2-purescale-azure). The author of the content was Larry Mead (larryme@microsoft.com). He might have ideas about what's going on for this customer.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or mute the thread.

Jatinder-Luthra commented 5 years ago

Hello Everyone, I believe I need some help on how to configure DB2 pure scale netmon.cf file. I tried different articles by IBM with different configurations but nothing working.

If there are some examples of exact DB2 pure scale netmon.cf file configuration needed on nodes, that will be a great help.

Thanks for the help.

Karishma-Tiwari-MSFT commented 5 years ago

@larryme24 Would you be able to share your insights on the customer's question or point us to someone who might help with this. Thanks :)

Karishma-Tiwari-MSFT commented 5 years ago

@Jatinder-Luthra I reached out to the product team offline. Can you please check if your vnets, witness or jump box are setup correctly. Db2 pureScale uses 1 vnet for admin, and another for storage and database connectivity. This configuration uses a jump box to connect to external users (not part of the vnets), and a witness for Db2 pings (seeing if nodes are alive).
Since the error mentions Db2 pings, the reason could be that the witness is not setup correctly to access the Db2 nodes. Can you please review the network connectivity and let me know. Thanks :)

Karishma-Tiwari-MSFT commented 5 years ago

@Jatinder-Luthra Is there any update? It looks like the witness is not setup correctly. Please let me know.

Jatinder-Luthra commented 5 years ago

Hello @Karishma-Tiwari-MSFT Thanks for checking with the product team. I revisited the whole setup and in fact did another setup. But the same issue persists in both setups. I didn't find any issues with witness setup and all nodes are able to communicate with each other, without any issues, when I checked manually.

For a similar issue, there is a KB article KB001 - need to have a witness node on this page- https://github.com/Azure/db2-on-azure/blob/master/doc/archive/KB_archive.md

Even after setting up stuff as per mentioned in the article, dint makes any difference.

Karishma-Tiwari-MSFT commented 5 years ago

@Jatinder-Luthra We would have to take a look at the backend in that case. Do you have the ability to create a support request? If not, please send an email with your Subscription Id to AzCommunity@microsoft.com and in the Subject mention "FYA: Karishma", I will enable a one time free support request for you and a support engineer will reach out to you. I will close this issue here. Let me know once you have sent the email.

Jatinder-Luthra commented 5 years ago

Thanks, @Karishma-Tiwari-MSFT I did create the support case.

Let me know if I need to share support case with you or any help you can do, to bring azure support up to speed.

~Thanks

Karishma-Tiwari-MSFT commented 5 years ago

@Jatinder-Luthra Yes, please share the support request number. Thanks.

Jatinder-Luthra commented 5 years ago

@Karishma-Tiwari-MSFT FYI Support request ID- 119081724000120

Thanks

marinnedea commented 5 years ago

I see a mention of "ping" in the error message ... by default ICMP is blocked in Azure, therefore the ping will fail.. as far I'm aware. There is a request for it on https://feedback.azure.com/forums/217313-networking-dns-traffic-manager-vpn-vnet/suggestions/3346609-icmp-support-for-azure-websites-roles-cloud-serv?page=3&per_page=20 .. I might be wrong though... but most likely the installation script needs updated to use a different method to test connectivity to specific IPs..

Jatinder-Luthra commented 5 years ago

@marinnedea ping is working fine across all servers in pure scale setup using private ip addresses.

Jatinder-Luthra commented 5 years ago

@Karishma-Tiwari-MSFT FYI, I got below confirmation from IBM support engineer.

I had a meeting about this issue with our pureScale developers.
We discussed this link from Microsoft for setting up DB2 pure scale environment in Azure
https://docs.microsoft.com/en-us/azure/virtual-machines/linux/ibm-db2-purescale-azure
Unfortunately, they have confirmed that this is not a supported procedure/environment, as the use of GlusterFS under GPFS is known to be susceptible to data corruption.
Our own communication with the MS team has requested that this document be taken down, or at minimum marked as experimental and unsupported by IBM.
Karishma-Tiwari-MSFT commented 5 years ago

Thanks @Jatinder-Luthra for sharing this information. I am reaching out to the right doc owner offline to get this updated.

Ed-Price commented 5 years ago

Thanks Jatinder and Karishma. We've got multiple solutions planned, which include more documentation on the GitHub repo with the scripts, as well as updating the related Docs articles to include info about GlusterFS and the recommended/supported solution from IBM.

Thanks for your help!

Jatinder-Luthra commented 5 years ago

Thanks @EdPrice-MSFT Is there something you have which I can try on my current setup? I would love to test any changes before you publish it. This is somewhat at priority for us at this time and we will greatly appreciate any help from your side.

Ed-Price commented 5 years ago

IBM recommends using Storage Spaces Direct. We'll update the documentation with more information about this topic, as well as with the SSD instructions. Thank you.