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