Process Scheduler

[BBosma]

Is it possible to modify the "sql" that the Process Scheduler(PSPRCSRV)is using? I would like to add an "Oracle Hint" to a SELECT statement.

 

[nexwave]

You may find the sql in question in the stored statements of src\cbl\base. If you are wanting to HINT the sql due to poor response then I would also investigate tables message_log, and message_logparm.

 

[BBosma]

The "dms" files are for the COBOL modules. PSNTSRV is a C++ module. The SQL I'm trying to modify is show below. Only takes about 2 seconds but is perform everytime the Scheduler wakes up (does full table scans on these two tables). With a "hint" I could make it less then a second.

SELECT Q.PRCSINSTANCE
,Q.JOBINSTANCE
,Q.SESSIONIDNUM
,Q.OPRID
,Q.OUTDESTTYPE
,Q.GENPRCSTYPE
,P.PRCSOUTPUTDIR
FROM PSPRCSQUE Q
,PSPRCSPARMS P
WHERE Q.RUNSTATUS = :1
AND Q.SERVERNAMERUN = :2
AND Q.RUNLOCATION = '2'
AND Q.PRCSINSTANCE = P.PRCSINSTANCE