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 ~ -->- 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 [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
