Roadmap for planning, installing, and upgrading SQL DI
Getting SQL DI up and running involves a sequence of tasks that might be best performed by experts in different roles at different times. Create a high level plan or roadmap to manage the tasks and progresses of your SQL DI planning, installation, and configuration.
Consider using the following roadmap for planning, installing, and configuring your SQL DI:
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, configuring, and starting 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 | Managing SQL DI user permissions | Optional (Required for post-installation configuration) | Configuration, administration | Db2 administrator, SQL DI administrator or 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.