MONITORQUERYBAND Open API Issue

Database
Enthusiast

MONITORQUERYBAND Open API Issue

Hi,

I am using the SYSLIB.MONITORQUERYBAND Open API in my application.

the API takes three parameters, 

HostId,SessionNo,RunVProcNo

The CLIv2 counterpart of this API has the option of passing null/0 for the parameter VprocNo , but the open API doesn't allow me to do this..

 

SELECT 

SessionNo

,UserName

,PartName

,PEstate

,AMPIO

,ReqSpool

,MonitorQueryBand(HostId,SessionNo,coalesce(RunVprocNo,0))

,Blk1SessNo

FROM TABLE(MonitorSession(-1,'*',0)) AS T1

 

fails saying PE Vproc number.

 

Note: I have tried explicit zero/null instead of coalesce. Teradata version 13.10

2 REPLIES
Junior Contributor

Re: MONITORQUERYBAND Open API Issue

The RunVProcNo parameter must be an existing PE number, but neither NULL nor 0 exist.

Remove the offending NULL: WHERE RunVprocNo IS NOT NULL

or use COALESCE(RunVprocNo ,LogonPENo)

Dieter

Enthusiast

Re: MONITORQUERYBAND Open API Issue

Hi Dieter,

Thanks for your reply..

But the issue is that some of the sessions that I process are FASTLOAD/MLOAD/FASTEXPORT sessions (through TPT).

Hence I think these sessions are logged on to the AMP directly. 

I do believe we have an option in TPT to set querybands to sessions used in Load/Update/Export operators.

I am not sure whether these querybands will be applied only to PE sessions of Opertor or the AMP sessions as well.

If the query bands are applied to Amp Session as well then I would have to somehow get the querybands for these sessions as well.

If not then how would I associate a AMP based TPT session with a specific TPT triggered from my Application.

Please let me know if I am wrong about the AMP based sessions in TPT.

Thanks in advance,

Charles