Hi Jim, I remember when we ported to Jbase from Universe in 1998 that we had to fix a ton of things UV let us get away with, but Jbase didn't. It was a royal pain and a very stressful time, but I really liked that Jbase forced us to do things "right". Regards, Charlie Noah On 08-15-2011 3:31 PM, Jim Idle wrote: --Nice idea, but I seem to remember that in fact I/we had to put this back in specifically for T24. All the things you mention, and anything that you could mention are unfortunately relied upon implicitly by almost all software. If I had a dollar for all the Universe bugs we had to recreate so that we could port things, then there would be a run on dollar bills.The system is what it is, and there is no changing it. This is not the jBASE guys saying this, this is all the users. Jim-----Original Message----- From: jbase@googlegroups.com [mailto:jbase@googlegroups.com] On Behalf Of Pawel (privately) Sent: Monday, August 15, 2011 12:56 PM 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 theirown '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 ofcases)...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 pointof 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 aswehave 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 lockshappeningfor a application, and AA and AZ have this so it is easier tospot.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 CUSTOMERfile)...Might be that some core code issued F.READU without supplyingID(orsupplying a COMMON variable that contains an empty string). Putthatquery to Temenos helpdesk.What's the task is BTW? Update of which fields in CUSTOMER? Mightbean 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?VKOn Aug 10, 7:45 pm, adrian <ar_atkin...@yahoo.com> wrote:We are using 10 threads at the momentswe 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 RAMdrive.as you can see below in the show-item-locks you can see blankkeys.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,W33 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_LANGUAGE0x0000001c,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 ---AAyep , 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 customerHow many? Which method is used? Service OFS.MESSAGE.SERVICE Ipresume?RECORDKEY is blank in the locking tablesWhich tables exactly? F.LOCKING or F.JOB.LIST.n?JR type files databaseSecure updates or non-secure?Last but not least - updating 1m customers looks like aone-timetask, not a regular one, isn't it?VKOn 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 mw42view.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 + aminute.Have we a problem with our Jbase version or is thisnormalto 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. Theunixlocking 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 manypatches.System Information ==================System : HP-UX vic-samt B.11.31.U ia64 UNIX User : aatkinso (uid 187,euid187)Ttyname : /dev/pts/0Time: Fri Aug 5 20:31:32 2011Environment ===========JBCPORTNO : Not SetTAFC_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 JBCGLOBALDIRHOME: '/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/t24/dm5/bnk.run/radlib:/app/t24/dm5/bnk.run/cardlib:/app/t24/dm5/bnk.run/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 |
- RE: jbase problems show-items-locks Jim Idle
- RE: jbase problems show-items-locks Mark Hogden
- RE: RE: jbase problems show-items-locks Pawel (privately)
- Re: jbase problems show-items-locks John Watson
- RE: jbase problems show-items-locks Jim Idle
- Re: jbase problems show-items-locks John Watson
- Re: jbase problems show-items-locks VK
- Re: jbase problems show-items-locks Charlie Noah
- RE: jbase problems show-items-locks Jim Idle
- Re: jbase problems show-items-locks John Watson
- Re: jbase problems show-items-locks Charlie Noah
- Re: jbase problems show-items-locks VK
- RE: jbase problems show-items-locks Jim Idle
- RE: RE: jbase problems show-items-locks Ross Ferris
- RE: RE: RE: jbase problems show-items-locks Pawel (privately)
- RE: RE: RE: jbase problems show-items-locks David McGehee
- RE: RE: RE: jbase problems show-items-locks Jim Idle