Running the pipeline and workflow and reviewing its output


(BMC.DB2.SPE2304)

This topic describes how to run a pipeline and a workflow in its respective deployment environment and to review the output log.

To run a pipeline in Azure DevOps manually

Important

You can run the pipeline manually or with an automatic trigger.

  1. On the Azure DevOps dashboard, click Pipelines to expand it.
  2. In Pipelines, click All to display a list of all the pipelines.
  3. Select a pipeline, to open a list of all runs for the specific pipeline.
  4. On the Runs tab, perform one of the following actions:
    • In the upper right corner, click Edit and edit the pipeline.
      • In the upper right corner, click Run to run a new instance of the pipeline.
      • In the Run pipeline dialog box, update any advanced options as required.
      • In the lower right corner, click Run to run the pipeline.
    • In the upper right corner, click Run to run a new instance of the pipeline.
      • In the Run pipeline dialog, update any advanced options as required.
      • In the lower right corner, click Run to run the pipeline.
  5. After the pipeline run is complete, perform one of the following actions on the summary dashboard:
    • Click the Jobs tab to view the logs of each step.
    • Click Rerun failed jobs to rerun unsuccessful jobs
    • Click Run new to run a new instance of the pipeline.

To review the output log for a pipeline run in Azure DevOps

  1. On the summary dashboard, perform one of the following steps:
    • Click the vertical ellipsis () at the top right corner of the Azure job summary.
      1. Click Download Logs .
      2. Unzip the downloaded zip file and open the log text files for the steps from the job folder.
    • In the Jobs section, click Job to open the logs for each step.
      • Select the steps to view the logs.
      • Select Job at the top or an individual step, and click View raw log to view its raw log.
  2. Review the following items in the output log:
    • Job name
    • Return code
    • Number of files
    • Pipeline status

To run a workflow in GitHub Actions manually

(BMC.DB2.SPE2307)

Important

You can run the workflow manually with the event trigger:
on: workflow_dispatch

  1. On the GitHub Actions tab, click All workflows to display a list of all the workflows.
  2. Select a workflow from the list to open a list of all runs for that workflow.
  3. In the workflow runs list, expand the Run workflow button at the upper right corner to perform one of the following actions:
    •  Select the branch for Use workflow from.
    • Click Run workflow to run the workflow.
  4. After the workflow run is complete, perform one of the following actions on the summary dashboard:
    • Select the steps in the workflow run to expand the workflow results.
    • Click Re-run all jobs to re-run all the jobs in the workflow.
    • Click the ellipsis (...) on the right side of the workflow run summary dashboard:
      • Click Create status badge to create a status badge.
      • Click Delete all logs to delete all the logs.

To review the output log for a workflow run in GitHub Actions

(BMC.DB2.SPE2307)

  1. In the workflow run list, click the link for the workflow run that you want to review. In the workflow run summary, under Jobs or in the visualization graph, select the job to view the logs.
  2. Review the following items in the output log:
    • Job name
    • Return code
    • Number of files
    • Workflow status

To run a pipeline in GitLab CI/CD manually

(BMC.DB2.SPE2504)

  1. On the GitLab Project Build menu, select Pipelines.
  2. Click New pipeline.
  3. On the Run pipeline dialog box, perform the following actions:
    • Select your branch.
    • (Optional) Define pipeline variables.
    • Click New pipeline.

Important

  • If you are editing your branch pipeline in the Pipeline editor, click Commit changes, to run pipeline automatically.
  • There are several types of GitLab CI/CD pipelines as well as several methods to run GitLab CI/CD pipelines. For more information, see the GitLab documentation.
  • Types of GitLab CI/CD pipeline:
    • Branch
    • Tag
    • Merge request
    • Merge result
    • Merge train
  • GitLab CI/CD pipeline methods: manual, trigger, schedule.

To review the output log for a pipeline run in GitLab CI/CD

(BMC.DB2.SPE2504)

Important

If you commit the pipeline from the Pipeline editor, click View pipeline and then follow step 2.

  1. From the GitLab Project Build menu, select Pipelines.
  2. From the list, select your pipeline run result.
  3. On the Pipeline tab of the Pipeline details page, select a job to open the output log.
    • Expand the Executing "step_script" stage of the job script and scroll through each step.
    • Click the Show complete raw button to view its raw output log.

To review the JES job log output

Use the following procedure to review the JES job log output after running a Schema Change Migration and JCL execution step in a pipeline or workflow:

  1. From the job log, select the Schema Change Migration or JCL execution step.
  2. Search for Job Log Output Path= in the log to get the agent or runner workspace path.
  3. Go to the server where the agent or runner is configured to view the job log output path previously found in the log.
  4. (BMC.DB2.SPE2307)Select the item corresponding to your log output. The format of the item is as follows:

    pipelineName/workflowName-buildNumber-jobName-jobID

Schema Change Migration build step results

The following table lists the possible outcomes of the Schema Change Migration build step.

Return code

Result

0000/0004

All process steps completed successfully and changes were detected in Compare.

0001

No changes were detected in Compare.

0008

  • Analysis might have encountered an invalid input value in a process step, causing the Schema Change Migration build step to fail.
  • Analysis might have encountered an error based on the schema definition or utilities selection.

0012

Analysis encountered a SQL error in a process step, causing the Schema Change Migration build step to fail.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*