ca.portal.admin

Re: [IDMSVENDOR-L] Specifying DBname  for SQL-defined databases

Discussion created by ca.portal.admin on Dec 22, 2006
Kay, how about a default DICTNAME in your SYSIDMS load module?


Chris Hoelscher
IDMS & DB2 Database Administrator
Humana Inc
502-476-2538
choelscher@humana.com (mailTo:choelscher@humana.com)
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: [IDMSVENDOR-L] Specifying DBname for SQL-defined databases
"not sure if this made it - so reposting

Question for you and Bill Allen: You both mentioned using the bind
counts to help make a decision. What would you look for, and what would
you do with the information?


depends ... you need to find out from CA what is the search order for
segments within a DBNAME - is it searched in the order that the segments
were added to the DBNAME? is it in alphabetical sequence of the SEGMENTS?

id the first, then you would want to drop the dbname and re-add it with
the most heavily-bound-to segments first - if the latter, well, i have
heard shops that get the segments funny names so that the most
heavily-bound-against segments sort to the top of the DBNAME


one other thought - have you considered EXIT 23 (pre-bind exit) - this
allows you to manipulate the dbname and/or dictname at bind time based on
whatever you can get your hands on CSECT-wise ...

chris

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
Happy Holidays
"I wish everyone on IDMS-L a happy holiday season

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: [IDMSVENDOR-L] Specifying DBname for SQL-defined databases
"Question for you and Bill Allen: You both mentioned using the bind
counts to help make a decision. What would you look for, and what would
you do with the information?


depends ... you need to find out from CA what is the search order for
segments within a DBNAME - is it searched in the order that the segments
were added to the DBNAME? is it in alphabetical sequence of the SEGMENTS?

id the first, then you would want to drop the dbname and re-add it with
the most heavily-bound-to segments first - if the latter, well, i have
heard shops that get the segments funny names so that the most
heavily-bound-against segments sort to the top of the DBNAME


one other thought - have you considered EXIT 23 (pre-bind exit) - this
allows you to manipulate the dbname and/or dictname at bind time based on
whatever you can get your hands on CSECT-wise ...

chris

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: [IDMSVENDOR-L] Specifying DBname for SQL-defined databases
"Alas, most of our CV's have multiple dictionaries and multiple user
databases.
We currently route everyone to a default application dictionary via
DBtable mapping. Then they override this as needed via user profile,
SYSIDMS parm, clist, etc. Finding and changing all those overrides
would be a monumental task.

Question for you and Bill Allen: You both mentioned using the bind
counts to help make a decision. What would you look for, and what would
you do with the information?

Outcomes