ca.portal.admin

Re:IDMS Server

Discussion created by ca.portal.admin on Sep 16, 2009
We are investigating the installation of CA-IDMS Server. Any suggestions
regarding training, etc.?

------------------------------------------------------------
Jacki K Hamilton
Lead Database Administrator
Madison Gas and Electric Company
608-252-7240
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Exit 23 Sample
"sure - this is one we use to route tasks away from the default when a
certain subschema is specified (the dbname is then detected by the
resource table and routed to another CV




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
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:
""Hathcock, Will"" <WHathcock@SEMPRAUTILITIES.COM>
To:
IDMSVENDOR-L@LISTSERV.IUASSN.COM
Date:
09/16/2009 04:50 PM
Subject:
[IDMSVENDOR-L] Exit 23 Sample
Sent by:
IDMS 3rd-party providers forum <IDMSVENDOR-L@LISTSERV.IUASSN.COM>



Would anyone have a sample of Exit 23 - Pre-Bind they would be willing
to share the source for?

Will Hathcock
Database Administrator
(719) 495-6177



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] Exit 23 Sample
"sure - this is one we use to route tasks away from the default when a
certain subschema is specified (the dbname is then detected by the
resource table and routed to another CV




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
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:
""Hathcock, Will"" <WHathcock@SEMPRAUTILITIES.COM>
To:
IDMSVENDOR-L@LISTSERV.IUASSN.COM
Date:
09/16/2009 04:50 PM
Subject:
[IDMSVENDOR-L] Exit 23 Sample
Sent by:
IDMS 3rd-party providers forum <IDMSVENDOR-L@LISTSERV.IUASSN.COM>



Would anyone have a sample of Exit 23 - Pre-Bind they would be willing
to share the source for?

Will Hathcock
Database Administrator
(719) 495-6177



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: XA STORAGE POOL 255
"Thanks to those who responded.

We are running Release 15.0

I think Bill Allen hit the nail on the head in his off list email. We don't
have an XA PROGRAM POOL defined (I have no idea why not) which is where it
sounds like the DMCL is supposed to reside.
We do have an XA REENTRANT PROGRAM POOL.

Anyway, I bumped the size of XA STROAGE POOL 255 from 5100 to 10000. The
first 2 GETSTG's were asking for about 5100k and if the DMCL is in there,
it 's full at startup.

More will be revealed. And I'll let you guys know.

Thanks

Tim Kupin
IDMS DBA
IBM Global Services

office 864.609.3564
cell 301.752.6857
home office 301.638.7424
timkupin@us.ibm.com
tim_kupin@comcast.net
"
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] XA STORAGE POOL 255
"Thanks to those who responded.

We are running Release 15.0

I think Bill Allen hit the nail on the head in his off list email. We don't
have an XA PROGRAM POOL defined (I have no idea why not) which is where it
sounds like the DMCL is supposed to reside.
We do have an XA REENTRANT PROGRAM POOL.

Anyway, I bumped the size of XA STROAGE POOL 255 from 5100 to 10000. The
first 2 GETSTG's were asking for about 5100k and if the DMCL is in there,
it 's full at startup.

More will be revealed. And I'll let you guys know.

Thanks

Tim Kupin
IDMS DBA
IBM Global Services

office 864.609.3564
cell 301.752.6857
home office 301.638.7424
timkupin@us.ibm.com
tim_kupin@comcast.net
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: XA STORAGE POOL 255
"just a reminder ....

in release 17 - the DMCL always gets loaded into a ""dynamc"" 2nd pool 255
- separate and apart from the ""sysgenned"" 1st pool 255 - this ""dynamic""
2nd poll 255 will always be the size of the DMCL (no bigger, no smaller)
and will appear to all commands to be 100% full (so yes, 2 pool 255s will
show)

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:
Tim Kupin <timkupin@US.IBM.COM>
To:
IDMSVENDOR-L@LISTSERV.IUASSN.COM
Date:
09/16/2009 05:19 PM
Subject:
Re: [IDMSVENDOR-L] XA STORAGE POOL 255
Sent by:
IDMS 3rd-party providers forum <IDMSVENDOR-L@LISTSERV.IUASSN.COM>



Thanks to those who responded.

We are running Release 15.0

I think Bill Allen hit the nail on the head in his off list email. We
don't
have an XA PROGRAM POOL defined (I have no idea why not) which is where it
sounds like the DMCL is supposed to reside.
We do have an XA REENTRANT PROGRAM POOL.

Anyway, I bumped the size of XA STROAGE POOL 255 from 5100 to 10000. The
first 2 GETSTG's were asking for about 5100k and if the DMCL is in there,
it 's full at startup.

More will be revealed. And I'll let you guys know.

Thanks

Tim Kupin
IDMS DBA
IBM Global Services

office 864.609.3564
cell 301.752.6857
home office 301.638.7424
timkupin@us.ibm.com
tim_kupin@comcast.net



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] XA STORAGE POOL 255
"just a reminder ....

in release 17 - the DMCL always gets loaded into a ""dynamc"" 2nd pool 255
- separate and apart from the ""sysgenned"" 1st pool 255 - this ""dynamic""
2nd poll 255 will always be the size of the DMCL (no bigger, no smaller)
and will appear to all commands to be 100% full (so yes, 2 pool 255s will
show)

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:
Tim Kupin <timkupin@US.IBM.COM>
To:
IDMSVENDOR-L@LISTSERV.IUASSN.COM
Date:
09/16/2009 05:19 PM
Subject:
Re: [IDMSVENDOR-L] XA STORAGE POOL 255
Sent by:
IDMS 3rd-party providers forum <IDMSVENDOR-L@LISTSERV.IUASSN.COM>



Thanks to those who responded.

We are running Release 15.0

I think Bill Allen hit the nail on the head in his off list email. We
don't
have an XA PROGRAM POOL defined (I have no idea why not) which is where it
sounds like the DMCL is supposed to reside.
We do have an XA REENTRANT PROGRAM POOL.

Anyway, I bumped the size of XA STROAGE POOL 255 from 5100 to 10000. The
first 2 GETSTG's were asking for about 5100k and if the DMCL is in there,
it 's full at startup.

More will be revealed. And I'll let you guys know.

Thanks

Tim Kupin
IDMS DBA
IBM Global Services

office 864.609.3564
cell 301.752.6857
home office 301.638.7424
timkupin@us.ibm.com
tim_kupin@comcast.net



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: IDMS Server
"=20
""Any information that you can provide to new users of IDMS Server is helpfu=
l and appreciated. The FAQ that you provided on Solving Server Issues is e=
xcellent."" This document can be found in the ""Contributed Software Library""=
section at the IUA Web Site http://iuassn.org=20
The document is under the SQL section: Solving Java SQL Problems 2005.08.02

We also have a slightly older document that has questions from Justice Tech=
nology with answers from CA about Transaction management - these date back =
to 2004 but we still refer to this document in-house. As always - read the =
CA manuals for most current information. This document (not checked recentl=
y by CA) can be found in the ""Contributed Software Library"" section at the =
IUA Web Site http://iuassn.org=20
The document is under the SQL section: SQL + Transaction management 2004.08=
.27

I had also asked CA to comment on two other documents which pertain to JDBC=
configuration, transaction pooling and timeouts - also being a few years o=
ld here is CA's comment (as a result of which I have not uploaded these to =
the web site): =20

""The other two documents that we had provided are a bit out of date, and th=
e information has now been included (in a slightly briefer form) in the cur=
rent User Guide, so it might be better for people to download that document=
from CA Support Online. Chapter 1 contains the overview information, and =
chapter 3 contains the timeout guidelines. Both sections now include infor=
mation about using the IDMS TCP/IP version of the JDBC driver, which you co=
rrectly point out as the preferred way to go.""

""Dave Hearn has posted a reply containing additional information about some=
of the recent webcasts that are available too.""

Hopefully new users of SQL Server will find some value from the posted info=
rmation - take care y'all - 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

On this page I appear to be deeply concerned about one thing or another ...=
.... this is merely an old habit of the face Leonard Cohen

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.
"
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: IDMS Server
"
""Any information that you can provide to new users of IDMS Server is helpful and appreciated. The FAQ that you provided on Solving Server Issues is excellent."" This document can be found in the ""Contributed Software Library"" section at the IUA Web Site http://iuassn.org
The document is under the SQL section: Solving Java SQL Problems 2005.08.02

We also have a slightly older document that has questions from Justice Technology with answers from CA about Transaction management - these date back to 2004 but we still refer to this document in-house. As always - read the CA manuals for most current information. This document (not checked recently by CA) can be found in the ""Contributed Software Library"" section at the IUA Web Site http://iuassn.org
The document is under the SQL section: SQL + Transaction management 2004.08.27

I had also asked CA to comment on two other documents which pertain to JDBC configuration, transaction pooling and timeouts - also being a few years old here is CA's comment (as a result of which I have not uploaded these to the web site):

""The other two documents that we had provided are a bit out of date, and the information has now been included (in a slightly briefer form) in the current User Guide, so it might be better for people to download that document from CA Support Online. Chapter 1 contains the overview information, and chapter 3 contains the timeout guidelines. Both sections now include information about using the IDMS TCP/IP version of the JDBC driver, which you correctly point out as the preferred way to go.""

""Dave Hearn has posted a reply containing additional information about some of the recent webcasts that are available too.""

Hopefully new users of SQL Server will find some value from the posted information - take care y'all - cheers- Gary

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

On this page I appear to be deeply concerned about one thing or another ....... this is merely an old habit of the face Leonard Cohen

This e-mail message and any attachments are qualified as follows: Addressing: If you have received this e-mail in error, please advise by reply e-mail to the sender. Please also destroy the original transmission and its contents. Confidentiality: This e-mail may contain confidential information which also may be legally privileged. Only the intended recipient(s) may access, use, distribute or copy this e-mail. Individual Views: Unless otherwise indicated, the views expressed are those of the sender, not Justice Technology Services. Computer Viruses: It is the recipient's responsibility to check the e-mail and any attached files 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: IDMS Server
"Hi

If you starting out new, use IDMS TCP/IP socket listener rather then using
IDMS Server.

Copied from an IDMS Server issue raised earlier this year with CA.

""the TCP/IP line doesn't replace IDMS Server, it eliminates the need
for the JDBC ""proxy"" server that runs in USS (or Windows, even though
that's not what you're doing). The same JDBC driver that's currently
running on
the client machine can support either type of connection. When it's
talking to a JDBC proxy, it's considered a JDBC type 3 driver, and when
it's
talking to IDMS through the TCP/IP line, it's considered a JDBC type 4
driver. In
regard to whether a switch to the TCP/IP line could be done transparently
depends on how things are configured today. The IDMS Server User Guide
provides more information on this in Appendix B, but the issue is mostly
related to the URL in the Java program. If the ""database"" in the string
(jdbc:idms://hostname:port/database) refers to the catalog dictionary name
in the CV, then it's possible to make the transition without changing the
Java program. If the ""database"" refers to a data source definition in the
caidms.cfg file, then the transition will require the program to be
changed.
The other thing is whether any non-default options have been set in the
caidms.cfg file, in which case they would have to be enabled on each
client.
However, there are performance improvements to be gained from going this
route, and of course you wouldn't have to worry about the JDBC proxy
anymore.""



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



Jacki Hamilton <JHamilton@MGE.COM>
Sent by: IDMS Public Discussion Forum <IDMS-L@LISTSERV.IUASSN.COM>
09/15/2009 06:02 PM
Please respond to
IDMS Public Discussion Forum <IDMS-L@LISTSERV.IUASSN.COM>


To
IDMS-L@LISTSERV.IUASSN.COM
cc

Subject
IDMS Server






We are investigating the installation of CA-IDMS Server. Any suggestions
regarding training, etc.?

------------------------------------------------------------
Jacki K Hamilton
Lead Database Administrator
Madison Gas and Electric Company
608-252-7240
"
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: IDMS Server
"Hi

If you starting out new, use IDMS TCP/IP socket listener rather then using
IDMS Server.

Copied from an IDMS Server issue raised earlier this year with CA.

""the TCP/IP line doesn't replace IDMS Server, it eliminates the need
for the JDBC ""proxy"" server that runs in USS (or Windows, even though
that's not what you're doing). The same JDBC driver that's currently
running on
the client machine can support either type of connection. When it's
talking to a JDBC proxy, it's considered a JDBC type 3 driver, and when
it's
talking to IDMS through the TCP/IP line, it's considered a JDBC type 4
driver. In
regard to whether a switch to the TCP/IP line could be done transparently
depends on how things are configured today. The IDMS Server User Guide
provides more information on this in Appendix B, but the issue is mostly
related to the URL in the Java program. If the ""database"" in the string
(jdbc:idms://hostname:port/database) refers to the catalog dictionary name
in the CV, then it's possible to make the transition without changing the
Java program. If the ""database"" refers to a data source definition in the
caidms.cfg file, then the transition will require the program to be
changed.
The other thing is whether any non-default options have been set in the
caidms.cfg file, in which case they would have to be enabled on each
client.
However, there are performance improvements to be gained from going this
route, and of course you wouldn't have to worry about the JDBC proxy
anymore.""



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



Jacki Hamilton <JHamilton@MGE.COM>
Sent by: IDMS Public Discussion Forum <IDMS-L@LISTSERV.IUASSN.COM>
09/15/2009 06:02 PM
Please respond to
IDMS Public Discussion Forum <IDMS-L@LISTSERV.IUASSN.COM>


To
IDMS-L@LISTSERV.IUASSN.COM
cc

Subject
IDMS Server






We are investigating the installation of CA-IDMS Server. Any suggestions
regarding training, etc.?

------------------------------------------------------------
Jacki K Hamilton
Lead Database Administrator
Madison Gas and Electric Company
608-252-7240
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: XA STORAGE POOL 255
"Chris,

Do you know what is meant by ""the size of the DMCL""? The size of the addit=
ional pool 255 on our test R17 CV does not match any of the following: the=
DMCL load module size, the size of the DMCL buffers, or the value specifie=
d for CV_STARTUP_XA_REGION_MB.
=20

Outcomes