Increasing the file size limits for JDBC driver file uploads

Important: IBM Cloud Pak® for Data Version 4.8 will reach end of support (EOS) on 31 July, 2025. For more information, see the Discontinuance of service announcement for IBM Cloud Pak for Data Version 4.X.

Upgrade to IBM Software Hub Version 5.1 before IBM Cloud Pak for Data Version 4.8 reaches end of support. For more information, see Upgrading from IBM Cloud Pak for Data Version 4.8 to IBM Software Hub Version 5.1.

IBM Cloud Pak for Data limits the size of the JDBC driver JAR files that you can upload. However, you can increase the limits if you need to upload JDBC driver files that are larger than the default limits.

Who needs to complete this task?

To complete this task, you must be either:

A cluster administrator
An instance administrator

When do you need to complete this task?

Complete this task if you are unable to upload JDBC driver files because they exceed the default limits.

Before you begin

Best practice: You can run many of the commands in this task exactly as written if you set up environment variables for your installation. For instructions, see Setting up installation environment variables.

Ensure that you source the environment variables before you run the commands in this task.

About this task

By default, you can upload:

A single JAR file up to 150 MB
Multiple JAR files up to 750 MB total

The limits prevent malicious uploads of large files and the consumption of storage on the persistent volume.

Procedure

Log in to Red Hat® OpenShift® Container Platform as a user with sufficient permissions to complete the task.
```
${OC_LOGIN}
```
To increase the limit for a single JAR file upload:
1. Identify the size of the JDBC driver, in bytes, that you need to upload.
2. Run the following command to increase the limit for a single file upload.
  Replace <file-size> variable with the size of the file you need to upload
```
oc patch ccs ccs-cr \
--namespace=${PROJECT_CPD_INST_OPERANDS} \
--type=merge \
--patch '{"spec": {"wdp_connect_connection_jdbc_jar_file_size_limit": "<file-size>"}}'
```
To increase the limit for a batch upload:
1. Identify the size of the set of files, in bytes, that you need to upload.
2. Run the following command to increase the limit for a single file upload.
  Replace <batch-size> variable with the size of the file you need to upload
```
oc patch ccs ccs-cr \
--namespace=${PROJECT_CPD_INST_OPERANDS} \
--type=merge \
--patch '{"spec": {"wdp_connect_connection_jdbc_jar_batch_size_limit": "<batch-size>"}}'
```