Connection Information

To perform the requested action, WordPress needs to access your web server. Please enter your FTP credentials to proceed. If you do not remember your credentials, you should contact your web host.

Connection Type

SystemOwner – PB Docs 126 – PowerBuilder Library

SystemOwner – PB Docs 126

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

Parameter

Description

owner_name

Specifies the owner of the DB2 system
tables that you want PowerBuilder to use (default=SYSIBM)

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
    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:


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x