ROUTINES CREATOR field
The ROUTINES CREATOR field specifies the CURRENT SQLID setting that is to be used when creating, configuring, and validating most Db2-supplied routines. This field also specifies the default OWNER for binding packages for these routines if the INSTALL PKG OWNER field is blank.
| Acceptable values: | 1–8 characters, the first of which must be an alphabetic character |
|---|---|
| Default: | SYSADM |
| Update: | option 6 on panel DSNTIPB |
| DSNZPxxx: | none |
The value in the ROUTINES CREATOR field is used by the installation CLIST to set the value of the AUTHID parameter for installation programs DSNTRIN in job DSNTIJRT and DSNTRVFY in job DSNTIJRV. If the INSTALL PKG OWNER field is not specified, the value in the ROUTINES CREATOR field is also used by the installation CLIST to set the value of the DEFPKOWN parameter for DSNTRIN and the PKOWNER parameter for DSNTRVFY.
DSNTRIN uses the value of the AUTHID parameter as the CURRENT SQLID for creating and configuring Db2-supplied routines. It also uses the value of the DEFPKOWN parameter to determine the default OWNER for binding the package for a Db2-supplied routine when an owner is not explicitly specified through the PKOWNER parameter in the routine's configuration control statement. If the DEFPKOWN parameter is not present, DSNTRIN uses the AUTHID parameter to determine the default OWNER.
DSNTRVFY uses the value of the AUTHID parameter as the CURRENT SQLID for validating Db2-supplied routines. It also uses the value of the PKOWNER parameter as the default OWNER for binding packages for routine validation. If the DEFPKOWN parameter is not present, DSNTRVFY uses the AUTHID parameter to determine the OWNER.
If you use installation SYSOPR authority for Db2 installation or migration, set the ROUTINES CREATOR field to SYSINSTL. Also, set the SEC DEF CREATOR and INSTALL SQL ID fields to SYSINSTL and the INSTALL PKG OWNER field to a non-blank value.
If the value of DSNTRIN parameter AUTHID is SYSINSTL, and an ID with installation SYSADM or installation SYSOPR authority is used to execute DSNTRIN to create or alter a Db2-supplied routine, Db2 identifies the routine as system-defined in the SYSIBM.SYSROUTINES catalog table.