SystemOwner
database parameter
Description
Specifies the owner of the IBM DB2 system tables that you want
PowerBuilder to use. PowerBuilder accesses the DB2 system tables to get
information about the tables and columns in your database.
Applies to
DIR SAP DirectConnect
Syntax
|
1 |
SystemOwner='owner_name' |
|
Parameter |
Description |
|---|---|
|
owner_name |
Specifies the owner of the DB2 system tables that |
Default value
SystemOwner=’SYSIBM’
Usage
When you use the SystemOwner parameter to specify a nondefault
system owner, PowerBuilder uses the set of system tables belonging to
this owner instead of the default system tables owned by SYSIBM.
If your site has a large DB2 system catalog, it might be useful to
create local copies of the catalog tables and populate them with a
subset of the information in the default system catalog. These local
copies are sometimes called shadow catalogs.
You can then set the value of SystemOwner to the owner of the
shadow catalogs. This tells PowerBuilder to access the smaller shadow
catalogs instead of the larger default system tables, resulting in
faster performance. However, you must make sure to keep the shadow
catalogs synchronized with the default system catalog owned by
SYSIBM.
For more about creating shadow catalogs, see your DB2 system
administrator or check whether there is a technical document that
describes how to do it.
Examples
To specify MYAPP as the owner of the system tables that you want
PowerBuilder to use:
-
Database profile
Type MYAPP in the CSP Catalog Qualifier box on the System page
in the Database Profile Setup dialog box. -
Application
Type the following in code:
1SQLCA.DBParm="SystemOwner='MYAPP'"