ibm-cloud-docs / db2oncloud Goto Github PK

• Source page: https://cloud.ibm.com/docs/Db2onCloud?topic=Db2onCloud-dcw

The paragraph that mention the IBM Database Harmony Profiler points to a document already removed:

To assess the compatibility of your database with Db2 and convert the SQL, you can also use the free, light-weight tool called IBM Database Harmony Profiler.

Tourisme

What is this error, please provide a solution. I'm not able to access DB2 console, Opening a page with this error

{"trace":"2394139d76683cc095a356bc2c10b196","errors":[{"code":"authentication_failure","message":"HWCSEC0016E: Authentication failed for SSO. This may caused by failed to generate access token in console side using existing credentials.","target":{"type":"","name":""},"more_info":""}]}

ChicagoCensusData.csv
ChicagoCrimeData.csv
ChicagoPublicSchools.csv

Needing to unlock a Db2 on Cloud userID is a common customer issue and not currently documented in the user management documentation (https://cloud.ibm.com/docs/Db2onCloud?topic=Db2onCloud-user_mgmt).

It would be nice to add this to the documentation to facilitate users efficiently handling lock/unlock tasks by themselves.

See attached screenshot which shows how to unlock/lock a user in the User management section of the web console

i can't click "create" for some reason and yes i have chosen London or Dallas

test db2

Hi,
I want to raise an issue with the topic=Db2onCloud-migration of the DB2Cloud documentation here https://cloud.ibm.com/docs/Db2onCloud?topic=Db2onCloud-migration .
The problem is with the download link of the IBM LIFT product. Infact, the website respond with "Error 526 Invalid SSL certificate".

I've been trying for 10 days, but the problem persists.

The problem is of course with the IBM LIFT host server, but as this product is the recommended product in the documentation I guess it is important to fix it.
I've tried to raise an issue with IBM, but it is impossible and they recommended that I should raise the issue here.

Thanks.

Regards,
FP

Customer can use IBM Log Analysis to view Db2 logs

https://cloud.ibm.com/docs/log-analysis?topic=log-analysis-cloud_services_locations

We receive the instruction:
"Create credentials. After creating the Db2 on Cloud service on IBM Cloud®, you must create a user name and password by clicking the Service credentials tab on your service page and selecting New credential."

However the Service credentials option, don't give us the option to username neither password. Just name and role

HPCS will now be supported for Db2 on cloud encryption, the provision, DR and copy docs will need to be updated for this newly enabled offering.

Connecting to the database from the DB2 took me a long time. The instructions were far from clear. It turns out only SSL is supported. That should be made clear to the user. There is so much stuff about non - ssl which people are naturally going to try first.

Using the instructions on this page, I was finally able to get it to work:
https://cloud.ibm.com/docs/Db2onCloud/connecting?topic=Db2onCloud-ssl_support

I found there was so much misleading information that didn't complete the process.
For example this connections page on the instance
Instructions

1. Download Windows driver package
   Download Windows driver package from driver list
   File name: ibm_data_server_driver_package_win64_v11.5.exe (104 MB)
2. Install the drivers by running the ibm_data_server_driver_package_win64_v11.5.exe file as an administrator.
3. In The Connection configuration resources section, select whether or not you want to secure your connections by using SSL.
   If your application uses its own driver and you want to connect with SSL, download the SSL certificate (DigiCertGlobalRootCA.crt).
   For Java apps, use the JDBC string as the database URL in your call to the JDBC getConnection method.
   For ODBC apps, add new entries to the db2dsdriver.cfg driver configuration file by running the following commands:
   For connections with SSL
   db2cli writecfg add -database bludb -host 1bbf73c5-d84a-4bb0-85b9-ab1a4348f4a4.c3n41cmd0nqnrk39u98g.databases.appdomain.cloud-port 32286
   db2cli writecfg add -dsn dashdb -database bludb -host1bbf73c5-d84a-4bb0-85b9-ab1a4348f4a4.c3n41cmd0nqnrk39u98g.databases.appdomain.cloud -port 32286
   db2cli writecfg add -database bludb -host 1bbf73c5-d84a-4bb0-85b9-ab1a4348f4a4.c3n41cmd0nqnrk39u98g.databases.appdomain.cloud-port 32286 -parameter "SecurityTransportMode=SSL"

What step is suppose to happen after cataloging the database.

Less is more if it works.

Please update the following topic under the Restrictions setting:

https://github.com/ibm-cloud-docs/Db2onCloud/blob/master/iam.md

Replace this line:

"IBMid federation is supported to allow custom user management portal or server to be used for authentication. Such support does not include any group federation"

with this line:

"IBMid federation is supported to allow custom user management portal or server to be used for authentication. Such support does not include any group federation. Currently AppID support is not provided although this support will be added in the future."

i keep getting errors and it says my credential is no good

Hi,

I'm currently working my way though the process here: https://cloud.ibm.com/docs/Db2onCloud?topic=Db2onCloud-upgrade_plans only to find that you've changed the VCAP services JSON and didn't mention it.

It should be made very clear that if you are migrating an application that used the previous DB2 service, you will likely need to change how you access the VCAP_SERVICES JSON object. This will require a code change in applications resulting in a more complex migration path.

The Flex and Precise Performance plans run on their own single-tenant virtual machines or bare metal servers.

Doc link:
https://cloud.ibm.com/docs/Db2onCloud?topic=Db2onCloud-free_plan

ChicagoCensusData.csv
ChicagoCrimeData.csv
ChicagoPublicSchools.csv

The following document is only applicable for V1 Db2 on Cloud service instances. We no longer support provisioning these so this can be removed: https://cloud.ibm.com/docs/Db2onCloud?topic=Db2onCloud-key-protect

Note: This topic is the good one and should remain - https://cloud.ibm.com/docs/Db2onCloud?topic=Db2onCloud-key-protect-v2

This link https://cloud.ibm.com/catalog/services/db2#about says: "High availability plans include two servers configured as an HA pair"

while
docs link https://cloud.ibm.com/docs/Db2onCloud?topic=Db2onCloud-about says: "High availability plans provide multizone region support in a three HA node"

which one is right?

It would seem that native(SQL) and java stored procs are only supported on db2 on cloud.

Whereas 'binary' stored procs like C/C++/fortran (what else is available in db2 server on prem) is not supported with db2 on cloud.

Can you update documentation to reflect the above.

The following section,
https://cloud.ibm.com/docs/Db2onCloud?topic=Db2onCloud-provisioning#prov_rc_api
and in the step 3 I see the following incomplete CURL command,

curl -X POST \
 https://resource-controller.cloud.ibm.com/v2/resource_instances \
 -H 'Authorization: Bearer <>' \
 -H 'Content-Type: application/json' \
   -d '{
   "name": "my-instance",
   "target": "bluemix-us-south",
   "resource_group": "5g9f447903254bb58972a2f3f5a4c711",
   "resource_plan_id": "dash
 }'

Hello,
I am a student to get SQL certificate. Using IBM DB2 is required in the section.
While studying the courese, I keep trying to click 'Go To UI', showing error as below.
{"trace":"ddbf23e018022e9b81c0b3b06adcbb82","errors":[{"code":"iam_sqlid_error","message":"HWCSEC6011E: User id can not be found for current instance.","target":{"type":"","name":""},"more_info":""}]}

Could you please help me with this error?

-p '{"high_availability": "yes"}

https://cloud.ibm.com/docs/Db2onCloud?topic=Db2onCloud-ssl_support#ssl_cfg_gskit

Above page explains about LD_LIBRARY_PATH for each Operating System environment.

"Linux: LD_LIBRARY_PATH /usr/local/ibm/gsk8/lib"

If you are working with 64 bit GSKit for 64bit Linux, the path should be:

/usr/local/ibm/gsk8_64/lib64

( For Windows,the above page has note for 64bit environment. Similar note for others, such as 64bit Linux are expected.)

https://cloud.ibm.com/docs/Db2onCloud?topic=Db2onCloud-log_mon

This page is incorrect. We provide logs via IBM Log Analysis as well as metrics via IBM Log Monitoring. This page is incorrect and should be updated to refer to these services to get such information.

This page https://cloud.ibm.com/docs/Db2onCloud?topic=Db2onCloud-about lists only two differences between Standard and Enterprise plan.

I know there are more differences between them (for example max storage) but they are not clearly described clearly/called out in the documentation. Can there be a table showing differences between the two plans?

Btw, there is a typo in the left column (under "Get Started"): Adminstration -> Administration

test data

Please can you help include a schematic view with some description as to how the HA is managed or handled if there is a failure with the primary storage volume mapped to the Db2 server/node in one of the Availability Zones within a Region? This is to get an understanding on how the redundancy/resiliency is built at the Storage level for the hosted Db2 nodes on IBM Cloud. Ideally, the Primary Db2 instance should be able to re-point itself to use one of the replicated secondary volume on the alternate availability zone. Appreciate if this can be detailed and included within this section please, thanks.

HI