ca.portal.admin

Visual DBA

Discussion created by ca.portal.admin on Apr 14, 2005
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,

The ONLY option of MAINTAIN INDEX that maintains the dups order is FROM
INDEX. Don't think you can change the size of the SR8 and use this option
easily. You could probably fake it out by manually changing some things,
but that could be risky. BUILD is for new indexes and I'm pretty sure will
fail if there is an SR7 already out there for the index.

If you are changing the number of entries in the SR8, the physical size of
the page or the index area, I'd use UNLOAD/RELOAD, which also maintains the
dups order.

Linda Campbell
Informatix Inc.

-----Original Message-----
From: IDMS Public Discussion Forum [mailTo:IDMS-L@LISTSERV.IUASSN.COM] On
Behalf Of Mason, Ina (DTUP)
Sent: Thursday, April 14, 2005 12:52 AM
To: IDMS-L@LISTSERV.IUASSN.COM
Subject: 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
Visual DBA
"Jim

I think the reason you are told to turn DB security on is to restrict
access to the dictionaries to authorised users - see Section 9.2 of the
Security Administration manual. The objects one secures for Visual DBA
reside in the dictionary, so unless the dictionary itself is secured,
securing them is meaningless.


Disclosure of Material Facts
Every Proposer or Insured / Reinsured when seeking new insurance / reinsurance or renewing an existing Policy must disclose any information which might influence the Insurer / Reinsurer in deciding whether or not to accept the risk, what the terms should be, or what premiums to charge. Failure to do so may render the insurance / reinsurance voidable from inception and enable the Insurer / Reinsurer to repudiate liability.

This email, together with any attachments, is for the exclusive and confidential use of the addressee(s) and may contain legally privileged information. Any other distribution, use or reproduction without the sender's prior consent is unauthorised and strictly prohibited. If you have received this message in error, please notify the sender by email immediately and delete the message from your computer without making any copies. While attachments are virus checked, Aon Limited does not accept any liability in respect of any virus which is not detected.

Aon Limited
Company Number: 210725
Registered Address: 8 Devonshire Square, London, EC2M 4PL

Aon Limited is authorised and regulated by the Financial Services Authority in respect of insurance mediation activities only

"
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
"Thankyou all for your help

Ina

"
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 actually can make any physical changes you want using MAINTAIN INDEX
.... FROM INDEX. Some of the things you can do are listed in the
Utilities manual. Look at the third row of the table on page 4-97 of
the R15.0 manual. Other things you can do include changing the physical
page size or number of pages for the area that holds the index. The key
to doing this is running the utility in two steps. The first step will
specify the option ""STEP IDMSTABX"" on the utility control statement.
The JCL for this step must provide access to the subschema and DMCL that
describe the current (old) database. This JCL will include the old
database files.

The second step would specify ""FROM SORT3"" option on the utility control
statement. Other options on this statement would be ignored. They are
passed through a work file from the first job step above. The JCL for
this job step must provide access to a subchema and DMCL that describe
the new database and include the new database files (properly
formatted). I generally use the same subschema and DMCL names for both
steps, however my second step gets these modules from a different load
library (my pending installation library). You can choose to use
different names. The subschema name would be specified by the NEWSUB
option in the control statement in the first step. The DMCL name is
specified in the SYSIDMS parameters for each IDMS job step.

Happy tuning,

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

Outcomes