HDTenEightyP/NetNews huggingface dataset:
Newsgroups: bit.listserv.dasig
Date:         Wed, 9 Sep 1992 09:51:45 EDT
From:         Trevor Garland <trevor@UMS1.LAN.MCGILL.CA>
Subject:      Re: Entity Modeling Request

Sept. 4 Victor Borden writes about EasyCase and the public domain version
and asks if anyone is using the commercial product. I am using EasyCase
Plus version 3.1 which is the current release of the basic product. There
is a developer's addition which provides generating SQL schemas.

The product is currently selling for about $500 which is affordable for an
upper case tool. It is very good for handling the upper case and
developing a data dictionary based on the E-R model. It allows for good
documentation of the model and the data elements and the data dictionary
can be read and manipulated by another package. It is not good for reading
an existing data dictionary and building the model based on what already
exists (if anyone does that).

I basically bought it because it is an affordable entry into CASE tools.
It does not link to any middle or lower CASE tools. But it does support
just about every upper case methodology ever published. Documentation is
quite good althpugh it does not train you in the methodologies, just how
to use EasyCase with your chosen methodology.

 << Trevor Garland             McGill University Information Systems >>
 << Manager, PC Applications      845 Sherbrooke St. W.              >>
 << (514) 398-7410                Montreal, Quebec                   >>
 << TREVOR@UMS1.LAN.MCGILL.CA     Canada     H3A 2T5                 >>
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.dasig
Date:         Tue, 8 Sep 1992 09:15:41 EST
From:         Gerry Bernbom <BERNBOM@UCS.INDIANA.EDU>
Subject:      RE: Entity Modeling Request

Re: Data Modeling Software.

At Indiana University we've focused on BACHMAN Data Analyst as
our preferred software for data modeling within the Data Administration
and DBA areas...(and also in one of our user offices where a signficant
amount of IS design is now going on.)

It isn't drawing tool to replace white-board and pens, nor is it low-cost
(unless you look at value for expense), but it is an excellent data design
tool.  At the conceptual and logical design stages the product provides
a measure of expert-system-like support to the data designer.  For
physical database design, we've been using the related BACHMAN product
for forward engineering design to DDL for our DB2 databases (and are
experimenting with using BACHMAN-generated DDL and an automated
syntax-conversion process for creating Ingres databases).

Re: Student Data Model.

We've done an enterprise-level data model for the student-related
subject area (admissions, course enrollment, student records, student
fees, financial aid, advising, etc.).  It's conceptual, not fully
detailed, and BIG.  (The model itself has approximately 40 entities.
The functional decomposition that led to the model had 10 major business
functions and approximately 50 sub-functions.)

I'd be happy to share what we have, but I agree with John W. from ASU:
you definitely have to build your own model using your own business
rules.

Gerry Bernbom
Indiana University
Bloomington, IN  47405

bernbom@ucs.indiana.edu
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Envelope-to: @cunyvm.cuny.edu:DASIG@SUVM.BITNET
X-VMS-To: IN%"<@cunyvm.cuny.edu:DASIG@SUVM.BITNET>"
X-VMS-Cc: EATON
Newsgroups: bit.listserv.dasig
Date:         Fri, 4 Sep 1992 15:01:00 CST
From:         "Bob Eaton, Computing Services, U. Sask." <EATON@ADMIN1.USASK.CA>
Subject:      Re: Entity Modeling Request

Hello all,

Patti Yehle asked, "Does anyone have any suggestions for a data modeling
tool, mainframe- or PC-based?"  We, at UofS, use DECdesign which is part of
the Campus-wide Software License Grant from Digital.  We find it to be not
bad at all (which is almost a superlative, coming from a Canadian).  The
added value is that stores its models in the CDD+, our data dictionary.

In short, if I was asked if DECdesign is the best, I would have to say,
"Probably not."  But then it *is* available for no cash (learning costs are,
I suspect, no worse than for any other product).  It runs on our VAXstations
and Digital claims it runs in an Ultrix environment.

We also have a partial model of our Student db.  I say partial because we
built the Student db in '86 as part of our Student Information System
project and didn't have models then.  However, in order for those working on
our Telephone Registration project to figure out the student db, they have
reverse-engineered, so to speak, a good part of the Student db and that
model can be made available to anyone requesting it.  How would you like it:
I think we should be able to send you a postscript file or FAX or paper.  Or
even the DD metadata.

Bob
___________________________
R.B. Eaton,
Manager, Administrative Applications
Computing Services
University of Saskatchewan                         Email:
EATON@ADMIN.USASK.CA
SASKATOON, SK                                      Phone: (306) 966-4854
S7N 0W0    CANADA                                  FAX:   (306) 966-4938
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.dasig
Date:         Fri, 4 Sep 1992 16:51:42 EST
From:         VICTOR BORDEN <VBORDEN@INDYCMS.BITNET>
Subject:      Re: Entity Modeling Request
              4 Sep 1992 15:01:00 CST from <EATON@ADMIN1.USASK.C A>

RE: E-R modeling tool

I too have some interest in identifying an E-R modeling tool for
some "small-scale" but "wide-scope" data modeling tasks.  Specifically
we are looking at modeling an institutional census resource, not
the whole transactional domain, but just a more analytically postured
read-only extract domain.

There is a PC-based product called EZCase, for which a stripped down
public domain version exists (internet address- wuarchive.wustl.edu
file name- /mirrors/msdos/case/ezcase17.zip)  The public domain version
of this product is not extremely helpful but the commercial version,
from Evergree Software, is supposed to be much more full featured,
including capabilities for loading data dictionaries and so on.

If I remember correctly, the commercial version price ranges from
$500 to $700 depending on the number of features you need to get
beyond the modeling stage to the implementation stage.

Has anyone had experience with the commercial version of this product?


Vic Borden
Director of Information Management and Institutional Research
Indiana University-Purdue University at Indianapolis
VBORDEN@INDYCMS
(317) 274-8213
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sqlinfo
Date:         Tue, 15 Sep 1992 14:22:58 -0600
From:         Carl Forde <CFORDE@BCSC02.BITNET>
Subject:      SQL/DS 3.2 SQLADBSP

 On Tue, 15 Sep 1992 10:09:39 -0600, Frank C. Fillmore Jr. wrote:

 >For those of you who are migrating to SQL/DS 3.2 (and from the list traffic
 >there appears to be quite a few) there's an undocumented "enhancement" that
 >affects the run time of SQLADBSP.  Under 3.2 and beyond, the internal
 >DBSpaces are reformatted each time SQLADBSP is run - whether or not the
 >configuration has been changed.  This is to eliminate the potential for
 >corruption.  The effect has been to extend the run time of SQLADBSP for
 >one of my customers from about 40 seconds to over an hour.

 This enhancement (no quotes) is available in 2.2 and 3.1 as well.  The
 APARs are: PL75404 (2.2), PN01989 (3.1) and PN10721 (3.2).

 This APAR arose out of a problem we experienced where we had a healthy
 database and after adding some DBSPACEs we had directory corruption in
 the new DBSPACEs.

 We had the mistaken belief that SQLEND DVERIFY would verify that the
 whole directory was in a consistant state.  What it really does is verify
 that the *allocated* portion of the directory is in a consistant state.
 Also note that DVERIFY does nothing to correct any errors it might find.

 Corruption can occur in an INTERNAL DBSPACE if the server abends when
 INTERNAL DBSPACEs are in use.  The directory blocks belonging to
 INTERNAL DBSPACEs are normally cleaned up the next time they are used.
 However, this clean up is not performed for directory blocks that belong
 to permanent DBSPACEs.  So if an INTERNAL DBSPACE becomes corrupted and
 it is not reused before the directory blocks become part of a permanent
 DBSPACE the corruption becomes part of the newly added DBSPACEs.  This
 corruption would not be detected until the directory blocks affected
 were used. At which point the database would return errors to the user
 and the data might not be recoverable.  Worse(?), the only sure way to
 get rid of the corrupted portion of the directory was to regen the
 database....

 I agree that an increase from 40 seconds to over an hour to add DBSPACEs
 is rather difficult to take.  I can't say that I've experienced the same
 kind of performance hit.  Were you adding a large number of large DBSPACEs
 all at the same time?

 Have fun,
 Carl Forde                            phonenet: 604-360-7130
 VM Database and Development Support   bitnet  : CFORDE@BCSC02
 British Columbia Systems Corporation  internet: cforde@bcsc02.gov.bc.ca
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sqlinfo
Date:         Mon, 14 Sep 1992 17:12:30 EDT
From:         SHESHENE@SJUVM.BITNET
Subject:      SQL 3.2, VM/ESA 370 (cms rel 7), DMKSNT Entries

Hi, we are currently upgrading to:

  SQL 3.2, service form put tape 9204 applied.
  QMF 3.1 (still at 2.2, going to 3.1)
  VM/ESA 370 (cms rel 7)
  ISPF 3.2

and are having trouble using shared segments.

We found that the database machines had to be cut to 6 meg due to the
SQL segements being moved below 8 meg.

The user machines are sporatically experiencing
"SQLRMGR was not loaded via the segment load function"
We're assuming this implies that we're not using the shared segments.
(We're not sure why yet, our systems group is working with IBM support center).

We're installing QMF and have a problem identifying where to fit it in DCSS.

Does anyone have a copy of a DMKSNT file for the above products which
allows larger amounts of user memory?

We only have 16 meg real memory.

ps:  If any one has memory for a 4381 (p22) they don't need we'll happily
     accept donations or purchase at a low? cost.


Thanks in advance,

John H. Sheshene
Manager - Academic Applications Programming    (718) 990-1674
St. John's University                          Jamaica, NY 11439
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sqlinfo
Date:         Mon, 14 Sep 1992 19:28:21 -0600
From:         Carl Forde <CFORDE@BCSC02.BITNET>
Subject: re: SQL 3.2, VM/ESA 370 (cms rel 7), DMKSNT Entries

 On Mon, 14 Sep 1992 17:12:30 EDT John Sheshene wrote:

 >We found that the database machines had to be cut to 6 meg due to the
 >SQL segements being moved below 8 meg.

 I don't think this is necessary.  We have our DCSSes mapped at the
 following addresses:

    CMS7     E00-FFF
    SQLSQLDS A00-AFF
    SQLXRDS  C00-D6F
    SQLXRMGR BC0-BEF

 Note that the DCSSes that the server machines use can overlay everything
 (except CMS) since they will not be running any other code than SQL/DS.
 This means that SQLXRMGR can be located at the same address as SQLSQLDS
 or SQLXRDS since the server machine never references SQLXRMGR in multi-
 user mode.  In single user mode you can run without DCSSes and avoid
 the overlay problem.  With our set up, a server can have a maximum
 machine size of 10M.  BTW, most of our users run in 4M machines.

 >The user machines are sporatically experiencing
 >"SQLRMGR was not loaded via the segment load function"
 >We're assuming this implies that we're not using the shared segments.
 >(We're not sure why yet, our systems group is working with IBM support
 center).

 This does not necessarily mean that you aren't using the shared segments.
 It could be that the segments were attached by a DIAG 64, the old method.
 You should be able to get rid of the error message by relinking the
 applications.

 How about overlaying SQLSQLDS and/or SQLXRDS?  Since the server machine
 won't be using QMF?  At least not at the same time it is running SQL/DS. :-)

 Have fun,
 Carl Forde                            phonenet: 604-360-7130
 VM Database and Development Support   bitnet  : CFORDE@BCSC02
 British Columbia Systems Corporation  internet: cforde@bcsc02.gov.bc.ca
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sqlinfo
Date:         Tue, 15 Sep 1992 10:09:39 -0600
From:         "Frank C. Fillmore Jr." <TFG01@IBRDVM1.BITNET>
Subject:      SQL/DS 3.2 SQLADBSP

 For those of you who are migrating to SQL/DS 3.2 (and from the list traffic
 there appears to be quite a few) there's an undocumented "enhancement" that
 affects the run time of SQLADBSP.  Under 3.2 and beyond, the internal
 DBSpaces are reformatted each time SQLADBSP is run - whether or not the
 configuration has been changed.  This is to eliminate the potential for
 corruption.  The effect has been to extend the run time of SQLADBSP for
 one of my customers from about 40 seconds to over an hour.

 Beware...

 I can be reached at IBRD 202-473-9682
 -or- at The Fillmore Group, Inc. 410-465-6335
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Organization: University of Antwerp - UFSIA - Computing Center
Newsgroups: bit.listserv.sqlinfo
Date:         Thu, 10 Sep 1992 14:31:36 SET
Comments:     Resent-From: <NETNEWS@RKC.UFSIA.AC.BE>
Comments:     Originally-From: <PS890866@BANUFS11.BITNET>
From:         NETNEWS@RKC.UFSIA.AC.BE
Subject:      Re: various questions

Hello,
I have a problem with Zyindex. When I do the setup after five minutes the scree
nsaver is strangely activated.  I use the explosiv screensaver and I have the i
impression that it is not copatible with certain other Windows applications.  C
an anyone help.
I want to become a betatester for Approach for windows, Zyindex, Omnipage Direc
t and Pro, Prowrite and Paperworks.  How must I apply?
Thanks in advance.
Lode
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Organization: Computing Services, Arizona State University
Newsgroups: bit.listserv.jes2-l
Date:         Wed, 9 Sep 1992 06:34:20 MST
From:         Bob Kaneshige <KHAAV@ASUVM.INRE.ASU.EDU>
Subject:      Re: AUTOMATIC PURGING OF SPOOL FILES

On Wed, 9 Sep 1992 04:53:00 EDT Mike Alexander said:
>You may want to lokk into the automatic command processing option to
>issue a $PQ,A=2 (with any other selection criteria options). The base
>form of the above command will purge any entries on spool that are
>older than 2 days.
>We have a general program to do that here which takes into account day
>of week processing, time of day, system id, etc. However, to issue just
>one or two commands to perform a specific function will not take that
>much code. This has been all approach to situations like you are
>describing. If I can provide more informaion, give a yell.

Ours does the following: 1) does a LISTCat for each of the 8 offload dsns
2) asks the operator via WTOR if you wish to continue 3) uncatalogs the
offload tape 4) issues the $PQ,A=x,H=y,R=Rz.
We use this as our 'incremental' backup of the spool as we use offload7 daily
for this purpose.

  Bob
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.jes2-l
Date:         Wed, 9 Sep 1992 15:40:19 SST
From:         Chang Koon Wang <CCECKW@NUSVM.BITNET>
Subject:      AUTOMATIC PURGING OF SPOOL FILES

We are currently purging our spool files manually and it's very time
consuming.  Does anyone have any idea or utilities that can automate
this process, ie purge it after say, 2 days?  Also, if we suddenly realise
that we want to keep a particular spool file, can we exclude that file
from purging?  We're running MVS/370.  Your ideas are most appreciated.





Systems Programmer

National University of Singapore
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Organization: Computing Services, Arizona State University
Newsgroups: bit.listserv.jes2-l
Date:         Tue, 8 Sep 1992 09:17:09 MST
From:         Bob Kaneshige <KHAAV@ASUVM.INRE.ASU.EDU>
Subject:      Jes 4.2/RACF 1.9, exit 20, verify userid w/ usergrp..

I need to verify that a user 1) is in a certain usergroup, else cancel job
2) can only submit locally, else cancel job.  It seems like exit 20 is the
place to do this since Jes has processed the job card and placed all info
into their respective control blocks.  I can check the NJH2USR/NJH2GRP and
NJH2SUSR/NJH2SGRP pairs.  What I am having difficulties with is with SAF and
$SEAS.  It seems that the $SEAS macro is what Jes uses as as interface with
SAF.  Also 'tokens' comes into play.  Reading Customizing Jes, Invoking the
Security Authorization Facility, 2-53, and the example has not helped in
understanding it.  If anyone has done similar work in an exit, I'd appreciate
looking at your code.  THANKS!

  Bob
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.jes2-l
Date:         Fri, 11 Sep 1992 15:02:00 PDT
From:         Leonard D Woren <LDW@USCMVSA.BITNET>
Subject:      Re: IEF287I - NOT CATLGD 2

The possibly best solution is to turn on SMS.  Then there will be no
uncataloged datasets created, and you won't have to worry about users
missing the messages, since the step won't run at all.

/Leonard
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Organization: Food and Agriculture Organization of the UN
X-Acknowledge-To: <AFCO73@IRMFAO01>
Newsgroups: bit.listserv.jes2-l
Date:         Thu, 10 Sep 1992 08:44:56 ITA
From:         AFCO73@IRMFAO01.BITNET
Subject:      IEF287I - NOT CATLGD 2

Good-day,

   Would anyone have a good solution to the 'IEF287I ...  NOT CATLGD 2'
annoyment?  We run MVS/XA and currently have 4 storage volumes in the
system.  Every so often, the users complain that their datasets are
not catalogued properly on these volumes.  The problem is due to that
they tried to allocate a new dataset with DISP=(NEW,CATLG) without
firstly making sure that the dataset does not exist on these volumes
already.  Although the msg IEF287I is issued to warn the users, but
it only appears in the job message and not everyone looks at the
message dataset.

   I looked around in MVS and found the message comes from IEFAB4A2,
IEFAB4FD and IEFAB4M6.  I guess that I can put a WTO zap somewhere in
these modules.  Would anyone have any suggestion?

   I seem to remember there was a suggestion in an early issue of
the 'MVS Update'.  But we don't have the 'very early' issues in FAO.

   THANK YOU FOR ANY SUGGESTIONS AND ASSISTANCE.


Johnny Hua,
System Programmer,
FAO of the UN,
ROME, ITALY

AFCO73@IRMFAO01
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.jes2-l
Date:         Wed, 9 Sep 1992 04:53:00 EDT
From:         Mike Alexander <ZSYSWMA@UCCCMVS.BITNET>
Subject:      Re: AUTOMATIC PURGING OF SPOOL FILES

You may want to lokk into the automatic command processing option to
issue a $PQ,A=2 (with any other selection criteria options). The base
form of the above command will purge any entries on spool that are
older than 2 days.

To implement automatically, have a quick program set up to issue a set
of any $TA commands you want each time you IPL. One of the automatic
commands that will be issued is one which will resubmit the issuing
program itself at the same time every day.

We have a general program to do that here which takes into account day
of week processing, time of day, system id, etc. However, to issue just
one or two commands to perform a specific function will not take that
much code. This has been all approach to situations like you are
describing. If I can provide more informaion, give a yell.

Mike Alexander (ZSYSWMA)
University of Cincinnati
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.jes2-l
Date:         Tue, 8 Sep 1992 14:40:02 DST
Comments:     Converted from PROFS to RFC822 format by PUMP V2.2X
From:         "Gary Garland Gregory - (SGGGG@TTUVM1)" <SGGGG@TTUVM1.BITNET>
Subject:      Jes 4.2/RACF 1.9, exit 20, verify userid w/ usergrp..

      System Programmer III - University Computing Facilities
      Texas Tech University - Lubbock, Texas
Bob,

1. What version of MVS and JES2 are you running?
2. Where are the job being submitted? (eg: TSO, Wylbur, CMS, etc).

I am currently writing code to verify some of this information - maybe I might
have something that will help.

Thanks.
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.jes2-l
Date:         Wed, 9 Sep 1992 10:49:45 EST
From:         SOMITCW@VCCSCENT.BITNET
Subject:      AUTOMATIC PURGING OF SPOOL FILES

 On Wed, 9 Sep 1992 15:40:19 SST, CCECKW@NUSVM said:
>We are currently purging our spool files manually and it's very time
>consuming.  Does anyone have any idea or utilities that can automate
>this process, ie purge it after say, 2 days?  Also, if we suddenly
>realise that we want to keep a particular spool file, can we exclude
>that file from purging?  We're running MVS/370.  - - -

    We're lazy also and have automated SPOOL file purging.
 We added start commands to our normal nightly processing job stream.
 Our PROC and control cards follow with the comments deleted.
 If you need the COMMAND program, just ask.  It's 184 lines and
 handles MVS commands coming in the EXEC PARM and as SYSIN.
 We do not backup any SPOOL files before purge.

    The following is PROC SPOOL:

//         PROC MEMBER=SPOOL
//COMMAND  EXEC PGM=COMMAND
//SYSIN    DD  DSN=xxxx.PARMxxx(&MEMBER),DISP=SHR

     The following is PARMLIB member SPOOLD which is executed daily
 with command // START SPOOL,MEMBER=SPOOLD

$OQ,Q=X,CANCEL,A=2
$OQ,ALL,CANCEL,A=30
$PQ,ALL,A=30

     The following is PARMLIB member SPOOLW which is executed every
 Friday night with command // START SPOOL,MEMBER=SPOOLW

$OQ,Q=X,CANCEL,A=2
$OQ,ALL,CANCEL,A=28
$PQ,ALL,A=28

     The following is PARMLIB member SPOOL which is executed when
 the Operator is running out of SPOOL space and cannot locate any
 System Programmer.  It's started with command S SPOOL

$OQ,Q=X,CANCEL
$OQ,ALL,CANCEL,A=21
$PQ,ALL,A=21
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Organization: Computing Services, Arizona State University
Newsgroups: bit.listserv.jes2-l
Date:         Tue, 8 Sep 1992 13:26:23 MST
From:         Bob Kaneshige <KHAAV@ASUVM.INRE.ASU.EDU>
Subject:      Re: Jes 4.2/RACF 1.9, exit 20, verify userid w/ usergrp..

>1. What version of MVS and JES2 are you running?
MVS 4.2  JES2 4.2 RACF 1.9
>2. Where are the job being submitted? (eg: TSO, Wylbur, CMS, etc).
TSO, WYLBUR, NJE

>I am currently writing code to verify some of this information - maybe I might
>have something that will help.

Appreciate it if you do have something to help me.

  Bob
From: SYSRONT@UCHIMVS1.UCHICAGO.EDU (312 Ron Thielen 702-7612)
Newsgroups: bit.listserv.jes2-l
Subject: Re: IEF287I - NOT CATLGD 2
Date: 10 Sep 92 15:26:00 GMT
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU

There is a package called Stop/X37 from Empact Software which will
optionally handle NOT CATLGD 2 errors.  You set up tables which tell
the package whether to delete the original dataset, uncatalog the
original, or rename it.  Stop/X37 also does other great stuff like
preventing B37, D37, and E37 ABENDs.

Also, we use a job scheduling package called ESP from Cybermation, Inc.
in Markham Ontario.  The restart/recovery component called Encore will
handle NOT CATLGD 2 errors for thos jobs submitted by the scheduling
package.

========================================================================
Ron Thielen <sysront@UCHIMVS1.UChicago.edu>
Manager of Operating Systems
Networking and Large Scale Computing
University of Chicago Computing Organizations
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU