I think that we might already have this as an envvar/config option but I cannot find it in any docs, so you will have to ask via the support channel.
Jim > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf > Of David McGehee > Sent: Tuesday, August 16, 2011 5:50 PM > To: [email protected] > Subject: RE: RE: RE: jbase problems show-items-locks > > Depending upon your file by file requirements, 1 trigger file in a pre- > write position might serve for all. Of course, again depending upon > what you want to do, it might be the same amount of work to a) handle > the failed write (null key) as b) handling the null key BEFORE you > write. If a general solution works for you a single trigger which > transformed the null into a specific key via an algorithm works fine. > We use triggers extensively and they are simple (keep it that way) and > very effective. > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf > Of Pawel (privately) > Sent: Tuesday, August 16, 2011 2:48 PM > To: [email protected] > Subject: RE: RE: RE: jbase problems show-items-locks > > Hi, > > We use triggers and they work like a charm :) Proposed approach with > trigger could be used, but sounds like workaround of problem and would > impact on performance negatively. > T24 has a lot of files - it would mean that we need to create a trigger > for each one (we do not want to have blank ids in our database!). > Solution would not laso work for tempfiles that can potentially be > created by the system. Therefore it does not sound interesting and I > would expect system solution. > > I think that there is no better (and more efficient) place to add > something like: > if (recordid[0] == '\0' && crash_on_empty_ids_enabled) { exit(-1); } in > right places of libjbase / (jEDI) driver(s) :) > > Null ids are causing jBASE to be inconistent in a way that on non-MV > database (Oracle, SQL Server, DB2) will not accept empty ids as primary > keys. Such WRITEs with empty id will fail on Oracle if I remember well. > RECORDID primary key on Oracle was mandatory, thus non nullable. > > Ross: could you explain me why would you need to create records with > blank ids? (or record ids with field/multi/value separators?) > > New environment variable has been proposed, because jBASE configuration > is built around environment variables. I would of course perfer some > more sophisticated and documented :) configuration file. > > Kind regards > Pawel > > NB. I like jBASE db very much, but I expect it to be superfast and > reliable :) > > Dnia 16-08-2011 o godz. 1:19 Ross Ferris napisał(a): > > You don't need an environment variable for EVERYTHING ... why not > just > > attach a trigger to the file, which would give you greater > granularity > > than a system wide environment variable, and give yiou greater > control > > over what does happen when an "event of interest"(aka trigger) takes > > place > > > > Ross Ferris > > Stamina Software > > Visage > Better by Design! > > > > > > > -----Original Message----- > > From: [email protected] [mailto:[email protected]] On > Behalf > > Of Pawel (privately) > > Sent: Tuesday, 16 August 2011 5:56 AM > > To: [email protected] > > Subject: RE: RE: jbase problems show-items-locks > > > > Hi, > > > > I hope that I will finally see an (environment variable?) option in > > jBASE, which will cause jBASE to abort when empty id is used in > > database operation. All cases with an empty id I have met so far were > > caused by software bugs. Moreover they were relatively hard to track > > - usually it was complex flow to recreate problem. I do not see any > > reason in keeping 'empty id functionality' available for T24. > > It would be nice if jBASE team could go forward and throw away some > > unnecessary, 'old days' things :) > > > > Another issue that can be caused by buggy software is to put > > field/value/subvalue markers. Some jBASE commands will be later > > confused. jBASE gurus: throw these possibilities away please! > > > > Kind regards > > Pawel > > > > Dnia 15-08-2011 o godz. 20:29 Jim Idle napisał(a): > > > An empty record key is just a key without any characters. It is > > > somewhat pointless, but must be supported as people inventing their > > > own > > 'security' > > > used it a lot in the old days of Pick. > > > > > > Jim > > > > > > > > > > > > > -----Original Message----- > > > > From: [email protected] [mailto:[email protected]] On > > > > Behalf Of VK > > > > Sent: Monday, August 15, 2011 7:56 AM > > > > To: jBASE > > > > Subject: Re: jbase problems show-items-locks > > > > > > > > ... and don't forget MATREADU (though used in less number of > cases)... > > > > > > > > BTW, it was always interesting to me - what's the idea of having > > > > lock with empty record key? Does it have any sense from DBMS > point > > > > of > > view? > > > > > > > > VK > > > > > > > > On Aug 14, 3:46 am, adrian <[email protected]> wrote: > > > > > With Temenos we have found there is a problem at the Jbase > level > > > > > as > > > > we > > > > > have patched the F.READU program and there were no NULL records > > > > > being delivered here. > > > > > The null problem is seen more when there are a lots of locks > > > > happening > > > > > for a application, and AA and AZ have this so it is easier to > spot. > > > > > > > > > > The F.OFS.REQUEST.DETAIL on some of out loads takes this file > to > > > > > 15gb and bigger. > > > > > > > > > > Regards and Thanks > > > > > AA > > > > > > > > > > On Aug 11, 6:58 am, VK <[email protected]> wrote: > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Hi, > > > > > > > > > > > F_JOB_LIST looks ok... 2 files with no IDs are F_LANGUAGE for > > > > > > one session and FBNK_CUSTOMER_ROLE for another (though it > > > > > > looks not being DM-related - maybe the problem is here? both > > > > > > use CUSTOMER > > > > file)... > > > > > > > > > > > Might be that some core code issued F.READU without supplying > > > > > > ID > > > > (or > > > > > > supplying a COMMON variable that contains an empty string). > > > > > > Put > > > > that > > > > > > query to Temenos helpdesk. > > > > > > > > > > > What's the task is BTW? Update of which fields in CUSTOMER? > > > > > > Might > > > > be > > > > > > an easier solution to that... > > > > > > > > > > > Another note - non-secure is really not secure :((  Consider > > > > > > using secure mode (and pay something in performance) or J4. > > > > > > > > > > > Yet another note... is DM something called "migration tool"? > > > > > > > > > > > And - your OFS.REQUEST.DETAIL is distributed? Just curious > why. > > > > > > Accumulating over 2Gb a day? > > > > > > > > > > > VK > > > > > > > > > > > On Aug 10, 7:45 pm, adrian <[email protected]> wrote: > > > > > > > > > > > > We are using 10 threads at the moments > > > > > > > > > > > > we are using JR type out of the box from Temenos. > > > > > > > (non-secure) > > > > > > > > > > > > we are using DM.SERVICE.DATA.FILE which we are using on a > > > > > > > RAM > > > > drive. > > > > > > > > > > > > as you can see below in the show-item-locks you can see > > > > > > > blank > > > > keys. > > > > > > > > > > > >    31    9358 ../bnk.data/st/ > > > > > > > FBNK_CUSTOMER_CHARGE > > > > > > > 5383596 > > > > > > > 0x57a7c41c,W     --- > > > > > > >    31    9358 ../bnk.data/st/ > FBNK_CUSTOMER_ROLE > > > > > > > 0x02300000,W     ---    31    9358 > > > > > > > ../bnk.data/st/ FBNK_RELATION_CUSTOMER > > > > > > > 5383596 > > > > > > > 0x57a7c41c,W     --- > > > > > > >    31    9358 ../bnk.data/st/ > > > > > > > FBNK_RELATION_CUSTOMER > > > > > > > 11561555 > > > > > > > 0x5e90b3b0,W     --- > > > > > > >    31    9358 ../bnk.data/st/ FBNK_CUSTOMER#NAU > > > > > > > 5383596 > > > > > > > 0x57a7c41c,W > > > > > > > > > > > >    33    9367 ../bnk.data/of/ > > > > > > > F_OFS_REQUEST_DETAIL_06 > > > > > > > MBDM112090115838227.05 > > > > > > > 0x31fc7d36,W     --- > > > > > > >    33    9367 ../bnk.data/eb/ > > > > > > > F_DM_SERVICE_DATA_FILE > > > > > > > CCS.DM.CUSTOMER.MEMA-20110810037483638476 > > > > > > > 0x59b0e064,W     --- > > > > > > >    33    9367 ../bnk.data/eb/ > > > > > > > F_JOB_LIST_3 > > > > > > > 1139 > > > > > > > 0x6883ccaf,W     --- > > > > > > >    34    9371 ../bnk.data/eb/ F_LANGUAGE > > > > 0x0000001c,R > > > > > > > --- > > > > > > >    34    9371 ../bnk.data/st/ FBNK_CUSTOMER#NAU > > > > > > > 4872036 > > > > > > > 0x04b9c9ed,W     --- > > > > > > >    34    9371 ../bnk.data/of/ > > > > > > > F_OFS_REQUEST_DETAIL_08 > > > > > > > MBDM112090521738237.01 > > > > > > > 0x5c4e0da1,W     --- > > > > > > >    34    9371 ../bnk.data/eb/ > > > > > > > F_DM_SERVICE_DATA_FILE > > > > > > > CCS.DM.CUSTOMER.MEMA-20110810037483537290 > > > > > > > 0x0f29a5e6,W     --- > > > > > > >    34    9371 ../bnk.data/eb/ > > > > > > > F_JOB_LIST_3 > > > > > > > 250 > > > > > > > 0x7b754110,W     --- > > > > > > > > > > > > AA > > > > > > > > > > > > yep , onlive it will be a one off but now its run once > every > > > > > > > two weeks. > > > > > > > > > > > > On Aug 10, 7:16 am, VK <[email protected]> wrote: > > > > > > > > > > > > > Hi, > > > > > > > > > > > > > Clarify several things please: > > > > > > > > > > > > > > many threads say to update customer > > > > > > > > > > > > > How many? Which method is used? Service > > > > > > > > OFS.MESSAGE.SERVICE I > > > > presume? > > > > > > > > > > > > > > RECORDKEY is blank in the locking tables > > > > > > > > > > > > > Which tables exactly? F.LOCKING or F.JOB.LIST.n? > > > > > > > > > > > > > > JR type files database > > > > > > > > > > > > > Secure updates or non-secure? > > > > > > > > > > > > > Last but not least - updating 1m customers looks like a > > > > > > > > one- > > > > time > > > > > > > > task, not a regular one, isn't it? > > > > > > > > > > > > > VK > > > > > > > > > > > > > On Aug 6, 5:39 am, adrian <[email protected]> wrote: > > > > > > > > > > > > > > When running many threads say to update customer > > > > > > > > > (1,000.000) some of the tsa's show SLEEP in the mw42 > view. > > > > > > > > > > > > > > Looking at the show-items-locks we are see many times > > > > > > > > > lately the RECORDKEY is blank in the locking tables, > > > > > > > > > when this is happening the agents are only processing > > > > > > > > > 120 per minute while if we see no blank keys then we > can > > > > > > > > > process > > > > > > > > > 20,000 + a > > > > minute. > > > > > > > > > > > > > > Have we a problem with our Jbase version or is this > > > > > > > > > normal to see records in the lock table with blanks , I > > > > > > > > > must say i have never seen this over the pass years. > > > > > > > > > > > > > > We are not using the jbase locking but the UNIX locking > > > > > > > > > (set at > > > > > > > > > 24,000) on a HP box as the jDLS was causing problems. > > > > > > > > > The > > > > unix > > > > > > > > > locking has been running fine for over a month now. > > > > > > > > > > > > > > Could somebody knowing Jbase explain many thanks. > > > > > > > > > > > > > > Sorry we are using JR type files database and R10 with > > > > > > > > > many > > > > patches. > > > > > > > > > > > > > > System Information > > > > > > > > > ================== > > > > > > > > > > > > > > System            : HP-UX vic-samt > > > > > > > > > B.11.31.U > > > > > > > > > ia64 UNIX User          : aatkinso > > > > > > > > > (uid 187, euid > > > > > > > > > 187) > > > > Tty > > > > > > > > > name           : /dev/pts/0 > > > > Time > > > > > > > > > : Fri Aug  5 20:31:32 2011 > > > > > > > > > > > > > > Environment > > > > > > > > > =========== > > > > > > > > > > > > > > JBCPORTNO          : Not Set > > > > TAFC_HOME > > > > > > > > > : '/app/tafc/r10SP8/R10' > > > > > > > > > JBCGLOBALDIR         : > '/app/tafc/r10SP8/R10' > > > > > > > > > WARNING: JBCDATADIR is not set, Default > > > > '/app/tafc/r10SP8/R10/ > > > > > > > > > jbase_data' > > > > > > > > > WARNING: JBCDATADIR is subdirectory of JBCGLOBALDIR > > > > HOME > > > > > > > > > : '/app/t24/dm5/bnk.run' > > > > > > > > > JEDIFILEPATH         : > '/app/t24/dm5/bnk.run' > > > > > > > > > JEDIFILENAME_MD       : > '/app/t24/dm5/bnk.run/VOC' > > > > > > > > > JEDIFILENAME_SYSTEM     : > '/app/t24/dm5/bnk.run/SYSTEM' > > > > > > > > > RELEASE Information     : Major 10.0 , Minor > 0.8 > > > > > > > > > , > > > > Patch > > > > > > > > > (Change > > > > > > > > > 92702) > > > > > > > > > Spooler dir (JBCSPOOLERDIR) : '/usr/spool/jspooler' > > > > > > > > > JBCEMULATE          : 'prime' > > > > > > > > > Object path (JBCOBJECTLIST) : > > > > > > > > > '/app/t24/dm5/bnk.run/ccslib:/app/t24/ > > > > > > > > > > > > > dm5/bnk.run/GR0800004lib:/app/t24/dm5/bnk.run/t24lib:/app/t24/ > > > > > > > > > dm5/ > > > > > > > > > > > > > bnk.run/GR0800005lib:/app/t24/dm5/bnk.run/GR0800006lib:/app/t2 > > > > > > > > > 4/dm5/ > > > > > > > > > > > > > bnk.run/radlib:/app/t24/dm5/bnk.run/cardlib:/app/t24/dm5/bnk.r > > > > > > > > > un/ > > > > > > > > > > > > > > usrdlib:/app/t24/dm5/bnk.run/GR0800012lib:/app/t24/dm5/bnk.run/atmlib' > > > > > > > > > jBASE Compiler Run-time   : > > > > > > > > > '/app/tafc/r10SP8/R10/config/ system.properties' > > > > > > > > > Program dir (JBCDEV_BIN)   : > '/app/t24/dm5/bnk.run/ccsbin' > > > > > > > > > Subroutine dir (JBCDEV_LIB) : > '/app/t24/dm5/bnk.run/ccslib' > > > > > > > > > Max open files        : 8192 jsh aatkinso > ~ > > > > > > > > > -->- > > > > -- > 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 > > -- > 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 -- 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
