Reading and Setting Soft Limits

Here are some SQL examples for reading and setting soft limits.

1. Reading concurrent job count value:

SQL

CALL "SYSADMIN.executeCli"(
    "script" => '/subsystem=teiid/:read-attribute(name=quartz)'
);;

2. Increasing concurrent job count to 30:

SQL

CALL "SYSADMIN.executeCli"(
    "script" => '/subsystem=teiid/:write-attribute(name=quartz,value=[("org.quartz.threadPool.threadCount" => "30"),("org.quartz.jobStore.class" => "com.datavirtuality.dv.core.scheduler.DVJobStore"),("com.datavirtuality.quartz.DVJobStore.misfireThreshold" => "3600000")])'
);;

3. Reading the number of concurrent queries and threads:

SQL

CALL "SYSADMIN.executeCli"("script" => '/subsystem=teiid:read-attribute(name=max-active-plans)');;

CALL "SYSADMIN.executeCli"("script" => '/subsystem=teiid:read-attribute(name=max-threads)');;

4. Increasing concurrent queries to 40:

SQL

CALL "SYSADMIN.executeCli"("script" => '/subsystem=teiid:write-attribute(name=max-active-plans,value="40")');;

CALL "SYSADMIN.executeCli"("script" => '/subsystem=teiid:write-attribute(name=max-threads,value="128")');;