ca.portal.admin

""Decompilation"" of IDD table load modules.

Discussion created by ca.portal.admin on Oct 10, 2007
Does anyone have any handy code to 'decompile"" an IDD table into
fixed-format output (including the table name itself), e.g. for a code
table such as this:

ADD
TABLE NAME IS PMCTCCST VERSION IS 1
TYPE IS CODE
VALUES ARE ( I 'IN PROCESS' C 'RESET COMPLETE' N 'NOT ACTIVE' R
REQUESTED S STARTED X 'REQ. RESET ONLY')
.

would yield output such as this:

PMCTCCST I IN PROCESS
PMCTCCST C RESET COMPLETE
PMCTCCST N NOT ACTIVE
PMCTCCST R REQUESTED
PMCTCCST S STARTED
PMCTCCST X REQ. RESET ONLY

and for an edit table:

ADD
TABLE NAME IS PMCTSYMB VERSION IS 1
TYPE IS EDIT VALID
VALUES ARE ( F N Z G E S P B )
.

the output would be:

PMCTSYMB F
PMCTSYMB N
PMCTSYMB Z
PMCTSYMB G
PMCTSYMB E
PMCTSYMB S
PMCTSYMB P
PMCTSYMB B

I'm confident I could write one (in assembler) but if someone's already
done it . . . why reinvent the wheel?

Ideally I'd want to read the entire dictionary and only process load
modules associated with tables, and each table would likely have to be
cycled through twice: once to determine the maximum length of the
elements and once to actually strip them off and write them out.

Any takers?

PELLERIN MILNOR CORPORATION
Michel J Champagne
Systems Analyst / DBA
<<Picture (Metafile)>>
Voice: 504-712-7589
FAX: 504-712-3589

CONFIDENTIALITY NOTICE: This message and any attachments may contain
confidential, proprietary or legally privileged information and is
intended only for the use of the addressee or addressees named above for
its intended purpose. If you are not the intended recipient of this
message, this message constitutes notice that any review,
retransmission, distribution, copying or other use or taking any action
in reliance on the information in this message and its attachments, is
prohibited. If you receive this communication in error, please
immediately advise the sender by reply e-mail and delete this message
and its attachments from your system without keeping a copy. Unless
expressly stated in this e-mail, nothing in this message may be
construed as a digital or electronic signature. Thank you.
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
"""Decompilation"" of IDD table load modules."
"Does anyone have any handy code to 'decompile"" an IDD table into fixed-format output (including the table name itself), e.g. for a code table such as this:

ADD
TABLE NAME IS PMCTCCST VERSION IS 1
TYPE IS CODE
VALUES ARE ( I 'IN PROCESS' C 'RESET COMPLETE' N 'NOT ACTIVE' R
REQUESTED S STARTED X 'REQ. RESET ONLY')
.

would yield output such as this:

PMCTCCST I IN PROCESS
PMCTCCST C RESET COMPLETE
PMCTCCST N NOT ACTIVE
PMCTCCST R REQUESTED
PMCTCCST S STARTED
PMCTCCST X REQ. RESET ONLY

and for an edit table:

ADD
TABLE NAME IS PMCTSYMB VERSION IS 1
TYPE IS EDIT VALID
VALUES ARE ( F N Z G E S P B )
.

the output would be:

PMCTSYMB F
PMCTSYMB N
PMCTSYMB Z
PMCTSYMB G
PMCTSYMB E
PMCTSYMB S
PMCTSYMB P
PMCTSYMB B

I'm confident I could write one (in assembler) but if someone's already done it . . . why reinvent the wheel?

Ideally I'd want to read the entire dictionary and only process load modules associated with tables, and each table would likely have to be cycled through twice: once to determine the maximum length of the elements and once to actually strip them off and write them out.

Any takers?

PELLERIN MILNOR CORPORATION
Michel J Champagne
Systems Analyst / DBA
<<Picture (Metafile)>>
Voice: 504-712-7589
FAX: 504-712-3589

CONFIDENTIALITY NOTICE: This message and any attachments may contain confidential, proprietary or legally privileged information and is intended only for the use of the addressee or addressees named above for its intended purpose. If you are not the intended recipient of this message, this message constitutes notice that any review, retransmission, distribution, copying or other use or taking any action in reliance on the information in this message and its attachments, is prohibited. If you receive this communication in error, please immediately advise the sender by reply e-mail and delete this message and its attachments from your system without keeping a copy. Unless expressly stated in this e-mail, nothing in this message may be construed as a digital or electronic signature. Thank you.
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Space Reserved on a Page
"I have been working reorging an area and trying to get a uniform
distribution of data across the pages. What I am ending up with is that
35 percent of the pages have less than 10 percent space left on them. I
have tried page-reserve and displacement (because there is an index in
the area), but still DBAN shows that 35 percent of the pages have less
than 10 percent space left on them. I am using CA's Reorg tool and have
53 percent free space after the reorg. I can't do an unload/reload due
to the number of pointers in the area.

Any ideas?

Will Hathcock
Database Administrator

We are what we repeatedly do. Excellence then, is not an act but a
habit. - Aristotle
"
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] Space Reserved on a Page
"well, let me add my thoughts:
depending on the IBC of the index (and the number of sr8s) it may be
impossible to get a good distribution. SR8s are VIA records to the SR7, so
the will always be some clumps
suggestions?
if spread out is what you really want, increase page reserve until the SR8s
are forced off the target page, and/or make the SR8s smaller (and more of
them) so that placement of 1 on a page does not drastically skew its %full

i am not sure either of these suggestions are good, but since i am not sure
why even distribution is overriding everytthing else, these are the onyl
suggestions I can make

thanks
chris hoelscher








I have been working reorging an area and trying to get a uniform
distribution of data across the pages. What I am ending up with is that
35 percent of the pages have less than 10 percent space left on them. I
have tried page-reserve and displacement (because there is an index in
the area), but still DBAN shows that 35 percent of the pages have less
than 10 percent space left on them. I am using CA's Reorg tool and have
53 percent free space after the reorg. I can't do an unload/reload due
to the number of pointers in the area.

Any ideas?

Will Hathcock
Database Administrator

We are what we repeatedly do. Excellence then, is not an act but a
habit. - Aristotle


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: ""Decompilation"" of IDD table load modules."
"Thanks for all responses on the below query - I now have a substantially
greater amount of information to consider when crafting a solution than
I did before.

Outcomes