The following table describes RPROF variables.
|
RPROF Variables |
Description |
User Notes |
|---|---|---|
|
DB2 subsystem ID |
DB2 subsystem identifier of the subsystem where you want to create an RPROF table. |
|
|
Explicit creator ID |
If specified, RPROF table and index are qualified using this ID. Explicit creator ID and secondary authorization ID are mutually exclusive. |
|
|
Secondary Authorization ID |
If specified, current SQLID is set to this ID before RPROF table and index are defined. Secondary authorization ID and explicit creator ID are mutually exclusive. |
|
|
DB name |
Name of database in which to build the RPROF table. |
|
|
Storage type |
Space for the RPROF database is allocated using storage groups or VSAM data sets. S – Storage Group allocation V - VSAM allocation |
|
|
Storage Group Name |
When Storage Type is set to S, you must specify the Storage Group Name to use when creating the tablespace and table for RPROF. |
|
|
VSAM Volume names |
If you select VSAM space allocation, you must specify the volume names when creating the VSAM data sets. |
|
|
RPROF initial size |
Primary size of tablespace containing the RPROF table. |
|
|
RPROF secondary size |
Secondary space allocation of tablespace containing the RPROF table. |
|
|
RPROFI1 initial size |
Primary size of RPROF index. |
|
|
RPROFI1 secondary size |
Secondary space allocation of RPROF index. |
|
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|