DB2CATALOG= SAS 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 specify 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

Table of Contents

Syntax

DB2CATALOG=SYSIBM | catalog-owner

Required Arguments

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 specify DB2CATALOG= in the restricted options table and then rebuild the table.
Last updated: February 3, 2026