ca.portal.admin

Re:Re: [IDMSVENDOR-L] RELOAD utility with MAXSORT

Discussion created by ca.portal.admin on Nov 4, 2009
didnt curtis-matheson make TVs back in the day (actually it was



Curtis Mathis


- i think you mean helios&matheson

Chris Hoelscher
Senior IDMS & DB2 Database Administrator
Humana Inc
502-476-2538
choelscher@humana.com

you only need to test the programs that you want to work correctly






From:
""Hunley, Tonya"" <Tonya.Hunley@SALLIEMAE.COM>
To:
IDMSVENDOR-L@LISTSERV.IUASSN.COM
Date:
11/04/2009 12:45 PM
Subject:
[IDMSVENDOR-L] RELOAD utility with MAXSORT
Sent by:
IDMS 3rd-party providers forum <IDMSVENDOR-L@LISTSERV.IUASSN.COM>



Does anyone happen to have JCL for a RELOAD utility using MAXSORT? =3D20

We are using the EZREORG UTILITY (TACT, CURTIS-MATHESON, ....) to
resize
o=3D
ur large Production database. Our Reload has failed with a b37 maximum
sor=3D
t exceeded so we want to add the maxsort to this to get it to work. We
did=3D
accomplish this about 10 years ago but unfortunately our example has
been
=3D
deleted.=3D20


Any help is apprecieated,

Thanks,=3D20
Tonya

Tonya D. Hunley
317-578-6267
Database Analyst
SallieMae, Inc.=3D20
11000 USA Parkway
Fishers, IN 46038



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.

This E-Mail has been scanned for viruses.
"
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: RELOAD utility with MAXSORT
"Tonya,

What company produces your sort utility?

Best Regards,
Neal Kostanski

Hunley, Tonya wrote:
Does anyone happen to have JCL for a RELOAD utility using MAXSORT?

We are using the EZREORG UTILITY (TACT, CURTIS-MATHESON, ....) to resize our large Production database. Our Reload has failed with a b37 maximum sort exceeded so we want to add the maxsort to this to get it to work. We did accomplish this about 10 years ago but unfortunately our example has been deleted.


Any help is apprecieated,

Thanks,
Tonya

Tonya D. Hunley
317-578-6267
Database Analyst
SallieMae, Inc.
11000 USA Parkway
Fishers, IN 46038

"
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: RELOAD utility with MAXSORT
"Tonya,

What company produces your sort utility?

Best Regards,
Neal Kostanski

Hunley, Tonya wrote:
Does anyone happen to have JCL for a RELOAD utility using MAXSORT?

We are using the EZREORG UTILITY (TACT, CURTIS-MATHESON, ....) to resize our large Production database. Our Reload has failed with a b37 maximum sort exceeded so we want to add the maxsort to this to get it to work. We did accomplish this about 10 years ago but unfortunately our example has been deleted.


Any help is apprecieated,

Thanks,
Tonya

Tonya D. Hunley
317-578-6267
Database Analyst
SallieMae, Inc.
11000 USA Parkway
Fishers, IN 46038

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








Normal

Normal
Subject: RELOAD utility with MAXSORT
"Hi Tonya,

I used 3 years agTo:


DYNALLOC=3D(WORK,50,SC=3DRAUTKONV)
MAXSORT =20
FILSZ=3DE2270280474 =20
CORE=3DMAX-512K =20
INCORE=3DON =20

Met vriendelijke groeten/ Kind regards,=20

Henny Malipaard=20
Consultant / DBA=20
Logica Nederland B.V.
GSD NL / ING Service Center=20
Meander 901
Postbus 7015=20
6801 HA Arnhem=20
T (0318) 663066, F (0318) 663961
E henny.malipaard@mail.rvs.nl of E henny.malipaard@logica.com=20
DBA mailbox: Gegevens.Management.RVS@mail.rvs.nl

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

Date: Wed, 4 Nov 2009 12:15:19 -0500
From: ""Hunley, Tonya"" <Tonya.Hunley@SALLIEMAE.COM>
Subject: RELOAD utility with MAXSORT

Does anyone happen to have JCL for a RELOAD utility using MAXSORT? =3D20

We are using the EZREORG UTILITY (TACT, CURTIS-MATHESON, ....) to
resize o=3D ur large Production database. Our Reload has failed with a
b37 maximum sor=3D t exceeded so we want to add the maxsort to this to get
it to work. We did=3D accomplish this about 10 years ago but
unfortunately our example has been =3D deleted.=3D20


Any help is apprecieated,

Thanks,=3D20
Tonya

Tonya D. Hunley
317-578-6267
Database Analyst
SallieMae, Inc.=3D20
11000 USA Parkway
Fishers, IN 46038

------------------------------
-----------------------------------------------------------------
ATTENTION:
The information in this electronic mail message is private and
confidential, and only intended for the addressee. Should you
receive this message by mistake, you are hereby notified that
any disclosure, reproduction, distribution or use of this
message is strictly prohibited. Please inform the sender by
reply transmission and delete the message without copying or
opening it.

Messages and attachments are scanned for all viruses known.
If this message contains password-protected attachments, the
files have NOT been scanned for viruses by the ING mail domain.
Always scan attachments before opening them.
-----------------------------------------------------------------
"
IDMS 3rd-party providers forum
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP
IDMSVENDOR-L@LISTSERV.IUASSN.COM
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Subject: RELOAD utility with MAXSORT
"Hi Tonya,

I used 3 years agTo:


DYNALLOC=(WORK,50,SC=RAUTKONV)
MAXSORT
FILSZ=E2270280474
CORE=MAX-512K
INCORE=ON

Met vriendelijke groeten/ Kind regards,

Henny Malipaard
Consultant / DBA
Logica Nederland B.V.
GSD NL / ING Service Center
Meander 901
Postbus 7015
6801 HA Arnhem
T (0318) 663066, F (0318) 663961
E henny.malipaard@mail.rvs.nl of E henny.malipaard@logica.com
DBA mailbox: Gegevens.Management.RVS@mail.rvs.nl

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

Date: Wed, 4 Nov 2009 12:15:19 -0500
From: ""Hunley, Tonya"" <Tonya.Hunley@SALLIEMAE.COM>
Subject: RELOAD utility with MAXSORT

Does anyone happen to have JCL for a RELOAD utility using MAXSORT? =20

We are using the EZREORG UTILITY (TACT, CURTIS-MATHESON, ....) to
resize o= ur large Production database. Our Reload has failed with a
b37 maximum sor= t exceeded so we want to add the maxsort to this to get
it to work. We did= accomplish this about 10 years ago but
unfortunately our example has been = deleted.=20


Any help is apprecieated,

Thanks,=20
Tonya

Tonya D. Hunley
317-578-6267
Database Analyst
SallieMae, Inc.=20
11000 USA Parkway
Fishers, IN 46038

------------------------------
-----------------------------------------------------------------
ATTENTION:
The information in this electronic mail message is private and
confidential, and only intended for the addressee. Should you
receive this message by mistake, you are hereby notified that
any disclosure, reproduction, distribution or use of this
message is strictly prohibited. Please inform the sender by
reply transmission and delete the message without copying or
opening it.

Messages and attachments are scanned for all viruses known.
If this message contains password-protected attachments, the
files have NOT been scanned for viruses by the ING mail domain.
Always scan attachments before opening them.
-----------------------------------------------------------------
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: RELOAD utility with MAXSORT
"in the old days - I used to split the big input into multi files sort =
them then MERGE those output files


Bob
----- Original Message -----=20
From: Hunley, Tonya<mailTo:Tonya.Hunley@SALLIEMAE.COM>=20
To: =
IDMSVENDOR-L@LISTSERV.IUASSN.COM<mailTo:IDMSVENDOR-L@LISTSERV.IUASSN.COM>=
=20
Sent: Wednesday, November 04, 2009 12:14 PM
Subject: Re: RELOAD utility with MAXSORT


So right.


-----Original Message-----
From: IDMS Public Discussion Forum [mailTo:IDMS-L@LISTSERV.IUASSN.COM] =
On B=3D
ehalf Of Chris Hoelscher
Sent: Wednesday, November 04, 2009 12:54 PM
To: IDMS-L@LISTSERV.IUASSN.COM<mailTo:IDMS-L@LISTSERV.IUASSN.COM>
Subject: Re: [IDMSVENDOR-L] RELOAD utility with MAXSORT

didnt curtis-matheson make TVs back in the day (actually it was



Curtis Mathis


- i think you mean helios&matheson

Chris Hoelscher
Senior IDMS & DB2 Database Administrator
Humana Inc
502-476-2538
choelscher@humana.com<mailTo:choelscher@humana.com>

you only need to test the programs that you want to work correctly






From:
""Hunley, Tonya"" =
<Tonya.Hunley@SALLIEMAE.COM<mailTo:Tonya.Hunley@SALLIEMAE.COM>>
To:
=
IDMSVENDOR-L@LISTSERV.IUASSN.COM<mailTo:IDMSVENDOR-L@LISTSERV.IUASSN.COM>=

Date:
11/04/2009 12:45 PM
Subject:
[IDMSVENDOR-L] RELOAD utility with MAXSORT
Sent by:
IDMS 3rd-party providers forum =
<IDMSVENDOR-L@LISTSERV.IUASSN.COM<mailTo:IDMSVENDOR-L@LISTSERV.IUASSN.COM=
>>



Does anyone happen to have JCL for a RELOAD utility using MAXSORT? =
=3D3D20

We are using the EZREORG UTILITY (TACT, CURTIS-MATHESON, ....) to =
resize
o=3D3D
ur large Production database. Our Reload has failed with a b37 =
maximum
sor=3D3D
t exceeded so we want to add the maxsort to this to get it to work. =
We
did=3D3D
accomplish this about 10 years ago but unfortunately our example has =
been
=3D3D
deleted.=3D3D20


Any help is apprecieated,

Thanks,=3D3D20
Tonya

Tonya D. Hunley
317-578-6267
Database Analyst
SallieMae, Inc.=3D3D20
11000 USA Parkway
Fishers, IN 46038



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

This E-Mail has been scanned for viruses.
"
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: RELOAD utility with MAXSORT
"in the old days - I used to split the big input into multi files sort them then MERGE those output files


Bob
----- Original Message -----
From: Hunley, Tonya<mailTo:Tonya.Hunley@SALLIEMAE.COM>
To: IDMSVENDOR-L@LISTSERV.IUASSN.COM<mailTo:IDMSVENDOR-L@LISTSERV.IUASSN.COM>
Sent: Wednesday, November 04, 2009 12:14 PM
Subject: Re: RELOAD utility with MAXSORT


So right.


-----Original Message-----
From: IDMS Public Discussion Forum [mailTo:IDMS-L@LISTSERV.IUASSN.COM] On B=
ehalf Of Chris Hoelscher
Sent: Wednesday, November 04, 2009 12:54 PM
To: IDMS-L@LISTSERV.IUASSN.COM<mailTo:IDMS-L@LISTSERV.IUASSN.COM>
Subject: Re: [IDMSVENDOR-L] RELOAD utility with MAXSORT

didnt curtis-matheson make TVs back in the day (actually it was



Curtis Mathis


- i think you mean helios&matheson

Chris Hoelscher
Senior IDMS & DB2 Database Administrator
Humana Inc
502-476-2538
choelscher@humana.com<mailTo:choelscher@humana.com>

you only need to test the programs that you want to work correctly






From:
""Hunley, Tonya"" <Tonya.Hunley@SALLIEMAE.COM<mailTo:Tonya.Hunley@SALLIEMAE.COM>>
To:
IDMSVENDOR-L@LISTSERV.IUASSN.COM<mailTo:IDMSVENDOR-L@LISTSERV.IUASSN.COM>
Date:
11/04/2009 12:45 PM
Subject:
[IDMSVENDOR-L] RELOAD utility with MAXSORT
Sent by:
IDMS 3rd-party providers forum <IDMSVENDOR-L@LISTSERV.IUASSN.COM<mailTo:IDMSVENDOR-L@LISTSERV.IUASSN.COM>>



Does anyone happen to have JCL for a RELOAD utility using MAXSORT? =3D20

We are using the EZREORG UTILITY (TACT, CURTIS-MATHESON, ....) to resize
o=3D
ur large Production database. Our Reload has failed with a b37 maximum
sor=3D
t exceeded so we want to add the maxsort to this to get it to work. We
did=3D
accomplish this about 10 years ago but unfortunately our example has been
=3D
deleted.=3D20


Any help is apprecieated,

Thanks,=3D20
Tonya

Tonya D. Hunley
317-578-6267
Database Analyst
SallieMae, Inc.=3D20
11000 USA Parkway
Fishers, IN 46038



The information transmitted is intended only for the person or entity to wh=
ich 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.

This E-Mail has been scanned for viruses.
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: FW: [IDMS-L] finding all OBTAINING USING .....
"IS ro12490/1 to be the published fix corresponding to your test fix?

thanks,
Chris Hoelscher
Senior IDMS & DB2 Database Administrator
Humana Inc
502-476-2538
choelscher@humana.com

you only need to test the programs that you want to work correctly






From:
""Pereira, Carla E"" <Carla.Pereira@CA.COM>
To:
IDMSVENDOR-L@LISTSERV.IUASSN.COM
Date:
09/01/2009 04:16 PM
Subject:
[IDMSVENDOR-L] FW: [IDMS-L] finding all OBTAINING USING .....
Sent by:
IDMS 3rd-party providers forum <IDMSVENDOR-L@LISTSERV.IUASSN.COM>


Hi Chris - I don't have a utility to scan the source but I did write an
apar (TB99850) to help out with this situation. =20

The apar first changes the generic DML004 message issued in this case to
a more descriptive DML084. With the apar applied and optional bit
settings, you can control the severity of the DML084. This will allow
precompiles complete with a warning or successful return code. As you
have done, we strongly suggest that the programs are addressed and
corrected as encountered to add the terminator the OBTAIN USING DML.
However we have found situations like yours where it is helpful to not
have a hard error for this situation. Changing the severity to a
warning will allow the precompile step to complete but warn you that the
situation in the program needs to be addressed. Remember if FIND/OBTAIN
USING DML statement is not coded properly runtime errors can occur.

The apar can be requested by opening an issue with Technical Support.
It has not been officially published yet.

Thanks, Carla


Carla Pereira
CA=20
Sr Sustaining Engineer
Tel: +1-508-628-8207
Fax: +1-508-820-4361
Carla.Pereira@ca.com

Outcomes