During the customization process, you must provide parameter
values for Db2 Table Editor,
for Db2®, and for your LPAR.
Customization values for the Discover EXEC
- Description
- Use the following worksheet to identify and record the customization
values for the Tools Customizer Discover EXEC. The values in this
worksheet are for extracting information from a product that has already
been customized. During the customization process, you will enter
these values on panel CCQPDSC.
Note: Complete this worksheet only if
you are recustomizing a product that has previously been customized
by using Tools Customizer.
| Parameter |
Sample or default value |
Your value |
| Discover EXEC for Extracting
Information from an Already Customized product |
- Discover EXEC library
- The fully qualified data set name that contains the product Discover
EXEC.
|
The name of the Discover EXEC Library that you
entered on the settings panel. |
|
- Discover EXEC name
- The name of the Discover EXEC.
|
ETIDISC |
|
- Discover output data set
- The name of the data set for the output from the product Discover
EXEC.
|
The name of the discover output library that
you entered on the settings panel. |
|
- New ETI load library
- The load library name for the new release of Db2 Table Editor.
For example,
if this release is V4.5,
the library name might be ETI.SETILOAD or ETI.LOADLIB (using a generic
load library name) or ETI.V450.SETILOAD
or ETI.V450.LOADLIB
(using a release specific library name).
|
ETI.V450.SETILOAD |
|
| Information for Discover EXEC
section |
- New ETI ISPM library
- The message library name for the new release of Db2 Table Editor.
For example,
if this release is V4.5,
the library name might be ETI.SETIMENU or ETI.ISPMLIB (using a generic
message library name); or ETI.V450.SETIMENU or ETI.V450.ISPMLIB (using a release
specific library name).
|
ETI.V450.SETIMENU |
|
- Discover from previous ETI control file
- ETI control file name to discover from.
|
ETI.V450.DB2.CONTROL |
|
- Discover from previous ETI CLIST library
- ETI CLIST library to discover from.
|
ETI.V450.SETISAMP |
|
- Discover from previous ETI SAMPLIB library
- ETI SAMPLIB library to discover from.
|
ETI.V450.SETISAMP |
|
Product to Customize section
- Description
- The parameters that are listed in the Product to Customize section
are read-only. They contain information that was provided on other
panels, by Tools Customizer, or by the Db2 Table Editor metadata data
set.
| Parameter |
Discovered? |
Source of this value |
- Product metadata library
- This value is the library that you specified on the Specify
the Product to Customize panel. This field is scrollable.
Place your cursor anywhere on the field and press PF11 to view its
full contents.
|
No |
This value is specified on the Specify
the Product to Customize panel (CCQPHLQ) |
- LPAR
- The LPAR field displays the LPAR on which
you are customizing Db2 Table Editor.
|
No |
This value is supplied by Tools Customizer. |
- Product name
- This value displays the product that is being customized. In this
example, IBM® Db2 Table Editor should be displayed
in this field. This field is scrollable. Place your cursor anywhere
on the field and press PF11 to view its full contents.
|
No |
This value is provided by the product metadata
file. |
- Version
- The Version field displays the version,
release and maintenance of the product you are customizing in the
format Vn.Rn.nn.
|
No |
This value is provided by the product metadata
file. |
- Product customization library
- This value displays the name of the data set in which the generated
library customization jobs will be stored.
|
No |
This value is derived from the user-specified
customization library qualifier on the Tools Customizer
Settings panel (CCQPSET). |
Required parameters section
- Description
- The parameters in this task are required for all customizations.
During the customization process, you will enter these values on panel
CCQPPRD.
| Parameter |
Required? |
Discovered? |
Default value |
Your value |
- Control file
- The name of the control file that will be used for this installation
or release of Db2 Table Editor.
The control file contains configuration information for each Db2 subsystem against which the
product can run.
|
Yes |
No |
ETI.DB2.CONTROL |
|
- CLIST for ETI
- The CLIST library name for Db2 Table Editor.
|
Yes |
No |
ETI.V450.SETISAMP |
|
- Db2 Table Editor HLQ
- This parameter specifies the high level qualifier of the product
data sets.
|
Yes |
No |
ETI.V450 |
|
- Db2 Table Editor startup
CLIST 1
- This parameter specifies the name of the first of two Db2 Table Editor startup CLISTs.
This CLIST sets up the application environment, and then calls the
second CLIST.
|
Yes |
No |
ETIV45 |
|
- Db2 Table Editor startup
CLIST 2
- This parameter specifies the name of the second of two Db2 Table Editor startup CLISTs.
This second CLIST invokes the product with specific parameters.
|
Yes |
No |
ETIV45C |
|
- Warn when excluding columns
- This parameter specifies to issue a warning when a column is excluded
in an edit session. Valid values are NO and YES.
|
Yes |
Yes |
NO |
|
- Warn when locking a table
- This parameter specifies to issue a warning when an attempt to
exclusively lock a table is made. Valid values are NO and YES.
|
Yes |
Yes |
NO |
|
- Warn when entering Db2 Subsystems
- This parameter specifies to issue a warning when an attempt is
made to enter the Db2 Subsystems
panel. Valid values are NO and YES.
|
Yes |
Yes |
NO |
|
- Lock in browse mode
- This parameter specifies to allow tables to be locked while in
browse mode. Valid values are YES and NO.
|
Yes |
Yes |
NO |
|
- Show locking options
- This parameter specifies to prevent the Lock Table option from
being displayed. Valid values are YES and NO.
|
Yes |
Yes |
YES |
|
Optional parameters section
- Description
- The parameters in this task are optional for all customizations. During the customization
process, you will enter these values in the A0CLIST job.
| Parameter |
Required? |
Discovered? |
Default value |
Your value |
- Globally defined close cursor mode
- Use this optional parameter to globally define the Close cursor mode
option. If specified, this value will override the Close cursor mode parameter
specified in a user’s profile every time you start the program.
|
No |
No |
NO |
|
- Globally defined skip locked data
- Use this optional parameter to globally define the Skip Locked Data option.
This option appends the Db2 clause SKIP LOCKED DATA to all
SELECT, INSERT, UPDATE, and DELETE statements that Db2 Table Editor performs. Valid values are YES (globally add SKIP LOCKED
DATA), NO (the default, do not globally add SKIP LOCKED DATA), and blank. If blank, the value
specified in the Skip locked data field of the User Settings panel is used.
If not specified in the user profile, then the default NO is used. The CLIST parameter is SCPLCKDT.
|
No |
No |
NO |
|
Task: ETI control file
- Description
- This task creates the control file if it does not exist or if
you are creating a new control file for a new release. The control
file contains specific information about each Db2 subsystem where Db2 Table Editor might run. During
the customization process, you will enter these values on panel CCQPPRD.
This
task is required / optional.
- Jobs generated
- This task generates the A7CCNTL job. This job is based on the
ETICCNTL template.
- Required authority
- TBD
| Step or parameter |
Required? |
Discovered? |
Default value |
Your value |
- ETI control file creation
- This step creates the control file if it does not exist or if
you are creating a new control file for a new release. The control
file contains specific information about each Db2 subsystem where Db2 Table Editor might run.
|
No |
TBD |
Selected |
|
- Volume serial number for the control file
- The volume serial number (VOLSER) to be used for the control file
creation. May be left as blanks for SMS shops.
|
No |
No |
blank |
|
Task: ETI repository objects creation DDL
- Description
- This task creates the objects that are required to use activity
log and table profile functions on a Db2 subsystem
only if those objects were not previously created in this installation
or a previous installation. During the customization process, you
will enter these values on panel CCQPDB2.
This task is required
/ optional.
- Jobs generated
- This task generates the A2DDLnn job. This job
is based on the ETIPROF1 template.
- Required authority
- The user ID that runs the A2DDLnn job must
have ETIDDL authority.
| Step or parameter |
Required? |
Discovered? |
Default value |
Your value |
- ETI repository objects creation DDL
- This step creates the objects that are required for activity log
and table profile functions on a Db2 subsystem
only if those objects were not previously created in this installation
or a previous installation.
|
No |
- |
Selected |
|
- database name
- This parameter indicates the database name that is used to store Db2 Table Editor objects.
|
Yes |
No |
ETIV45DB |
|
- SET CURRENT SQLID
- This parameter specifies the Db2 user
ID that will be used to create the Db2 Table Editor objects.
|
Yes |
No |
DB2USER |
|
- Repository table schema
- This parameter specifies the table creator for the Db2 Table Editor repository table.
This value is also used as the BIND qualifier for some packages.
|
Yes |
No |
ETIV45TB |
|
- Repository table space STOGROUP
- This value is the storage group into which to create the Db2 Table Editor V4.5 table space.
|
Yes |
No |
SYSDEFLT |
|
- Repository table space buffer pool
- This parameter specifies the buffer pool that is used for creating
the Db2 Table Editor V4.5 table
space.
|
Yes |
No |
BP0 |
|
- Repository table space primary quantity
- This parameter specifies the primary quantity in kilobytes to
allocate to the table space. Valid values are -1 or value from 1 to
4194304.
|
Yes |
No |
4194304 |
|
- Repository table space secondary quantity
- This parameter specifies the secondary quantity in kilobytes to
allocate to the table space. If you do not specify a secondary quantity, Db2 uses a formula to determine
a value. Valid values are -1 or value from 1 to 4194304.
|
No |
No |
4194304 |
|
- Repository index STOGROUP
- This value is the storage group into which to create the Db2 Table Editor index.
|
Yes |
No |
SYSDEFLT |
|
- Repository index buffer pool
- This parameter specifies the buffer pool that is used for creating
the Db2 Table Editor index.
|
Yes |
No |
BP0 |
|
- Repository index primary quantity
- This parameter specifies the primary quantity in kilobytes to
allocate to the index. Valid values are -1 or value from 1 to 2097152.
|
Yes |
No |
2097152 |
|
- Repository index secondary quantity
- This parameter specifies the secondary quantity in kilobytes to
allocate to the index. If you do not specify a secondary quantity, Db2 uses a formula to determine
a value. Valid values are -1 or value from 1 to 2097152.
|
No |
No |
2097152 |
|
- Existing log table schema
- Specify the value of the table creator used to create the Db2 Table Editor V4.4 activity
log table.
|
No |
No |
No default value. |
|
Task: ETI bind SQL
- Description
- This task binds the ETI SQL. During the customization process,
you will enter these values on panel CCQPDB2.
This task is required
/ optional.
- Jobs generated
- This task generates the A5BINDnn job. This
job is based on the ETIBIND template.
- Required authority
- The user ID that runs the A5BINDnn job must
have TBD authority.
| Step or parameter |
Required? |
Discovered? |
Default value |
Your value |
- ETI bind
- This step binds the ETI SQL.
|
Yes |
- |
Selected |
|
- BIND package owner
- This parameter indicates the user ID for the owner of the plan
and packages. The user ID value is used during the bind on the OWNER(userid)
parameter.
|
Yes |
Yes |
ETIUSER |
|
- BIND package name
- This parameter indicates the collection name to be used within
the Db2 Table Editor bind.
|
Yes |
Yes |
ETIV45PK |
|
- Repository table schema
- This parameter specifies the table creator for the Db2 Table Editor repository table.
This value is also used as the BIND qualifier for some packages.
|
Yes |
No |
ETIV45TB |
|
- Existing log table schema
- Specify the value of the table creator used to create the Db2 Table Editor V4.4 activity
log table.
|
No |
No |
No default value. |
|
- BIND plan name
- This parameter specifies the plan name (up to 8 characters) to
use for Db2 Table Editor.
|
Yes |
No |
ETI450PL |
|
- ENCODING bind option
- This parameter allows you to generate bind plans for Unicode or EBCDID systems. The ENCODING
option specifies the application encoding for all host variables in static statements in a plan or a
package.
|
No |
No |
ENCODING (EBCDIC) |
|
Task: Edit startup CLIST
- Description
- During the customization process, you will enter these values
on panel CCQPPRD.
This task is required / optional.
- Jobs generated
- This task generates the A0CLIST job. This job is based on the
ETICLIST template.
- Required authority
- The user ID that runs the A0CLIST job must have TBD authority.
| Step or parameter |
Required? |
Discovered? |
Default value |
Your value |
- Edit startup CLIST
- This step edits the startup CLIST to provide proper dsnames for
your site.
|
Yes |
- |
Selected |
|
Task: ETI configure Db2
- Description
- This task configures each Db2 subsystem
within the control file.
This task is optional in the sense that
you can either perform this task for all your Db2 subsystems (or any subset of them), or you
can perform this same task using option #1 (Db2 Subsystems) from the Db2 Table Editor main menu to
configure each Db2 subsystem
individually, as needed. A Db2 subsystem
must be configured using one of these methods before it can be used
with Db2 Table Editor.
During
the customization process, you will enter these values on panel CCQPDB2.
This
task is required / optional.
- Jobs generated
- This task generates the A8UCNTnn job. This
job is based on the ETIUCNTL template.
- Required authority
- The user ID that runs the A5LOADnn job must
have TBD authority.
| Step or parameter |
Required? |
Discovered? |
Default value |
Your value |
- ETI configure Db2
- This step configures each Db2 subsystem
within the control file. It is optional in the sense that you can
either perform this task here for all your Db2 subsystems (or any subset thereof), or you
can perform this same task using option #1 (Db2 Subsystems) from the Db2 Table Editor main menu to
configure each Db2 subsystem
individually, as needed. A Db2 subsystem
must be configured using one of these methods before it can be used
within Db2 Table Editor.
|
No |
- |
Not selected |
|
- BIND plan name
- This parameter specifies the plan name (up to 8 characters) to
use for Db2 Table Editor.
|
Yes |
No |
ETI450PL |
|
- Enable user activity log
- This parameter specifies to enable user activity logging. Valid
values are NO and YES.
|
Yes |
No |
NO |
|
- Db2 subsystem ID description
- A description for the Db2 subsystem.
This value must be 72 characters or less.
|
No |
No |
No default value. |
|
- Load library
- The data set name of the Db2 load
library.
|
Yes |
Yes |
No default value. |
|
- Run library
- The data set name of the Db2 run
library.
|
Yes |
No |
No default value. |
|
- Exit library
- The data set name of the Db2 exit
library.
|
Yes |
No |
No default value. |
|
Task: Launchpad
- Description
- This task adds Db2 Table Editor to
the Db2 Administration Tool
Launchpad. During the customization process, you will enter these
values on panel CCQPPRD.
This task is required / optional.
- Jobs generated
- This task generates the A9ADBI job, which is based on the ETIADBI
template.
- Required authority
- The user ID that runs the A9ADBI job must have TBD authority.
| Step or parameter |
Required? |
Discovered? |
Default value |
Your value |
- Launchpad
Modifies the REXX EXEC to add Db2 Table Editor to the Db2 Administration Tool Launchpad.
|
No |
- |
Not selected |
|
- Db2 Administration Tool
HLQ
- This parameter specifies the high-level qualifier of the Db2 Administration Tool data sets.
If the task is selected, this value is required.
|
Yes |
No |
ADB.V110 |
|
- ADBDMTI EXEC data set
This parameter specifies the library that contains the ADBDMTI
EXEC that, when executed, adds Db2 Table
Editor to the Db2 Administration
Launchpad. If the task is selected, this value is required. If the
data set name is longer than 42 characters it must be enclosed in
quotation marks.
|
Yes |
No |
ADB.SADBEXEC |
|
Db2 Parameters
section
- Description
- This section contains Db2 parameters.
All parameters are required. During the customization process, you
will enter these values on panel CCQPDB2.
| Parameter |
Required? |
Discovered? |
Default value |
Your value |
- Mode
- This parameter indicates the mode in which the Db2 subsystem is running. The following values
are valid:
- CM is compatibility mode on all listed Db2 versions except Db2 10.
- NFM is new-function mode on all listed Db2 versions.
|
Yes |
No |
NFM |
|
- Level number
- This parameter indicates the version, release, and modification
level of the Db2 subsystem.
The following values are valid:
- 101 is valid only for NFM.
- 111 is valid only for CM or NFM.
- 121 is valid only for CM and NFM.
|
Yes |
No |
blank |
|
- Load library
- This parameter indicates the data set name of the Db2 load library.
|
Yes |
Yes |
DSN. SDSNLOAD |
|
- Run library
- This parameter indicates the data set name of the Db2 run library.
|
Yes |
Yes |
DSN.RUNLIB. LOAD |
|
- Exit library
- This parameter indicates the data set name of the Db2 exit library.
|
Yes |
Yes |
DSN.SDSNEXIT |
|
- Repository table space buffer pool/Repository index buffer pool
- This parameter indicates the name of the 4 KB bufferpool to be
used for customization. The value must be 8 characters or less.
|
Yes |
No |
BP0 |
|
- Plan name for the DSNTEP2 utility
- This parameter indicates the plan name for the DSNTEP2 utility.
The value must be 8 characters or less.
|
Yes |
No |
DSNTEP2 |
|
- Repository table space STOGROUP
- This value is the storage group into which to create the Db2 Table Editor V4.5 table space.
|
Yes |
No |
SYSDEFLT |
|
- Repository index STOGROUP
- This value is the storage group into which to create the Db2 Table Editor index.
|
Yes |
No |
SYSDEFLT |
|
- BIND plan name
- This parameter indicates the plan name to be used on the Db2 Table Editor bind.
|
Yes |
Yes |
ETI450PL |
|
LPAR Parameters section
- Description
- This section contains LPAR parameters. All parameters are required.
During the customization process, you will enter these values on panel
CCQPLPR.
| Parameter |
Required? |
Discovered? |
Default value |
Your value |
- Message library
- The data set name of the ISPF message library.
|
Yes |
No |
|
|
- Panel library
- The data set name of the ISPF panel library.
|
Yes |
No |
|
|
- Skeleton library
- The data set name of the ISPF skeleton library.
|
Yes |
No |
|
|
- ISPF table input library
- The data set name of the ISPF table input library.
|
Yes |
No |
|
|