How to restrict number of active database in DB2?

Опубликовано: 18 Октябрь 2025
на канале: DB Tutorials

812

Hello Welcome to DB Tutorials.

We are going to look at "how to restrict number of active database in DB2?"

Now open run, by pressing win+R and type db2cmd, then press enter.

As my instance is not started yet, i'm issuing db2start to up my instance.

Now lets see how many databases I've in my instance.

Here I've two database.

If you see here, I'm able to connect to, two databases in separate windows.

Now lets see the number of active databases.

Now I want to restrict the number of active databases.

For that we've to update, "NUMDB" in "database manager".

Once you update this parameter, need to bounce the instance.

If you see here, after updating this parameter, we are able to connect only one database, at a time.