ca.portal.admin

Re:Re: Record and set changes

Discussion created by ca.portal.admin on Jan 10, 2007
Hi Bill,

I must admit I know very little to nothing about assembler. The
fields will get initialized with values based on other data values so
I am afraid it must be updated via program. At least my programming
skills will get used again. :-)

Thanks for your help,
Petra

At 01:05 PM 1/10/2007, you wrote:
Hello Petra:

If you know assembler language you don't need a program to initialize the
fields, you can just modify the output of the Schema Compare and change the
statements to the proper format for your new fields.

I'll look around for an example that I might have.

Bill Allen

In a message dated 1/10/2007 2:27:36 P.M. Eastern Standard Time,
lafresep@U.ARIZONA.EDU writes:

I thought it might be the case. My program that initializes the data
would then cause the set to be updated and put in the proper order.

Thanks for your help.
Petra



At 12:10 PM 1/10/2007, you wrote:
I think the restructure puts the expanded records in the
new sequence in=0D=
=0Athe set=2E I always thought of restructure handling the
logical=0D=0Aorg=
anization of the database and unload/reload the physical org=2E I
dont=0D=
=0Athink you need to run an unload/reload unless you're also changing
the=
=0D=0Apage size or cleaning up
fragmentation=2E=0D=0A=0D=0ALutz Petzold=0D=

=0A=0D=0A=0D=0A=0D=0A=0D=0A-----------------------------------------=0D=0AT
=
his e-mail may contain confidential or privileged information=2E
If=0D=0Ayo=
u think you have received this e-mail in error, please advise
the=0D=0Asend=
er by reply e-mail and then delete this
e-mail immediately=2E=0D=0AThank yo=
u=2E Aetna=0D=0A
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Record and set changes
"Hi Bill,

I must admit I know very little to nothing about assembler. The
fields will get initialized with values based on other data values so
I am afraid it must be updated via program. At least my programming
skills will get used again. :-)

Thanks for your help,
Petra

At 01:05 PM 1/10/2007, you wrote:
Hello Petra:

If you know assembler language you don't need a program to initialize the
fields, you can just modify the output of the Schema Compare and change the
statements to the proper format for your new fields.

I'll look around for an example that I might have.

Bill Allen

In a message dated 1/10/2007 2:27:36 P.M. Eastern Standard Time,
lafresep@U.ARIZONA.EDU writes:

I thought it might be the case. My program that initializes the data
would then cause the set to be updated and put in the proper order.

Thanks for your help.
Petra



At 12:10 PM 1/10/2007, you wrote:
I think the restructure puts the expanded records in the
new sequence in=0D=
=0Athe set=2E I always thought of restructure handling the
logical=0D=0Aorg=
anization of the database and unload/reload the physical org=2E I dont=0D=
=0Athink you need to run an unload/reload unless you're also changing the=
=0D=0Apage size or cleaning up
fragmentation=2E=0D=0A=0D=0ALutz Petzold=0D=
=0A=0D=0A=0D=0A=0D=0A=0D=0A-----------------------------------------=0D=0AT=
his e-mail may contain confidential or privileged information=2E
If=0D=0Ayo=
u think you have received this e-mail in error, please advise
the=0D=0Asend=
er by reply e-mail and then delete this
e-mail immediately=2E=0D=0AThank yo=
u=2E Aetna=0D=0A
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Record and set changes
"Hi Petra,

It's true that unload/reload does not change the set order from last to
sorted. You usually need a user-written program. However, if you're on
R16 SP4, the new express REORG will change the set order for index sets,
and you wouldn't need to write a program. I've tried REORG quite a bit,
but I must admit I didn't test out changing a set from unsorted to sorted.

Laura Rochon
Ajilon Consulting

Petra LaFrese wrote:
I have a procedural question.

I am planning on expanding a record and changing the order of a set
that uses the record from last to sorted. I know I need to run a
restructure segment to add new fields to the record. I also need to
run a program to initialize the new fields with data (It may not be
the same for every record). Then I plan to do an unload/load.My
question is this: Since I am doing the unload/load, do I have to
worry about the new sort order of the index? Won't the load put it in
the proper sort order? Or is this something I need to handle in my
initialization program? Some of the new fields that I will be
populating will be used as sort keys for the set.

Thanks for your help.

Petra


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








Normal

Normal
Re: Record and set changes
"To clear up a few questions: It is a standard set ordered last, not
an index of any sort. I want to change it to sorted by some new
fields that are to be populated.

The restructure will add the new fields.

The program will populate the new fields.

The Express Reorg idea is good, but unfortunately we don't have it.



It sounds like the best and easiest approach is to :

1. Run the restructure.
2. Extract the member records and the key of the owning set and
populate the new fields
3. Delete the record (the only set it is a member of is the one being
reordered).
4. Change the schema to sorted.
5. Readd the record. While this may be a bit expensive in terms of
I/O, I am only talking about 104,000 records, which is not too large an amount.
6. Unload/load to reorg the area.




Thank you all for all your help and great ideas. I knew this forum
would be a great help.

Regards,
Petra

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








Normal

Normal
Re: Record and set changes
"If you are going to delete the via records anyway, there really is no
need to restructure them. Your user written program can write the
extracted records in the new format with the new (calculated) sort field
data. Then these records can be loaded using the new subschema.

I/O during the load can be reduced during the load if you sort the
extracted records as follows:
1) decreasing on owner dbkey (this reduces set page overflow growth,
only applies if the member is stored VIA)
2) member sort key in opposite direction to the IDMS set order (each
STORE record will be first in set)

For 104K records I would not bother with the sort as long as the member
records are stored VIA. If the member record is stored CALC, the sort
will definitely pay for itself in reduced I/O during the store run.


Thank you,

Preston Lyon
Boeing FTCS Database Administration
B-XZ33 14-ME 206-655-2055
email preston.v.lyon@boeing.com

Outcomes