## zowe › profiles › update › dbm-db2-profile

The DBM-Db2 profile is a named set of DBM Data Service parameters that are implicitly used with the zowe dbm-db2 commands. The profile includes server connection, z/OS execution, and user-dependent details.

Warning: This command has been deprecated.
Recommended replacement: The 'config set' command

#### Usage

zowe profiles update dbm-db2-profile <profileName> [options]

#### Positional Arguments

- `profileName` (string)

  - Specifies the name of the new dbm-db2 profile. You can load this profile by using the name on commands that support the "--dbm-db2-profile" option.

#### DBM-Db2 Options

- `--host` | `-H` (string)

  - Specifies the DBM Data Service REST API server host name or TCP/IP address to use.

- `--port` | `-P` (number)

  - Specifies the DBM Data Service REST API server TCP/IP port number.

- `--user` | `-u` (string)

  - Specifies the mainframe user name that you want to use to connect to the mainframe systems during execution of the Zowe CLI commands. This user name can be the same as your TSO login ID.

- `--password` | `--pass` | `--pw` (string)

  - Specifies the mainframe password for the user name that is used to connect to the mainframe systems during execution of the CLI commands. This password can be the same as your TSO password.

- `--protocol` (string)

  - Specifies the communication protocol between zowe dbm-db2 client and DBM Data Service.

    Allowed values: http, https

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

  - Determines whether the dbm-db2 command is accepted or rejected when a self-signed certificate is returned by the DBM Data Service.

- `--environment-list` | `--el` (string)

  - Specifies a string of one or more entries consisting of a Db2 subsystem ID and a DBM Data Service REST API server host name or TCP/IP address. Use a comma to separate entries. The same Db2 subsystem can be used in multiple DBM Data Service environments. For more information about configuring the DBM Data Service, see the Database Management Solutions for Db2 for z/OS documentation at https://techdocs.broadcom.com/db2mgmt

- `--job-cards` | `--jc` (array)

  - Specifies a string array of z/OS JCL JOB statements.

- `--work-dataset-prefix` | `--wdp` (string)

  - Specifies the prefix (high-level qualifier) in z/OS work data set names.

- `--delete-work-datasets` | `--dwd` (boolean)

  - Specifies whether to delete work data sets on a mainframe after the request is fulfilled.

- `--overwrite-output-files` | `--oof` (boolean)

  - Specifies whether to overwrite output files if they exist.

- `--authid` | `-a` (string)

  - Specifies the primary Db2 authorization ID that is used to establish a connection between Db2 and a process.

- `--sqlid` | `-s` (string)

  - Specifies the authorization ID that is used in generated SET CURRENT SQLID statements.

- `--termination-character` | `--tc` (string)

  - Specifies the SQL termination character to use in DDL generation when the default termination character conflicts with the SQL statements that are used in triggers, XML indexes, and routines (external SQL functions and native SQL stored procedures). The default termination character is a semi-colon (;). You cannot specify a comma, double quote, single quote, left or right parentheses, or an underscore.

#### Examples

- Update a DBM-Db2 profile named profile_name1 with a new work data set prefix:

  - `zowe profiles update dbm-db2-profile profile_name1 --work-dataset-prefix NEWPREFX.DDL`

- Update a DBM-Db2 profile named dbm123 with a new username and password:

  - `zowe profiles update dbm-db2-profile dbm123 --user newuser --password newp4ss`

- Update a DBM-Db2 profile named dbm124 with a new environment list. Existing subsystem SUBA will be updated with a new hostname "host4" and subsystem SUBC will be added to the list:

  - `zowe profiles update dbm-db2-profile dbm124 --environment-list "SUBA:prod@host4.com:322,SUBC:stage@host3.net:722"`

- Update a DBM-Db2 profile named dbm125 with new job cards:

  - `zowe profiles update dbm-db2-profile dbm125 --job-cards "//NEWJOBNM JOB (123456789)," "// CLASS=A,MSGCLASS=X,MSGLEVEL=(1,1),"`