zowe › mat › monitor › db2 › db2view🖨️

Get the DB2View details for the measurement.

Usage

zowe mat monitor db2 db2view [options]

Options

• --profile (string)

  • Specifies the name of the profile that you want to analyze. When you specify the profile name, you get the data for the latest measurement within the specified profile.

• --mon_num (number)

  • Specifies the unique monitor number of the measurement.

• --top (number)

  • Specifies the maximum number of the top consuming DB2 statements that you want to obtain in the response (e.g., --top 5). If you specify --top 0, you get the list of all DB2 statements that MAT has detected during the measurement.The --top parameter is optional. Values: numbers between 0 and 300.

MAT Profile Options

• --protocol | -o (string)

  • Specifies the protocol defined for the MAT REST API server (http or https).

    Default value: https
    Allowed values: http, https

• --host | -H (string)

  • Specifies the hostname or IP address defined for the MAT REST API server (e.g. 127.0.0.0 or localhost).

• --port | -P (number)

  • Specifies the server port (e.g. 8080).

• --user | -u (string)

  • Your mainframe username.

• --password | --pw (string)

  • Your mainframe password.

• --base-path | --bp (string)

  • The base path for your API mediation layer instance. Specify this option to prepend the base path to all resources when making REST requests. Do not specify this option if you are not using an API mediation layer.

• --reject-unauthorized | --ru (boolean)

  • Reject self-signed certificates.

    Default value: true

• --listingDir | --ldir (string)

  • Specifies the directory where you want to store the registered program listings (e.g. 'c:\listings') for your immediate source code inspection. You can use the advantage of automated listing registration with MAT and listing retrieval through Endevor® footprints for Cobol, C/C++, and Assembler programs. When a source program listing is registered with MAT, you can enhance the histogram analysis data with the program listing details that pertain to the specific CSECT and program statement. The listing is transfered to the specified directory, which enables you to navigate directly to the line of the source code in you VS Code IDE and inspect the program statement. To use the listing retrieval option through Endevor® footprints, you need to have the Endevor® Web Services installed and configured and specify the Endevor® web server details in the MAT database configuration.

Profile Options

• --mat-profile | --mat-p (string)

  • The name of a (mat) profile to load for this command execution.

• --base-profile | --base-p (string)

  • The name of a (base) profile to load for this command execution.

Base Connection Options

• --token-type | --tt (string)

  • The type of token to get and use for the API. Omit this option to use the default token type, which is provided by 'zowe auth login'.

• --token-value | --tv (string)

  • The value of the token to pass to the API.

• --cert-file (local file path)

  • The file path to a certificate file to use for authentication

• --cert-key-file (local file path)

  • The file path to a certificate key file to use for authentication

Examples

• Get the DB2View details for monitor number 5:

  • zowe mat monitor db2 db2view --mon_num 5 Copy

• Get the DB2View details for the latest monitor in the TESTPROF profile, with the top consumer limitation set to 5 top consumers:

  • zowe mat monitor db2 db2view --profile TESTPROF --top 5 Copy

• Get the DB2View details for monitor number 5, with the specific MAT profile details defined:

  • zowe mat monitor db2 db2view --mon_num 5 --host "example.com" --port 12345 --user johndoe --password qwerty Copy