Skip to content

Scenario: Db2 versioning

Scenario overview

Speaker's script

You are now a new database administrator (DBA) and need to quickly familiarize yourself with the Db2 subsystem in your company's IBM Z environment. You would like to understand more about Db2 on z/OS versus other platforms, the latest supported version of Db2, and the process for migrating to a newer version. Most early-tenure DBAs don't have this experience. You leverage the virtual assistant that is customized with pre-existing automation your team has in place. And by leveraging the retrieval augmented generation (RAG) grounded on IBM Z-specific knowledge, you have confidence that the responses generated from the questions are accurate. You like the fact that you can go to one place to get answers to any question, on-demand, and can help automate some of the tasks, which in turn reduces your learning curve and increases your efficiency.

Responses from the virtual assistant are likely to change

Responses generated by IBM watsonx Assistant for Z are likely to change over time. The responses you see when you run the queries in this section may differ from the screen images captured in the IBM watsonx Assistant for Z for Technical Sales Level 3 Demonstration Guide. Using the exact queries specified will help assure a successful demonstration. Also, as updates to the environment are made, some confirmation dialogs may no longer be displayed as illustrated in the Example outputs.

Prerequisite steps

None.

Prompts and Example outputs

Copy and paste the prompt

Use the copy icon () to copy prompts from this demonstration guide and then paste the prompt using Ctrl+V, or right click and select Paste.

  1. Ask the assistant what is different about Db2.

    Prompt:

    Why is Db2 different than other database systems?

    Example output:

    Speaker's script

    Notice the detailed level of the response, and more importantly, notice the expandable section at the bottom of the response.

  2. Ask the assistant how Db2 differs on the z/OS platform and distributed platforms.

    Prompt:

    What is the difference between Db2 for z/OS and Db2 on distributed?
    Example output:

  3. Ask the assistant what is the latest release of Db2 for z/OS.

    Prompt:

    What is the latest release of Db2 for z/OS?

    Example output:

  4. Ask the assistant what version of z/OS is required for Db2 v13.

    Prompt:

    What version of z/OS does Db2 v13 run on?

    Example output:

  1. Ask the assistant how to check the version of Db2 on an LPAR.

    Prompt:

    What is the operator command used to check the Db2 for z/OS version level?

    Example output:

  2. Ask the assistant if it can run the version check.

    Prompt:

    Run the command to check my version level?

    Example output:

    Speaker's script

    A skill is triggered to use an Ansible playbook that runs the referenced operator command to return the Db2 details.

  3. Wait approximately 10 seconds and then click Apply.

    Example output:

    Speaker's script

    See the skill returned the version of Db2 running on the LPAR.

  1. Ask the assistant how to migrate from one version of Db2 to another.

    Prompt:

    How do I migrate from Db2 v12 to Db2 v13 on z/OS?

    Example output:

    Cleanup steps

    None.