ca.portal.admin

Re:[IDMSVENDOR-L] DBHASH and USERSTAT

Discussion created by ca.portal.admin on Feb 11, 2009
We just migrated to R16 and one of our customers are having problems
with 2 of their assembler programs. They are named DBHASH (which I
think came from the old Boxes and Arrow magazine) and the other is a
user program invoked by the task code USERSTAT which we think came from
one of the CA User Conferences. Is anyone familiar with and/or using
either of these in a R16 environment? If so, did you have to do anything
other than relink them when you migrated?

Jim Irwin
Database Technical Support
non impediti ratione congitatonis
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: DBHASH and USERSTAT
"Hmm, that clicked some synapses with me regarding the DBHASH problem.
When we migrated from 15 to 16, we had problems with German character
sets not being displayed correctly. It turned out that the problem was
that when release 16 came in, so did Code Tables. The default code
table turned out to not be the one that was necessary. We installed the
correct one, and all was right with the world (at least our world).

Since your HASH algorithm is likely returning some unusual binary
values, they may be getting translated to characters that are not what
you expect. You may need to change to a non-default Code Table.

Sorry, I am at home and don't have my notes. It seemed that CA had some
different name for the Code Table, but that was essentially what it
was. If you search the new features looking for something like language
support or international character support, you may find it.

If you think this might be your problem,but can't find the reference,
send an e-mail to my work account and I will look through my notes
tomorrow. mailTo:james.ritterbusch@ge.com

Jim Ritterbusch

Irwin, Jim wrote:
The USERSTAT program does nothing but display it's header lines. It
returns no user detail information. When DBHASH hashes a password and
compares it to the value in the database they never match. I am told
this only happens in ADS/O ...... the same code runs in CICS with no
problem. We will run the ADS dialog through ADS Alive this afternoon
and verify the values being passed are correct.


-----Original Message-----
From: IDMS Public Discussion Forum [mailTo:IDMS-L@LISTSERV.IUASSN.COM]
On Behalf Of Laura Rochon
Sent: Wednesday, February 11, 2009 2:04 PM
To: IDMS-L@LISTSERV.IUASSN.COM
Subject: Re: DBHASH and USERSTAT

Jim,

We had a problem with program SHOWUSER (from Boxes & Arrows, author
Michael A. Newman Southwest Airlines) when we migrate to R12, but no
problem going to R16. But as Dan pointed out, you have to reassemble
it. But I presumed that is what you meant when you said relinked.

What kinda problems are you having with them?
Laura

Irwin, Jim wrote:
We migrated from 15.0. DBHASH takes a user password and hashes it
before either storing it on a database or comparing it to one that has
already been stored. USERSTAT looks to be a combination of the DCUF
Show User All and DCUF Show Profile commands. =20

-----Original Message-----
From: IDMS Public Discussion Forum [mailTo:IDMS-L@LISTSERV.IUASSN.COM]
On Behalf Of Laura Rochon
Sent: Wednesday, February 11, 2009 1:28 PM
To: IDMS-L@LISTSERV.IUASSN.COM
Subject: Re: DBHASH and USERSTAT

Hi Jim,

First off, what release did you migrate from? and secondly, could you
give a brief explanation of what each program does, as we might have
called them differently.

Thanks,
Laura Rochon
Ajilon

Irwin, Jim wrote:

We just migrated to R16 and one of our customers are having problems
with 2 of their assembler programs. They are named DBHASH (which I
think came from the old Boxes and Arrow magazine) and the other is a
user program invoked by the task code USERSTAT which we think came

from

one of the CA User Conferences. Is anyone familiar with and/or using
either of these in a R16 environment? If so, did you have to do

anything

other than relink them when you migrated?

Jim Irwin
Database Technical Support
non impediti ratione congitatonis



--
Aren't you glad we didn't let Bush put your Social Security money into Wall Street?
"
IDMS 3rd-party providers forum
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP
IDMSVENDOR-L@LISTSERV.IUASSN.COM
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: DBHASH and USERSTAT
"Hmm, that clicked some synapses with me regarding the DBHASH problem.
When we migrated from 15 to 16, we had problems with German character
sets not being displayed correctly. It turned out that the problem was
that when release 16 came in, so did Code Tables. The default code
table turned out to not be the one that was necessary. We installed the
correct one, and all was right with the world (at least our world).

Since your HASH algorithm is likely returning some unusual binary
values, they may be getting translated to characters that are not what
you expect. You may need to change to a non-default Code Table.

Sorry, I am at home and don't have my notes. It seemed that CA had some
different name for the Code Table, but that was essentially what it
was. If you search the new features looking for something like language
support or international character support, you may find it.

If you think this might be your problem,but can't find the reference,
send an e-mail to my work account and I will look through my notes
tomorrow. mailTo:james.ritterbusch@ge.com

Jim Ritterbusch

Irwin, Jim wrote:
The USERSTAT program does nothing but display it's header lines. It
returns no user detail information. When DBHASH hashes a password and
compares it to the value in the database they never match. I am told
this only happens in ADS/O ...... the same code runs in CICS with no
problem. We will run the ADS dialog through ADS Alive this afternoon
and verify the values being passed are correct.


-----Original Message-----
From: IDMS Public Discussion Forum [mailTo:IDMS-L@LISTSERV.IUASSN.COM]
On Behalf Of Laura Rochon
Sent: Wednesday, February 11, 2009 2:04 PM
To: IDMS-L@LISTSERV.IUASSN.COM
Subject: Re: DBHASH and USERSTAT

Jim,

We had a problem with program SHOWUSER (from Boxes & Arrows, author
Michael A. Newman Southwest Airlines) when we migrate to R12, but no
problem going to R16. But as Dan pointed out, you have to reassemble
it. But I presumed that is what you meant when you said relinked.

What kinda problems are you having with them?
Laura

Irwin, Jim wrote:
We migrated from 15.0. DBHASH takes a user password and hashes it
before either storing it on a database or comparing it to one that has
already been stored. USERSTAT looks to be a combination of the DCUF
Show User All and DCUF Show Profile commands. =20

-----Original Message-----
From: IDMS Public Discussion Forum [mailTo:IDMS-L@LISTSERV.IUASSN.COM]
On Behalf Of Laura Rochon
Sent: Wednesday, February 11, 2009 1:28 PM
To: IDMS-L@LISTSERV.IUASSN.COM
Subject: Re: DBHASH and USERSTAT

Hi Jim,

First off, what release did you migrate from? and secondly, could you
give a brief explanation of what each program does, as we might have
called them differently.

Thanks,
Laura Rochon
Ajilon

Irwin, Jim wrote:

We just migrated to R16 and one of our customers are having problems
with 2 of their assembler programs. They are named DBHASH (which I
think came from the old Boxes and Arrow magazine) and the other is a
user program invoked by the task code USERSTAT which we think came

from

one of the CA User Conferences. Is anyone familiar with and/or using
either of these in a R16 environment? If so, did you have to do

anything

other than relink them when you migrated?

Jim Irwin
Database Technical Support
non impediti ratione congitatonis



--
Aren't you glad we didn't let Bush put your Social Security money into Wall Street?
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: DBHASH and USERSTAT
"Can you show us the ""heading lines"" for USERSTAT - if it was a User
Contributed program the author might recognise the output. From your
comments it sounds like you don't actually have the source yourself -
there's likely some (assembler) comments at the front the identify the
original author and date - that would be of some value also.

Cheers - Gary =20


Gary Cherlet
Justice Technology Services
Department of Justice, SA Government
Telephone +61 (0)8 8226 5199
Facsimile +61 (0)8 8226 5311
Mobile +61 (0)41 333 1613
MailTo:cherlet.gary@saugov.sa.gov.au

This e-mail message and any attachments are qualified as follows:
Addressing: If you have received this e-mail in error, please advise by
reply e-mail to the sender. Please also destroy the original
transmission and its contents. Confidentiality: This e-mail may contain
confidential information which also may be legally privileged. Only the
intended recipient(s) may access, use, distribute or copy this e-mail.
Individual Views: Unless otherwise indicated, the views expressed are
those of the sender, not Justice Technology Services. Computer Viruses:
It is the recipient's responsibility to check the e-mail and any
attached files for viruses.

Outcomes