Re: jbase problems show-items-locks

Charlie Noah Thu, 18 Aug 2011 08:27:30 -0700

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

Re: jbase problems show-items-locks

Reply via email to