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
SystemOwner='owner_name'
|
Parameter |
Description |
|---|---|
|
owner_name |
Specifies the owner of the DB2 system tables that you want PowerBuilder to use (default=SYSIBM) |
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:
SQLCA.DBParm="SystemOwner='MYAPP'"
