XCOM Data TransportXCOM Data Transport - WindowsXCOM Data Transport - Linux PCXCOM Data Transport - z/OS
Issue/Introduction
Today we had an issue where the XCOM GW just stopped sending the files and we could not detect in a timely manner. The reason ( or technical symptom was “no available active session”. We need to monitor with our management platform ( Microfocus OBM) the performance of XCOM GW. Today, we are already monitoring the log files. It is ok for errors, but we cannot understand easily the performance of our XCOM platform. To give us more control we need to: Perform a recurrent query ( every 1 hour ) with a time scope of every hour with the following output: Number of files transferred sucessfuly | Number of files failed | Number of files in “transferring” could you provide us this query? Can a database query be used to check if the files in the queue are increasing or not? That should help us determine if there is a problem with file transfers. Can a database query be used to check if the files in the queue are increasing or not? That should help us determine if there is a problem with file transfers.
Environment
XCOM r12.0 for Gateway
Resolution
Yes, you can use a database query or XCOM line command line to query the XCOM agent history running on the Gateway. Here is a sample database query created by the user to query XCOM Gateway database:
SELECT * FROM XCOM_GATEWAY_FILE_TRANSFER t3, XCOM_GATEWAY_FILE t2, XCOM_GATEWAY_POLICY t1, XCOM_GATEWAY_FILE_DISPOSAL t0 WHERE (((((((t1.POLICY_ROWID = t2.POLICY_ROWID) AND (t2.FILE_ROWID = t3.FILE_ROWID)) AND (t2.FILE_ROWID = t0.FILE_ROWID)) AND (t0.USER_ROWID = 0)) AND (t0.DISPOSAL_STATUS >= 1)) AND (t2.FILE_IMPORTATION_TIME >= '< date > ' )) )
Creating Index on XCOM_GATEWAY_FILE table as shown below improves the response time of query and even the file transfer status page of Gateway UI (Customer reported that response time improved from 15 sec to 2 sec)
create index XCOM_GATEWAY_FILE_IDX_02 on XCOM_GATEWAY_FILE ( FILE_IMPORTATION_TIME, FILE_ROWID, POLICY_ROWID)