ca.portal.admin

Release 16.0 Data Dictionary (IDD)

Discussion created by ca.portal.admin on Jun 22, 2005
We have just upgraded 2 Test CV's from release 14.1 to 16.0 SP1. We've
noticed that application tables in the IDD have additional information
now. CODE tables have a NAME IS parm. added to the end of the table,
and EDIT VALID tables have an ADDRESS IS parm added to the end (see
example of ADDRESS IS below). Is this a new feature of releases 15/16?
I wasn't able to find any info. in the documentation about it.

Thanks.
Mary Benson
Tufts University

ADD

TABLE NAME IS IAVRT080 VERSION IS 1

*+       DATE CREATED IS      08/25/87

*+       DATE LAST UPDATED IS 06/03/05

*+       TIME LAST UPDATED IS 14432136

*+       PREPARED BY CAL

*+       REVISED  BY DBAUMSB

DESCRIPTION IS 'ACADEMIC ACTION EDIT TABLE'

PUBLIC ACCESS IS ALLOWED FOR ALL

TYPE IS EDIT VALID

SEARCH IS LINEAR

TABLE DATA IS ALPHANUMERIC

TABLE IS SORTED

DUPLICATES ARE ALLOWED

VALUES ARE ( ' ' CM GM PM R1 R2 R3 R4 R8 SM 0M 1M 2M 3M )

*+       INCLUDE MAP IARMP170 VERSION IS 1

*+           TYPE IS UNLINKED EDIT/CODE

ADDRESS IS
' +ò                                   '
' '
' '
' CM'
' GM'
' PM'
' R1'
' R2'
' R3'
' R4'
' R8'
' SM'
' 0M'
' 1M'
' 2M'
' 3M'
' '
GENERATE
.

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








Normal

Normal
Re: Release 16.0 Data Dictionary (IDD)
"No we don't, but we will now! Thanks Terry!

Schwartz, Terry wrote:
Do you have APAR QO61266 applied? We had the same issue with the
""NAME IS"" being an invalid value on an Edit Table update and
needed the following APAR.

Terry Schwartz
Perot Systems

++APAR (QO61266)
/* ---------------------------------------------------------------- */
/* PRODUCT: CA-IDMS/DB CORE-MVS/VSE/VM/MSP/BS2000 */
/* RELEASE: 16.0 */
/* DATE: 1 NOV 2004 */
/* HYPER: NO */
/* */
/* STARTRAK PROBLEM PRODUCT NAME: IDD PROBLEM NUMBER: 81 */
/* ---------------------------------------------------------------- */
/* IDD DISPLAY OF A CODE OR EDIT TABLE CAN RESULT IN */
/* AN INVALID DISPLAY OF EXCESS UNREADABLE TEXT. */
/* THE INCORRECT DISPLAY TEXT WILL START WITH 'NAME IS' */
/* FOR A CODE TABLE, AND 'ADDRESS IS' FOR AN EDIT TABLE. */
/* */
/* THIS PROBLEM ONLY OCURS IN RELEASE 16.0. */
/* ---------------------------------------------------------------- */

-----Original Message-----
From: IDMS Public Discussion Forum [mailTo:IDMS-L@LISTSERV.IUASSN.COM] On Behalf Of Mary Benson
Sent: Wednesday, June 22, 2005 9:28 AM
To: IDMS-L@LISTSERV.IUASSN.COM
Subject: Release 16.0 Data Dictionary (IDD)

We have just upgraded 2 Test CV's from release 14.1 to 16.0 SP1. We've
noticed that application tables in the IDD have additional information
now. CODE tables have a NAME IS parm. added to the end of the table,
and EDIT VALID tables have an ADDRESS IS parm added to the end (see
example of ADDRESS IS below). Is this a new feature of releases 15/16?
I wasn't able to find any info. in the documentation about it.

Thanks.
Mary Benson
Tufts University

ADD

TABLE NAME IS IAVRT080 VERSION IS 1

*+       DATE CREATED IS      08/25/87

*+       DATE LAST UPDATED IS 06/03/05

*+       TIME LAST UPDATED IS 14432136

*+       PREPARED BY CAL

*+       REVISED  BY DBAUMSB

DESCRIPTION IS 'ACADEMIC ACTION EDIT TABLE'

PUBLIC ACCESS IS ALLOWED FOR ALL

TYPE IS EDIT VALID

SEARCH IS LINEAR

TABLE DATA IS ALPHANUMERIC

TABLE IS SORTED

DUPLICATES ARE ALLOWED

VALUES ARE ( ' ' CM GM PM R1 R2 R3 R4 R8 SM 0M 1M 2M 3M )

*+       INCLUDE MAP IARMP170 VERSION IS 1

*+           TYPE IS UNLINKED EDIT/CODE

ADDRESS IS
' +ò                                   '
' '
' '
' CM'
' GM'
' PM'
' R1'
' R2'
' R3'
' R4'
' R8'
' SM'
' 0M'
' 1M'
' 2M'
' 3M'
' '
GENERATE
.
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Brock Shaw
"I am sorry to hear of Brock's passing. I met him and Becky through the
UKIUA. My condolences go out to his family. He was one of the good guys and he
will be missed.

Leslie Jordan
(formerly a DBA of Air Express/DHL))

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








Normal

Normal
Brock Shaw
"Although Brock Shaw’s passing has been previously announced on the list, I
want to let all IUA members and IDMS-L subscribers know what a staunch
supporter of IDMS and the IUA Brock was. For the past 6 years Brock has
been the Eiua liason to the IUA Board of directors. He has also been
involved in the UKIUA and the EIUA for many years. His keen insight and
well thought out positions will be sorely missed.

Brock has been a good friend to the IDMS community and myself personally
for many years.

Bob Wiklund
IUA Chair
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: DCMT D LOCKS STATS
"An update with new findings.

We have done some rough testing and found that a 'normal' condition
would overflow under control block Resource. When we have seen this
before, we have increased syslocks to handle our new limits.

This new case stems from varying a segment offline, with users still
online and others trying to gain access to the db. If an overflow has
occurred before in control block Resource it will further overflow in
that control block. If no overflows have occurred before it will now
overflow in control block Class.

Changing the vary offline to vary retrieval (as Steve suggested) stops
the overflow from happening or reduces the number of locks being
acquired. This is different behaviour in 16.0 than happened in 15.0.

We will change to vary retrieval unless we have to make the segment
totally unavailable.

Thanks

Chris

Outcomes