Reading and Setting Soft Limits

You are looking at an older version of the documentation. The latest version is found here.

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")');;