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.
Controls
-
DIR Sybase DirectConnect
Syntax
1 |
SystemOwner='<span>owner_name</span>' |
Parameter |
Description |
---|---|
owner_name |
Specifies the owner of the DB2 system |
Default
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. Updated information about
connectivity issues is available from the Sybase Customer Service and Support Web site
.
Examples
To specify MYAPP as the owner of the system tables
that you want PowerBuilder to use:
-
Database
profileType
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.DbParameter="SystemOwner='MYAPP'"