Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Using statistical variables in the Data flow to load a log table

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Using statistical variables in the Data flow to load a log table
 Login/Join
 
Balaji
Member
posted
Hi All,
I am new to Iway and I need to know some information about the statistical variables (like &ACCEPTS, &DELETD,&DUPLS). My requirement is to have a log table with columns like Source Database name, Target Database name, Source table name, target table name, No of rows inserted, No of rows rejected, No of rows deleted, No of rows updated, flow start time and end time. From the data migrator help I came to know that such statistical variables will be useful for this requirement. How to use such variable in my data flow or is there any other way to get such information. Kindly help me with the solutions to achieve this.

Thanks,
Balaji
 
Posts: 11 | Registered: November 06, 2013Report This Post
Clif
Guru
posted Hide Post
When you Submit or Schedule a DataMigrator flow the statistical variables are written to DataMigrator's statistics table ETLSTATS when the flow completes. See DataMigrator User's Guide Appendix A for details.


N/A
 
Posts: 397 | Location: New York City | Registered: May 03, 2007Report This Post
Balaji
Member
posted Hide Post
Clif,

Thank you. That was really helpful.
 
Posts: 11 | Registered: November 06, 2013Report This Post
Balaji
Member
posted Hide Post
Clif,

I tried recreating the log and statistical tables using the recreate option under Workspace->configuration Monitor ->Logs and traces -> DataMigrator Logs and Statistics -> Recreate.

ETLSTATS table is now created with only three columns S_REQ_Name, S_REQ_ID,S_APP_NAME.

How do I create the ETLSTATS table now with all the statistical variables?

Thanks,
Balaji
 
Posts: 11 | Registered: November 06, 2013Report This Post
Clif
Guru
posted Hide Post
It's possible that there is a etlstats.mas in your app path. Please run the command
WHENCE ETLSTATS MASTER
This will show you where the synonym you are using resides. It should be in the home\catalog directory for your release of the server.

From the menu options it looks like you are using an old version of DataMigrator. What release are you using? Please use the current production Release 7.7.05M.


N/A
 
Posts: 397 | Location: New York City | Registered: May 03, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Using statistical variables in the Data flow to load a log table

Copyright © 1996-2020 Information Builders