---
title: "system.db.setDatasourceMaxConnections"
description: "Sets the Max Active and Max Idle parameters of a given database connection."
---

# system.db.setDatasourceMaxConnections

> Sets the Max Active and Max Idle parameters of a given database connection.

This function is used in **Python Scripting**.

## Description
Sets the *Max Active* and *Max Idle* parameters of a given database connection.

## Client Permission Restrictions
[Permission Type](projects\project-properties\project-properties.md#client---permissions): Datasource Management

Client access to this scripting function is blocked to users that do not meet the role/zone requirements for the above permission type. This function is unaffected when run in the Gateway scope.

## Syntax
`system.db.setDatasourceMaxConnections(name, maxConnections)`

### Parameters
Type | Parameter | Description 
------- | ------- | ------
String | `name` | The name of the database connection in Ignition.
Integer | `maxConnections` | Sets the Max Active and Max Idle parameters of a given database connection.

### Returns

Nothing

### Scope

All

## Code Examples
```python title="Example #1"
# Example 1: Enable a connection
system.db.setDatasourceMaxConnections("MySQL", 20)
```