Use job DSNTIJSG to bind Db2-supplied packages and plans, initialize the
Db2 communications database, and create
user-managed databases for the Db2 resource
limit facility (RLF), Data Definition Control support, and query optimization.
Before you begin
Important: In a data sharing environment, you
must ensure that the resource limit facility (RLF) is inactive on
all members in the data sharing group before running DSNTIJSG. To
do this, issue the STOP RLIMIT command for each member.
Procedure
To use job DSNTIJSG:
- If you use a product that uses a semicolon as a delimiter,
replace the semicolons at the end of each SQL statement in job DSNTIJSG
before you run the job.
If you use a product that uses
a semicolon as a delimiter, the CLIST adds SQL statements to job DSNTIJSG.
Products that use a semicolon as a delimiting character cause semicolons
to be removed from the installation CLIST before it is executed.
- Run job DSNTIJSG.
If the DSNTIJSG job runs successfully, it produces return codes of 0. It might also produce a
return code of 4 because a step within this job attempts to delete a row from a table that might not
exist at the time that this job runs. Expect the following messages from the BIND statement for each
object that
Db2 provides:
DSNE932I WARNING, ONLY IBM-SUPPLIED PLAN NAMES SHOULD BEGIN WITH DSN
DSNE932I WARNING, ONLY IBM-SUPPLIED PACKAGE-IDS SHOULD BEGIN WITH DSN
DSNE932I WARNING, ONLY IBM-SUPPLIED COLLECTION-IDS SHOULD BEGIN WITH DSN
- If the DSNTIJSG job fails or abends:
- Be sure that the user that is specified
on the JOB statement is authorized. Use the same name that you specified
for either the SYSTEM ADMIN 1 option or the SYSTEM ADMIN 2 option
on installation panel DSNTIPP1.
-
Correct any other problems with the DSNTIJSG job, and run it again. If you do not have enough
resources to run the job, review the values that you specified for the Db2 installation parameters. (See job DSNTIJUZ.) Use
the standard update procedure to make any necessary modifications. Then stop Db2, run the DSNTIJUZ job, start Db2, and run the DSNTIJSG job again.
What to do next
During the ISPF tailoring session, you named one or two IDs to have installation
SYSADM authority. One of these users can now grant various levels of authority to other users. You
can use SPUFI or a job similar to DSNTIJSG to perform the authorization. To grant SYSOPR authority
to all primary and secondary user IDs that issue
Db2 commands from the z/OS® console or TSO SDSF, issue the following statement in SPUFI:
GRANT SYSOPR TO userid