on 01-30-2015 5:14 AM
Please help me on this what is the use of proxy table and on what purpose we should use
Hi Goyal,
Proxy table named also existing tbale, is a table visible in SAP IQ database and mapped to a different table which physically exists in a remote Database SAP IQ, SAP ASE, Oracle or others.
They can be used to copy data from/to local IQ Database and remote database, query remote data etc.
Regards,
Tayeb.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Tayeb,
Kindly resolve my below problem
How can i union of three table sp_iqconnection() and sp_iqtransaction and sp_iqcontext()
i want output in below format(add one more column for IDLE and INTENSIVE query)
if query running more then 30 minutes means its an intensive query
if user is not doing anything past 30 minutes means its idle
i want output in below format
connectio type | ConnHandle | Userid | LastReqTime | LowestIQCursorState | IQthreads | TempWorkspace | Nodeaddr | LastIdle(in hours) | cmd |
IDLE | 10 | xxx | 17:13.4 | None | 10 | 200 | 10.12.12.12 | 1 | select * from tmp |
INTENSIVE | 11 | yyy | 15:10:05 | fetching | 20 | 300 | 10.14.13.19 | NA | select * from sp_iqcontecx |
if there is any new method please help me
Updated in your other post http://scn.sap.com/thread/3688516 .
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.