ca.portal.admin

Index Space Problem

Discussion created by ca.portal.admin on Nov 19, 2007
Latest reply on Nov 20, 2007 by ca.portal.admin
I hope I am doing this correctly. This is my first time posting to
LISTSERV.

Here is my problem:

We added a new index area to an existing record and modified the
segment/DMCL for the new index. We modified the schema with the new
index and then ran the IDMSTBLU to build the new index. The problem is
that before we ran the IDMSTBLU we ran a space report and had 95% space
available on the new index. But, after running IDMSTBLU, the space
available goes down to 7%. The key for the new index is 55 characters
and when we created the file for the new index it is 2 tracks and Lrecl
is 3172. Do we need to increase the size of the index? We are not sure
what is causing this.

Vr,
Lisa.Schaffner@navy. mil
NAVSISA
DBA


Dick

Richard Pierce
(617) 973-8911
richard.pierce@state.ma.us
-----Original Message-----
From: IDMS Public Discussion Forum
[mailTo:IDMS-L@listserv.iuassn.com] On Behalf Of Pierce, Richard
(RMV)
Sent: Tuesday November 20, 2007 10:01 AM
To: IDMS-L@listserv.iuassn.com
Subject: Re: Index Space Problem

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








Normal

Normal
Re: Index Space Problem
"Any time,

By the way, I would have sized for 2000 + records in the index and the
results of my calculations would be something like this:
(Note - there are differences between load time and run time
specifications.)

ADD
SET NAME IS NASA-IX-SET
ORDER IS SORTED
MODE IS INDEX
USING @SYM-NASA-IX
OWNER IS SYSTEM
WITHIN AREA NASA-IX-AREA
OFFSET 0 PERCENT FOR 100 PERCENT
MEMBER IS NASA-IX-RECORD
INDEX DBKEY POSITION IS OMITTED
MANDATORY AUTOMATIC
KEY IS ( KKKKKKKKKKKKKKKKKKKKK
)
DUPLICATES ARE NOT ALLOWED
UNCOMPRESSED
.

CREATE
PHYSICAL AREA SEGMENT.NASA-IX-AREA
PRIMARY SPACE 103 PAGES FROM PAGE XXXXXXXX
MAXIMUM SPACE 103 PAGES
PAGE SIZE 3172 CHARACTERS
PAGE RESERVE (load) 964 CHARACTERS
PAGE RESERVE (final) 0 CHARACTERS
INCLUDE SYMBOLIC INDEX @SYM- NASA IX
BLOCK CONTAINS (load) 7 KEYS DISPLACEMENT 17
PAGES
BLOCK CONTAINS (final) 8 KEYS DISPLACEMENT 17
PAGES
WITHIN FILE YYYYYYYYY
FROM 1 FOR ALL BLOCKS
;

Dick

Richard Pierce
(617) 973-8911
richard.pierce@state.ma.us

Outcomes