If you are a system administrator at a DB2 site, you might prefer to create the extended attribute system tables outside InfoMaker for two reasons:
The first user to connect to the DB2 database using InfoMaker might not have the proper authority to create tables.
When InfoMaker creates the extended attribute system tables, it places them in the default tablespace. This might not be appropriate for your needs.
When using the DirectConnect interface
You must create the extended attribute
system tables outside InfoMaker if you are using the DirectConnect
interface. You need to decide which database and tablespace should
store the system tables. You might also want to grant update privileges
only to specific developers or groups.
To create the extended attribute system tables, you run the DB2SYSPB.SQL script outside InfoMaker. This script contains SQL commands that create and initialize the system tables with the table owner and tablespace you specify.
The DB2SYSPB.SQL script is in the Server directory on the InfoMaker CD-ROM. This directory contains server-side installation components and is not installed with InfoMaker on your computer.
You can access the DB2SYSPB.SQL script directly from your computer’s CD-ROM drive or you can copy it to your computer.
Use the following procedure from the database server to create the extended attribute system tables in a DB2 database outside InfoMaker. This procedure assumes you are accessing the DB2SYSPB.SQL script from the product CD in your computer’s CD-ROM drive and the drive letter is Z.
To create the extended attribute system tables
in a DB2 database outside InfoMaker:
Log in to the database server or gateway as the system administrator.
Insert the InfoMaker CD-ROM into the computer’s CD-ROM drive.
Use any text editor to modify Z:\Server\DB2SYSPB.SQL for your environment. You can do any of the following:
Change all instances of PBOwner to another name.
Change all instances of database.tablespace to the appropriate value.
Add appropriate SQL statement delimiters for the tool you are using to run the script.
Remove comments and blank lines if necessary.
Save any changes you made to the DB2SYSPB.SQL script.
Execute the DB2SYSPB.SQL script from the database server or gateway using the SQL tool of your choice.
