DEFID—Db2 default system user ID


Use the Modify Default System User ID panel or the DEFID command to specify a new Db2 default system user ID. The new value is used the next time an undefined user attempts to access Db2.

Important

This element is subject to OPERTUNE security checking. Only authorized OPERTUNE systems and users are allowed to alter the Db2 default system user ID.

Modify Default System User ID panel

DDTG DBI1 Modify Default System User ID
Command ===> _________________________________________________________________

 Command: CURRENT
Description . . . . . . . . : DEFAULT SYSTEM USER ID

Type the new default userid value that you wish to change to. Then press Enter.

Default System Parameter
User ID . . . . . . . . . . ________

Command syntax and parameters

image2018-12-20_17-43-55.png

Value

Description

DB2ssid

Db2 subsystem ID or the name of the Db2 data sharing group to which the command applies.

opertuneID

OPERTUNE system profile name (if OPERTUNE is running as a started task) or the batch job name (if OPERTUNE is running as a batch job).

authID

Default system user ID. This value is used when an undefined user attempts to access Db2.

  • Db2 version 7: Authorization IDs must be 1–8 characters.
  • Db2 version 8 and later: Authorization IDs must be 1–128 characters.1

The first character must be a letter of the alphabet or a national character ($, #, or @). The remaining characters can be alphanumeric or national. The Db2 default is IBMUSER.

NORESET

The changes you request remain in effect until the Db2 subsystem is cycled.

1 OPERTUNE panels display only the first 8 characters of authorization IDs. To change the auth ID to a longer name, type the first 8 characters in the User ID field and press Enter. Use the EDIT command on the Command Confirmation panel to modify the ID to a longer value before submitting the command.

Db2 parameter values

Field

Installation panel

CLIST parameter

ZPARM macro

ZPARM parameter

User ID

DSNTIPP

PROTUNKN

DSN6SPRM

DEFLTID

 

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