DB2CATALOG= System Option

Overrides the default owner of DB2 catalog tables.
Valid in: OPTIONS statement
Category: Databases: DB2
Default: SYSIBM
Restriction: This option applies to only the local DB2 subsystem. So when you set the LOCATION= or SERVER= connection option in the LIBNAME statement, the SAS/ACCESS engine always uses SYSIBM as the default value.
Data source: DB2 under z/OS
See: LOCATION= connection option, SERVER= connection option

Syntax

DB2CATALOG=SYSIBM | catalog-owner

Syntax Description

SYSIBM
specifies the default catalog owner.
catalog-owner
specifies a different catalog owner from the default.

Details

The default value for this option is initialized when SAS is installed. You can override the default only when these conditions are met:
  • SYSIBM cannot be the owner of the catalog that you want to access.
  • Your site must have a shadow catalog of tables (one to which all users have access).
  • You must set DB2CATALOG= in the restricted options table and then rebuild the table.