 |
|||||
|
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
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. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| FOCUS databse update not working | Login/Join |
| Member |
I'm executing a FOCUS program on the mainframe via a batch job to update a database containing 1,582,864 records. The job ends with a RC 8. There are no errors indicated. However, at the bottom of the SYSPRINT output is the following: REFERENCE...AT TRANS 1582000 TRANSACTIONS: TOTAL =****** ACCEPTED=****** REJECTED= 0 SEGMENTS: INPUT = 0 UPDATED =****** DELETED = 0 Are the asterisks indicating that there were too many records to handle and thus the reason for the RC 8 and the database not getting updated? | ||
|
| Expert |
The asterisks indicate that the informational counters used for the MODIFY command aren't big enough for the number of records processed. Has this program run successfully in the past? Is this a very simple MODIFY request or a complex one? Have you considered advanced facilities of the MODIFY command, such as ACTIVATE? Francis  Give me code, or give me retirement. In FOCUS since 1991 Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server | |||
|
| Gold member |
The status counters overflowed, hence the asterisks. Can you do a ? FILE dbname to see the segment counts (for large files, it will take a while to count). Do a ? FDT dbname to get directory/page count stats (quick). If these run and counts look good, you're probably OK. If this is an ongoing JOB, can the transactions be split and processed separtely? If FOCUS file is large, is it possible to segment into physical files by some high level identifier (like period, FY etc.) and use USE commands to report from? WebFOCUS 7.6.11, WINDOWS, HTML, PDF, EXCEL | |||
|
| Expert |
You could also try adding your own version of the completion message by referencing the relevant variables as there are more than just the base ones in the system messaging - TOTAL=&READS INPUT=&INPUT TRANSACTIONS=&TRANS ACCEPTED=&ACCEPTS REJECTED=&REJECTS DELETED=&DELTD DUPLICATES=&DUPLS INVALID=&INVALID NOMATCH=&NOMATCH MODIFIED=&CHNGD You could also try and intercept any errors etc. using &RETCODE, &FORERRNUM, &EXITRC etc. T
| |||||||||
|
| Member |
Just a heads up - If you are running in MVS batch mode you will always get a RC 8 if you don't put a FIN at the end of your code. WebFOCUS Production: UNIX 7.7.03M WebFOCUS Test: UNIX EDASERVE 7.7.05 Client 8.0.01 | |||
|
| Expert |
That's a good one! Hadn't thought of that. Probably is the issue! Francis Give me code, or give me retirement. In FOCUS since 1991 Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |