ca.portal.admin

Maintain Index

Discussion created by ca.portal.admin on Jul 2, 2008
Latest reply on Jul 2, 2008 by ca.portal.admin
I am moving a system owned index to some new page ranges. I usually do =
this with the DB Reorg tool but decided to use the Maintain Index =
utility, running this in two steps as noted in the manual. I cannot get =
it to work using two steps. (the one step Maintain Index works fine to =
rebuild indexes). I am sure someone has run the Maintain Index using two =
or more steps. The system is 16.1 z/OS.

Here are the steps I have for the utility.

Step 1.

//SYSIDMS DD * =20
DMCL=3DCurrent-DMCL =20
USERCAT=3DOFF =20
/* =20
//SYSIPT DD * =20
CONNECT TO SYSTEM; =20
MAINTAIN INDEX IN SEGMENT seg-name =20
USING current-ssc NEWSUB new-ssc =20
STEP IDMSTABX =20
REBUILD Index-name FROM INDEX =20


Step 2.

//SYSIDMS DD * =20
DMCL=3Dnew-dmcl (new dmcl renamed to the current dmcl and in different
library as per the documentation) =20
USERCAT=3DOFF =20
/* =20
//SYSIPT DD * =20
CONNECT TO SYSTEM; =20
MAINTAIN INDEX IN SEGMENT seg-name =20
USING current-ssc NEWSUB new-ssc =20
FROM SORT3 =20
; =20
=20
The most recent error is a bind failure.=20

Thanks in advance,

Will Hathcock
Database Administrator
(719) 495-6177
"
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: Maintain Index
"Will

We do this frequently. We actually use a variation where we do TABX in the first jobstep. The next jobstep uses FileAid Batch to modify the RELDCTL file to point to the new DMCL name, then the last jobstep starts MAINTAIN INDEX at SORT3. We usually specify SORTEXIT REUSE on this step.

I have a hunch that you missed specifying the REBUILD index-name FROM INDEX in your second step - it is still necessary there.


Either that, or your USERCAT=OFF may be your culprit. From the manual:

¦ USERCAT=ON/OFF ¦ Specifies whether the user ¦
¦ ¦ catalog is to be accessed. ¦
¦ ¦ Specify OFF only when formatting ¦
¦ ¦ the user catalog or when the ¦
¦ ¦ DMCL does not have access to a ¦
¦ ¦ user catalog. ON is the default.



Jim Ritterbusch Mail:
83 Wooster Heights, GE Capital Solutions
4th Floor 44 Old Ridgebury Rd.
Danbury, CT 06810
T 203.546.4370 F 203.546.4499
D 8*447.4370 E james.ritterbusch@ge.com
http://www.ge.com/capitalsolutions/

Outcomes