ca.portal.admin

Viewing IDMS/SQL created indexes

Discussion created by ca.portal.admin on Sep 16, 2009
Latest reply on Sep 16, 2009 by ca.portal.admin
We have implemented several SQL tables and indexes within our production en=
vironment, and would like to determine how the structure is holding up. Th=
ese are native SQL, not native IDMS with a SQL schema on top. We can run a=
print space on the area to see volume, but how do we run a report (similar=
to DBAN) to get insight to the levels of the index?
Physically, they are created as typical SR7/SR8 unlinked indexes, but they =
do not belong to a subschema because they are purely SQL. Are there any ou=
t-of-the-box monitoring tools for the SQL side of IDMS? Any information wo=
uld be appreciated.

Thanks.
Donna

Donna Kivala
Sr. Systems Engineer/Technical Database Consultant Information Technology S=
ervices Thermo Fisher Scientific

Office: 412-490-8820
Fax: 412-490-8311
Email: donna.kivala@thermofisher.com
www.thermofisher.com <http://www.thermofisher.com> <BLOCKED::http://www.the=
rmofisher.com> =20

The World Leader in Serving Science
WORLDWIDE CONFIDENTIALITY NOTE: Dissemination, distribution or copying of t=
his e-mail or the information herein by anyone other than the intended reci=
pient, or an employee or agent of a system responsible for delivering the m=
essage to the intended recipient, is prohibited. If you are not the intende=
d recipient, please inform the sender and delete all copies.
"
IDMS 3rd-party providers forum
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP
IDMSVENDOR-L@LISTSERV.IUASSN.COM
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Viewing IDMS/SQL created indexes
"You can use the ""print index"" utility. It's the same one that you use for a non-SQL index, except that you specify a table instead of a subschema. The following statements are input to IDMSBCF. Run it in local mode.

CONNECT TO __DICT__
;
PRINT INDEX ______________
SEGMENT ________
TABLE __SCH___.__TAB___
TREE TERSE
;

Outcomes