Configuring network ports for SQL DI
Preparing for installation involves obtaining the SQL Data Insights (SQL DI) product code and readying your system environment. SQL DI has specific system, network, user access, and security requirements. You must satisfy these requirements before you install SQL DI.
Network requirements
SQL DI requires dedicated networks and ports for communications across systems and services. Some of the ports are predefined while others can be user-defined. You must configure the following ports in your firewall before the SQL DI installation.
| System or service | Port number | Outbound system | Inbound system | Default address space |
|---|---|---|---|---|
| SQL DI UI | 15001 or user-defined | Your network | z/OS® system | SQLDAPPS |
| z/OS Spark master | 7077 or user-defined | z/OS system | z/OS Spark system | SQLDSPKM |
| z/OS Spark master REST API | 6066 or user-defined | z/OS system | z/OS Spark system | SQLDSPKM |
| z/OS Spark master UI | 8080 or user-defined | Your network | z/OS Spark system | SQLDSPKM |
| z/OS Spark worker | System-assigned* or user-defined | z/OS system | z/OS Spark system | SQLDSPKW |
| z/OS Spark worker UI | 8081 or user-defined | Your network | z/OS Spark system | SQLDSPKW |
| z/OS Spark driver | System-assigned* or user-defined | z/OS system | z/OS Spark system | SQLDSPKD |
| z/OS Spark block manager | System-assigned* or user-defined | z/OS system | z/OS Spark system | SQLDSPKX |
| z/OS driver-specific port for Spark block manager | System-assigned* or user-defined | z/OS system | z/OS Spark system | SQLDSPKD |
Notes:
- * If you manage port assignments and access in your sysplex, do not use system-assigned port numbers for Spark worker, Spark driver, Spark block manager, or z/OS driver-specific port for Spark block manager. Also, a Spark cluster requires a port range, instead of a single port, at runtime. The actual range depends on the specified maximum number of retries for binding to a port.