ca.portal.admin

Re:Index key length

Discussion created by ca.portal.admin on Feb 9, 2007
What is the maximum length (in bytes) of an index key?

Kay Rozeboom
State of Iowa
Information Technology Enterprise
Department of Administrative Services
Telephone: 515.281.6139 Fax: 515.281.6137
Email: Kay.Rozeboom@Iowa.Gov

"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Lim Woo Liew/ITS/CPFBoard is out of the office.
"I will be out of the office starting 03/03/2006 and will not return until
06/03/2006.

I will respond to your message when I return. Any urgent matter, you can
contact my backup Ms Renae Ng x3477 or refer to my sup Ms Ang Moy Gek
x3469. Thks



WARNING: This communication is meant only for the addressee(s) named above and may contain information which is confidential and/or legally privileged. If you are not the named addressee(s), or the agent responsible for receiving and delivering this communication to the named addressee(s), this communication has been sent to you in error. If so, kindly notify the sender and delete the information immediately. Unauthorised dissemination, distribution, copying or reliance on this communication is prohibited and may attract criminal penalties.

"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
VS: [IDMSVENDOR-L] Common Signon
"This is exactly what we are doing - different reasons though, our need is to re-direct run-unit to different cv depending on subschema name AND current cv. Our applications don't fill in DBNAME, and it would be too big task to change.

This works fine when run-units are ADS or DC-Cobol, because CSADCVID holds cv version number. But we have problems with batch run under CV, CSADCVID is zero.

Does anybody know way to find out under what cv batch is run ?

It sure would be nice if resource table was checked AFTER subschema mapping (too?), becase then we could build this logic without any programming, exit or otherwise.

Timo Kotilainen,
FENNIA


-----Alkuperäinen viesti-----
Lähettäjä: IDMS Public Discussion Forum [mailTo:IDMS-L@LISTSERV.IUASSN.COM] Puolesta Chris Hoelscher
Lähetetty: 28. helmikuuta 2006 21:16
Vastaanottaja: IDMS-L@LISTSERV.IUASSN.COM
Aihe: Re: [IDMSVENDOR-L] Common Signon


Dan - you can turn all your CVs into ""front ends"" by using the DB RESOURCE
TABLE (your suggesting of DBNODES is pretyy much on target)

an example would be as follows:

*+   ADD SYSTEM 62
*+       SYSTEM ID IS CV62
*+   ADD NODE CV75
*+       CVNUMBER 75 SVC 250 BLOCKSIZE 8192
*+       .
*+       .
*+   ADD RESOURCE TABLE
*+       DBNAME IS FIPROD01 VIA CV75
*+       DBNAME IS FIPROD02 VIA CV75
*+       DBNAME IS FIPROD03 VIA CV75
*+       DBNAME IS FIPROD04 VIA CV75
*+       DBNAME IS FIPROD05 VIA CV75
*+       DBNAME IS FIPROD06 VIA CV75
*+       DBNAME IS FIPROD11 VIA CV75
*+       DBNAME IS FIPROD12 VIA CV75
*+       DBNAME IS FIPROD13 VIA CV75
*+       DBNAME IS FIPROD14 VIA CV75
*+       DBNAME IS FIPROD15 VIA CV75
*+       DBNAME IS FIPROD16 VIA CV75
*+       DBNAME IS MCPRODA VIA CV75
*+       DBNAME IS MCPRODB VIA CV75
*+       DBNAME IS MCPRODC VIA CV75
*+       DBNAME IS MCPRODD VIA CV75
*+       DBNAME IS MCPRODE VIA CV75
*+       DBNAME IS MCPRODF VIA CV75
*+       DBNAME IS MCPRODG VIA CV75
*+       DBNAME IS MCPRODH VIA CV75
*+       DBNAME IS MCPRODI VIA CV75
*+       DBNAME IS MCPRODJ VIA CV75
*+       DBNAME IS MCPRODK VIA CV75
*+       DBNAME IS MCPRODL VIA CV75
*+       DBNAME IS MCPRODM VIA CV75
*+       DBNAME IS MCPRODN VIA CV75
*+       DBNAME IS MCPRODO VIA CV75
*+       DBNAME IS MCPRODP VIA CV75
*+       DBNAME IS MCPRODQ VIA CV75
*+       DBNAME IS SCPFI01 VIA CV75
*+       DBNAME IS SCPGH02 VIA CV75
*+       DBNAME IS SCPMC02 VIA CV75
*+       DBNAME IS SCPMC5X VIA CV75
*+       DBNAME IS SCPRE02 VIA CV75
*+       DBNAME IS SCPSV01 VIA CV75
*+       DBNAME IS SCPTB01 VIA CV75
*+       DBNAME IS SCPUS02 VIA CV75
*+       DBNAME IS SCPXR01 VIA CV75
*+       DBNAME IS SCPGHRT VIA CV75
*+       .

this would force anytime a run unit was bound with DBNAME SCPGHRT to go to
CV75


one problem we ran into - the resource table is checked BEFORE the
subschema mapping table - so if you come in with no DBNAME but bound with
a subschema (as we were written to do many yeas ago) , the RESOURCE table
will never get a match - our solution was to code an exit 23 as follows:
(we recompiled certain programs that we wanted executed from a different
CV ti have a specific subschema name)

TITLE 'EXIT 23 - PRE BIND EXIT'
UT23EXIT #MOPT ENV=SYS,AMODE=31,RMODE=ANY
UT23EXIT CSECT
UT23EP1 #START MPMODE=ANY
USING CSA,R10
L R2,4(,R1) R2 ==> 40 BYTE DATA AREA
USING PARMAREA,R2
TEST1 CLC PSSCNAM,=CL8'SSTGHRT ' IS THIS FOR DEV SPC RETRIEVAL?
BNE TEST2 NO! TRY QA/PROD
MVC PDBNAME,=CL8'SCDGHRT ' OVERRIDE DBNAME
B RETURN EXIT
TEST2 CLC PSSCNAM,=CL8'SSPGHRT ' IS THIS FOR QA/PRD SPC RETR
BNE RETURN NO! JUST EXIT
MVC PDBNAME,=CL8'SCPGHRT ' OVERRIDE DBNAME
RETURN #RTN RETURN TO CALLER
LTORG
COPY #CSADS
PARMAREA DSECT
PSSCNAM DS CL8 SSC NAME
PDBNODE DS CL8 DATABASE NODE
PDBNAME DS CL8 DATABASE NAME
PDICNOD DS CL8 DICTIONARY NODE
PDICNAM DS CL8 DICTIONARY NAME
END











Chris Hoelscher
IDMS & DB2 Database Administrator
Humana Inc
502-710-3038
choelscher@humana.com




The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.

"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: R14.1 vs. R16 ADS performance
"Kay -

We have seen a notable increase in 14.0 VS. 16.0..
For us, it is especially noticeable in local mode batch retrieval.

In fact, we have a test sample program we are using that is almost
completely database work (no other real business logic code).
We've seen large increases with this test program.
We've seen large, (but not as large as the sample program) increases with
real-world batch testing.

We are working with C.A., who has been very earnest in working on a
performance APAR for us.
It's still work-in-progress as we are going through an iterative process of
re-coding and re-testing.
We are seeing improvements as a result, but not quite where we want to be,
just yet.
So, you may not see this published for another month or two.
The APAR, in it's current form, is enormous (under 2000 lines of VERS and
REPS).

IDMSDBMS was practiacally split into two because it is so big now.
The two major CSECTS are IDMSDBMS and IDMSDBM2.
It appears there is a significant amount of debugging code in both of these
that is really only useful in certain specific circumstances.
C.A. is taking the stance that we are executing a lot of instructions for
something that is of little value most of the time.
They can always Option-APAR this code right back in if it's needed for
troubleshooting a problem.

I know some of you out there said you saw no increase going to R16.
I wish I could have said the same thing.
However, after almost 60 different tests so far since January, there is no
denying the evidence.
It's ""right-in-your-face"".

We spent the first several days ruling out things that might have been
set-up incorrectly or missed during the install.
I'm pretty sure we have been testing on a level playing field now.

We, too, are kind-of stuck in Limbo.
Based on extrapolations, we wouldn't finish our nightly batch by morning's
deadline.
So, we are staying put for the time being.

Jon Gocher.


----- Original Message -----
From: ""Rozeboom, Kay [DAS]"" <KAY.ROZEBOOM@IOWA.GOV>
To: <IDMS-L@LISTSERV.IUASSN.COM>
Sent: Thursday, March 02, 2006 3:09 PM
Subject: R14.1 vs. R16 ADS performance


After upgrading our test CV's from R14.1 SP6 to R16 SP2, most dialogs
are using .01 additional second of CPU, according to PMAM report 01.
This may not sound like much, but it would have a significant impact in
production. We are trying to figure out if this is:

1) An artifact of the testing process. (We no longer have an R14.1
test CV, so cannot repeat the test at that release.)
2) Something done incorrectly during the upgrade.
3) An actual increase in CPU required for ADS in R16.

We have storage protection on at the system level, and off at the
program level for ADSOMAIN and ADSORUN1. This did not change with the
upgrade. (I checked.) We are not using the new HPSPO.

Has anyone else experienced an increase in ADS CPU use after upgrading
to R16?

Kay Rozeboom
State of Iowa
Information Technology Enterprise
Department of Administrative Services
Telephone: 515.281.6139 Fax: 515.281.6137
Email: Kay.Rozeboom@Iowa.Gov

"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
VS: [IDMSVENDOR-L] Common Signon
"Our exit23 modifies DBNODE depending on cv version and subschema name, and we have set up nodes using svc, which adds up kind of poor mans DDS.

Application task stays on original cv, and run unit is on the target cv, this can be tested for example with DMLO or OLQ. OPER on target cv shows run unit and task, accessing database and terminal id begins with 'LD'

We have application specific production cv's and this is way to direct database activity to the cv with update access to that database.

Timo


-----Alkuperäinen viesti-----

Lähettäjä: IDMS Public Discussion Forum puolesta: Petzold, Lutz

Lähetetty: pe 3.3.2006 15:40

Vastaanottaja: IDMS-L@LISTSERV.IUASSN.COM

KopiTo:

Aihe: Re: [IDMSVENDOR-L] Common Signon






Timo, how do you get the application (ads, dc-cobol) to run on the

other cv? DBNODE is the way to make the DB run-unit run over there, but

will it invoke an application task and program to run on the other cv?





Lutz Petzold







-----------------------------------------

This e-mail may contain confidential or privileged information. If you

think you have received this e-mail in error, please advise the sender

by

reply e-mail and then delete this e-mail immediately. Thank you.

Aetna





"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: [IDMSVENDOR-L] R14.1 vs. R16 ADS performance
"Chris - I was it the first time - so it DID get posted



Chris Hoelscher
IDMS & DB2 Database Administrator
Humana Inc
502-710-3038
choelscher@humana.com




The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.

"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: R14.1 vs. R16 ADS performance
"Jon,

Can you tell the rest of us what OS and hardware, version of COBOL and
other tuning methods you may use for the test job and other jobs please?

Chris Wood
Alberta Department of Energy
CANADA

I sent this message earlier but have not received the reply from the
Listserv yet so I don't believe that it was posted.

Outcomes