ca.portal.admin

FW: REBUILD FROM INDEX

Discussion created by ca.portal.admin on Apr 14, 2005
Perhaps I should state my reason why I want to do REBUILD rather than BUILD.
It's because my index is DUPLICATE LAST hence I need to keep the order of
duplicate.
-----Original Message-----
From: Mason, Ina (DTUP)
Sent: Thursday, 14 April 2005 5:02 PM
To: IDMS-L (E-mail)
Subject: REBUILD FROM INDEX

In the past I have done Maintain index using BUILD option to some of our
indexes ( to a new definition of my new segment/DMCL).
(to my understanding, doing BUILD is really the same as doing REBUILD FROM
MEMBER?)
Can someone tell me if I can do 'REBUILD FROM INDEX' to a new definition
of segment (lager page, different SR8 etc) ?

Thankyou.

Ina Mason
IDMS DBA
TSA Australia
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
FW: REBUILD FROM INDEX
"Perhaps I should state my reason why I want to do REBUILD rather than BUILD.
It's because my index is DUPLICATE LAST hence I need to keep the order of
duplicate.
-----Original Message-----
From: Mason, Ina (DTUP)
Sent: Thursday, 14 April 2005 5:02 PM
To: IDMS-L (E-mail)
Subject: REBUILD FROM INDEX

In the past I have done Maintain index using BUILD option to some of our
indexes ( to a new definition of my new segment/DMCL).
(to my understanding, doing BUILD is really the same as doing REBUILD FROM
MEMBER?)
Can someone tell me if I can do 'REBUILD FROM INDEX' to a new definition
of segment (lager page, different SR8 etc) ?

Thankyou.

Ina Mason
IDMS DBA
TSA Australia
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
REBUILD FROM INDEX
"In the past I have done Maintain index using BUILD option to some of our
indexes ( to a new definition of my new segment/DMCL).
(to my understanding, doing BUILD is really the same as doing REBUILD FROM
MEMBER?)
Can someone tell me if I can do 'REBUILD FROM INDEX' to a new definition of
segment (lager page, different SR8 etc) ?

Thankyou.

Ina Mason
IDMS DBA
TSA Australia

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








Normal

Normal
Visual DBA
"I have a question for anyone out there using Visual DBA. Do you have to
turn security on at the database level in order to secure the Visual DBA
objects? I don't see anything in the documentation that mentions doing that
but we have been told that we have to.



*************************
CONFIDENTIALITY STATEMSent:
This e-mail and any attachments are intended only for those to which it is
addressed and may contain information which is privileged, confidential and
prohibited from disclosure and unauthorized use under applicable law. If you
are not the intended recipient of this e-mail, you are hereby notified that
any use, dissemination, or copying of this e-mail or the information
contained in this e-mail is strictly prohibited by the sender. If you have
received this transmission in error, please return the material received to
the sender and delete all copies from your system.

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








Normal

Normal
Re: REBUILD FROM INDEX
"Ina,
You can do a rebuild from index. You'll need to create a ""new view""
schema/subschema for SR8 changes and a local DMCL for physical changes.
Then run the index rebuild in step mode. IDMSTABX will use the old/new
subschemas and the current DMCL. Before you run the DBL3 step, you need
to edit the RELDCTL file to change the DMCL to be the same as the DMCL
with your new segment definitions. Be sure to have your new sized index
file in the DBL3 step

Outcomes