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: jbase@googlegroups.com [mailto:jbase@googlegroups.com] On Behalf > Of Pawel (privately) > Sent: Tuesday, 16 August 2011 5:56 AM > To: jbase@googlegroups.com > 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: jbase@googlegroups.com [mailto:jbase@googlegroups.com] 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 <ar_atkin...@yahoo.com> 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 <kzm...@yahoo.com> 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 <ar_atkin...@yahoo.com> 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 <kzm...@yahoo.com> 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 <ar_atkin...@yahoo.com> 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 jBASE@googlegroups.com To unsubscribe, send email to jbase-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/jBASE?hl=en