Roadmap for installing and configuring SQL DI
Getting SQL DI up and running involves a sequence of tasks that might be best performed by people in different roles at different times. Create a high level action plan for planning, installing, and configuring SQL DI.
Consider using the following roadmap to manage your planning, installation, and configuration activities and progresses.
Sequence | Task and instructions | Priority | Type | Role and skills |
---|---|---|---|---|
Step 1 | Preparing for SQL DI installation
|
Required | Planning, installation, configuration | z/OS system administrator or programmer, Db2 system or database administrator, SQL DI setup user |
Step 2 | Configuring system capacity and resources for SQL DI | Required | Planning, configuration | z/OS system administrator, MVS system administrator |
Step 3 | Configuring network ports for SQL DI | Required | Planning, configuration | z/OS system programmer with Unix service system skills, network administrator |
Step 4 | Configuring setup user ID for SQL DI | Required | Planning, configuration | z/OS system administrator or programmer with Unix service system skills, security administrator |
Step 5 | Configuring a keyring-based keystore (JCERACFKS) for SQL DI | Required | Configuration | z/OS system administrator or programmer with Unix service system skills and z/OS keyring and keystore skills, network administrator, security administrator |
Step 6 | Configuring Db2 for SQL DI | Required | Configuration | Db2 system or database administrator |
Step 7 | Installing and configuring SQL DI | Required | Installation, configuration | SQL DI setup user, z/OS system programmer with Unix shell skills |
Step 8 | Verifying the installation and configuration of SQL DI | Required | Installation, configuration | z/OS system administrator or programmer, Db2 system or database administrator, SQL DI setup user |
Step 9 | Upgrading SQL DI | Required (for installing the latest enhancements) | z/OS system administrator or programmer, Db2 system or database administrator, SQL DI setup user |
The roadmap consists of the following elements:
- Sequence
- Prescribes the order in which a task must be performed in the overall installation and configuration process. It will be noted if a particular task can be executed concurrently with another one or otherwise out of the order.
- Task and instructions
- Specifies the name of a task in the sequence and links to step-by-step instructions for performing the task.
- Priority
- Specifies whether a task is required or optional.
- Type
- Indicates the type of a task that can be planning, installation, or configuration. Some planning tasks, such as allocating system capacity and procuring prerequisite hardware and software, require longer lead time to complete. Quickly identify those tasks so that you can factor in the required time in your own action plan.
- Role and skills
- Recommends the IT role, skills, and access levels required for performing a particular task. For example, a z/OS system administrator with UNIX shell programming skills is one of the roles required for installing and configuring SQL DI. While the roles of database administrator, security administrator, network administrator, and UNIX shell programmer are optional, their skills and knowledge are much wanted.