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/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 - > > - Show 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