ca.portal.admin

Re:Re: CASERVER and ODBC

Discussion created by ca.portal.admin on Feb 5, 2010
Chris

I assume educating the users has failed as it so often does:)

Could you use the limits exit to take a look around to see if this user has another CCI task running and if he has kill this one (as this probably started first) if not up the limit and let it carry on.

Cheers
Martin

_____

From: IDMS Public Discussion Forum on behalf of Trayler, Christopher
Sent: Fri 05/02/2010 09:26
To: IDMS-L@LISTSERV.IUASSN.COM
Subject: CASERVER and ODBC



We allow unlimited SQL select access to our IDMS network database on the Test system. Developers love it because they can use Excel and Access etc to verify their test results without having to write Culprits or special Cobol programs.

Unfortunately it is really easy with a point and click system like Windows to get it wrong pretty much instantly by doing a cartesian join for example without any where criteria and various other combinations which - from the PC user's point of view - is a locked up system. In reality the run unit on the mainframe is beavering away trying to build a huge result table.

PC users are used to just clicking the cross at the top right hand corner and then starting again. The result is multiple CCI sessions for a user and an enormous useless overhead on the mainframe.

I can kick them off by using Limits on the CASERVER task but some queries are expensive but valid. Finding the right limit for on DB Calls to avoid cancelling a valid task is very difficult. So I have to put the limits unrealistically high which means that the problem is not really solved.

IDMS has the CHKUSER tasks to solve this kind of problem with batch jobs. But with an ODBC query it is trickier. IDMS only realises via CCI that the physical terminal is no longer there when the query is ready to return rows to the user.

Does anybody have a clever trick to make IDMS realise that a Windows application on the other end of a CCILINE has disappeared before the query has finished?

Here is the kind of thing I get.

PM-R17.0 TIDMS11E CA, Inc. V126 10.036 10:18:24.68
CMD-->
CMD--> Window : 02
Refresh: 10
02 Transaction Detail i>

Task Tskcd/ Bound Task Subschma Transaction DBMS Pages Pages Pages Rcrds Rcrds Frags Updat Selct Locks Bfore After
Number LTE Program Status Acc_Mod Status Calls Writn Read Reqst Reqst Curnt Stord Locks Locks Reqst Image Image
2 RHDCRUAL WAIT IDMSNWK7 H 25 0 4 5 5 0 0 1 0 6 0 0
3 RHDCRUAL WAIT IDMSNWKL H 2154 0 101 1668 1675 1591 0 1 0 1657 0 0
4 RHDCRUAL WAIT IDMSNWK6 A 795 0 95 397 717 396 0 0 1 1 0 0
5 RHDCRUAL WAIT IDMSSECU H 743 0 25 289 459 63 0 1 0 417 0 0
6 RHDCRUAL WAIT IDMSSECS A 1011 0 210 1366 3004 314 0 0 1 1 0 0
7 RHDCRUAL WAIT IDMSSECQ A 512K 0 1797 442K 564K 37210 0 0 2 2 0 0
8 RHDCLGSD WAIT IDMSNWK9 A 3 0 0 0 0 0 0 0 1 1 0 0
9 RHDCLGSD WAIT IDMSNWK9 A 3 0 0 0 0 0 0 0 1 1 0 0
10 RHDCLGSD WAIT IDMSNWK9 A 3 0 0 0 0 0 0 0 1 1 0 0
160643 CASERVER CAIDOD32 WAIT IDMSCATY I H 20M 0 726K 53M 65M 9932K 0 0 18 71M 0 0
164874 CASERVER CAIDOD32 WAIT IDMSCATY IBH 16M 0 468K 42M 51M 7829K 0 0 23 56M 0 0
LTECCI03 CAIDOD32 IBH 0 0 0 0 0 0 0 0 0 0 0 0
181955 CASERVER CAIDOD32 HICCUP IDMSCATY I H 11121 0 44686 24M 25M 9334 0 0 10 48M 0 0
184558 CASERVER CAIDOD32 WAIT IDMSCATY I H 74641 0 27803 111K 122K 44114 0 0 14 145K 0 0
185921 CASERVER CAIDOD32 WAIT IDMSCATY I H 196K 0 33074 655K 769K 203K 0 0 12 757K 0 0
186808 11EBBULK TKP00 WAIT PPROD H 191 6 28 230 239 138 0 59 30 234 10 10


All those CASERVER tasks belong to the same user. He has killed 4 of them at the PC end and has no idea that they are still running in IDMS. I have to monitor manually and then call him to find out which windows he still has open. Almost certainly the 36 Million calls made by the first two tasks are a complete waste of effort for IDMS.

Any ideas would be great. On the Windows side we currently are quite backward. CA SERVER 5.0 is actually being used. I have CA SERVER 16.1 in test but I am waiting for the guys from the Windows world to roll it out for me - and have been for some time. Even then I will still have the problem. I think.
______________________________________________________________

Chris Trayler, IXD
Bank Julius Baer & Co. Ltd.
P. O. Box, CH-8010 Zürich, Switzerland
Telephone +41 (0)58 887 4332, Fax +41 (0)58 887 4969 www.juliusbaer.com <http://www.juliusbaer.com/>

______________________________________________________________

*****JuliusBaer Disclaimer***** This e-mail is for the intended recipient only and may contain confidential or privileged information. If you have received this e-mail by mistake, please contact us immediately and completely delete it (and any attachments) and do not forward it or inform any other person of its contents. If you send us messages by e-mail, we take this as your authorization to correspond with you by e-mail, however, we will not accept the electronic transmission of orders/instructions without a specific agreement being in place to govern the same. If you do not wish to receive any further e-mail correspondence please let us know. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, amended, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Neither the Julius Baer Group nor the sender accept liability for any errors or omissions in the content of this message which arise as a result of its e-mail transmission. Please note that all e-mail communications to and from the Julius Baer Group may be monitored. This communication is for informational purposes only. It is not intended as an offer or solicitation for the purchase or sale of any financial instrument or as an official confirmation of any transaction.








Reuters Limited, a Thomson Reuters company, is a company incorporated under the laws of England and Wales (registered number 145516) having its registered office and address for service at the Thomson Reuters Building, 30 South Colonnade, Canary Wharf, London, E145EP, United Kingdom.

This e-mail is for the sole use of the intended recipient and contains information that may be privileged and/or confidential. If you are not an intended recipient, please notify the sender by return e-mail and delete this e-mail and any attachments.

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








Normal

Normal
Dictionary Subschema
"Hello, I need to call on the collective wisdom of the list.

I have a situation which requires a DBAUDIT of system dictionary areas
and am having a little difficulty finding a subschema for this utility
job.

We are getting strange errors out of a DMCL compile which makes me
suspect a damaged dictionary.

Any suggestions on a subschema to audit the dictionary would be
appreciated. =20


Hal Govan
Senior Database Administrator
Reed Elsevier - Technology Services
harold.govan@reedelsevier.com <mailTo:harold.govan@lexisnexis.com>=20
Phone: (937) 865-7820
"
IDMS 3rd-party providers forum
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP
IDMSVENDOR-L@LISTSERV.IUASSN.COM
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Dictionary Subschema
"Hello, I need to call on the collective wisdom of the list.

I have a situation which requires a DBAUDIT of system dictionary areas
and am having a little difficulty finding a subschema for this utility
job.

We are getting strange errors out of a DMCL compile which makes me
suspect a damaged dictionary.

Any suggestions on a subschema to audit the dictionary would be
appreciated.


Hal Govan
Senior Database Administrator
Reed Elsevier - Technology Services
harold.govan@reedelsevier.com <mailTo:harold.govan@lexisnexis.com>
Phone: (937) 865-7820
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Dictionary Subschema
"can you post the error(s) you are receiving?

and would problems with a DMCL compile suggest a corrupt CATALOG as
opposed to DICTIONARY?

a subschema to traverse the CATALOG might be IDMSNWKG in IDMSNTWK

chris
"
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: Dictionary Subschema
"can you post the error(s) you are receiving?

and would problems with a DMCL compile suggest a corrupt CATALOG as
opposed to DICTIONARY?

a subschema to traverse the CATALOG might be IDMSNWKG in IDMSNTWK

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








Normal

Normal
Greetings
"With the SuperBowl imminent, I thought I'd share this piece of IDMS =
history. =20

http://adland.tv/commercials/cullinet-bobby-orr-1985-030-usa =
<http://adland.tv/commercials/cullinet-bobby-orr-1985-030-usa>=20

=20
Bob Wiklund
Tiburon Technologies
623 594-6022
"
IDMS 3rd-party providers forum
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP
IDMSVENDOR-L@LISTSERV.IUASSN.COM
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Greetings
"With the SuperBowl imminent, I thought I'd share this piece of IDMS history.

http://adland.tv/commercials/cullinet-bobby-orr-1985-030-usa <http://adland.tv/commercials/cullinet-bobby-orr-1985-030-usa>


Bob Wiklund
Tiburon Technologies
623 594-6022
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Dictionary Subschema
"Hal,=20
=20
If it's just the DDLDML area, then IDMSNWKA of IDMSNTWK should do what =
you're looking for.
=20
Bob
=20
Bob Wiklund
Tiburon Technologies
623 594-6022

________________________________

From: IDMS 3rd-party providers forum on behalf of Govan, Hal (RET-DAY)
Sent: Sat 2/6/2010 5:29 AM
To: IDMSVENDOR-L@LISTSERV.IUASSN.COM
Subject: Dictionary Subschema



Hello, I need to call on the collective wisdom of the list.

I have a situation which requires a DBAUDIT of system dictionary areas
and am having a little difficulty finding a subschema for this utility
job.

We are getting strange errors out of a DMCL compile which makes me
suspect a damaged dictionary.

Any suggestions on a subschema to audit the dictionary would be
appreciated. =3D20


Hal Govan
Senior Database Administrator
Reed Elsevier - Technology Services
harold.govan@reedelsevier.com <mailTo:harold.govan@lexisnexis.com>=3D20
Phone: (937) 865-7820

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
"
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: Dictionary Subschema
"Hal,

If it's just the DDLDML area, then IDMSNWKA of IDMSNTWK should do what you're looking for.

Bob

Bob Wiklund
Tiburon Technologies
623 594-6022

________________________________

From: IDMS 3rd-party providers forum on behalf of Govan, Hal (RET-DAY)
Sent: Sat 2/6/2010 5:29 AM
To: IDMSVENDOR-L@LISTSERV.IUASSN.COM
Subject: Dictionary Subschema



Hello, I need to call on the collective wisdom of the list.

I have a situation which requires a DBAUDIT of system dictionary areas
and am having a little difficulty finding a subschema for this utility
job.

We are getting strange errors out of a DMCL compile which makes me
suspect a damaged dictionary.

Any suggestions on a subschema to audit the dictionary would be
appreciated. =20


Hal Govan
Senior Database Administrator
Reed Elsevier - Technology Services
harold.govan@reedelsevier.com <mailTo:harold.govan@lexisnexis.com>=20
Phone: (937) 865-7820

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
testing
"Testing IDMS-L status
=20
Bob Wiklund
IUA Board
=20
"
IDMS 3rd-party providers forum
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP
IDMSVENDOR-L@LISTSERV.IUASSN.COM
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
testing
"Testing IDMS-L status

Bob Wiklund
IUA Board

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








Normal

Normal
SYSGEN concurrent VS non concurrent
"Hello All:



Does anybody out there have any experiences with the SYSGEN entity PROGRAM
parameter concurrent/NONconcurrent that they can share?



We have a situation where a business process has changed and we are now
experiencing deadlocks on the CAS CSYPGNUM program (number Generator) and
number generator records.



This appears to be an application bottleneck.



William M. Allen, Jr.

ARCH Consulting Associates, Ltd.

(704) 641-0296
"
IDMS 3rd-party providers forum
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP
IDMSVENDOR-L@LISTSERV.IUASSN.COM
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
SYSGEN concurrent VS non concurrent
"Hello All:



Does anybody out there have any experiences with the SYSGEN entity PROGRAM
parameter concurrent/NONconcurrent that they can share?



We have a situation where a business process has changed and we are now
experiencing deadlocks on the CAS CSYPGNUM program (number Generator) and
number generator records.



This appears to be an application bottleneck.



William M. Allen, Jr.

ARCH Consulting Associates, Ltd.

(704) 641-0296
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
automating journal file concatenation
"Before trying to reinvent the wheel, I thought I would ask how others have =
accomplished this: I am looking for a way to automate the generation of DD=
statements for a job to concatenate journal offload files for the previous=
day. Our journal offload file DSN's contain the date and time of offload =
as part of their names. So it is easy enough to create the DD statements m=
anually. (Just cut and paste the DSN's from TSO panel 3.4.) But we would =
like automate the process.

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 3rd-party providers forum
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP
IDMSVENDOR-L@LISTSERV.IUASSN.COM
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
automating journal file concatenation
"Before trying to reinvent the wheel, I thought I would ask how others have accomplished this: I am looking for a way to automate the generation of DD statements for a job to concatenate journal offload files for the previous day. Our journal offload file DSN's contain the date and time of offload as part of their names. So it is easy enough to create the DD statements manually. (Just cut and paste the DSN's from TSO panel 3.4.) But we would like automate the process.

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
Re: automating journal file concatenation
"key - we run an IDCAMS to determine the datasets created during the
business cycle (day or week depending upon how frequently we backup) -
sort by generation # (ascending) - throw the formatted DD cards into an
INCLUDE librate, and run an ICEGENER to concatenate into a daily backup

we then take the same output from IDCAMS, format into DELETE statements,
and run IDCAMS again to delete the just-rolled-up journal tapes

Chris Hoelscher
IDMS/DB2 Database Architect
Humana Inc
502-476-2538
choelscher@humana.com

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






From:
""Rozeboom, Kay [DAS]"" <KAY.ROZEBOOM@IOWA.GOV>
To:
IDMSVENDOR-L@LISTSERV.IUASSN.COM
Date:
02/12/2010 12:42 PM
Subject:
[IDMSVENDOR-L] automating journal file concatenation
Sent by:
IDMS 3rd-party providers forum <IDMSVENDOR-L@LISTSERV.IUASSN.COM>



Before trying to reinvent the wheel, I thought I would ask how others have
=
accomplished this: I am looking for a way to automate the generation of
DD=
statements for a job to concatenate journal offload files for the
previous=
day. Our journal offload file DSN's contain the date and time of offload
=
as part of their names. So it is easy enough to create the DD statements
m=
anually. (Just cut and paste the DSN's from TSO panel 3.4.) But we would
=
like automate the process.

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



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 3rd-party providers forum
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP
IDMSVENDOR-L@LISTSERV.IUASSN.COM
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: [IDMSVENDOR-L] automating journal file concatenation
"key - we run an IDCAMS to determine the datasets created during the
business cycle (day or week depending upon how frequently we backup) -
sort by generation # (ascending) - throw the formatted DD cards into an
INCLUDE librate, and run an ICEGENER to concatenate into a daily backup

we then take the same output from IDCAMS, format into DELETE statements,
and run IDCAMS again to delete the just-rolled-up journal tapes

Chris Hoelscher
IDMS/DB2 Database Architect
Humana Inc
502-476-2538
choelscher@humana.com

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






From:
""Rozeboom, Kay [DAS]"" <KAY.ROZEBOOM@IOWA.GOV>
To:
IDMSVENDOR-L@LISTSERV.IUASSN.COM
Date:
02/12/2010 12:42 PM
Subject:
[IDMSVENDOR-L] automating journal file concatenation
Sent by:
IDMS 3rd-party providers forum <IDMSVENDOR-L@LISTSERV.IUASSN.COM>



Before trying to reinvent the wheel, I thought I would ask how others have
=
accomplished this: I am looking for a way to automate the generation of
DD=
statements for a job to concatenate journal offload files for the
previous=
day. Our journal offload file DSN's contain the date and time of offload
=
as part of their names. So it is easy enough to create the DD statements
m=
anually. (Just cut and paste the DSN's from TSO panel 3.4.) But we would
=
like automate the process.

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



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: automating journal file concatenation
"Hi

I really like the SHARE.ORG program SPECGDGC, which processes GDGs in
desired order.

Just feed it the gdg base name and it copies all generations

//step exec program=specgdgc,parm='all.my.daily.journals'

It is on share tape 18, well I think that is what it is called, tape
18.....

I have seen this used for many years at some large sites hence avoiding
writing journal concatenation rexx execs.
.
I have also heard, through the grapevine, a software supplier has program
of this type in planning.




Rob Klan/Cincinnati/IBM
Phone: 1-877-205-4871 (T/L: 349-2446)
VOIP Users 1-513-897-8148
ITN: 23492446
Email: rklan@us.ibm.com



From:
Chris Hoelscher <choelscher@HUMANA.COM>
To:
IDMS-L@LISTSERV.IUASSN.COM
Date:
02/12/2010 01:40 PM
Subject:
Re: [IDMSVENDOR-L] automating journal file concatenation
Sent by:
IDMS Public Discussion Forum <IDMS-L@LISTSERV.IUASSN.COM>



key - we run an IDCAMS to determine the datasets created during the
business cycle (day or week depending upon how frequently we backup) -
sort by generation # (ascending) - throw the formatted DD cards into an
INCLUDE librate, and run an ICEGENER to concatenate into a daily backup

we then take the same output from IDCAMS, format into DELETE statements,
and run IDCAMS again to delete the just-rolled-up journal tapes

Chris Hoelscher
IDMS/DB2 Database Architect
Humana Inc
502-476-2538
choelscher@humana.com

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






From:
""Rozeboom, Kay [DAS]"" <KAY.ROZEBOOM@IOWA.GOV>
To:
IDMSVENDOR-L@LISTSERV.IUASSN.COM
Date:
02/12/2010 12:42 PM
Subject:
[IDMSVENDOR-L] automating journal file concatenation
Sent by:
IDMS 3rd-party providers forum <IDMSVENDOR-L@LISTSERV.IUASSN.COM>



Before trying to reinvent the wheel, I thought I would ask how others have
=
accomplished this: I am looking for a way to automate the generation of
DD=
statements for a job to concatenate journal offload files for the
previous=
day. Our journal offload file DSN's contain the date and time of offload
=
as part of their names. So it is easy enough to create the DD statements
m=
anually. (Just cut and paste the DSN's from TSO panel 3.4.) But we would
=
like automate the process.

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



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 3rd-party providers forum
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP
IDMSVENDOR-L@LISTSERV.IUASSN.COM
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: [IDMSVENDOR-L] automating journal file concatenation
"Hi

I really like the SHARE.ORG program SPECGDGC, which processes GDGs in
desired order.

Just feed it the gdg base name and it copies all generations

//step exec program=specgdgc,parm='all.my.daily.journals'

It is on share tape 18, well I think that is what it is called, tape
18.....

I have seen this used for many years at some large sites hence avoiding
writing journal concatenation rexx execs.
.
I have also heard, through the grapevine, a software supplier has program
of this type in planning.




Rob Klan/Cincinnati/IBM
Phone: 1-877-205-4871 (T/L: 349-2446)
VOIP Users 1-513-897-8148
ITN: 23492446
Email: rklan@us.ibm.com



From:
Chris Hoelscher <choelscher@HUMANA.COM>
To:
IDMS-L@LISTSERV.IUASSN.COM
Date:
02/12/2010 01:40 PM
Subject:
Re: [IDMSVENDOR-L] automating journal file concatenation
Sent by:
IDMS Public Discussion Forum <IDMS-L@LISTSERV.IUASSN.COM>



key - we run an IDCAMS to determine the datasets created during the
business cycle (day or week depending upon how frequently we backup) -
sort by generation # (ascending) - throw the formatted DD cards into an
INCLUDE librate, and run an ICEGENER to concatenate into a daily backup

we then take the same output from IDCAMS, format into DELETE statements,
and run IDCAMS again to delete the just-rolled-up journal tapes

Chris Hoelscher
IDMS/DB2 Database Architect
Humana Inc
502-476-2538
choelscher@humana.com

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






From:
""Rozeboom, Kay [DAS]"" <KAY.ROZEBOOM@IOWA.GOV>
To:
IDMSVENDOR-L@LISTSERV.IUASSN.COM
Date:
02/12/2010 12:42 PM
Subject:
[IDMSVENDOR-L] automating journal file concatenation
Sent by:
IDMS 3rd-party providers forum <IDMSVENDOR-L@LISTSERV.IUASSN.COM>



Before trying to reinvent the wheel, I thought I would ask how others have
=
accomplished this: I am looking for a way to automate the generation of
DD=
statements for a job to concatenate journal offload files for the
previous=
day. Our journal offload file DSN's contain the date and time of offload
=
as part of their names. So it is easy enough to create the DD statements
m=
anually. (Just cut and paste the DSN's from TSO panel 3.4.) But we would
=
like automate the process.

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



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: SYSGEN concurrent VS non concurrent
"We have played with this option in the past. Under the right circumstances =
it ""may"" cause the desirable effect of single threading through a program r=
esource . If the circumstances aren't right - you may get the ""calling prog=
rams"" abending due to ""program not available"". The ""call"" ( or in IDMS-DC a=
TRANSFER PGM ... RETURN ) must specify ""WAIT"" option to handle the case wh=
en the program is not immediately available.

There is another fix for this problem - specifically addressing CSYPGNUM - =
which is a code replacement for it that front-ends a stand-alone task that =
acts as a ""next Number Server"" - it is single threaded by using ENQ/DEQ on =
a piece of shared storage - no change is required to any other components o=
f CAS - it is a complete retrofit that has been proven in production.=20

The technique has been used for similar purposes in other applications at o=
ther sites, as well as for a CAS user where I was contracted to solve a nu=
mber of bottleneck issues - number generation being one in particular - but=
there are others! There is a paper, ""Creative Application Tuning Technique=
s"" that provides a detailed description on how to replace CSYPGNUM to get r=
id of the deadlocks - permanently and forever -=20
or at least until you get rid of CAS 8-)

HTH - 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:gary.cherlet@sa.gov.au

This e-mail message and any attachments are qualified as follows: Addressin=
g: If you have received this e-mail in error, please advise by reply e-mai=
l to the sender. Please also destroy the original transmission and its con=
tents. Confidentiality: This e-mail may contain confidential information w=
hich also may be legally privileged. Only the intended recipient(s) may ac=
cess, use, distribute or copy this e-mail. Individual Views: Unless otherw=
ise indicated, the views expressed are those of the sender, not Justice Tec=
hnology Services. Computer Viruses: It is the recipient's responsibility t=
o check the e-mail and any attached files for viruses.

Outcomes