days left for your 2X growth
 / 

2X Growth

2X the points gained during the growth doubling period

Points

Get points: use points for successful completion of experiments, challenges and learning route courses:points can unlock advanced features such as: discovery mode, schedule experiments, extended experiments, VIP experiments, etc.

Number of active activities

Each time you complete an experiment, challenge, or course, you increase the number of active activities to earn a higher level

The system detects that you've not completed the task
Quick path - Complete any of the following experiments
You can
Unlock more experiment and learn path
Schedule experiment and access the discovery mode
Get your own experiment environment with VIP authority
2X Growth Points
News about the latest experiment, learning path and other events information.
You have Bonus Task(s) awaiting completion.
Bonus task list
Preference Setting

Save

Database development self-service
Experience Db2 DevOps Experience for z/OS

Db2 DevOps Experience for z/OS

Only    0 seat(s) available

    0 already completed

Experiment: Db2 DevOps Experience for z/OS

14 already completed

Experiment Content:

1) Deploy a set of own database development environment through IBM Db2 DevOps Experience for z/OS, and modify the database definition according to the modification of the database definition, and then update it to the benchmark database environment (APPLICATION) after approval.
2) Be familiar with the management process of Db2 DevOps and the basic functions of IBM Db2 DevOps Experience for z/OS.

Experiment Resources:

Db2 version, Db2 12 Function Level 504
Z/OS version: 2.4
IBM Db2 DevOps Experience for z/OS version: 1.1 ZOWE version: 1.7.1

IBM Db2 for z/OS DevOps Experience Architecture experimental product architecture
The IBM Db2 for z/OS DevOps Experience user interface runs on the Zowe platform as a plug-in. The main functions include the following parts:
a) Handling REST API requests
b) Maintain definition, configuration, and operational data
c) Db2 DDL as code (Database as code) for managing version control through Git
d) By configuring naming rules, authority management guides developers' activities
e) Integrate ZOSMF, submit and run DB2 database maintenance job

Medal Status


Lighten Medals

Latest Activites

zhoufc

has completed the experiment and received a blue medal

chenjian

has completed the experiment and received a blue medal

739163912

has completed the experiment and received a blue medal

739163912

has completed the experiment and received a blue medal

739163912

has completed the experiment and received a blue medal

739163912

has completed the experiment and received a blue medal

syyjcyao

has completed the experiment and received a blue medal

syyjcyao

has completed the experiment and received a blue medal

yanqingc

has completed the experiment and received a blue medal

yanqingc

has completed the experiment and received a blue medal

Discovery:Db2 DevOps Experience for z/OS

0 already completed

Experiment Content:

1) Deploy a set of own database development environment through IBM Db2 DevOps Experience for z/OS, and modify the database definition according to the modification of the database definition, and then update it to the benchmark database environment (APPLICATION) after approval.
2) Be familiar with the management process of Db2 DevOps and the basic functions of IBM Db2 DevOps Experience for z/OS.

Experiment Resources:

  • Db2 version, Db2 12 Function Level 504
    Z/OS version: 2.4
    IBM Db2 DevOps Experience for z/OS version: 1.1 ZOWE version: 1.7.1

    IBM Db2 for z/OS DevOps Experience Architecture experimental product architecture
    The IBM Db2 for z/OS DevOps Experience user interface runs on the Zowe platform as a plug-in. The main functions include the following parts:
    a) Handling REST API requests
    b) Maintain definition, configuration, and operational data
    c) Db2 DDL as code (Database as code) for managing version control through Git
    d) By configuring naming rules, authority management guides developers' activities
    e) Integrate ZOSMF, submit and run DB2 database maintenance job

Tips

1. Discovery provides longer time for your experience;you are home free
2. Data will be cleared after the end of discovery
3. It is needed to finish the experiment and challenge first to start your discovery

Please start your challenge after you finish the experiment

Please start your discovery after you finish the challenge.

Please start your discovery after you finish the experiment.

Experiment Manual

The following content is displayed on the same screen for your experiment so that you can make any necessary reference in experiment. Start your experiment now!

  1. Log in to the Db2 DevOps Experience interface(Duration: 2 mins)

    Log in to Zowe in the Firefox browser, enter username: DOEUSRn, password: abc

    Click the start menu in the lower left corner of Zowe, click Db2 DevOps Experience, and enter the DOE app

    Select the menu in the upper left corner of the DOE homepage and click Instance

  2. Create Instance of current user(Duration: 3 mins)

    The current Instance is empty, click ‘Provision new instance’ to create a new instance

    Enter the Instance name, the name is doeusr1_inst (differentiated according to experimental users, the name SAMPLE DB INST1 in the example is for reference, pay attention to case). And select Application, Team, Environment.
    If you want Instance to include data, select ‘Include data from source application’ (DOE will prepare data through Unload/Load)
    Then click Provision

    Privisioning in progress...

    Provision is completed and the status is Ready

  3. The user modifies the DDL definition of the Instance table(Duration: 5 mins)

    Click on Details

    Check all objects of the current Instance. The Application of this experiment has two tables, DEPT and EMP, and choose one DEPT to modify. Click the "pencil" next to the object

    Check the DDL of DEPT, modify column DEPTINO, change from CHAR(6) to CHAR(7), and then Apply object change.
    (Source DEPTINO may have been merged by other users, the initial value may not be CHAR(6), adjust +1 accordingly)
    Other objects are modified in the same way. If you modify multiple objects, click Apply all changes.

    DDL change processing

    Click Apply DDL Changes to confirm the changes

    Successfully modified

    Query Db2 catalog to verify that the DDL modification is successful, and click SQL Processor in the upper left corner of the DOE. Select DB2connection: DB11. Execute SQL: SELECT NAME,COLTYPE,LENGTH FROM SYSIBM.SYSCOLUMNS WHERE TBNAME='DEPT' AND TBCREATOR='DEXKJSGO';
    (TBCREATOR will be different, please modify accordingly, the current environment setting Schema starts with DEX, which will be randomly generated later)


    Query returns the result to confirm that the modification is successful

  4. Development users submit merge requests to modify Application synchronously(Duration: 5 mins)

    Back to Instnace, click Details of SAMPLE DB INST1.

    Now DOEUSR1 hopes to apply the DDL modification just now to the master branch. Click Pull request to submit the request

    Check the change of DDL, write a short description in Comment, and click Submit pull request

    The submission is successful, the current request is waiting for admin approve

    Click ‘home’ in the upper left corner to return to the DOE homepage. You can see the request you just submitted in YOUR OPEN PULL REQUESTS.

  5. Log in to the Admin user, check the request, execute approve, and finally merge to the master branch(Duration: 6 mins)

    In this step, switch the user admin to log in, execute the approve request, and merge to the master branch.
    User DOEUSER1 clicks on the portrait in the lower right corner, Log out

    Switch admin user DOEADMn login:

    Enter the DOE app, you can see the request submitted by DOEUSR1 just now on the homepage, click Details

    Check change, click Approve

    Click Merge to merge the code (DDLs as code) to the master branch.
    (After requset is approve, both admin and user can execute Merge)

    Enter the Sql processor, execute SQL: SELECT NAME,COLTYPE,LENGTH FROM SYSIBM.SYSCOLUMNS WHERE TBNAME='DEPT' AND TBCREATOR='DOEDEMO';
    Confirm that the source object DOEDEMO.DEPT has been changed

  6. After the experiment is completed, switch User, delete instance, and recycle resources(Duration: 7 mins)

    The experiment is completed and the experimental environment is restored. Switch to DOEUSRn login, enter Instance, click Deprovision, delete instance

    Deleteing…

    Instance is successfully deleted and resources are recovered

    The experiment is over, thank you!

Scan here to share it


Reserve Experiment Summary

Experiment Name:

Experiment Content: Db2 DevOps Experience for z/OS

:

Hour(s)

Points:,This appointment will use 50 points

You have successfully reserve this experiment. You can view it at Personal Center > My Reservation later

You are not authorized to reserve the experiment!

It’s only for Premium Member.

VIP 项目申请

什么是VIP项目:
可以在一段时期内使用您专有的实验资源,进行深入测试。期间可以根据您的需要手工进行环境的初始化与回收

实验名称:
数据库开发自服务
Db2 DevOps Experience for z/OS

Please login before sharing



    Copy succeeded


Please fill in the email address

    Send succeeded

Poster sharing

Scan to share poster

您将使用100个消费积分开启自由实验

您当前的消费积分不足

您将使用200个消费积分解锁VIP实验

您当前的消费积分不足

您将使用50个消费积分预约实验

您当前的消费积分不足

该天预约已满,请选择其他时间

Non-Premium Member only has 5 opportunities every month to experiment. You still have 0 opportunities. Do you want to start the experiment now?

p.s Premium Member enjoys unlimited access to routine experiments.
沪ICP备18004249号-1