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 ~ -->- > > > > > > > Hide quoted text - > > -- 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 -- 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