Hi,
1. I think there is nothing weird. What are these 2 banks doing? There are no 2 banks with similar business in the world :)
Check what is in logsets of bank 1 and what is in logsets of bank 2. You may discover that bank 1 money flow consists of teller operations and bank 2 money flow is done maily through internet channels (eg. TELLER vs FUNDS.TRANSFER). Numbers of accountings may be the same, but T24 contracts can be completely different.
Different records in logsets, different logset size, right?
2. You are also trying to compare two different jBASE releases to each other. I belive that transaction journal logsets internal format (!!!) may change over minor jBASE releases (compare kindly 4.1.5.11 and latest 4.1.5.31). I would never compare two different kinds of software (jb5 is a major change from jb4 - you are likely not able to use logsets from jb4 on jb5 release).
3. I do not want to mention also that T24 table structures in R06 and R09 are different (so R09 records will be effectively a bit bigger from R06 records).
Kind regards
Pawel
Dnia 18-08-2010 o godz. 8:30 FaktoriyeL ! napisał(a):
Hi;
Log size issue is very interesting for us. let me explain;
we have two banks in different country that using T24.As I said The first bank uses T24 R09 and TAFC. The other bank uses T24 R07 and jbase 4.1.5.11. First bank creates 4 Million records and log size is 11 GB approx for each day. The other bank creates 4 million records and log size is 3 GB approx for each day. I think this is weird. Because record count is almost same.
And yes we closed some files logging attirube. the files like following.
(and I cannot analyze our log files. because all command (like SELECT LIST) get this error)
F.EB.PHANTOM
F.ACTIVITY
F.PROTOCOL
F.DE.SYSLOG
F.OS.TOKEN
F.OS.TOKEN.USE
F.DE.PHANTOM.LOG
F.TERMINAL
F.ENQUIRY.SELECT
F.ENQUIRY.LEVEL
F.OS.XML.CACHE
F.TSA.SERVICE
F.TSA.SERVICE$HIS
F.TSA.STATUS
F.BATCH.STATUS
F.JOB.TIMES
F.OFS.MSG.UNIQUE.REF
F.OFS.REQUEST.DETAIL
and of course $JBCDIR/jbc/jspooler/*
when we used old version of T24 (R06 and jbase 4.1.5) we did not get any error message. we upgraded t24 version and jbase version (same time) and this issue occurred.
Thank you, Best Regards
2010/8/18 Pawel (privately) <[email protected]>
Hi,
So you should really stress out to CSHD that it is important issue and
you really require assistance (you pay for it I belive!). I am sure they
will help you - your Support and Account Managers are first escalation
points.
Logsets 10 GB large from a whole business day is not anything uncommon.
You should however check what you store to logsets. I hope you do not
save unnecessary information like F.TSA.STATUS, F.TSA.SERVICE,
F.EB.PHANTOM tables. These files you can safely exclude (jchmod -T if I
remember well).
Analyse logsets also to check which tables are most popular - perhaps
you will find something that you do not need to keep.
Release information did not tell me much (Major 09.0 , Minor 0.6 , Patch
 (Change 86864)).
I think that rebranding jBASE to TAFC and hiding (real?) version number
will only introduce people's confusion. TAFC 9.06 is equal to jBASE 5,
right? (which minor release by the way?) :|
Last thing (just comment): I see that you use gcc as compiler. Is this
new default? We (and Temenos I think) are normally using xLC, which is
shipped together with AIX.
I am afraid that I can not help you much. Does issue happen since you
upgraded to R09? Has not it been adressed before upgrade?
Kind regards
Pawel
Dnia 17-08-2010 o godz. 9:33 cengizhan napisał(a):
> Firstly thank you very much for all your answers.
>
> We already have gone to Temenos Support. They wanted our TJ Log files
> but the log file size is about 10 GB and log counts are about 4
> Million. Is this normal? Anyway I sent the files them but they have
> not responded yet. we have been waiting for two months.
>
> And the other information. We had used jbase4 before jbase5. There was
> no error. We upgraded our DBMS. And we got these errors.
>
> And I am so sorry for your rules. This is first post in this group and
> I didn't know the rules. after that I will be more careful.
>
> Â Â Â Â jdiag - jBASE diagnostic '$Revision: 1.15 $'
>
> System Information
> ==================
>
> System            : AIX trkshaix 3.5 000CC802D900
> OS Release          : 5.3.9.0
> UNIX User          : bulent (uid 204, euid 204)
> Tty name           : /dev/pts/76
> Time             : Tue Aug 17 10:22:58 2010
>
> Environment
> ===========
>
> JBCPORTNO Â Â Â Â Â Â Â Â Â : Not Set
> JBCRELEASEDIR Â Â Â Â Â Â Â : '/opt/TAFC/R09'
> JBCGLOBALDIR Â Â Â Â Â Â Â Â : '/opt/TAFC/R09'
> WARNING: JBCDATADIR is not set, Default '/opt/TAFC/R09/jbase_data'
> WARNING: JBCDATADIR is subdirectory of JBCGLOBALDIR
> HOME Â Â Â Â Â Â Â Â Â Â Â Â : '/opt/globus/TBASLIV/bnk/bnk.run'
> JEDIFILEPATH Â Â Â Â Â Â Â Â : '/opt/globus/TBASLIV/bnk/bnk.run'
> JEDIFILENAME_MD Â Â Â Â Â Â : '/opt/globus/TBASLIV/bnk/bnk.run/VOC'
> JEDIFILENAME_SYSTEM Â Â Â Â : '/opt/TAFC/R09/src/SYSTEM'
> RELEASE Information     : Major 09.0 , Minor 0.6 , Patch  (Change
> 86864)
> Spooler dir (JBCSPOOLERDIR) : '/opt/globus/TBASLIV/bnk/bnk.run/
> jspooler'
> JBCEMULATE Â Â Â Â Â Â Â Â Â : 'prime'
> WARNING: Cannot access Executable path '/usr/vac/bin', error 2
> WARNING: Cannot access Executable path '/usr/local/bin', error 2
> WARNING: Cannot access Executable path '/opt/globus/TBASLIV/bnk/
> bnk.run/globuspatchbin', error 2
> WARNING: Cannot access Library path '/usr/java5/jre/lib/platform',
> error 2
> Object path (JBCOBJECTLIST) : '/opt/globus/TBASLIV/bnk/bnk.run/t24lib:/
> opt/globus/TBASLIV/bnk/bnk.run/gdGR0100040lib:/opt/globus/TBASLIV/bnk/
> bnk.run/globuspatchlib:/opt/globus/TBASLIV/bnk/bnk.run/lib:/opt/globus/
> TBASLIV/bnk/bnk.run/GR0300108lib:/opt/TAFC/R09/lib'
> WARNING: Cannot access Object path '/opt/globus/TBASLIV/bnk/bnk.run/
> gdGR0100040lib', error 2
> WARNING: Cannot access Object path '/opt/globus/TBASLIV/bnk/bnk.run/
> globuspatchlib', error 2
> jBASE Compiler Run-time   : '/opt/TAFC/R09/config/system.properties'
> jcompile.ccjbc        : 'gcc'
> jcompile.ccjbc.options    : '-fPIC -w -maix64'
> jcompile.cc         : 'gcc'
> jcompile.cc.options     : '-fPIC -w -maix64'
> jcompile.cpp         : 'g++'
> jcompile.cpp.options     : '-fPIC -w -maix64'
> jcompile.ccslib       : 'gcc'
> jcompile.ccslib.options   : '-shared -Wl,-brtl'
> jcompile.ccexe        : 'gcc'
> jcompile.ccexe.options    : '-shared -Wl,-brtl'
> jcompile.output.file     : '-maix64 -o'
> jcompile.debug        : '-g'
> jcompile.optimise      : '-O2'
> jcompile.obj.extension    : '.o'
> Program dir (JBCDEV_BIN) Â Â : '/opt/globus/TBASLIV/bnk/bnk.run/bin'
> Subroutine dir (JBCDEV_LIB) : '/opt/globus/TBASLIV/bnk/bnk.run/lib'
> Max open files        : 65534
>
> Thank You..
>
>
>
>
>
>
>
>
>
>
>
>
> On Aug 17, 12:48Â am, "Pawel (privately)" <[email protected]> wrote:
> > Hi,
> >
> > Not sure about jBASE 5, but in 4.1.5.29 jBASE guys did a lot of updates
> > to Transaction Journaling processes. We have reported only 1 serious (in
> > our opinion) thing - "DB-PAUSE -art" seemed to not stop db activity
> > properly. We suspect that problem is coming from older 4.1 release (did
> > not test to be honest). There is a (little?) change that we also did not
> > do everything properly (I am in doubts with problem reported)...
> >
> > Get change logs for jBASE 5 - perhaps it is worth upgrading to newer
> > minor release. Guys are really fixing issues and it is worth to read
> > changelogs - to convince people to upgrade :)
> >
> > Segmentation Violation problems are rather serious problems. Is in not
> > that one related to your setup / OS (version)? Anything special?
> >
> > Kind regards
> > Pawel
> >
> > Dnia 16-08-2010 o godz. 11:36 cengizhan napisa (a):
> >
> > > Hi All;
> >
> > > We are testing Transaction Journaling on our systems. The Log records
> > > are created by T24 without any error message. But we replay these logs
> > > to another environment on another server. we got  "jBASE: Segmentation
> > > violation. Aborting" error message. these two server excatly same. We
> > > think the problem about Journaling logs because of we use SELECT or
> > > LIST command on log files and get same error message. for example
> >
> > > jsh tbasjrn ~ -->SELECT TJLOGWINDOW WITH TIME EQ 13:40
> > > jBASE: Segmentation violation. Aborting
> >
> > > our jbase version is TAFC (jbase 5) Â and T24 verison is R09;
> >
> > > Could you please help me;
> >
> > > Thank You....
--
Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines
IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24
To post, send email to [email protected]
To unsubscribe, send email to [email protected]
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
