Increasing the file size limits for JDBC driver file uploads

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

  1. Log in to Red Hat® OpenShift® Container Platform as a user with sufficient permissions to complete the task.
    ${OC_LOGIN}
  2. 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>"}}'
  3. 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>"}}'